public JsonResult AddNewQuazi(Quazi quazi) { var quaziInvestigation = context.Quazies.Where(x => x.NidNo == quazi.NidNo) .Select(x => x) .FirstOrDefault(); if (quaziInvestigation != null) { return(new JsonResult { Data = quaziInvestigation, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } else if (quazi != null) { var now = DateTime.Now; var year = Convert.ToString(now.Year); var month = now.Month.ToString("00"); var date = now.Day.ToString("00"); var fomat = year + month + date; var maxId = 0; if (context.Quazies.Any(m => m.RegistrationNo.StartsWith(fomat)) && context.Quazies.Count() != 0) { maxId = context.Quazies .Where(m => m.RegistrationNo.StartsWith(fomat)) .Select(m => m.RegistrationNo.Substring(fomat.Length)).AsEnumerable() .Select(int.Parse) .Max() + 1; } var RegistrationNo = fomat + (maxId.ToString().PadLeft(5, '0')); quazi.RegistrationNo = RegistrationNo; context.Quazies.Add(quazi); context.SaveChanges(); Generator.IsReport = "IsOk"; Generator.Message = "Add new quazi"; } return(new JsonResult { Data = new { Generator.IsReport, Generator.Message }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult UpdateQuaziByQuaziId(Quazi quazi) { int noOfRowUpdated = context.Database.ExecuteSqlCommand($"UPDATE Quazi SET Name='{quazi.Name}', [] = '{quazi.Address}"); context.SaveChanges(); Generator.IsReport = "Ok"; Generator.Message = "Quazi updated successfully"; return(new JsonResult { Data = new { Generator.IsReport, Generator.Message }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public IHttpActionResult AddNewQuazi(Quazi quazi) { return(Ok(_services.AddNewQuazi(quazi).Data)); }