public ActionResult Create(opr.Models.school school, FormCollection form) { //if (Request["Campus"] == null) //{ // return Json(new { message = "Please select at least one campus to continue", type = "error" }); //} //string campus = Request["Campus"]; //string[] ids = campus.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); //foreach (var id in ids) //{ // school.school_campus.Add(new opr.Models.school_campus() { CampusID = int.Parse(id) }); //} //int sid = SchoolModel.Add(school); //if (sid > 0) //{ // return Json(new { message = "Successfully stored record to database.", type = "success" }); // //return JavaScript("window.location='" + Url.Action("SchoolConfig", "Schools", new { area = "Admin",id=sid }) + "'"); //} //else if (sid == -1) //{ // return Json(new { message = "School name already regstered", type = "error" }); //} //else if (sid == -2) //{ // return Json(new { message = "Username already registered", type = "error" }); //} return(Json(new { message = "unable to store data. please view the log file or contact admin.", type = "error" })); }
public int Edit(school s) { s.LastEditedBy = Helpers.CurrentUser.UserID; s.LastEditedOn = DateTime.Now; database.Entry(s).State = System.Data.Entity.EntityState.Detached; database.Entry(s).State = System.Data.Entity.EntityState.Modified; return(SaveChanges()); }
public int Update(opr.Models.school s) { var old = database.schools.Where(w => w.ID == s.ID).FirstOrDefault(); //database.Entry(old).State = System.Data.Entity.EntityState.Detached; //database.Entry(s).State = System.Data.Entity.EntityState.Modified; if (s.Pasword == null) { s.Pasword = old.Pasword; } if (s.UserName == null) { s.UserName = old.UserName; } old.Address = s.Address; old.Contact = s.Contact; old.Email = s.Email; old.LastEditedBy = Helpers.CurrentUser.UserID; s.LastEditedOn = DateTime.Now; old.Mobile = s.Mobile; old.Name = s.Name; old.Princepal = s.Princepal; old.UserID = s.UserID; if (string.IsNullOrEmpty(s.Website)) { old.Website = ""; } else { old.Website = s.Website; } s.LastEditedBy = Helpers.CurrentUser.UserID; s.LastEditedOn = DateTime.Now; old.IsExpired = s.IsExpired; old.IsActive = s.IsActive; old.Logo = s.Logo; foreach (var c in s.school_campus) { old.school_campus.Add(c); } return(SaveChanges()); }
public int Add(opr.Models.school s) { school schol = database.schools.Where(w => w.Name == s.Name).FirstOrDefault(); if (schol != null) { return(-1); } schol = null; schol = database.schools.Where(w => w.UserName == s.UserName).FirstOrDefault(); //check if school with same username exist var user = database.users.Where(w => w.UserName == s.UserName).FirstOrDefault(); // check if users with same user exist if (schol != null || user != null) { return(-2); } s.UserID = Helpers.CurrentUser.UserID; s.LastEditedBy = Helpers.CurrentUser.UserID; s.LastEditedOn = DateTime.Now; s.Address = string.IsNullOrEmpty(s.Address) ? string.Empty : s.Address; s.Contact = string.IsNullOrEmpty(s.Contact) ? string.Empty : s.Contact; s.Email = string.IsNullOrEmpty(s.Email) ? string.Empty : s.Email; s.Mobile = string.IsNullOrEmpty(s.Mobile) ? string.Empty : s.Mobile; s.Princepal = string.IsNullOrEmpty(s.Princepal) ? string.Empty : s.Princepal; s.Website = string.IsNullOrEmpty(s.Website) ? string.Empty : s.Website; database.schools.Add(s); if (SaveChanges() > 0) { return(s.ID); } else { return(0); } }
public school GetByID(int id) { school s = database.schools.FirstOrDefault(a => a.ID == id); return(s); }
public bool Delete(int id) { school s = database.schools.FirstOrDefault(a => a.ID == id); return(SaveChanges() > 0); }