}//Edit // GET: TreatmentOffices/Delete/5 public ActionResult Delete(int?id) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TreatmentOffice treatoff = db.TreatmentOffice.Find(id); if (treatoff == null) { return(HttpNotFound()); } TreatmentOfficeViewModel view = new TreatmentOfficeViewModel(); view.TreatmentOffice_id = treatoff.TreatmentOffice_id; view.TreatmentOfficeName = treatoff.TreatmentOfficeName; view.Address = treatoff.Address; view.Note = treatoff.Note; view.MapPlace = treatoff.MapPlace; view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id; view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1; view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id; view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode; view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice; return(View(view)); }//Delete
}//Edit // GET: TreatmentOffices/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TreatmentOffice treatoff = db.TreatmentOffice.Find(id); if (treatoff == null) { return(HttpNotFound()); } TreatmentOfficeViewModel view = new TreatmentOfficeViewModel(); view.TreatmentOffice_id = treatoff.TreatmentOffice_id; view.TreatmentOfficeName = treatoff.TreatmentOfficeName; view.Address = treatoff.Address; view.Note = treatoff.Note; view.MapPlace = treatoff.MapPlace; view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id; view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1; view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id; view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode; view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice; return(View(view)); }//Delete
public ActionResult DeleteConfirmed(int id) { TreatmentOffice treatmentOffice = db.TreatmentOffice.Find(id); db.TreatmentOffice.Remove(treatmentOffice); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; TreatmentOffice treatmentOffice = db.TreatmentOffice.Find(id); db.TreatmentOffice.Remove(treatmentOffice); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(TreatmentOfficeViewModel model) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; TreatmentOffice trmoff = db.TreatmentOffice.Find(model.TreatmentOffice_id); trmoff.TreatmentOfficeName = model.TreatmentOfficeName; trmoff.Address = model.Address; trmoff.Note = model.Note; //trmoff.MapPlace = model.MapPlace; if (trmoff.Phone == null) { Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.TreatmentOffice = trmoff; db.Phone.Add(pho); } else { Phone phone = trmoff.Phone.FirstOrDefault(); if (phone != null) { phone.PhoneNum_1 = model.PhoneNum_1; } } if (trmoff.PostOffices == null) { PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.TreatmentOffice = trmoff; db.PostOffices.Add(pos); } else { PostOffices po = trmoff.PostOffices.FirstOrDefault(); if (po != null) { po.PostalCode = model.PostalCode; po.PostOffice = model.PostOffice; } } db.SaveChanges(); return(RedirectToAction("Index")); }//Edit
public ActionResult Edit(TreatmentOfficeViewModel model) { TreatmentOffice trmoff = db.TreatmentOffice.Find(model.TreatmentOffice_id); trmoff.TreatmentOfficeName = model.TreatmentOfficeName; trmoff.Address = model.Address; trmoff.Note = model.Note; //trmoff.MapPlace = model.MapPlace; if (trmoff.Phone == null) { Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.TreatmentOffice = trmoff; db.Phone.Add(pho); } else { Phone phone = trmoff.Phone.FirstOrDefault(); if (phone != null) { phone.PhoneNum_1 = model.PhoneNum_1; } } if (trmoff.PostOffices == null) { PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.TreatmentOffice = trmoff; db.PostOffices.Add(pos); } else { PostOffices po = trmoff.PostOffices.FirstOrDefault(); if (po != null) { po.PostalCode = model.PostalCode; po.PostOffice = model.PostOffice; } } db.SaveChanges(); return(RedirectToAction("Index")); }//Edit
public ActionResult Create(TreatmentOfficeViewModel model) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; JohaMeriSQL1Entities db = new JohaMeriSQL1Entities(); TreatmentOffice trmoff = new TreatmentOffice(); trmoff.TreatmentOfficeName = model.TreatmentOfficeName; trmoff.Address = model.Address; trmoff.Note = model.Note; trmoff.MapPlace = model.MapPlace; //byte[] buffer = Encoding.UTF8.GetBytes(csv.ToString()); db.TreatmentOffice.Add(trmoff); Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.TreatmentOffice = trmoff; db.Phone.Add(pho); PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.TreatmentOffice = trmoff; db.PostOffices.Add(pos); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
}//Index //Lisätty 28.3.2017 oma koodi: // GET: TreatmentOffices/Details/5 public ActionResult Details(int?id) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; TreatmentOfficeViewModel model = new TreatmentOfficeViewModel(); JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities(); try { TreatmentOffice treatoff = entities.TreatmentOffice.Find(id); if (treatoff == null) { return(HttpNotFound()); } TreatmentOfficeViewModel view = new TreatmentOfficeViewModel(); view.TreatmentOffice_id = treatoff.TreatmentOffice_id; view.TreatmentOfficeName = treatoff.TreatmentOfficeName; view.Address = treatoff.Address; view.Note = treatoff.Note; view.MapPlace = treatoff.MapPlace; view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id; view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1; view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id; view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode; view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice; model = view; } finally { entities.Dispose(); } return(View(model)); }//details
public ActionResult Create(TreatmentOfficeViewModel model) { JohaMeriSQL1Entities db = new JohaMeriSQL1Entities(); TreatmentOffice trmoff = new TreatmentOffice(); trmoff.TreatmentOfficeName = model.TreatmentOfficeName; trmoff.Address = model.Address; trmoff.Note = model.Note; trmoff.MapPlace = model.MapPlace; //byte[] buffer = Encoding.UTF8.GetBytes(csv.ToString()); db.TreatmentOffice.Add(trmoff); Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.TreatmentOffice = trmoff; db.Phone.Add(pho); PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.TreatmentOffice = trmoff; db.PostOffices.Add(pos); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
}//Index //Lisätty 28.3.2017 oma koodi: // GET: TreatmentOffices/Details/5 public ActionResult Details(int?id) { TreatmentOfficeViewModel model = new TreatmentOfficeViewModel(); JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities(); try { TreatmentOffice treatoff = entities.TreatmentOffice.Find(id); if (treatoff == null) { return(HttpNotFound()); } TreatmentOfficeViewModel view = new TreatmentOfficeViewModel(); view.TreatmentOffice_id = treatoff.TreatmentOffice_id; view.TreatmentOfficeName = treatoff.TreatmentOfficeName; view.Address = treatoff.Address; view.Note = treatoff.Note; view.MapPlace = treatoff.MapPlace; view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id; view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1; view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id; view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode; view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice; model = view; } finally { entities.Dispose(); } return(View(model)); }//details