Web Technologies

Sharepoint Basics

What is SharePoint

  • SharePoint is a collaborative platform to publish the content, build productivity apps, to track our projects and keep our team connected in the modern workspace.

Why Share Point

1.Manages your projects

          It helps to manage projects in one place. It shows u all the info in Gantt Chart View. So, it is easy to track projects easily. We can divide one project into no: of activities that needed to be performed for successful completion of the project. We can also bring the issue tracking system which keeps the track of issue that comes up with the project.

2.Manages Reports

         We can simply create a report in excel by simply reporting all the data to excel.

3.Manages calendar and contacts

               Integrates with outlook calendar

4.Easy to Manage

        Since all data will be stored in one SQL server we can easily manage it. No need for data in the local system

5.Alerts

        Alert will be given as soon as there is a change on your site. For example, when anyone uploads a daily report, apply for leave.

6.No special training required

        No special training required for users because its ui is very easy to understand.

SharePoint features

  • SharePoint features makes it different like
  • Intranet
  • Documents
  • Collaboration
  • Extranet
  • Websites

SharePoint 2013 and SharePoint 2016 differences

  2013 2016
Content Database size 200gb 1+TB
Site Collections per Database 5000 100000
App launcher no yes
Search application Index 100 million items Index 500 million items
Min roles no yes
Upload file size 2gb 10gb
Zero Down Time patching no yes
5000 threshold override yes yes

Advantages of SharePoint

  • Centralized Administration
  • Customizable
  • Collaboration
  • Security and Integrity
  • Ease of Use

SharePoint Architecture (Physical and Logical Topology)

     Physical Architecture mainly contains

  1. Front End (Web Front End)
  2. App Server
  3. Sql

       Logical Architecture mainly contains

  1. Farm
  2. Web Apps
  3. Site Collections
  4. Sub Sites/Root Site
  5. Lists and Libraries

Min Role

While configuring SharePoint farm, we can select the role of a server when you create a new farm or we can join a server to an existing farm. SharePoint will automatically configure services on every server based on the server’s role

Min Role Farm Topology

Six predefined roles are available for creating a new farm. SharePoint automatically configures the services as per the role selected.

Benefits of using Min Role Farm Topology

  • Simplified Deployment
  • Improved performance and reliability
  • Simplified capacity and farm scalability

Farm

Group of one or more server computers works together to provide SharePoint functionality.

 Share Point farm contains

  • On a Farm, we will be having 1 or more Web Apps
  • On a Web App, we have one or more Site collections
  • On a Site Collection, we may have multiple sites/ webs
  • On a web, we may have multiple Sub webs
  • On a sub web, we may have multiple lists
  • On a list, we may have many list items

App Server

These servers provide services running on them. They are there to provide specific service needed such as Excel, Search, User Profile info, etc.

Site

Site is a website that contains different share Point web parts like doc library, calendar, Task List, etc. It contains one or more pages to display to the user.

Site Collection

Generally, a Site Collection is a collection of SharePoint sites that share similar features like content types, templates, site columns, permissions, web parts, etc.

 Separate site collections

  • Unique set of users.
  • Unique and separated databases
  • Unique set of workflows, content types and site columns

Single Site Collection with Sub Sites

  • Shares data and content from site to site
  • Shared permission management across all sites
  • Single Database

Features of share point 2007

1.Collaboration

        We can work easily, efficiently and effectively with other people in your organization. For example

  1. Share documents, contacts, tasks and calendars
    1. Share ideas with blogs
    1. Manages projects
    1. Manages documents and some types of lists offline
    1. Access content on mobiles
  2. Enterprise content management

           It provides the foundation for document management tasks, such as versioning, auditing, and workflow. It extends these capabilities to deliver enhanced documentation, web content management, and publishing record management, records management, policy management, and content management is divided into three categories mainly Document management, records management and web content management.

2.Workflow

           The process will depend on the flow of information or documents, requires the active participation of info workers to complete the tasks. it implements and manages these types of process.

3.My sites

                  Site is a website that contains different share Point web parts like doc library, calendar, Task List, etc. It contains one or more pages to display to the user.

4.User profile

    It maintains the user profiles and all the information about them.

5.Search

    It provides a consistent and familiar search and improved manageability and extensibility.

