public async Task <IActionResult> Edit(int id, [Bind("Id,InfrastructureInfoId,MaleTeacherNum,FemaleTeacherNum,AdditionalTeacher,RecordYear,IsMigrated,MigratedOn,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy,IsDeleted,DeletedOn,DeletedBy")] TeacherInfoVM teacherInfoVM)
{
if (id != teacherInfoVM.Id)
{
return(NotFound());
}
if (teacherInfoVM.RecordYear > DateTime.Now.Year)
{
ModelState.AddModelError("RecordYear", "Record Year Can't be greater than Current Year..");
}
if (teacherInfoVM.MaleTeacherNum < 0)
{
ModelState.AddModelError("MaleTeacherNum", "Negative Value not allowed here.");
}
if (teacherInfoVM.FemaleTeacherNum < 0)
{
ModelState.AddModelError("FemaleTeacherNum", "Negative Value not allowed here.");
}
if (ModelState.IsValid)
{
try
{
var teacherInfoUpdate = await _context.TeacherInfo.FindAsync(id);
teacherInfoUpdate.FemaleTeacherNum = teacherInfoVM.FemaleTeacherNum;
teacherInfoUpdate.MaleTeacherNum = teacherInfoVM.MaleTeacherNum;
teacherInfoUpdate.AdditionalTeacher = teacherInfoVM.AdditionalTeacher;
teacherInfoUpdate.RecordYear = teacherInfoVM.RecordYear;
teacherInfoUpdate.UpdatedOn = DateTime.Now;
_context.Update(teacherInfoUpdate);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeacherInfoExists(teacherInfoVM.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["InfrastructureInfoId"] = new SelectList(_context.InfrastructureInfo, "Id", "EmisCode", teacherInfoVM.InfrastructureInfoId);
return(View(teacherInfoVM));
}
public async Task <IActionResult> EditPV(int id, [Bind("Id,InfrastructureInfoId,MaleTeacherNum,FemaleTeacherNum,AdditionalTeacher,RecordYear,IsMigrated,MigratedOn,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy,IsDeleted,DeletedOn,DeletedBy")] TeacherInfoVM teacherInfoVM)
{
if (id != teacherInfoVM.Id)
{
return(NotFound());
}
if (teacherInfoVM.RecordYear > DateTime.Now.Year)
{
ModelState.AddModelError("RecordYear", "Record Year Can't be greater than Current Year..");
}
if (teacherInfoVM.MaleTeacherNum < 0)
{
ModelState.AddModelError("MaleTeacherNum", "Negative Value not allowed here.");
}
if (teacherInfoVM.FemaleTeacherNum < 0)
{
ModelState.AddModelError("FemaleTeacherNum", "Negative Value not allowed here.");
}
if (ModelState.IsValid)
{
try
{
var teacherInfoUpdate = await _context.TeacherInfo.Include(l => l.InfrastructureInfo).FirstOrDefaultAsync(x => x.InfrastructureInfoId == id);
teacherInfoUpdate.FemaleTeacherNum = teacherInfoVM.FemaleTeacherNum;
teacherInfoUpdate.MaleTeacherNum = teacherInfoVM.MaleTeacherNum;
teacherInfoUpdate.AdditionalTeacher = teacherInfoVM.AdditionalTeacher;
teacherInfoUpdate.RecordYear = teacherInfoVM.RecordYear;
teacherInfoUpdate.UpdatedOn = DateTime.Now;
_context.Update(teacherInfoUpdate);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeacherInfoExists(teacherInfoVM.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok(new ServerResponse(message: "Teacher information Updated successfully", isSuccess: true)));
}
return(BadRequest(new ServerResponse(isSuccess: false, data: ModelState)));
}
public IActionResult Edit(TeacherInfoVM vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
vm.DoEdit(false);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
return(Ok(vm.Entity));
}
}
}
public TeacherInfo ConvertToTeacherInfo(TeacherInfoVM teacherInfoVM)
{
return(new TeacherInfo
{
Id = teacherInfoVM.Id,
InfrastructureInfo = teacherInfoVM.InfrastructureInfo,
InfrastructureInfoId = teacherInfoVM.InfrastructureInfoId,
MaleTeacherNum = teacherInfoVM.MaleTeacherNum,
FemaleTeacherNum = teacherInfoVM.FemaleTeacherNum,
AdditionalTeacher = teacherInfoVM.AdditionalTeacher,
RecordYear = teacherInfoVM.RecordYear,
IsMigrated = teacherInfoVM.IsMigrated,
MigratedOn = teacherInfoVM.MigratedOn,
CreatedOn = teacherInfoVM.CreatedOn,
CreatedBy = teacherInfoVM.CreatedBy,
UpdatedOn = teacherInfoVM.UpdatedOn,
UpdatedBy = teacherInfoVM.UpdatedBy,
IsDeleted = teacherInfoVM.IsDeleted,
DeletedOn = teacherInfoVM.DeletedOn,
DeletedBy = teacherInfoVM.DeletedBy
});
}
public async Task <IActionResult> CreatePV([Bind("Id,InfrastructureInfoId,MaleTeacherNum,FemaleTeacherNum,AdditionalTeacher,RecordYear,IsMigrated,MigratedOn,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy,IsDeleted,DeletedOn,DeletedBy")] TeacherInfoVM teacherInfoVM)
{
bool IsExist = _context.TeacherInfo.Any(X => X.InfrastructureInfoId == teacherInfoVM.InfrastructureInfoId);
if (IsExist == true)
{
ModelState.AddModelError("InfrastructureInfoId", " This School EMIS Code Already Exist.");
return(BadRequest(new ServerResponse(data: ModelState, isSuccess: false)));
}
if (teacherInfoVM.RecordYear > DateTime.Now.Year)
{
ModelState.AddModelError("RecordYear", "Record Year Can't be greater than Current Year..");
return(BadRequest(new ServerResponse(data: ModelState, isSuccess: false)));
}
if (teacherInfoVM.MaleTeacherNum < 0)
{
ModelState.AddModelError("MaleTeacherNum", "Negative Value not allowed here.");
return(BadRequest(new ServerResponse(data: ModelState, isSuccess: false)));
}
if (teacherInfoVM.FemaleTeacherNum < 0)
{
ModelState.AddModelError("FemaleTeacherNum", "Negative Value not allowed here.");
return(BadRequest(new ServerResponse(data: ModelState, isSuccess: false)));
}
if (ModelState.IsValid)
{
teacherInfoVM.CreatedOn = DateTime.Now;
_context.Add(ConvertToTeacherInfo(teacherInfoVM));
await _context.SaveChangesAsync();
return(Ok(new ServerResponse(message: "Teacher information saved successfully")));
}
return(BadRequest(new ServerResponse(data: ModelState, isSuccess: false)));
}
public void CreateTest()
{
TeacherInfoVM vm = _controller.Wtm.CreateVM <TeacherInfoVM>();
TeacherInfo v = new TeacherInfo();
v.PositionId = AddPosition();
v.TitleId = AddTitle();
v.ID = 12;
v.Code = "vGZx";
v.Name = "s1Zly2jQk";
v.CellPhone = "pcPIG";
v.ZipCode = "76SBHKce";
v.EmContacts = "FFIYdZ";
v.EmConPhone = "ELqcr";
v.SchoolInfoId = AddSchoolInfo();
v.MajorInfoId = AddMajorInfo();
v.PhotoId = AddPhoto();
v.GradeClassId = AddGradeClass();
vm.Entity = v;
var rv = _controller.Add(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <TeacherInfo>().Find(v.ID);
Assert.AreEqual(data.ID, 12);
Assert.AreEqual(data.Code, "vGZx");
Assert.AreEqual(data.Name, "s1Zly2jQk");
Assert.AreEqual(data.CellPhone, "pcPIG");
Assert.AreEqual(data.ZipCode, "76SBHKce");
Assert.AreEqual(data.EmContacts, "FFIYdZ");
Assert.AreEqual(data.EmConPhone, "ELqcr");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public async Task <IActionResult> Create([Bind("Id,InfrastructureInfoId,MaleTeacherNum,FemaleTeacherNum,AdditionalTeacher,RecordYear,IsMigrated,MigratedOn,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy,IsDeleted,DeletedOn,DeletedBy")] TeacherInfoVM teacherInfoVM)
{
bool IsExist = _context.TeacherInfo.Any(X => X.InfrastructureInfoId == teacherInfoVM.InfrastructureInfoId);
if (IsExist == true)
{
ModelState.AddModelError("InfrastructureInfoId", " This School EMIS Code Already Exist.");
}
if (teacherInfoVM.RecordYear > DateTime.Now.Year)
{
ModelState.AddModelError("RecordYear", "Record Year Can't be greater than Current Year..");
}
if (teacherInfoVM.MaleTeacherNum < 0)
{
ModelState.AddModelError("MaleTeacherNum", "Negative Value not allowed here.");
}
if (teacherInfoVM.FemaleTeacherNum < 0)
{
ModelState.AddModelError("FemaleTeacherNum", "Negative Value not allowed here.");
}
if (ModelState.IsValid)
{
teacherInfoVM.CreatedOn = DateTime.Now;
_context.Add(ConvertToTeacherInfo(teacherInfoVM));
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["InfrastructureInfoId"] = new SelectList(_context.InfrastructureInfo, "Id", "EmisCode", teacherInfoVM.InfrastructureInfoId);
return(View(teacherInfoVM));
}
public void EditTest()
{
TeacherInfo v = new TeacherInfo();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.PositionId = AddPosition();
v.TitleId = AddTitle();
v.ID = 12;
v.Code = "vGZx";
v.Name = "s1Zly2jQk";
v.CellPhone = "pcPIG";
v.ZipCode = "76SBHKce";
v.EmContacts = "FFIYdZ";
v.EmConPhone = "ELqcr";
v.SchoolInfoId = AddSchoolInfo();
v.MajorInfoId = AddMajorInfo();
v.PhotoId = AddPhoto();
v.GradeClassId = AddGradeClass();
context.Set <TeacherInfo>().Add(v);
context.SaveChanges();
}
TeacherInfoVM vm = _controller.Wtm.CreateVM <TeacherInfoVM>();
var oldID = v.ID;
v = new TeacherInfo();
v.ID = oldID;
v.Code = "Hxs";
v.Name = "fVvJIq";
v.CellPhone = "hkydYmOk6";
v.ZipCode = "wh2";
v.EmContacts = "7CV";
v.EmConPhone = "KZ5J8od";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.PositionId", "");
vm.FC.Add("Entity.TitleId", "");
vm.FC.Add("Entity.ID", "");
vm.FC.Add("Entity.Code", "");
vm.FC.Add("Entity.Name", "");
vm.FC.Add("Entity.CellPhone", "");
vm.FC.Add("Entity.ZipCode", "");
vm.FC.Add("Entity.EmContacts", "");
vm.FC.Add("Entity.EmConPhone", "");
vm.FC.Add("Entity.SchoolInfoId", "");
vm.FC.Add("Entity.MajorInfoId", "");
vm.FC.Add("Entity.PhotoId", "");
vm.FC.Add("Entity.GradeClassId", "");
var rv = _controller.Edit(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <TeacherInfo>().Find(v.ID);
Assert.AreEqual(data.Code, "Hxs");
Assert.AreEqual(data.Name, "fVvJIq");
Assert.AreEqual(data.CellPhone, "hkydYmOk6");
Assert.AreEqual(data.ZipCode, "wh2");
Assert.AreEqual(data.EmContacts, "7CV");
Assert.AreEqual(data.EmConPhone, "KZ5J8od");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
