public ActionResult ShowEditTeacher(long TeacherId)
{
List <tblTeacherCategory> TCategorylist = Connection.tblTeacherCategories.ToList();
ViewBag.TeacherCategoryDrpDown = new SelectList(TCategorylist,
"TeacherCategoryId",
"TeacherCategoryName");
List <tblSchool> TSlist = Connection.tblSchools.ToList();
ViewBag.ETSchools = new SelectList(TSlist, "SchoolId", "SchoolName");
TeacherModel TModel = new TeacherModel();
tblTeacher TCtable = Connection.tblTeachers.SingleOrDefault(x => x.TeacherId == TeacherId);
TModel.IsActive = TCtable.IsActive;
TModel.Address1 = TCtable.Address1;
TModel.Address2 = TCtable.Address2;
TModel.Address3 = TCtable.Address3;
TModel.DateOfBirth = TCtable.DateOfBirth;
TModel.Description = TCtable.Description;
TModel.DrivingLicense = TCtable.DrivingLicense;
TModel.EmployeeNo = TCtable.EmployeeNo;
TModel.Gender = TCtable.Gender;
TModel.UserId = TCtable.UserId;
TModel.Name = TCtable.Name;
TModel.Telephone = TCtable.Telephone;
TModel.NIC = TCtable.NIC;
TModel.Passport = TCtable.Passport;
TModel.DrivingLicense = TCtable.DrivingLicense;
TModel.TeacherId = TCtable.TeacherId;
TModel.TeacherCategoryId = TCtable.TeacherCategoryId;
tblTeacherSchool Tstbl = Connection.tblTeacherSchools.SingleOrDefault(
x => x.TeacherId == TeacherId);
TModel.SchoolID = Tstbl.SchoolId;
return(PartialView("EditTeacherDetailsView", TModel));
}
public JsonResult EditTeacherDetails(TeacherModel Model)
{
string result = "Error";
try
{
tblTeacher Newt = Connection.tblTeachers.SingleOrDefault(x => x.TeacherId == Model.TeacherId);
Newt.ModifiedBy = "ADMIN";
Newt.ModifiedDate = DateTime.Now;
Newt.TeacherCategoryId = Model.TeacherCategoryId;
Newt.DateOfBirth = Model.DateOfBirth;
Newt.Address1 = Model.Address1;
Newt.Address2 = Model.Address2;
Newt.Address3 = Model.Address3;
Newt.Telephone = Model.Telephone;
Newt.Gender = Model.Gender;
Newt.Description = Model.Description;
Newt.EmployeeNo = Model.EmployeeNo;
Newt.DrivingLicense = Model.DrivingLicense;
Newt.NIC = Model.NIC;
Newt.Name = Model.Name;
Newt.Passport = Model.Passport;
tblTeacherSchool Tstbl = Connection.tblTeacherSchools.SingleOrDefault(
x => x.TeacherId == Model.TeacherId);
Tstbl.SchoolId = Model.SchoolID;
Connection.SaveChanges();
result = Model.TeacherId.ToString();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Errorlog.ErrorManager.LogError("Teacher Controller @EditTeacherDetails", dbEx);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult CreateTeacher(TeacherModel Model)
{
string result = "Error";
using (SchoolMGTEntitiesConnectionString Connection = new SchoolMGTEntitiesConnectionString())
{
using (var scope = new TransactionScope())
{
try
{
tblTeacher Newt = new tblTeacher();
Newt.CreatedBy = _session.User_Id;
Newt.CreatedDate = DateTime.Now;
Newt.TeacherCategoryId = 0;
Newt.TeacherCategoryId = Model.TeacherCategoryId;
Newt.DateOfBirth = Model.DateOfBirth;
Newt.Address1 = Model.Address1;
Newt.Address2 = Model.Address2;
Newt.Address3 = Model.Address3;
Newt.Telephone = Model.Telephone;
Newt.Gender = Model.Gender;
Newt.Description = Model.Description;
Newt.EmployeeNo = Model.EmployeeNo;
Newt.DrivingLicense = Model.DrivingLicense;
Newt.NIC = Model.NIC;
Newt.Name = Model.Name;
Newt.Passport = Model.Passport;
Newt.UserId = Model.UserId;
Newt.IsActive = "Y";
Connection.tblTeachers.Add(Newt);
Connection.SaveChanges();
var TID = Connection.tblTeachers.Where(b => b.UserId == Model.UserId).FirstOrDefault();
tblTeacherSchool ts = new tblTeacherSchool();
ts.SchoolId = Model.SchoolID;
ts.TeacherCategoryId = TID.TeacherCategoryId;
ts.TeacherId = TID.TeacherId;
ts.CreatedBy = _session.User_Id;
ts.CreatedDate = DateTime.Now;
ts.IsActive = "Y";
tblUser user = new tblUser();
string pass = Encrypt_Decrypt.Encrypt(Model.Password, Password);
user.PersonName = Model.Name;
user.CreatedBy = _session.User_Id;
user.CreatedDate = DateTime.Now;
user.IsActive = "Y";
user.JobDescription = "School Teacher";
user.LoginEmail = Model.LoginEmail;
user.Mobile = Model.Telephone;
user.Password = pass;
user.UserCategory = TeacherCatID;
user.UserId = Model.UserId;
user.SchoolId = Model.SchoolID;
Connection.tblUsers.Add(user);
Connection.tblTeacherSchools.Add(ts);
Connection.SaveChanges();
result = "Success";
scope.Complete();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
//Exception raise = dbEx;
//foreach (var validationErrors in dbEx.EntityValidationErrors)
//{
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// // raise a new exception nesting
// // the current instance as InnerException
// raise = new InvalidOperationException(message, raise);
// }
//}
Errorlog.ErrorManager.LogError("public JsonResult CreateTeacher(TeacherModel Model) @TeacherController", dbEx);
// throw raise;
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