Farm level features

  • Data connection library
  • Excel services
  • Global web parts
  • Spell checking

 Enterprise features

  • Excel services
  • Report center
  • Business data catalog

 Features of share point 2010

1. Sand boxed solutions

     Admin may limit the resources per application basis and they run under a different process together to give security and isolation.

2.New user interface including ribbon

       The user interface has been changed so that a user will be able to perform operation just with few clicks.

3.Access services

        Edit, update and create and create Microsoft access databases that can be viewed and manipulated by using the browser or linked HTML page.

4.Managed metadata

       It is a hierarchal collection of centrally managed terms that you can define and then use as attributes in share point.

5. Central administration web site

       It provides a better user experience and makes it easier for an administrator to find what they are looking for. It groups the major functional areas like application management, monitoring, and security. It is also equipped with a ribbon UI which makes easier to view.

6.New hardware and software requirements

        Some new hardware and software requirements are added.

7. Business data connectivity services

        It provides read/write access to external data from databases, web service and other external systems. We must be aware of the business data catalog. It had been replaced by business connectivity services(BCS).  Using BCS we can read/write back to external systems and we can read data from external systems.

8. Visio services

            Improved UI with ribbon which improves its usability and makes it consistent

  1. Permissions can be set for every individual user.
  2.  Saving and deleting site templates is now possible
  3. Support for attaching workflows in content type
  4. Create content types and attach to lists
  5. developer dashboard

      it displays the performance and tracking info in the bottom of every page. Developers can use this information to debug and troubleshoot issues.

9.New share point developer tools in visual studio 2010

         a new set of tools introduced in visual studio 2010 which makes share point apps easy as other .net apps. New tools include project templates for many of share point application types such as web parts, lists modules application pages, workflows, user controls.

10.client object model

         it is a new programming interface where code runs on the user’s client machine against a local object model and interacts with data on the server.

11.Language integrated query for share point

                  You can use language integrated query (LINQ) objects to query lists.

Features of share point 2013

  • excel services
  • access services
  • user profile service
  • search
  • business connectivity services
  • performance point services
  • content management

          simplify how u design publishing sites and publishing process of our organization.

  • translation service

         it translates the content to other languages also.

  • workflow services

                  Process will depend on the flow of information or documents, requires the active participation of info workers to complete the tasks. it implements and manages these types of process.

  • mobile features

Service applications

  1. Access Service

         Let the user to view edit and interact with access 2010 databases in a web browser.

  • App Management Service

          Is responsible for storing and providing info and permissions, licenses

  • Business Data Connectivity Service

         It provides read/write access to external data from databases, web service and other external systems. We must be aware of the business data catalogue. It had been replaced by business connectivity services(BCS).  Using BCS we can read/write back to external systems and we can read data from external systems

  • Machine Translation Service

          It allows to translate the content to other languages also

  • Managed Meta Data Service

         It is a hierarchal collection of centrally managed terms that you can define and then use as attributes in share point   

  • Search Service

          Crawls content, produces index partitions and server search queries

  • Secure Store Service

          Provides every single sign on authentication process to access multiple applications or services

  • User Profile Service

             Adds support for my sites, profile pages, social tagging and others

  • Visio Graphics Service

     Improved UI with a ribbon which improves its usability and makes it consistent   Permissions can be set for every individual user. Saving and deleting site templates is now possible Support for attaching workflows in the content type. Create content types and attach to lists

  1. Word Automation Service

Performs automated bulk document conversations

  1. Work Management Service

             It provides the functionality to aggregate tasks to a central location server. Users get the possibility to view and track their to-dos and tasks. Tasks can also be cached to the user’s personal site

 Share point online

  • No need for IT team for server maintenance Microsoft will see the maintenance and automatically updating and adding patches.
  • Cost is as per the annual subscriptions for office 365 plans billed.
  • Cheap storage cost.
  • No requirement of people for maintenance.
  • In a cloud environment, we can share the content to the external users like clients so that this may risk the security of data.

  Advantages

  • It simplifies the ever day business activities by easy searching, tracking and getting required information regarding projects with in less time.
  • It enables employee to make better informed decisions by creating live or interactive business intelligent portals that displays the critical information.
  • Secured and ease of use.
  • Manage and reuse content, speedup business process.

Collaboration

  • Collaboration is nothing but bringing people together through different types of collaboration by web content management, social computing, enterprise content management.
  • Collaboration is managed through the apps in 2013 version of share point.
  • Developers can customize, extend or build their own apps for share point as well a manage collaboration on share point.

