public ActionResult Create()
{
var disp = new vmCourse();
using (DeptManager)
{
using (InstManager)
{
using (PeopleManager)
{
using (TBManager)
{
disp.Departments = DeptManager.GetAllDepartments().ToList();
var inst = InstManager.GetAllInstructors();
var people = PeopleManager.GetAllPeople();
var instr = from instructor in inst
join person in people on instructor.PersonID equals person.ID
select new KeyValuePair <int, string>(instructor.ID, string.Format("{0}, {1}", person.LastName, person.FirstMidName));
disp.Instructors = instr.ToDictionary(t => t.Key, t => t.Value);
disp.Textbooks = TBManager.GetAllTextbooks().ToList();
return(View(disp));
}
}
}
}
}
//
// GET: /Instructor/Delete/5
public ActionResult Delete(int id)
{
using (DeptManager)
{
using (InstManager)
{
using (PeopleManager)
{
var item = InstManager.GetInstructorbyID(id);
var disp = Mapper.Map <vmInstructor>(item);
if (disp != null)
{
disp.Person = Mapper.Map <vmPerson>(PeopleManager.GetPersonbyID(item.PersonID));
disp.Department = Mapper.Map <vmDepartment>(DeptManager.GetDepartmentbyID(item.DepartmentID));
}
else
{
disp = new vmInstructor();
ModelState.AddModelError("", "Failed to load details for requested object");
}
return(View(disp));
}
}
}
}
public ActionResult Edit(int id)
{
using (DeptManager)
{
using (InstManager)
{
using (PeopleManager)
{
var item = InstManager.GetInstructorbyID(id);
var disp = Mapper.Map <vmInstructor>(item);
if (disp != null)
{
disp.Person = Mapper.Map <vmPerson>(PeopleManager.GetPersonbyID(item.PersonID));
disp.Departments = DeptManager.GetAllDepartments().OrderBy(d => d.Name).ToList();
}
else
{
disp = new vmInstructor();
ModelState.AddModelError("", "Failed to load details fo requested item.");
}
return(View(disp));
}
}
}
}
/// <summary>
/// true a>b
/// </summary>
/// <param name="tenantId"></param>
/// <param name="deptA"></param>
/// <param name="deptB"></param>
/// <returns></returns>
private bool compareDeptLevel(int tenantId, int deptA, int deptB)
{
var deptManager = new DeptManager();
var childs = deptManager.GetChildDepts(tenantId, deptA);
return(childs.Any(p => p == deptB));
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (lvwDepts.SelectedItems != null && lvwDepts.SelectedItems.Count != 0)
{
if (!IsList)
{
if (objUIRights.DeleteRight)
{
DialogResult dr = new DialogResult();
dr = MessageBox.Show("Do You Really Want to Delete Record ?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (dr == DialogResult.Yes)
{
Department objDept = new Department();
objDept = DeptManager.GetItem(Convert.ToInt32(lvwDepts.SelectedItems[0].Name));
DeptManager.Delete(objDept);
lvwDepts.Items.Remove(lvwDepts.SelectedItems[0]);
}
}
else
{
throw new Exception("Not Authorised.");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void modifyToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (lvwDepts.SelectedItems != null && lvwDepts.SelectedItems.Count != 0)
{
if (IsList)
{
btnOk_Click(sender, e);
}
else
{
if (objUIRights.ModifyRight)
{
Department objDept;
frmDeptProp objFrmProp;
objDept = DeptManager.GetItem(Convert.ToInt32(lvwDepts.SelectedItems[0].Name));
objFrmProp = new frmDeptProp(objDept, objCurUser);
objFrmProp.MdiParent = this.MdiParent;
objFrmProp.Entry_DataChanged += new frmDeptProp.DeptUpdateHandler(Entry_DataChanged);
objFrmProp.Show();
}
else
{
throw new Exception("Not Authorised.");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public ServiceFixture()
{
var admin = new AdminContext(new DbContextOptions <AdminContext>());
ILogger <DeptManager> logger = new LoggerTest();
Sut = new DeptManager(admin, logger);
}
public ActionResult Create()
{
using (DeptManager)
{
var disp = new vmInstructor();
disp.Departments = DeptManager.GetAllDepartments().OrderBy(d => d.Name).ToList();
return(View(disp));
}
}
public ActionResult Index()
{
using (DeptManager)
{
var disp = new vmInstructorSearch();
disp.Departments = DeptManager.GetAllDepartments().ToList();
return(View(disp));
}
}
public ActionResult Index()
{
using (DeptManager)
{
var items = DeptManager.GetAllDepartments().OrderBy(d => d.Name);
var disp = Mapper.Map <IEnumerable <vmDepartment> >(items);
return(View(disp));
}
}
public ActionResult Edit(int id)
{
using (DeptManager)
{
var disp = Mapper.Map <vmDepartment>(DeptManager.GetDepartmentbyID(id));
if (disp == null)
{
disp = new vmDepartment();
ModelState.AddModelError("", "Failed to load details for requested object");
}
return(View(disp));
}
}
public ActionResult Edit(vmCourse course)
{
try
{
if (ModelState.IsValid)
{
using (CoursesManager)
{
var item = CoursesManager.GetCoursebyID(course.ID);
item.Credits = course.Credits;
item.DepartmentID = course.DepartmentID;
item.Description = course.Description;
item.InstructorID = course.InstructorID;
item.TextBookID = course.TextBookID;
item.Title = course.Title;
var success = CoursesManager.UpdateCourse(item);
if (success)
{
return(RedirectToAction("Details", new { id = item.ID }));
}
throw new DataException("Failed to save " + course.Title + ". Please try again");
}
}
}
catch (DataException ex)
{
ModelState.AddModelError("", ex.Message);
}
using (DeptManager)
{
using (InstManager)
{
using (PeopleManager)
{
using (TBManager)
{
course.Departments = DeptManager.GetAllDepartments().ToList();
var inst = InstManager.GetAllInstructors();
var people = PeopleManager.GetAllPeople();
var instr = from instructor in inst
join person in people on instructor.PersonID equals person.ID
select new KeyValuePair <int, string>(instructor.ID, string.Format("{0}, {1}", person.LastName, person.FirstMidName));
course.Instructors = instr.ToDictionary(t => t.Key, t => t.Value);
course.Textbooks = TBManager.GetAllTextbooks().ToList();
}
}
}
}
return(View(course));
}
public ActionResult Edit(vmInstructor inst)
{
try
{
if (ModelState.IsValid)
{
using (InstManager)
{
using (PeopleManager)
{
var person = PeopleManager.GetPersonbyID(inst.PersonID);
person.FirstMidName = inst.Person.FirstMidName;
person.LastName = inst.Person.LastName;
var success = PeopleManager.UpdatePerson(person);
if (success)
{
var item = InstManager.GetInstructorbyID(inst.ID);
item.PersonID = person.ID;
item.HireDate = inst.HireDate;
item.DepartmentID = inst.DepartmentID;
success = InstManager.UpdateInstructor(item);
if (success)
{
return(RedirectToAction("Details", new { id = item.ID }));
}
else
{
throw new DataException("Unable to save Instructor. Please try again.");
}
}
else
{
throw new DataException("Unable to save person. Please try again.");
}
}
}
}
}
catch (DataException ex)
{
ModelState.AddModelError("", ex.Message);
}
using (DeptManager)
{
inst.Departments = DeptManager.GetAllDepartments().OrderBy(d => d.Name).ToList();
}
return(View(inst));
}
public ActionResult Create(vmInstructor inst)
{
try
{
if (ModelState.IsValid)
{
using (InstManager)
{
using (PeopleManager)
{
var person = Mapper.Map <Person>(inst.Person);
var success = PeopleManager.AddPerson(person);
if (success)
{
var item = Mapper.Map <Instructor>(inst);
item.PersonID = person.ID;
success = InstManager.AddInstructor(item);
if (success)
{
return(RedirectToAction("Details", new { id = item.ID }));
}
else
{
throw new DataException("Unable to save Instructor. Please try again.");
}
}
else
{
throw new DataException("Unable to save person. Please try again.");
}
}
}
}
}
catch (DataException ex)
{
ModelState.AddModelError("", ex.Message);
}
using (DeptManager)
{
inst.Departments = DeptManager.GetAllDepartments().OrderBy(d => d.Name).ToList();
}
return(View(inst));
}
public async Task <ActionResult> Edit(DeptManager dept_manager)
{
try
{
if (ModelState.IsValid)
{
await _deptManagerService.UpdateDeptManager(dept_manager);
return(RedirectToAction("Index"));
}
var departments = Common.GetDepartments(_departmentService);
ViewBag.DepartmentList = departments;
var employees = Common.GetEmployees(_employeeService);
ViewBag.EmployeeList = employees;
return(View(dept_manager));
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
int index = ex.InnerException.Message.IndexOf("UC_");
string message = ex.InnerException.Message;
if (index > 0)
{
message = message.Substring(0, index - 1);
}
ModelState.AddModelError("Error", "There was an error during: " + message);
}
else
{
ModelState.AddModelError("Error", "There was an error during: " + ex.ToString());
}
var departments = Common.GetDepartments(_departmentService);
ViewBag.DepartmentList = departments;
var employees = Common.GetEmployees(_employeeService);
ViewBag.EmployeeList = employees;
return(View(dept_manager));
}
}
private void FillList()
{
DepartmentList objList = new DepartmentList();
objList = DeptManager.GetList("");
lvwDepts.Items.Clear();
if (objList != null)
{
foreach (Department objDept in objList)
{
ListViewItem objLvwItem = new ListViewItem();
objLvwItem.Name = Convert.ToString(objDept.DBID);
objLvwItem.Text = Convert.ToString(objDept.DeptName);
objLvwItem.SubItems.Add(Convert.ToString(objDept.Description));
lvwDepts.Items.Add(objLvwItem);
}
}
}
public ActionResult Edit(vmDepartment dept)
{
try
{
using (DeptManager)
{
var item = DeptManager.GetDepartmentbyID(dept.ID);
item.Name = dept.Name;
var success = DeptManager.UpdateDepartment(item);
if (success)
{
return(RedirectToAction("Index"));
}
throw new DataException("Failed to save " + dept.Name + ". Please try again");
}
}
catch (DataException ex)
{
ModelState.AddModelError("", ex.Message);
}
return(View(dept));
}
public ActionResult Edit(int id)
{
using (DeptManager)
{
using (InstManager)
{
using (PeopleManager)
{
using (TBManager)
{
using (CoursesManager)
{
var disp = Mapper.Map <vmCourse>(CoursesManager.GetCoursebyID(id));
if (disp != null)
{
disp.Departments = DeptManager.GetAllDepartments().ToList();
var inst = InstManager.GetAllInstructors();
var people = PeopleManager.GetAllPeople();
var instr = from instructor in inst
join person in people on instructor.PersonID equals person.ID
select new KeyValuePair <int, string>(instructor.ID, string.Format("{0}, {1}", person.LastName, person.FirstMidName));
disp.Instructors = instr.ToDictionary(t => t.Key, t => t.Value);
disp.Textbooks = TBManager.GetAllTextbooks().ToList();
}
else
{
disp = new vmCourse();
ModelState.AddModelError("", "Failed to load details for requested object");
}
return(View(disp));
}
}
}
}
}
}
public ActionResult Details(int id)
{
using (DeptManager)
{
using (InstManager)
{
using (PeopleManager)
{
using (TBManager)
{
var item = InstManager.GetInstructorbyID(id);
var disp = Mapper.Map <vmInstructor>(item);
if (disp != null)
{
disp.Person = Mapper.Map <vmPerson>(PeopleManager.GetPersonbyID(item.PersonID));
disp.Department = Mapper.Map <vmDepartment>(DeptManager.GetDepartmentbyID(item.DepartmentID));
disp.Textbooks = TBManager.GetAllTextbooks().ToList();
var books = InstManager.FindInstructorBooks(i => i.InstructorID == id).Select(i => i.TextBookID);
foreach (var b in books)
{
var t = TBManager.GetTextbookbyID(b);
if (t != null)
{
disp.InstructorTextbooks.Add(Mapper.Map <vmTextbook>(t));
}
}
}
else
{
disp = new vmInstructor();
ModelState.AddModelError("", "Failed to load details for requested item.");
}
return(View(disp));
}
}
}
}
}
public ActionResult Create(vmDepartment dept)
{
try
{
if (ModelState.IsValid)
{
using (DeptManager)
{
var item = Mapper.Map <Department>(dept);
var success = DeptManager.AddDepartment(item);
if (success)
{
return(RedirectToAction("Index"));
}
throw new DataException("Failed to save " + dept.Name + " Department. Please try again.");
}
}
}
catch (DataException ex)
{
ModelState.AddModelError("", ex.Message);
}
return(View(dept));
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
bool flgApplyEdit;
flgApplyEdit = DeptManager.Save(objDept, objCurUser);
if (flgApplyEdit)
{
// instance the event args and pass it value
DeptUpdateEventArgs args = new DeptUpdateEventArgs(objDept.DBID, objDept.DeptName, objDept.Description);
// raise event wtth updated
if (Entry_DataChanged != null)
{
if (this.IsNew)
{
Entry_DataChanged(this, args, DataEventType.INSERT_EVENT);
}
else
{
Entry_DataChanged(this, args, DataEventType.UPDATE_EVENT);
}
}
this.Close();
}
else
{
MessageBox.Show("Record Not Saved.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public ActionResult GetDepts()
{
return(Json(DeptManager.GetDepts(), JsonRequestBehavior.AllowGet));
}
private PostInfo InitialData()
{
IDeptManager target = new DeptManager();
DeptInfo dept = target.Get(new Guid("23efb19f-9f75-42d8-a7ea-673995800330"));
PostInfo info = new PostInfo();
info.Dept = dept;
info.PostNo = "1000";
info.Name = "营业员";
info.SortNO = 1;
return info;
}
public ActionResult Edit(Dept de)
{
return(Json(DeptManager.Edit(de), JsonRequestBehavior.AllowGet));
}
public ActionResult GetById(int id)
{
return(Json(DeptManager.GetById(id), JsonRequestBehavior.AllowGet));
}
public ActionResult dele(Dept dd)
{
return(Json(DeptManager.dele(dd), JsonRequestBehavior.AllowGet));
}
public ActionResult Add(Dept d)
{
d.CreateTime = DateTime.Now;
return(Json(DeptManager.Add(d), JsonRequestBehavior.AllowGet));
}
public ActionResult Del(int DeptId)
{
return(Json(DeptManager.Del(DeptId), JsonRequestBehavior.AllowGet));
}
public ActionResult DemoPageList(int pageindex, int pagesize)
{
return(Json(DeptManager.PageListDemo(pageindex, pagesize), JsonRequestBehavior.AllowGet));
}
private IDeptManager CreateInstance()
{
IDeptManager target = new DeptManager();
return target;
}
public async Task <IActionResult> Generate()
{
var existingEmployess = await _employeeService.GetAll();
if (existingEmployess.Count > 0)
{
return(View());
}
var daysGenerator = new RandomGenerator();
string[] gender = { "M", "F" };
var employees = Builder <Employee> .CreateListOfSize(10000)
.All()
.With(c => c.Ssn = Faker.Identification.SocialSecurityNumber())
.With(c => c.FirstName = Faker.Name.First())
.With(c => c.MiddleName = Faker.Name.Middle())
.With(c => c.LastName = Faker.Name.Last())
.With(c => c.Gender = Faker.Extensions.ArrayExtensions.Random(gender))
.With(c => c.HireDate = DateTime.Now.AddDays(-daysGenerator.Next(1, 3650))) // HireDate within last 10 years
.With(c => c.BirthDate = DateTime.Now.AddDays(-daysGenerator.Next(6750, 21170))) // Age between 18 to 58 Years
.With(c => c.Address1 = Faker.Address.StreetAddress())
.With(c => c.Address2 = Faker.Address.StreetName())
.With(c => c.City = Faker.Address.City())
.With(c => c.State = Faker.Address.UsStateAbbr())
.With(c => c.Zipcode = Faker.Address.ZipCode())
.With(c => c.HomePhone = Faker.Phone.Number())
.With(c => c.MobilePhone = Faker.Phone.Number())
.With(c => c.Email = Faker.Internet.Email())
.Build();
foreach (var employee in employees)
{
try
{
employee.HomePhone = employee.HomePhone.Replace("(", "").Replace(")", "").Replace("-", "");
if (employee.HomePhone.Length > 12)
{
employee.HomePhone = employee.HomePhone.Substring(0, 12);
}
else
{
employee.HomePhone = employee.HomePhone.Substring(0, employee.HomePhone.Length);
}
employee.MobilePhone = employee.MobilePhone.Replace("(", "").Replace(")", "").Replace("-", "");
if (employee.MobilePhone.Length > 12)
{
employee.MobilePhone = employee.MobilePhone.Substring(0, 12);
}
else
{
employee.MobilePhone = employee.MobilePhone.Substring(0, employee.MobilePhone.Length);
}
await _employeeService.AddEmployee(employee);
}
catch (Exception ex)
{
}
}
string[] departments = { "Transport",
"Security",
"Research and development",
"Product development",
"Learning and development",
"IT services",
"Infrastructures",
"Engineering",
"Business development",
"Admin",
"Accounts and Finance" };
string[] titles = { "Vice-President",
"Senior Account Manager",
"Account Manager",
"Senior Project Manager",
"Project Manager",
"Senior Technical Lead",
"Technical Lead",
"Project Lead",
"Senior Team Lead",
"Team Lead",
"Module Lead",
"Senior Software Engineer",
"Software Engineer",
"Associate Software Engineer",
"Intern" };
for (int i = 0; i < departments.Length; i++)
{
Department dept = new Department();
dept.DeptNo = "D" + i;
dept.Name = departments[i];
await _departmentService.AddDepartment(dept);
var flag = false;
while (!flag)
{
try
{
var index = daysGenerator.Next(1, employees.Count);
var emp = employees[index - 1];
DeptManager deptManager = new DeptManager();
deptManager.DeptNo = dept.DeptNo;
deptManager.EmpNo = emp.EmpNo;
deptManager.FromDate = DateTime.Now.AddDays(-daysGenerator.Next(1, 3650));
deptManager.ToDate = deptManager.FromDate.Value.AddDays(daysGenerator.Next(1, 3650));
await _deptManagerService.AddDeptManager(deptManager);
flag = true;
}
catch (Exception)
{
flag = false;
}
}
}
foreach (var employee in employees)
{
try
{
var index = daysGenerator.Next(1, departments.Length);
var dept = departments[index - 1];
DeptEmp deptEmp = new DeptEmp();
deptEmp.DeptNo = "D" + (index - 1).ToString();
deptEmp.EmpNo = employee.EmpNo;
deptEmp.FromDate = DateTime.Now.AddDays(-daysGenerator.Next(1, 3650));
deptEmp.ToDate = deptEmp.FromDate.Value.AddDays(daysGenerator.Next(1, 3650));
Expression <Func <DeptEmp, bool> > deptEmpPred = d => (d.EmpNo == employee.EmpNo && d.DeptNo == deptEmp.DeptNo);
var dept_emp = _deptEmpService.FindDeptEmp(deptEmpPred).Result.FirstOrDefault();
if (dept_emp == null)
{
await _deptEmpService.AddDeptEmp(deptEmp);
}
Salary salary = new Salary();
salary.EmpNo = employee.EmpNo;
salary.Salary1 = daysGenerator.Next(25000, 200000);
salary.FromDate = DateTime.Now.AddDays(-daysGenerator.Next(1, 3650));
salary.ToDate = salary.FromDate.Value.AddDays(daysGenerator.Next(1, 3650));
await _salaryService.AddSalary(salary);
index = daysGenerator.Next(1, titles.Length);
var sTitle = titles[index - 1];
Title title = new Title();
title.EmpNo = employee.EmpNo;
title.Title1 = sTitle;
title.FromDate = DateTime.Now.AddDays(-daysGenerator.Next(1, 3650));
title.ToDate = title.FromDate.Value.AddDays(daysGenerator.Next(1, 3650));
await _titleService.AddTitle(title);
}
catch (Exception ex)
{
}
}
return(View());
}
public ActionResult queryDept()
{
return(Json(DeptManager.queryDept(), JsonRequestBehavior.AllowGet));
}
