public void DeleteTest()
{
School v = new School();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.SchoolCode = "ece";
v.SchoolName = "QZ8AgkqPf";
context.Set <School>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(SchoolVM));
SchoolVM vm = rv.Model as SchoolVM;
v = new School();
v.ID = vm.Entity.ID;
vm.Entity = v;
_controller.Delete(v.ID.ToString(), null);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(context.Set <School>().Count(), 0);
}
}
public void CreateTest()
{
SchoolVM vm = _controller.Wtm.CreateVM <SchoolVM>();
School v = new School();
v.SchoolCode = "G15";
v.SchoolName = "I8KN8vsf2";
v.SchoolType = Ray.BiliBiliToolPro.AdminWeb.Model.SchoolTypeEnum.PUB;
v.Remark = "cRS";
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 <School>().Find(v.ID);
Assert.AreEqual(data.SchoolCode, "G15");
Assert.AreEqual(data.SchoolName, "I8KN8vsf2");
Assert.AreEqual(data.SchoolType, Ray.BiliBiliToolPro.AdminWeb.Model.SchoolTypeEnum.PUB);
Assert.AreEqual(data.Remark, "cRS");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public ActionResult Create2(SchoolVM vm)
{
if (!ModelState.IsValid)
{
vm.MajorList.ProcessListError(vm.Entity.Majors);
return(PartialView(vm));
}
else
{
if (vm.Entity.Majors == null)
{
vm.Entity.Majors = new System.Collections.Generic.List <Major>();
}
vm.DoAdd();
if (!ModelState.IsValid)
{
vm.MajorList.ProcessListError(vm.Entity.Majors);
vm.DoReInit();
return(PartialView(vm));
}
else
{
return(FFResult().CloseDialog().RefreshGrid());
}
}
}
public School createSchool(SchoolVM model)
{
if (model == null)
{
throw new Exception("no data submitted");
}
var isSchoolAvailable = (from m in _context.School
where m.SchoolID == model.SchoolID select m).FirstOrDefault();
if (isSchoolAvailable != null)
{
throw new Exception("This school is already registered");
}
var newSchool = new School()
{
SchoolName = model.SchoolName
};
_context.School.Add(newSchool);
_context.SaveChanges();
return(newSchool);
}
public async Task <IActionResult> SchoolDetails(string id)
{
var schools = await _schoolClient.GetAllSchools();
SchoolVM school = schools.SingleOrDefault(s => s.Id == id);
return(PartialView(school));
}
public IActionResult AddSchool(SchoolVM schoolVM)
{
var data = _teacherService.AddSchool(schoolVM);
if (data > 0)
{
return(Ok(data));
}
return(BadRequest("Failed"));
}
public IActionResult Put(SchoolVM schoolVM)
{
var data = _schoolService.Update(schoolVM);
if (data > 0)
{
return(Ok(data));
}
return(BadRequest("Failed"));
}
public IActionResult Post(SchoolVM schoolVM)
{
var data = _schoolService.Create(schoolVM);
if (data > 0)
{
return(Ok(data));
}
return(BadRequest("Failed"));
//var status = Ok(data);
}
public async Task <IActionResult> AddSchool([FromForm] SchoolVM newSchool)
{
var result = await _schoolClient.AddSchool(newSchool);
if (result.Status == Status.Error)
{
TempData["addSchoolErrorMessage"] = result.Message;
return(RedirectToAction("AddSchool"));
}
return(RedirectToAction("Index"));
}
public int Create(SchoolVM schoolVM)
{
parameters.Add("Name", schoolVM.SchoolName);
parameters.Add("Address", schoolVM.Address);
parameters.Add("Country", schoolVM.CountryId);
using (var connection = new SqlConnection(_connectionString.Value))
{
var items = connection.Execute("SP_InsertSchool",
parameters, commandType: CommandType.StoredProcedure);
return(items);
}
}
public int Update(SchoolVM schoolVM)
{
parameters.Add("id", schoolVM.SchoolId);
parameters.Add("name", schoolVM.SchoolName);
parameters.Add("address", schoolVM.Address);
using (var connection = new SqlConnection(_connectionString.Value))
{
var items = connection.Execute("SP_UpdateSchool",
parameters, commandType: CommandType.StoredProcedure);
return(items);
}
}
public ActionResult Edit([Bind(Include = "Id,Name")] SchoolVM schoolVm)
{
if (ModelState.IsValid)
{
School school = db.Schools.Find(schoolVm.Id);
if (school == null)
{
return(HttpNotFound());
}
school.Name = schoolVm.Name;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(schoolVm));
}
public void EditTest()
{
School v = new School();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.SchoolCode = "G15";
v.SchoolName = "I8KN8vsf2";
v.SchoolType = Ray.BiliBiliToolPro.AdminWeb.Model.SchoolTypeEnum.PUB;
v.Remark = "cRS";
context.Set <School>().Add(v);
context.SaveChanges();
}
SchoolVM vm = _controller.Wtm.CreateVM <SchoolVM>();
var oldID = v.ID;
v = new School();
v.ID = oldID;
v.SchoolCode = "c4Z";
v.SchoolName = "Fw9Zg";
v.SchoolType = Ray.BiliBiliToolPro.AdminWeb.Model.SchoolTypeEnum.PRI;
v.Remark = "LwU";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.SchoolCode", "");
vm.FC.Add("Entity.SchoolName", "");
vm.FC.Add("Entity.SchoolType", "");
vm.FC.Add("Entity.Remark", "");
var rv = _controller.Edit(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <School>().Find(v.ID);
Assert.AreEqual(data.SchoolCode, "c4Z");
Assert.AreEqual(data.SchoolName, "Fw9Zg");
Assert.AreEqual(data.SchoolType, Ray.BiliBiliToolPro.AdminWeb.Model.SchoolTypeEnum.PRI);
Assert.AreEqual(data.Remark, "LwU");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
public async Task <ResultVM> AddSchool(SchoolVM newSchool)
{
try
{
ResultVM result = await HttpMethods <SchoolVM> .PostAsync(Client, newSchool, "/addSchool");
return(result);
}
catch (Exception e)
{
return(new ResultVM
{
Status = Status.Error,
Message = e.Message
});
}
}
public HttpResponseMessage addSchool(SchoolVM model)
{
try
{
var data = _repo.createSchool(model);
if (data != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { success = true, message = "Created successfully", result = data }));
}
return(Request.CreateResponse(HttpStatusCode.OK, new { success = false, message = "Something went wrong!" }));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { success = false, message = ex.Message }));
}
}
public IActionResult Edit(SchoolVM vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
vm.DoEdit(true);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
return(Ok(vm.Entity));
}
}
}
// GET: Schools/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
School school = db.Schools.Find(id);
if (school == null)
{
return(HttpNotFound());
}
var schoolVm = new SchoolVM {
Id = school.Id, Name = school.Name
};
return(View(schoolVm));
}
public ActionResult Create(SchoolVM vm)
{
if (!ModelState.IsValid)
{
return(PartialView(vm));
}
else
{
vm.DoAdd();
if (!ModelState.IsValid)
{
vm.DoReInit();
return(PartialView(vm));
}
else
{
return(FFResult().CloseDialog().RefreshGrid());
}
}
}
public ActionResult Edit(SchoolVM vm)
{
if (!ModelState.IsValid)
{
return(PartialView(vm));
}
else
{
vm.DoEdit();
if (!ModelState.IsValid)
{
vm.DoReInit();
return(PartialView(vm));
}
else
{
return(FFResult().CloseDialog().RefreshGridRow(vm.Entity.ID));
}
}
}
public void EditTest()
{
School v = new School();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.SchoolCode = "ece";
v.SchoolName = "QZ8AgkqPf";
context.Set <School>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(SchoolVM));
SchoolVM vm = rv.Model as SchoolVM;
v = new School();
v.ID = vm.Entity.ID;
v.SchoolCode = "xLq";
v.SchoolName = "36xgZ9K7";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.SchoolCode", "");
vm.FC.Add("Entity.SchoolName", "");
_controller.Edit(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <School>().FirstOrDefault();
Assert.AreEqual(data.SchoolCode, "xLq");
Assert.AreEqual(data.SchoolName, "36xgZ9K7");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
public ActionResult Create2(SchoolVM vm)
{
if (!ModelState.IsValid)
{
vm.MajorList.ProcessListError(vm.Entity.Majors);
return(PartialView(vm));
}
else
{
vm.DoAdd();
if (!ModelState.IsValid)
{
vm.MajorList.ProcessListError(vm.Entity.Majors);
vm.DoReInit();
return(PartialView(vm));
}
else
{
return(FFResult().CloseDialog().RefreshGrid());
}
}
}
public ActionResult Create([Bind(Include = "Name")] SchoolVM schoolVm)
{
if (ModelState.IsValid)
{
var school = new School
{
Name = schoolVm.Name
};
db.Schools.Add(school);
try
{
db.SaveChanges();
}
catch (Exception e)
{
return(View(schoolVm));
}
return(RedirectToAction("Index"));
}
return(View(schoolVm));
}
public void CreateTest()
{
PartialViewResult rv = (PartialViewResult)_controller.Create();
Assert.IsInstanceOfType(rv.Model, typeof(SchoolVM));
SchoolVM vm = rv.Model as SchoolVM;
School v = new School();
v.SchoolCode = "ece";
v.SchoolName = "QZ8AgkqPf";
vm.Entity = v;
_controller.Create(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <School>().FirstOrDefault();
Assert.AreEqual(data.SchoolCode, "ece");
Assert.AreEqual(data.SchoolName, "QZ8AgkqPf");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
// GET: Schools/Details/5
public ActionResult Details(int?SchoolId)
{
PopulatePartialView();
if (SchoolId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var AccountabilityDetails = (from accountable in db.Accountabilities
join staff in db.Staffs on accountable.OCStaffAssigned equals staff.UserName into accountvm
from person in accountvm.DefaultIfEmpty()
where accountable.SchoolID == SchoolId
select new { accountable, person }).ToList();
AccountabilityStaffVM accountStaffVM = new AccountabilityStaffVM();
foreach (var value in AccountabilityDetails)
{
//Accountability Model Information
if (!(value.accountable == null))
{
accountStaffVM.ID = value.accountable.ID;
accountStaffVM.SchoolID = value.accountable.SchoolID;
}
//Person Model Information
if (!(value.person == null))
{
accountStaffVM.EmployeeID = value.person.EmployeeID;
accountStaffVM.Region = value.person.Region;
accountStaffVM.FirstName = value.person.FirstName;
accountStaffVM.LastName = value.person.LastName;
accountStaffVM.Extension = value.person.Extension;
accountStaffVM.Title = value.person.Title;
}
}
var schoolDetails = (from school in db.Schools
join contacts in db.Contacts on school.ContactID equals contacts.ID into schoolvm
from contact in schoolvm.DefaultIfEmpty()
where school.ID == SchoolId
select new { school, contact }).ToList();
if (schoolDetails == null)
{
return(HttpNotFound());
}
SchoolVM schoolVM = new SchoolVM();
foreach (var value in schoolDetails)
{
//Schools Model Information
if (!(value.school == null))
{
schoolVM.ID = value.school.ID;
schoolVM.SchoolName = value.school.SchoolName;
schoolVM.Address = value.school.Address;
schoolVM.City = value.school.City;
schoolVM.State = value.school.State;
schoolVM.Zip = value.school.Zip;
schoolVM.MainPhone = String.IsNullOrEmpty(value.school.MainPhone) ? "" : String.Format("{0:(###) ###-####}", double.Parse(value.school.MainPhone));
schoolVM.Website = value.school.Website;
schoolVM.NumberOfStudents = value.school.NumberOfStudents;
schoolVM.DistrictID = value.school.DistrictID;
schoolVM.ImageLink = value.school.ImageLink;
}
//Contacts Model Information
if (!(value.contact == null))
{
schoolVM.ContactFirstName = value.contact.ContactFirstName;
schoolVM.ContactLastName = value.contact.ContactLastName;
schoolVM.ContactTitle = value.contact.ContactTitle;
schoolVM.ContactPhone = String.IsNullOrEmpty(value.school.MainPhone) ? "" : String.Format("{0:(###) ###-####}", double.Parse(value.contact.ContactPhone));
schoolVM.ContactEmail = value.contact.ContactEmail;
schoolVM.PrimaryOrSecondary = value.contact.PrimaryOrSecondary;
schoolVM.Coordinator = value.contact.Coordinator;
schoolVM.ContactID = value.contact.ID;
}
}
List <SchoolVM> data = new List <SchoolVM>();
data.Add(schoolVM);
return(View(data));
}
public int Create(SchoolVM schoolVM)
{
return(schoolRepository.Create(schoolVM));
}
public int Update(SchoolVM schoolVM)
{
return(schoolRepository.Update(schoolVM));
}
public int AddSchool(SchoolVM schoolVM)
{
return(teacherRepository.AddSchool(schoolVM));
}
