Store Data in table using linq.

6y745Learn iOS Programming

How tpo send this type format data and save in database in c# web api using linq.

{"injuries":{"injuriesList":

[{"userInjuriesTypeId":4,"description": "Over Wegiht", "date": "22/7/2020"},

{"userInjuriesTypeId":4,"description": "Over Wegiht", "date": "22/7/2020"}],"UserId":4}}

please make a demo code

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jenith Thakkar6y ago
1. static void Main(string[] args)
2. {
3. stringjsonData = @ "{
4. 'FirstName': 'Jignesh', 'LastName': 'Trivedi'
5. }
6. ";
7. var myDetails = JsonConvert.DeserializeObject < MyDetail > (jsonData);
8. Console.WriteLine(string.Concat("Hi ", myDetails.FirstName, " " + myDetails.LastName));
9. Console.ReadLine();
10. }
11. public class MyDetail
12. {
13. public string FirstName {
14. get;
15. set;
16. }
17. public string LastName {
18. get;
19. set;
20. }
21. }
Please check above example

6y ago

Any example please it's most important for me.

Its me model code .

public class InjuerisResult

{

public int Response { get; set; }

public string ErrorMessage { get; set; }

}

public class RootObject

{

public string InjuriesDetails { get; set; }

public List UserInjerisList { get; set; }

}

[Table("TblInjurie")]

public class InjerisDetail

{

public int? UserId { get; set; }

public int UserInjuriesTypeId { get; set; }

public string Description { get; set; }

public bool? IsActive { get; set; }

[Column(TypeName = "date")]

public string Date { get; set; }

}

it's me c# code please help me.

public InjuerisResult SavePhysicalInjueris(InjerisDetail[] obj_parameter)

{

InjuerisResult obj_result = new InjuerisResult();

try

{

if (obj_parameter == null)

{

obj_result.Response = 2;

obj_result.ErrorMessage = " object is null";

}

else

{

List list_Injurie = new List();

obj_parameter.ToList().ForEach(x =>

{

var obj_tblInjurie = new TblInjurie();

obj_tblInjurie.Date = DateTime.ParseExact(x.Date, "d/M/yyyy", CultureInfo.InvariantCulture);

obj_tblInjurie.Description = x.Description;

obj_tblInjurie.UserInjuriesTypeId = x.UserInjuriesTypeId;

obj_tblInjurie.UserId = x.UserId;

obj_tblInjurie.IsActive = true;

obj_tblInjurie.UpdatedDate = DateTime.UtcNow;

list_Injurie.Add(obj_tblInjurie);

});

_context.TblInjurie.AddRange(list_Injurie);

_context.SaveChanges();

}

obj_result.Response = 1;

obj_result.ErrorMessage = "No Error Found";

}

catch (Exception ex)

{

obj_result.Response = 0;

obj_result.ErrorMessage = "Internal Server Error";

}

return obj_result;

}

Jenith Thakkar6y ago

Serialize that json and convert it into sting so you can store that string in database