public ActionResult LDZCases() { using (CMSDBContext context = new CMSDBContext()) { LDZCas lDZCas = new LDZCas(); return(View(context.LDZCases.ToList())); } }
public ActionResult Edit(LDZCas lDZCas) { using (CMSDBContext context = new CMSDBContext()) { ViewBag.ProviderName = new SelectList(context.Providers.ToList(), "ProviderName", "ProviderName"); //ViewBag.CaseStatus = new SelectList(context.Providers.ToList(), "CaseStatus", "CaseStatus"); context.LDZCases.AddOrUpdate(lDZCas); context.SaveChanges(); } return(RedirectToAction(nameof(LDZCases))); }
private static void InsertToLDZCase(Case cas) { using (CMSDBContext context = new CMSDBContext()) { if (cas != null) { LDZCas cc = new LDZCas(); cc.EmailId = cas.EmailId; cc.IncidentType = cas.IncidentType; cc.IncidentDescription = cas.IncidentDescription; cc.ServiceId = cas.ServiceId; cc.Location = cas.Location; cc.CustomerPhone = cas.CustomerPhone; cc.ProviderName = ""; cc.CaseStatus = "Pending"; context.LDZCases.Add(cc); context.SaveChanges(); } } }