public string DeleteSchool(long id)
{
try
{
utblSchool model = db.utblSchools.Find(id);
db.utblSchools.Remove(model);
db.SaveChanges();
return("School Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
public string SaveSchool(utblSchool model)
{
try
{
model.UDISECode = Regex.Replace(model.UDISECode.Trim(), @"\s+", " ");
var parSchoolID = new SqlParameter("@SchoolID", model.SchoolID);
var parDistCode = new SqlParameter("@DistCode", model.DistCode);
var parBlockID = new SqlParameter("@BlockID", model.BlockID);
var parUDISECode = new SqlParameter("@UDISECode", model.UDISECode);
var parSchoolName = new SqlParameter("@SchoolName", model.SchoolName);
var parSchoolAddress = new SqlParameter("@SchoolAddress", model.SchoolAddress);
var parTransDate = new SqlParameter("@TransDate", model.TransDate);
var parUserID = new SqlParameter("@UserID", model.UserID);
return(db.Database.SqlQuery <string>("udspSchoolSave @SchoolID, @DistCode, @BlockID,@UDISECode, @SchoolName, @SchoolAddress, @TransDate, @UserID",
parSchoolID, parDistCode, parBlockID, parUDISECode, parSchoolName, parSchoolAddress, parTransDate, parUserID).FirstOrDefault());
}
catch (Exception ex)
{
throw ex;
}
}