Platform

  • Share point is a platform that not only supports the collaboration and interoperability, but also a set of development tools and extensibility.

Inter-operability

  • Share point is also about bring the collaboration together through the interoperability such as web based document integration, integrating with the wider  web technologies or deploying applications to the cloud.

Site Content type

     Content type is reusable collection of metadata, workflow, behavior and others for items or document. It enables u to manage the settings for a category of information in a centralized, reusable way.

How to create a content type

  • Goto site settings in that click on site content types.
  • Click on create
  • Enter name u need to give that content type
  • Select the parent content type carefully if we select the document content type it can be accessible within the library only and if we select the list content type it can be used only in lists not in libraries
  • Select the parent content type from so that it can inherit the content type from another content type.
  • We can also add site columns from add existing site columns so that whenever we add a content type to the list or library automatically those columns are added.

Site Column type

            It describes how data is stored and displayed in list or library.

  How to create a Column type

  • Goto site settings in that click on site Column types.
    •    Click on Create Column
    • Enter name u need to give that Column type
    •  Select the type of information in the column that provides the type of information it is going to store

There are 14 types of column types available they are

  • Single line of text
  • Multiple lines of text
  • Choice
  • Number
  • Currency
  • Date and time
  • Lookup
  • Yes/no
  • Person or group
  • Hyperlink or picture
  • Calculated
  • Task outcome
  • External data
  • Managed metadata

Share point Foundation

  • Share point is the essential solution for the organizations that need a securable, manageable, web-based platform, this share point foundation feature helps to provide basic collaboration features.
  • Share point foundation is downloadable and free, it includes no of features like security, administration and team site collaboration.

Features of share point foundation

  • Effective documentation and task collaboration
  • Better control on the organization business data
  • Reduced implementation and deployment resources
  • Embrace web for collaboration

Share Point hierarchy

                            Farm

                               ↓

                       Web applications

                               ↓

                      Site collections

                               ↓

                             Sites

                               ↓

                             Lists

                               ↓

                         Documents

Scopes

  • Farm-level scope
  • Web app scope
  • Site collection
  •  Subsite

Library

  • Versioning is allowed.
  • Check-In /Out is there.
  • Editing of a document is allowed.
  • We can perform search operation by the title of the document.
  • Able to see the title of the document and can also rename the file.

 List

  •  Versioning is not allowed.
  • Check In /Out are not there.
  • Editing of document is not allowed.
  • We cannot perform search operation by title of document.

 View

     The view is also a list it means that you can turn any list of info into a calendar or at least any data contains dates.

Options available in views are

  • Name
  • Columns to be shown and there will be some default columns
  • Sort
  • Filter
  • Tabular view
  • Group by
  • Totals
  • Style
  • Folders
  • Item limit
  • Mobile

 There are different types of views available are there

  • Standard view
  • Calendar view
  • Datasheet view
  • Gantt view

 Templates available in list/libraries

  • Calendar
  • Category
  • Document library
  • Micro feed
  • Site assets
  • Site pages
  • Style library
  • Announcements
  • Custom list
  • Form library
  • Wiki page library
  • Picture library
  • Links
  • Contacts
  • Promoted links
  • Discussion board
  • Survey

    Calculated formulas for

   Numbers

  Conditional formulas

  Text based

  Date and time

Share point server

  • Share point server provides the extended features of the share point foundation that is the advanced collaboration features.

Features of share point server

  • Web content management
  • Enterprise services
  • Advanced search and business connectivity services
  • Records management
  • Social networking and computing

How to create Data Sheet view

  • Click on create view
  • Select data sheet view
  • In settings select the columns u need to display, sort, filter, number of items to display and can also add a new column

List view threshold

           It restricts the amount of list data that can be queried and displayed. 5000 items are the limit.

  To overcome the list view threshold problem

  • spread the content 
  • create sub folders
  • setup metadata
  • index the columns
  • create filtered views
  • There will be a limit to display number of records
  • adjust default view

otherwise,

  • central admin → app management
  • manage web apps in ribbon
  • select web apps u want to edit
  • select general settings
  • edit list view threshold item limit

Office 365

Office 365 is a fully cloud model of a share point, it is an alternate option for the on-premises data center

