How to get or extract the data from different json format in c#, webapi

-
                        JSON
 C# Code
 Model Class
Sample 1:
{
   "EmployeeList": [
      {
         "EmpNumber": "10029597-3",
         "JobCode": "03363-001",
         "Location": "Triad North"
      },
      {
         "EmpNumber": "10029600-1",
         "JobCode": "03363-001",
         "Location": "Triad North"
      },
      {
         "EmpNumber": "10029626-2",
         "JobCode": "03363-001",
         "Location": "Triad North"
      },
      {
         "EmpNumber": "10029629-1",
         "JobCode": "03363-001",
         "Location": "Triad North"
      }
   ]
}
Type 1:

 public void JsonChecker(clsEmployeeList json)
        {
            //Do Something          
        }

public class clsEmployee
{
        public string EmpNumber{ get; set; }
        public string JobCode { get; set; }
        public string Location{ get; set; }
}

public class clsEmployeeList
{
        public List<clsEmployee> EmployeeList { get; set; }
}

Sample 2:
[
   {
      "EmpNumber": "10029597-3",
      "JobCode": "03363-001",
      "Location": "Triad North"
   },
   {
      "EmpNumber": "10029600-1",
      "JobCode": "03363-001",
      "Location": "Triad North"
   },
   {
      "EmpNumber": "10029626-2",
      "JobCode": "03363-001",
      "Location": "Triad North"
   },
   {
      "EmpNumber": "10029629-1",
      "JobCode": "03363-001",
      "Location": "Triad North"
    }
]
Type 1:
 public void JsonChecker(clsEmployee[] json)
        {
            //Do Something 
        }

Type 2:
 public void JsonChecker(List<clsEmployee>  json)
        {
           //Do Something   
        }


public class clsEmployee
{
        public string EmpNumber{ get; set; }
        public string JobCode { get; set; }
        public string Location{ get; set; }
}
Sample 3:
{
   "EmpNumber": "10029597-3",
   "JobCode": "03363-001",
   "Location": "Triad North"
}
Type 1:
public void JsonChecker(clsEmployee json)
        {
           //Do Something    
        }
public class clsEmployee
{
        public string EmpNumber{ get; set; }
        public string JobCode { get; set; }
        public string Location{ get; set; }
}
Sample 4:
{
   "Addresses": [
      "test1",
      "test2",
      "test3",
      "test4"
   ]
}
Type 1:
public void JsonChecker(clsEmployeeList json)
        {
           //Do Something    
        }


 public class clsEmployeeList
 {
        public List <string> Addresses { get; set; }
 }
Sample 5 :
["test1","test2","test3","test4"]
Type 1:
public void JsonChecker(string[] json)
        {
           //Do Something    
        }

Type 2:
public void JsonChecker(List<string> json)
        {
           //Do Something    
        }


Sample 6:
{
   "Name": "Abhinay Kumar",
   "Email": "Test@mail.com",
   "Addresses": [
      "test1",
      "test2",
      "test3",
      "test4"
   ],
   "pfa": [
      {
         "EmpNumber": "10029597-3",
         "JobCode": "03363-001",
         "Location": "Triad North"
      },
      {
         "EmpNumber": "10029600-1",
         "JobCode": "03363-001",
         "Location": "Triad North"
      },
      {
         "EmpNumber": "10029626-2",
         "JobCode": "03363-001",
         "Location": "Triad North"
      },
      {
         "EmpNumber": "10029629-1",
         "JobCode": "03363-001",
         "Location": "Triad North"
      }
   ]
}
Type 1:
public void JsonChecker(clsEmployeeList json)
        {
           //Do Something    
        }
public class clsEmployeeList
{
        public string Name { get; set; }
        public string Email { get; set; }

        public List<string> Addresses { get; set; }
        public List<clsEmployee> pfa { get; set; }
}

public class clsEmployee
 {
        public string EmpNumber{ get; set; }
        public string JobCode { get; set; }
        public string Location{ get; set; }
 }

Popular posts from this blog

How to get the user details, user current level, next level, Rank in sql server

-
 ALTER PROCEDURE [dbo].[SP_GETUSERPROFILE] @UserId int AS BEGIN --checks whether user reported any tweet or not IF EXISTS(SELECT * FROM OnGoingReports WHERE UserId=@UserId) BEGIN --if user already reported tweets then gets the user details and rank select UserId,UserName,Name,UserReportedTweetCount,Rank      from  (select UserId,UserName,Name,UserReportedTweetCount,ROW_NUMBER() OVER(ORDER BY UserReportedTweetCount desc) AS Rank  from      (select ogr.UserId,uc.UserName,Name,Count(*) UserReportedTweetCount from UserCredentials uc       inner join OnGoingReports ogr       on       ogr.UserId=uc.UserId        GROUP BY ogr.UserId,uc.Name,uc.UserName) as TopList ) as UserRank      where UserId=@UserId END ELSE BEGIN --if user not reported any tweets then it get the default value as 0 and rank based on tweets reported select UserId,UserName,Nam...
Read more

How to update the user level when ever user report any tweet in sql

-
  ALTER PROCEDURE [dbo].[SP_UPDATEUSERLEVEL] @Userid INT AS BEGIN Declare @CountOfUserReportedTweets INT Declare @LevelBadgeId INT SET @CountOfUserReportedTweets=(select count(*) from OnGoingReports where UserId=@Userid) --CHECKS WHETHER THE LEVEL EXIST OR NOT IF EXISTS(select Top 1 * from LevelBadge where NoofTweets<=@CountOfUserReportedTweets order by NoofTweets desc) BEGIN --IF LEVEL EXISTS UPDATE OR INSERT WITH THAT LEVEL ID SET @LevelBadgeId=(select Top 1 Id from LevelBadge where NoofTweets<=@CountOfUserReportedTweets order by NoofTweets desc) IF EXISTS(select * from UserLevel where UserId=@Userid) BEGIN UPDATE UserLevel SET LevelBadgeId=@LevelBadgeId WHERE UserId=@Userid END ELSE BEGIN INSERT INTO UserLevel(UserId,LevelBadgeId) VALUES (@Userid,@LevelBadgeId) END END ELSE BEGIN --IF NO LEVEL EXISTS THEN INSERTING DEFAULT LEVEL IF EXISTS(select * from UserLevel where UserId=@Userid) BEGIN UPDATE UserLeve...
Read more

Implement virtualisation in kendo drop down list using jquery ajax in mvc, aspx page

-
virtualization helps to load huge data fastly. $("#abcd").kendoDropDownList({                 filter: "contains",                 dataTextField: "WorkOrderNumber",                 dataValueField: "WorkOrderNumber",                 virtual: {                     itemHeight: 26,                     valueMapper: function (options) {                     }     ...
Read more