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"));
}
