Save record in database using linq.

6y982Learn iOS Programming

{

"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 list_Injurie = new List();
var JsonData = JsonConvert.SerializeObject((Json));
UserInjuries list = JsonConvert.DeserializeObject(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? 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; }
}
public class UserInjuries
{
public int? UserId { get; set; }
public List UserInjuriesList { get; set; }
}
public class Root
{
public UserInjuries userInjuries { get; set; }
}

Please resolve this issue it's important for me.

5 Replies

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

Rohan Mistry6y ago
Accepted answer
Hello Sourabh Dhiman

Here, No need to "SerializeObject" and "DeserializeObject" JSON object.

also, I have changed in foreach loop.
[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 list_Injurie = new List();
            foreach (var res in Json.userInjuries.UserInjuriesList)
            {
                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();

        }
    }
    catch (Exception ex)
    {
    }
}
6y ago
foreach (var res in Json.UserInjuries.UserInjuriesList)
{

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 = res.UserId;
obj_tblInjurie.IsActive = true;
obj_tblInjurie.UpdatedDate = DateTime.UtcNow;
list_Injurie.Add(obj_tblInjurie);

Rohan Sir it's change code.But UserId null here.Please proper solution provide me.
Rohan Mistry6y ago
Hello Sourabh Dhiman

Use the below code for UserId in foreach loop. because InjerisDetail does not have UserId property.
obj_tblInjurie.UserId = list.UserId;
6y ago
Rohan Sir ur solution run but i have face a problem.

obj_tblInjurie.UserId = res.UserId; ---here userid null
Jenith Thakkar6y ago
Hi
Root Class and UserInjuries class structure is same?

If yes then why you're doing serialize and deserialize it

also in serializing you had set two (( brackets it should be one only