public object Delete(UpdateSchool s) { try { TblSchool objuser = db.TblSchools.Where(r => r.SchoolId == s.SchoolId).FirstOrDefault(); if (objuser.Status == 1) { objuser.Status = 0; } else { objuser.Status = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Deactivted" }); } catch (Exception e) { return(new Error() { IsError = true, Message = e.Message }); } }
public object UpdateSchoolInfo(UpdateSchool school) { if (school.SchoolName == null) { return(new Error() { IsError = true, Message = "Requird Name" }); } var data = db.TblSchools.FirstOrDefault(r => r.SchoolId == school.SchoolId); if (data == null) { return(new Error() { IsError = true, Message = "Check School Name" }); } else { data.SchoolId = school.SchoolId; data.SchoolName = school.SchoolName; data.PhoneNo = school.PhoneNo; data.Address = school.Address; data.ContactPerson = school.ContactPerson; data.PayrollTemplateId = school.PayrollTemplateId; data.FeeTemplateId = school.FeeTemplateId; data.LoginTemplateId = school.LoginTemplateId; data.ExamTemplateId = school.ExamTemplateId; data.ModifiedBy = 1; data.ModifiedDate = System.DateTime.Today.Date; data.UserPrefix = school.UserPrefix; data.UserName = school.UserName; data.Password = school.Password; data.BoardId = school.BoardId; data.Language = school.Language; data.LandlineNo = school.LandlineNo; data.EmailId = school.EmailId; data.Designation = school.Designation; data.Logo = school.Logo; data.Banner = school.Banner; data.CreatedBy = data.CreatedBy; data.CreatedDate = data.CreatedDate; // db.TblSchools.Add(data); db.SaveChanges(); return(new Result { IsSucess = true, ResultData = "School Updated!" }); } }
public object UpdateSchool(UpdateSchool obj) { try { SchoolBusiness update = new SchoolBusiness(); var result = update.UpdateSchoolInfo(obj); return(result); } catch (Exception e) { return(new Error() { IsError = true, Message = e.Message }); } }
public object DeleteSchool([FromBody] UpdateSchool PR) { try { SchoolBusiness Objdelete = new SchoolBusiness(); var result = Objdelete.Delete(PR); return(result); } catch (Exception e) { return(new Error() { IsError = true, Message = e.Message }); } }
public object UpdateSchoolInfo(UpdateSchool school) { var httpRequest = HttpContext.Current.Request; var Logo = System.Web.HttpContext.Current.Request.Files["logo"]; var Banner = System.Web.HttpContext.Current.Request.Files["banner"]; var json1 = System.Web.HttpContext.Current.Request.Form["id"]; var json = System.Web.HttpContext.Current.Request.Form["data"]; UpdateSchool info = Newtonsoft.Json.JsonConvert.DeserializeObject <UpdateSchool>(json); if (info.SchoolName == null) { return(new Error() { IsError = true, Message = "Requird Name" }); } //var datas = db.TblSchools.FirstOrDefault(r => r.SchoolName == info.SchoolName); //if (Logo != null) //{ // return new Error() { IsError = true, Message = "Duplicate Entry Not Allowed" }; //} var data = db.TblSchools.Where(r => r.SchoolId == info.SchoolId).FirstOrDefault(); TblSchool obj = new TblSchool(); string UploadBaseUrl = ConfigurationManager.AppSettings["UploadBaseURL"]; string fileLogo = string.Empty; string fileBanner = string.Empty; var filePath = string.Empty; var filePathBanner = string.Empty; var filePathSave = string.Empty; string savePath = string.Empty; var Upload = data.SchoolName; data.SchoolId = info.SchoolId; data.SchoolName = info.SchoolName; data.PhoneNo = info.PhoneNo; data.Address = info.Address; data.ContactPerson = info.ContactPerson; data.PayrollTemplateId = info.PayrollTemplateId; data.FeeTemplateId = info.FeeTemplateId; data.LoginTemplateId = info.LoginTemplateId; data.ExamTemplateId = info.ExamTemplateId; data.ModifiedBy = 1; data.ModifiedDate = System.DateTime.Today.Date; data.UserPrefix = info.UserPrefix; data.UserName = info.UserName; data.Password = info.Password; data.Language = info.Language; data.LandlineNo = info.LandlineNo; data.EmailId = info.EmailId; data.Designation = info.Designation; data.CreatedBy = data.CreatedBy; data.CreatedDate = data.CreatedDate; TblBoardDetail board = new TblBoardDetail(); string[] ids = json1.Split(','); var boarddata = db.TblBoardDetails.Where(r => r.SchoolId == info.SchoolId).FirstOrDefault(); //var getinfo = db.TblBoardDetails.Where(r => r.SchoolId == info.SchoolId && r.BoardId==boarddata.BoardId).FirstOrDefault(); if (boarddata == null) { for (int i = 0; i < ids.Length; i++) { board.SchoolId = data.SchoolId; board.BoardId = Convert.ToInt64(ids[i].Replace("[", "").Replace("]", "")); board.CreatedBy = 1; board.CreatedDate = System.DateTime.Today.Date; board.ModifiedBy = null; board.ModifiedDate = System.DateTime.Today.Date; db.TblBoardDetails.Add(board); db.SaveChanges(); } } else { for (int i = 0; i < ids.Length; i++) { board.SchoolId = boarddata.SchoolId; board.BoardId = Convert.ToInt64(ids[i].Replace("[", "").Replace("]", "")); board.CreatedBy = 1; board.CreatedDate = System.DateTime.Today.Date; board.ModifiedBy = null; board.ModifiedDate = System.DateTime.Today.Date; //db.TblBoardDetails.Add(board); db.SaveChanges(); } } if (httpRequest.Files.Count == 0) { db.SaveChanges(); return(new Result { IsSucess = true, ResultData = "School Updated!" }); } else { var uploaddirc = Path.Combine(HttpContext.Current.Server.MapPath("/"), "SchoolUpload" + ("\\")); if (!Directory.Exists(uploaddirc)) { DirectoryInfo di = Directory.CreateDirectory(uploaddirc); } string paths = "SchoolUpload"; for (int i = 0; i < httpRequest.Files.Count; i++) { var uploadpath = Path.Combine(HttpContext.Current.Server.MapPath("/"), paths, Upload.ToString() + ("\\")); if (!Directory.Exists(uploadpath)) { DirectoryInfo di = Directory.CreateDirectory(uploadpath); } if (i == 0 && Logo != null) { var file = httpRequest.Files[i]; var Guids = Guid.NewGuid(); filePathSave = uploadpath + Guids; filePath = filePathSave + file.FileName; savePath = uploadpath; file.SaveAs(filePath); data.Logo = UploadBaseUrl + paths + ("/") + Upload.ToString() + ("/") + Guids + file.FileName; //string Logo1 = data.Logo.Replace("~/", ""); //data.Logo = Logo1; } else { var file = httpRequest.Files[i]; var GuidsBanner = Guid.NewGuid(); filePathSave = uploadpath + GuidsBanner; filePathBanner = filePathSave + file.FileName; savePath = uploadpath; file.SaveAs(filePathBanner); data.Banner = UploadBaseUrl + paths + ("/") + Upload.ToString() + ("\\") + GuidsBanner + file.FileName; //string Banner1 = data.Banner.Replace("~/", ""); //data.Banner = Banner1; } } db.SaveChanges(); return(new Result { IsSucess = true, ResultData = "School Updated!" }); } }
public async Task <IActionResult> UpdateSchoolAction(UpdateSchool school) { InitialSystemInfo(); //1. Check if have required model if (!ModelState.IsValid) { foreach (var model in ModelState) { if (model.Value.Errors.Count == 0) { continue; } if ((string)TempData["Error"] != "") { TempData["Error"] += "\n"; } if (model.Key == "PostCode") { TempData["Error"] += "Correct postcode is required"; } else { foreach (var error in model.Value.Errors) { TempData["Error"] += error.ErrorMessage; } } } return(RedirectToAction("AddSchool")); } var suburbs = _context.Suburbs .Where(a => a.Name == school.SuburbName && a.PostCode == school.PostCode); var updateRaw = _context.Schools .Where(a => a.Id == school.Id); //2. Check if correct suburb if (!suburbs.Any()) { TempData["Error"] = "Cannot find your suburb. Please select correct one."; return(RedirectToAction("AddSchool")); } //3. Check if correct school id if (!updateRaw.Any()) { TempData["Error"] = "Cannot find your school. Pleas enter correct one."; return(RedirectToAction("AddSchool")); } var duplication = _context.Schools.Where(a => a.SuburbId == suburbs.First().Id&& a.DomainExtension == updateRaw.First().DomainExtension&& a.NormalizedName == updateRaw.First().NormalizedName ); //4. Check duplicate entry for school & campus if (duplication.Any()) { if (duplication.First().Id != school.Id) { TempData["Error"] = "School " + duplication.First().SchoolName + " & Campus " + suburbs.First().Name + " " + suburbs.First().PostCode + " already in database."; return(RedirectToAction("AddSchool")); } } var update = updateRaw.First(); //5. Update school Name //TODO Can make a log in database in later version if (school.SchoolName != update.SchoolName) { if ((string)TempData["Inform"] != "") { TempData["Inform"] += "\n"; } TempData["Inform"] += "School " + update.SchoolName + "'s Name updated" + " from " + update.SchoolName + " to " + school.SchoolName; update.SchoolName = school.SchoolName; update.NormalizedName = school.SchoolName.ToUpper(); _context.Update(update); _context.SaveChanges(); await UpdateRelatedInfo(update.SchoolName, update.DomainExtension); } var finalSchoolName = school.SchoolName; //6. Update domain extension if (school.DomainExtension != update.DomainExtension) { if ((string)TempData["Inform"] != "") { TempData["Inform"] += "\n"; } TempData["Inform"] += "School " + finalSchoolName + "'s Domain Extension updated" + " from " + update.DomainExtension + " to " + school.DomainExtension; update.DomainExtension = school.DomainExtension.ToLower(); _context.Update(update); _context.SaveChanges(); await UpdateRelatedInfo(update.SchoolName, update.DomainExtension); } //7. Update school suburb if (suburbs.First().Id != update.SuburbId) { if ((string)TempData["Inform"] != "") { TempData["Inform"] += "\n"; } var oldSuburbId = update.SuburbId; var newSuburbId = suburbs.First().Id; var oldSuburbName = _context.Suburbs.First(a => a.Id == oldSuburbId).Name; var oldSuburbPostCode = _context.Suburbs.First(a => a.Id == oldSuburbId).PostCode; var newSuburbName = _context.Suburbs.First(a => a.Id == newSuburbId).Name; var newSuburbPostCode = _context.Suburbs.First(a => a.Id == newSuburbId).PostCode; TempData["Inform"] += "School " + finalSchoolName + "'s suburb updated" + " from " + oldSuburbName + " " + oldSuburbPostCode + " to " + newSuburbName + " " + newSuburbPostCode; update.SuburbId = newSuburbId; _context.Update(update); _context.SaveChanges(); } //8. Update school status if (school.Status != update.Status) { if ((string)TempData["Inform"] != "") { TempData["Inform"] += "\n"; } string oldStatus; string newStatus; switch (update.Status) { case SchoolStatus.InUse: oldStatus = "In Use"; break; case SchoolStatus.InRequest: oldStatus = "In Request"; break; default: oldStatus = "No longer used"; break; } switch (school.Status) { case SchoolStatus.InUse: newStatus = "In Use"; break; case SchoolStatus.InRequest: newStatus = "In Request"; break; default: newStatus = "No longer used"; break; } TempData["Inform"] += "School " + finalSchoolName + "'s status updated" + " from " + oldStatus + " to " + newStatus; update.Status = school.Status; _context.Update(update); _context.SaveChanges(); } TempData["Success"] = "School updated successfully"; return(RedirectToAction("AddSchool")); }