// GET: PostOffices public ActionResult Index() { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; List <PostOffices> model = new List <PostOffices>(); JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities(); try { List <PostOffices> postoff = entities.PostOffices.ToList(); // muodostetaan näkymämalli tietokannan rivien pohjalta foreach (PostOffices post in postoff) { PostOffices view = new PostOffices(); view.Post_id = post.Post_id; view.PostalCode = post.PostalCode; view.PostOffice = post.PostOffice; model.Add(view); } } finally { entities.Dispose(); } return(View(model)); }//Index
// GET: PostOffices/Edit/5 public ActionResult Edit(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)); } PostOffices postOffices = db.PostOffices.Find(id); if (postOffices == null) { return(HttpNotFound()); } ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id); ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id); return(View(postOffices)); }
public ActionResult DeleteConfirmed(int id) { PostOffices postOffices = db.PostOffices.Find(id); db.PostOffices.Remove(postOffices); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(CustomerViewModel model) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; JohaMeriSQL1Entities db = new JohaMeriSQL1Entities(); Customer cus = new Customer(); cus.FirstName = model.FirstNameA; cus.LastName = model.LastNameA; cus.Identity = model.Identity; cus.Address = model.Address; cus.Email = model.Email; cus.Notes = model.Notes; cus.CreatedAt = DateTime.Now; cus.LastModifiedAt = DateTime.Now; cus.DeletedAt = model.DeletedAt; cus.Active = model.Active; cus.Permission = model.Permission; db.Customer.Add(cus); User usr = new User(); usr.UserIdentity = model.UserIdentity; usr.Password = "******"; usr.Customer = cus; ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null); db.User.Add(usr); Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.Customer = cus; db.Phone.Add(pho); PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.Customer = cus; db.PostOffices.Add(pos); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
public ActionResult DeleteConfirmed(int id) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; PostOffices postOffices = db.PostOffices.Find(id); db.PostOffices.Remove(postOffices); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(PersonnelViewModel model) { JohaMeriSQL1Entities db = new JohaMeriSQL1Entities(); Personnel per = new Personnel(); per.FirstName = model.FirstNameP; per.LastName = model.LastNameP; per.Identity = model.Identity; per.Email = model.Email; per.Notes = model.Notes; per.CreatedAt = DateTime.Now; per.LastModifiedAt = DateTime.Now; per.DeletedAt = model.DeletedAt; per.Active = model.Active; db.Personnel.Add(per); ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null); User usr = new User(); usr.UserIdentity = model.UserIdentity; usr.Password = "******"; usr.Personnel = per; db.User.Add(usr); Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.Personnel = per; db.Phone.Add(pho); PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.Personnel = per; db.PostOffices.Add(pos); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
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
}//Index // GET: PostOffices/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PostOffices postOffices = db.PostOffices.Find(id); if (postOffices == null) { return(HttpNotFound()); } return(View(postOffices)); }
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
}//Index // GET: PostOffices/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 ?? ""; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PostOffices postOffices = db.PostOffices.Find(id); if (postOffices == null) { return(HttpNotFound()); } return(View(postOffices)); }
public ActionResult Create([Bind(Include = "Post_id,PostalCode,PostOffice,Personnel_id,Phone_id,Customer_id,Reservation_id,Student_id,Treatment_id,TreatmentOffice_id,TreatmentPlace_id,User_id")] PostOffices postOffices) { if (ModelState.IsValid) { db.PostOffices.Add(postOffices); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id); ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id); return(View(postOffices)); }
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
public ActionResult Create([Bind(Include = "Post_id,PostalCode,PostOffice,Personnel_id,Phone_id,Customer_id,Reservation_id,Student_id,Treatment_id,TreatmentOffice_id,TreatmentPlace_id,User_id")] PostOffices postOffices) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; if (ModelState.IsValid) { db.PostOffices.Add(postOffices); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id); ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id); return(View(postOffices)); }
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
// GET: PostOffices/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PostOffices postOffices = db.PostOffices.Find(id); if (postOffices == null) { return(HttpNotFound()); } ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id); ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id); ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id); return(View(postOffices)); }
public ActionResult Edit(StudentViewModel model) { Studentx stu = db.Studentx.Find(model.Student_id); stu.FirstName = model.FirstNameH; stu.LastName = model.LastNameH; stu.Identity = model.Identity; stu.Address = model.Address; stu.Email = model.Email; stu.EnrollmentDateIN = model.EnrollmentDateIN; stu.EnrollmentDateOUT = model.EnrollmentDateOUT; stu.EnrollmentDateOFF = model.EnrollmentDateOFF; stu.Notes = model.Notes; stu.CreatedAt = model.CreatedAt; stu.LastModifiedAt = DateTime.Now; stu.DeletedAt = model.DeletedAt; stu.Active = model.Active; ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", stu.Student_id); stu.Information = model.Information; //ViewBag.User_id = new SelectList(db.User, "User_id", "UserIdentity"); if (stu.User == null) { User usr = new User(); usr.UserIdentity = model.UserIdentity; usr.Password = "******"; usr.Studentx = stu; db.User.Add(usr); } else { User user = stu.User.FirstOrDefault(); if (user != null) { user.UserIdentity = model.UserIdentity; } } ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null); if (stu.Phone == null) { Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.Studentx = stu; db.Phone.Add(pho); } else { Phone pho = stu.Phone.FirstOrDefault(); if (pho != null) { pho.PhoneNum_1 = model.PhoneNum_1; } } if (stu.PostOffices == null) { PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.Studentx = stu; db.PostOffices.Add(pos); } else { PostOffices po = stu.PostOffices.FirstOrDefault(); if (po != null) { po.PostalCode = model.PostalCode; po.PostOffice = model.PostOffice; } } int studentgroupId = int.Parse(model.StudentGroupName); if (studentgroupId > 0) { StudentGroup stg = db.StudentGroup.Find(studentgroupId); stu.StudentGroup_id = stg.StudentGroup_id; } ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null); db.SaveChanges(); return(RedirectToAction("Index")); }//edit
public ActionResult Edit(PersonnelViewModel model) { Personnel per = db.Personnel.Find(model.Personnel_id); per.FirstName = model.FirstNameP; per.LastName = model.LastNameP; per.Identity = model.Identity; per.Email = model.Email; per.Notes = model.Notes; per.CreatedAt = model.CreatedAt; per.LastModifiedAt = model.LastModifiedAt; per.DeletedAt = model.DeletedAt; per.Active = model.Active; if (per.User == null) { User usr = new User(); usr.UserIdentity = model.UserIdentity; usr.Password = "******"; usr.Personnel = per; db.User.Add(usr); } else { User user = per.User.FirstOrDefault(); if (user != null) { user.UserIdentity = model.UserIdentity; } } ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null); if (per.Phone == null) { Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.Personnel = per; db.Phone.Add(pho); } else { Phone phone = per.Phone.FirstOrDefault(); if (phone != null) { phone.PhoneNum_1 = model.PhoneNum_1; } } if (per.PostOffices == null) { PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.Personnel = per; db.PostOffices.Add(pos); } else { PostOffices po = per.PostOffices.FirstOrDefault(); if (po != null) { po.PostalCode = model.PostalCode; po.PostOffice = model.PostOffice; } } db.SaveChanges(); return(RedirectToAction("Index")); }//edit
public ActionResult Create(StudentViewModel model) { JohaMeriSQL1Entities db = new JohaMeriSQL1Entities(); Studentx stu = new Studentx(); stu.FirstName = model.FirstNameH; stu.LastName = model.LastNameH; stu.Identity = model.Identity; stu.Address = model.Address; stu.Email = model.Email; stu.Notes = model.Notes; stu.EnrollmentDateIN = model.EnrollmentDateIN; stu.EnrollmentDateOUT = model.EnrollmentDateOUT; stu.EnrollmentDateOFF = model.EnrollmentDateOFF; stu.CreatedAt = DateTime.Now; stu.LastModifiedAt = DateTime.Now; stu.DeletedAt = model.DeletedAt; stu.Active = model.Active; stu.Information = model.Information; db.Studentx.Add(stu); User usr = new User(); usr.UserIdentity = model.UserIdentity; usr.Password = "******"; usr.Studentx = stu; db.User.Add(usr); Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.Studentx = stu; db.Phone.Add(pho); PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.Studentx = stu; db.PostOffices.Add(pos); // etsitään StudentGroup-rivi kannasta valitun nimen perusteella int studentgroupId = int.Parse(model.StudentGroupName); if (studentgroupId > 0) { StudentGroup stg = db.StudentGroup.Find(studentgroupId); stu.StudentGroup_id = stg.StudentGroup_id; } ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null); ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null); ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", null); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
public ActionResult Edit(CustomerViewModel model) { string username = User.Identity.Name; string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? ""; Customer cus = db.Customer.Find(model.Customer_id); cus.FirstName = model.FirstNameA; cus.LastName = model.LastNameA; cus.Identity = model.Identity; cus.Address = model.Address; cus.Email = model.Email; cus.Notes = model.Notes; cus.CreatedAt = model.CreatedAt; cus.LastModifiedAt = DateTime.Now; cus.DeletedAt = model.DeletedAt; cus.Active = model.Active; cus.Permission = model.Permission; if (cus.User == null) { User usr = new User(); usr.UserIdentity = model.UserIdentity; usr.Password = "******"; usr.Customer = cus; db.User.Add(usr); } else { User user = cus.User.FirstOrDefault(); if (user != null) { user.UserIdentity = model.UserIdentity; } } if (cus.Phone == null) { Phone pho = new Phone(); pho.PhoneNum_1 = model.PhoneNum_1; pho.Customer = cus; db.Phone.Add(pho); } else { Phone phone = cus.Phone.FirstOrDefault(); if (phone != null) { phone.PhoneNum_1 = model.PhoneNum_1; } } if (cus.PostOffices == null) { PostOffices pos = new PostOffices(); pos.PostalCode = model.PostalCode; pos.PostOffice = model.PostOffice; pos.Customer = cus; db.PostOffices.Add(pos); } else { PostOffices po = cus.PostOffices.FirstOrDefault(); if (po != null) { po.PostalCode = model.PostalCode; po.PostOffice = model.PostOffice; } } ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null); db.SaveChanges(); return(RedirectToAction("Index")); }//edit