Features of office 365

  • This has become a great place for developing the applications without the cost of on premises infrastructure
  • Capability for customizing any of the share point edition like server, foundation and the office 365
  • Office 365 doesn’t provide same services as share point foundation and share point server but consists of more additional featured for developing the applications.
  • Licensing the share point with office 365 is based on the features you want and how much data can be stored and the no of users

how to create a list as a template

  • Open the list you want to save as a template
  • Click settings and then click list settings
  • In the permission and management column, click save list as template.

Roles of SharePoint

        There are 4 different types of roles in Share Point they are

  1. SharePoint Administrator 
    1. The role of share point admin includes the setting up the share point infrastructure with servers and services
    2. He requires the knowledge of both SQL server and windows server
  2. SharePoint Developer
    1. The minimum role of a developer is to develop the custom web parts and components for share point
    2. He requires the knowledge about c#, VB.net, JQuery, HTML, CSS
  3. SharePoint Designer
    1. These are responsible for all the non-programming customization of share point solutions
    2. He requires the knowledge about caml, xml, xslt
  4. SharePoint Architect
    1. He needs to collect, transform, validate and map functional and non-functional requirements
    2. Plan and architect infrastructure integration
    3. Define solution
    4. Map most of solution requirements to existing features of share point

Web Technologies

Create Asp.Net Core Web API in Visual Studio

In this article we are going to learn about “How to create Asp.Net Core Web API in visual studio”.

Steps to create Web API:

1. Open Visual studio, Select New Project.

2. Select Web application project and then select .Net core project.

3. Select Web API project and click OK.

4. The project created with ValuesController by default , Open the ValuesController.cs file and edit the code with your code.

5. Run the solution, You got the following output for the above code.

Web Technologies

Difference between Array, ArrayList and List in C#

Array is a collection of items, where we can store multiple items in a single element. Similarly ArrayList and List can also store items.

The Difference Between Array , ArrayList and List are:

Array: The size of the Array must be declared while declaration.

ArrayList and List: ArrayList and List are dynamic in nature, they don’t require size of the collection while declaration. You can add or delete element in the collection at any time.

What is the Difference between ArrayList and List ?

ArrayList: ArrayList is not type-safe, you can insert any type of data.

List: List is a type-safe, you can insert data only on declared List type.

Uncategorized

Azure Functions

Azure Functions is the server less computing service hosted on public cloud in Microsoft Azure.

Generally traditional application development requires consideration of underlying IT infrastructure. For cloud computing, an IT team must create, monitor and pay for cloud computing instances — regardless of how much work that instance actually does for the business.

Function as a service is the idea behind server less computing, it is to eliminate those infrastructure considerations for the user. With server less, a user can simply create and upload code, and then define the triggers or events that will execute the code. Triggers basically comes from a wide range of sources, including other user’s application or any other cloud services, such as databases, events and notification hubs.

Once a trigger or event occurs, it is mainly cloud provider’s responsibility to load all the code into a suitable execution environment, run the code and to release the compute resources. There will be servers involved, but the user no longer needs to provision or manage compute instances. In addition, rather than pay for those compute instances and other associated resources each month, users pay for server less computing based on the amount of time a function runs in a given billing cycle

Create a function app:

  1. Click on New button found on the upper left-hand corner of the Azure portal, then select Compute > Function App.
  • Use function app settings as specified in table below the image.
  • Click on create to provision & deploy the function app.
  • Click on Notification icon in the upper-right corner of portal and watch

for the Deployment succeeded message

  • Click on Go to resource to view new function app.

Trigger Templates

  • HTTP Trigger
  • Time Trigger
  • Queue Trigger
  • Service Bus Queue Trigger
  • Service Bus Topic Trigger
  • Blob Trigger
  • Event Hub Trigger
  • Cosmos DB Trigger
  • IoT Hub (Event hub)
  • IoT Hub (Service Bus Queue)
  • IoT Hub (Service Bus Topic)
  • Generic webhook
  • GitHub Commenter
  • GitHub webhook
  • Http Get
  • Http Post
  • Http Put
  • Http trigger with parameters
  • Scheduled Mail
  • Send Grid
  • Face Locator
  • Image resizer
  • SAS Token Generator
  • Manual Trigger
  • Application insights Http availability
  • Applications insights power BI
  • Application insights scheduled analytics
  • Application insights scheduled digest
  • External file trigger
  • External table
  • Event grid trigger
  • Http post with azure storage queue

