{
"userInjuries": {
"userId": 4,
"userInjuriesList": [
{
"userInjuriesTypeId": 4,
"description": "ABC",
"date": "22/7/1990"
}
]
}
}
How to store this type Format Data in database.I have make a api but i have a problem.Please check me code.
it's me save code.
- [Produces("application/json")]
- [Route("SavePhysicalInjueris")]
- [AllowAnonymous]
- public InjuerisResult SavePhysicalInjueris(Root Json)
- {
- InjuerisResult obj_result = new InjuerisResult();
- try
- {
- if (Json == null)
- {
- obj_result.Response = 2;
- obj_result.ErrorMessage = " object is null";
- }
- else
- {
- List<TblInjurie> list_Injurie = new List<TblInjurie>();
- var JsonData = JsonConvert.SerializeObject((Json));
- UserInjuries list = JsonConvert.DeserializeObject<UserInjuries>(JsonData);
- foreach (var res in list.UserInjuriesList)------ Here I have face a issue (list.UserInjuriesList null)
- {
- var obj_tblInjurie = new TblInjurie();
- obj_tblInjurie.Date = DateTime.ParseExact(res.Date, "d/M/yyyy", CultureInfo.InvariantCulture);
- obj_tblInjurie.Description = res.Description;
- obj_tblInjurie.UserInjuriesTypeId = res.UserInjuriesTypeId;
- obj_tblInjurie.UserId = list.UserId;
- obj_tblInjurie.IsActive = true;
- obj_tblInjurie.UpdatedDate = DateTime.UtcNow;
- list_Injurie.Add(obj_tblInjurie);
- }
- _context.TblInjurie.AddRange(list_Injurie);
- _context.SaveChanges();
- It's me modle code
- [Table("TblInjurie")]
- public class InjerisDetail
- {
-
- public int UserInjuriesTypeId { get; set; }
- public string Description { get; set; }
- public bool? IsActive { get; set; }
- [Column(TypeName = "date")]
- public string Date { get; set; }
- }
- public class UserInjuries
- {
- public int? UserId { get; set; }
- public List<InjerisDetail> UserInjuriesList { get; set; }
- }
- public class Root
- {
- public UserInjuries userInjuries { get; set; }
- }
Please resolve this issue it's important for me.