Choose template & select language that you wanted to code with.

Creating an Http Function:

Expand your function app & select the + button next to Functions. If it is your first function in function app, select Custom function. This displays the complete set of templates.

In the search, type http and then choose C# for the HTTP trigger template.

Give a Name for the function Name, choose Function for Authentication level, and then select Create.

Replace the contents of the run.csx file with the following code, then click on Save:

To test the function, click Test at the far right to expand the test tab. Enter the following value for the Request body, and then click on Run.

Generate OpenAPI definition

Now you are ready to generate OpenAPI definition. This definition can be used by other Microsoft technologies, like API Apps, PowerApps and Microsoft Flow, as well as third party developer tools like Postman and many packages.

  1. Select on the verbs that your API supports (in this case POST). This makes the generated API definition cleaner.
    1. On Integrate tab of your new HTTP Trigger function, change Allowed HTTP methods to Selected methods
    1. In the Selected HTTP methods, clear all options except POST, then click Save.
  • Click on your function app name (like function-demo-energy) > Platform features > API definition.
  • On the API definition tab, click on Function.
  • This step enables a suite of OpenAPI options for your function app, including endpoint to host an OpenAPI file from your function app’s domain, an inline copy of the OpenAPI Editor, & an API definition template generator.
  • Click Generate API definition template > Save.

Web Technologies

Is HTML really a basic to build a website

LayMan’s Perceptive

If you are thinking to build a very basic website, and you don’t mind working 100% within the design you purchased, then there’s no reason to learn HTML. HTML is not a true programming language, so it doesn’t result in new ways of thinking that allow you to view the world with an enhanced perspective. For most of the people, knowing HTML is a lot like knowing how to change your own oil, or cook a good meal. There’s value on it, but it probably isn’t necessary.

On another way, if you want a little bit of understanding about your website, it’s a nice skill to have. It’ll let you troubleshoot basic problems, and it’ll let you avoid paying someone every time you need a change that the author of the theme didn’t provide. Just because I take my car to the mechanic when it needs serious work, that doesn’t mean I don’t want to know how to change my brake pads or swap a spark plug.

In my case, I am a mechanic. I design web experiences for a living and I’m happy to let you pay me for it. Even as a professional, I enjoy clients who understand a bit about my craft. It helps me to feel valued and lets us have much more productive discussions. It gives me an extra measure of respect for the client as well.

Knowing HTML as a layperson isn’t necessary, but it is still valuable.

Professional Perceptive

HTML is just the first step into a much larger world. There are lots of questions about it on Quora, do some searching. HTML is the most basic markup. It’s a document full of tags that we target with other languages in order to display and manipulate a design.

So why don’t we all just use Squarespace or Wix and call it a day? Setting aside the question of who would design anything if nobody cared for design, let’s address the idea that designers aren’t necessary to the average person.

Why should I learn how to write well when there are lots of good authors on Amazon?
Why should I eat at a restaurant when I can buy a frozen meal at the market and cook it at home?
For that matter, why bother learning to cook?
Why do people pay for music when it’s already available on the radio?
Why would anyone make a movie when there is so much to see on television?
Why would I want to own a dog when the city has a petting zoo?
Why would I buy a computer if there are literally seven of them at the library for free?

It’s all the same question.

If you aim to be a valuable creative professional, you will have no shortage of work unless you learn just one thing (basic markup) and stop. That won’t get you a job anywhere.

People like to be unique in many, but not all cultures. Even in collective cultures, quality matters to the group. Not everybody in the world wants to drive a Toyota Corolla or a Honda Civic. Your friend is suggesting that, when it comes to websites, they do.

Web Technologies

How to create Asp.Net WebForms in visual studio

In this article we are going to learn about ” How to create asp.net WEBForms in visual studio.”

Steps to create create Asp.Net WebForms:

1. Open Visual Studio.

2. Create New Protect.

3. Select Web Application Projects.

4. Select the .Net Framework and click OK .

5. Select the Empty Template and click OK.

6. Now right click on Project, Click Add—->New Item

7. Search Web Form and Rename the Webform.aspx as HelloWorld.aspx and finally click on Add.

8. Open HelloWorld.aspx and edit your code.

Run the Solution.