public async Task <IActionResult> Add(DepartmentView department)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = "Invalid Model State";
return(BadRequest(objHelper));
}
try
{
if (departmentRepository.Exists(department))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await departmentRepository.Insert(department);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
objHelper.Data = department;
return(Ok(objHelper));
}
catch
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = "Save Unsuccessful";
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
/// <summary>
/// 加载所有部门
/// </summary>
/// <returns></returns>
public List <DepartmentView> Load()
{
//var result = (from d in UnitWork.Find<Department>(null) orderby d.CascadeId select d).ToList();
//var listCascade = UnitWork.SqlQuery<Department>(
// "select Id, Name,Name as Label, ParentId, ParentName, CascadeId,UseChildId, Explain, CreateTime, UpdateTime, IsAble, Sort from Departments where id in (select UseChildId From Departments where UseChildId is not null)"
// , new object[] { }).ToList();
var sWhere = new SqlParameter()
{
ParameterName = "@where",
Value = "",
DbType = DbType.String
};
var listDept = UnitWork.SqlQuery <Department>(
"select Id, Name,Name as Label, ParentId, ParentName, CascadeId, Explain, CreateTime, UpdateTime, IsAble,isDel, Sort from Departments where isAble = 0 and isDel=0 order by Sort desc,CreateTime asc"
, new object[] { sWhere }).ToList();
var listDV = new List <DepartmentView>();
foreach (var d in listDept)
{
DepartmentView dv = d;
var Roles = UnitWork.SqlQuery <Role>(
"select r.id,r.name as Label,name,createTime,updateTime,Sort,explain,IsAble,IsDel,r.CascadeId,r.ParentId,r.ParentName " +
"from Roles r left join DepartmentRole dr on r.Id = dr.RoleId " +
"where r.isAble=0 and r.isDel=0 and dr.DepartmentId in ('" + d.Id + "')", new object[] { }).ToList();
//d.Roles = Roles;
dv.RoleIds = string.Join(',', Roles.Select(s => s.Id).ToList());
dv.RoleNames = string.Join(',', Roles.Select(s => s.Name).ToList());
listDV.Add(dv);
}
return(BindNew(listDV, null));
}
public async Task <IActionResult> PutDepartments(int id, DepartmentView departments)
{
if (id != departments.Id)
{
return(BadRequest());
}
_context.Entry(departments).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DepartmentsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// Creates the edit department view.
/// </summary>
/// <param name="departmentInfo">The department information.</param>
/// <param name="departmentsList">The departments list.</param>
/// <param name="companyList">The company list.</param>
/// <param name="message">The message.</param>
/// <returns></returns>
/// <exception cref="ArgumentNullException">
/// departmentInfo
/// or
/// departmentsList
/// or
/// companyList
/// </exception>
public IDepartmentView CreateEditDepartmentView(IDepartment departmentInfo, IList <IDepartment> departmentsList, string message)
{
if (departmentInfo == null)
{
throw new ArgumentNullException(nameof(departmentInfo));
}
if (departmentsList == null)
{
throw new ArgumentNullException(nameof(departmentsList));
}
var departmentDDL = GetDropDownList.DepartmentListItems(departmentsList, departmentInfo.ParentDepartmentId);
var view = new DepartmentView
{
DepartmentId = departmentInfo.DepartmentId,
CompanyId = departmentInfo.CompanyId,
ParentDepartmentDropDown = departmentDDL,
ProcessingMessage = message,
DepartmentName = departmentInfo.DepartmentName,
Description = departmentInfo.Description,
IsActive = departmentInfo.IsActive,
ParentDepartmentId = departmentInfo.ParentDepartmentId,
DateCreated = departmentInfo.DateCreated
};
return(view);
}
/// <summary>
/// Creates the edit department view.
/// </summary>
/// <param name="departmentInfo">The department information.</param>
/// <param name="departmentCollection">The department collection.</param>
/// <returns></returns>
/// <exception cref="ArgumentNullException">
/// departmentInfo
/// or
/// departmentCollection
/// </exception>
public IDepartmentViews CreateEditDepartmentView(IDepartment departmentInfo, IList <IDepartment> departmentCollection)
{
if (departmentInfo == null)
{
throw new ArgumentNullException(nameof(departmentInfo));
}
if (departmentCollection == null)
{
throw new ArgumentNullException(nameof(departmentCollection));
}
var departmentDDL = GetDropDownList.DepartmentListItems(departmentCollection, -1);
var returnDepartment = new DepartmentView
{
CompanyId = departmentInfo.CompanyId,
DepartmentId = departmentInfo.DepartmentId,
DepartmentName = departmentInfo.DepartmentName,
Description = departmentInfo.Description,
ParentDepartmentId = departmentInfo.ParentDepartmentId,
ParentDepartmentDropDown = departmentDDL,
IsActive = departmentInfo.IsActive,
};
return(returnDepartment);
}
public async Task Update(DepartmentView entity)
{
try
{
//Update Old Department
var vList = adbContext.department.Where(w => w.Dept_Id == entity.Dept_Id).FirstOrDefault();
if (vList != null)
{
vList.Dept_Code = entity.Dept_Code.Trim();
vList.Dept_Name = entity.Dept_Name.Trim();
vList.Company_Id = entity.Company_Id;
vList.Notes = entity.Notes;
vList.isActive = entity.isActive;
vList.UpdatedBy = entity.UpdatedBy;
vList.UpdatedOn = DateTime.Now;
adbContext.department.Update(vList);
await Task.FromResult(adbContext.SaveChanges());
}
else
{
throw new Exception("Data Not Available");
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void FillData()
{
DataTable employeeTable = department.DisplayDepartment();
DepartmentView.DataSource = employeeTable;
DepartmentView.DataBind();
}
public ActionResult EditDepartment(DepartmentView deptInfo)
{
if (deptInfo == null)
{
throw new ArgumentNullException(nameof(deptInfo));
}
if (!ModelState.IsValid)
{
var model = adminService.GetDepartmentRegistrationView(deptInfo,
string.Empty); // update model with dropdown list
return(View("EditDepartment", model));
}
var message = adminService.ProcessEditDepartmentInfo(deptInfo);
if (!string.IsNullOrEmpty(message))
{
var model = adminService.GetDepartmentRegistrationView(deptInfo,
message); // update model with dropdown list
return(this.View("EditDepartment", model));
}
var returnMessage = string.Format("Department Information Updated - {0}", deptInfo.DepartmentName);
return(this.RedirectToAction("DepartmentList",
new { companyId = deptInfo.CompanyId, message = returnMessage }));
}
public IEnumerable <DepartmentView> PutDepartment(DepartmentView depart)
{
var result = op.EditDepartment(depart.depaId, depart.departmentName);
var list = op.displayDepartments();
return(list);
}
private void OpenDepartmentView(OpenWindowMessage msg)
{
BaseWindow view;
if (msg.WindowType == "SyncDepartmentView")
{
view = new SyncDepartmentView()
{
DataContext = msg.DataContext
};
view.BorderThickness = new Thickness(1);
view.GlowBrush = null;
view.SetResourceReference(MetroWindow.BorderBrushProperty, "AccentColorBrush");
view.ShowDialog();
}
else
{
view = new DepartmentView {
DataContext = msg.DataContext
};
view.BorderThickness = new Thickness(1);
view.GlowBrush = null;
view.SetResourceReference(MetroWindow.BorderBrushProperty, "AccentColorBrush");
view.ShowDialog();
}
}
public ActionResult AddDepartment(DepartmentView deptInfo, HttpPostedFileBase departmentExcelFile)
{
var processingMessage = String.Empty;
if (departmentExcelFile != null)
{
processingMessage = this.adminService.ProcessUploadExcelDepartment(departmentExcelFile);
if (!string.IsNullOrEmpty(processingMessage))
{
var viewModel = this.adminService.GetDepartmentRegistrationView(deptInfo, processingMessage);
return(this.View("AddDepartment", viewModel));
}
processingMessage = string.Format("{0} successful added", deptInfo.DepartmentName);
return(this.RedirectToAction("DepartmentList", "HR", new { message = processingMessage }));
}
if (deptInfo == null)
{
throw new ArgumentNullException(nameof(deptInfo));
}
//Check that Departmnet Info is Not Null
if (deptInfo == null)
{
throw new ArgumentNullException(nameof(deptInfo));
}
//Validate Model
if (!ModelState.IsValid)
{
var model = adminService.GetDepartmentRegistrationView(deptInfo,
string.Empty); // update model with dropdown list
return(View("AddDepartment", model));
}
//Process The Department Information
var message = adminService.ProcessDepartmentInfo(deptInfo);
//Check if the Processing Message is Not Empty
//If it is not empty, Means there is no error
if (!string.IsNullOrEmpty(message))
{
var model = adminService.GetDepartmentRegistrationView(deptInfo,
message); // update model with dropdown list
return(View("AddDepartment", model));
}
var returnMessage = string.Format("New Department Registered - {0}", deptInfo.DepartmentName);
return(this.RedirectToAction("DepartmentList", "HR",
new
{
message = returnMessage
}));
}
//[TypeFilter(typeof(ActionFilters.RolesValidate), Arguments = new object[] { "Department", EnumPermission.Edit })]
public async Task <IActionResult> Edit(DepartmentView department)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = ModelException.Errors(ModelState);
return(BadRequest(objHelper));
}
try
{
if (departmentRepository.Exists(department))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await departmentRepository.Update(department);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
return(Ok(objHelper));
}
catch (Exception ex)
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = ex.Message;
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public ActionResult CreateDepartment(DepartmentView deptInfo)
{
//Check that Departmnet Info is Not Null
if (deptInfo == null)
{
throw new ArgumentNullException(nameof(deptInfo));
}
//Validate Model
if (!ModelState.IsValid)
{
return(View("CreateDepartment", deptInfo));
}
//Process The Department Information
var returnModel = departmentService.ProcessDepartmentInfo(deptInfo);
//Check if the Processing Message is Not Empty
//If it is not empty, Means there is no error
if (!string.IsNullOrEmpty(returnModel.ProcessingMessage))
{
return(this.View("CreateDepartment", returnModel));
}
return(this.RedirectToAction("DepartmentList", new { returnModel.CompanyId }));
}
public DepartmentView AddNewDepartment(DepartmentView parent)
{
var newDep = NewDepartment(parent?.Department);
var newDepView = new DepartmentView(newDep, new List <EmployeeView>());
_departmentViews.Add(newDepView);
return(newDepView);
}
public void DeleteDepartment([NotNull] DepartmentView department)
{
if (department == null)
{
throw new ArgumentNullException(nameof(department));
}
_unitOfWork.DepartmentRepository.DeleteDepartment(department.Id);
_departmentViews = null;
}
public IActionResult Index()
{
var departmants = _departmantService.GetAll();
var departmantView = new DepartmentView
{
Departmants = departmants
};
return(View(departmantView));
}
public async Task <ActionResult <DepartmentView> > PostDepartments(DepartmentView departments)
{
// Наиболее предпочтительным является создание отдела БЕЗ польователей, чтобы была возможность добавить новых
_context.Departments.Add(new Departments {
Id = departments.Id, Name = departments.Name
});
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDepartments", new { id = departments.Id }, departments));
}
// GET: Department
public ActionResult Index()
{
var departments = this._contex.Departments.ToList();
var DeptView = new DepartmentView
{
Departments = departments,
};
return(PartialView(DeptView));
}
private void DoNewDepartmentView(object obj)
{
DepartmentViewModel dvm = new DepartmentViewModel(null);
dvm.AddDepartmentEvent += MainModel.AddDepartment;
DepartmentView dView = new DepartmentView {
DataContext = dvm
};
dView.ShowDialog();
}
public EmployeeView AddNewEmployee([NotNull] DepartmentView depView)
{
if (depView == null)
{
throw new ArgumentNullException(nameof(depView));
}
var newEmployee = NewEmployee(depView.Department);
var newEmpView = new EmployeeView(newEmployee);
depView.Employees.Add(newEmpView);
return(newEmpView);
}
private void LoadDepartments()
{
Departments.Clear();
foreach (var department in db.GetDepartments())
{
var departmentView = new DepartmentView()
{
Department = department,
Head = Instructors.FirstOrDefault(instructor => instructor.Id == department.HeadInstructorId)
};
Departments.Add(departmentView);
}
}
/// <summary>
/// Creates the department view.
/// </summary>
/// <param name="departmentCollection">The department collection.</param>
/// <param name="companyId">The company identifier.</param>
/// <param name="companyCollection"></param>
/// <returns></returns>
public IDepartmentView CreateDepartmentView(IList <IDepartment> departmentCollection, int companyId)
{
var departmentDDL = GetDropDownList.DepartmentListItems(departmentCollection, -1);
var view = new DepartmentView
{
CompanyId = companyId,
ParentDepartmentDropDown = departmentDDL,
ProcessingMessage = string.Empty
};
return(view);
}
public void UpdateEditWpf(AppointmentView appoView)
{
List <UserView> clients = _controller.GetClientsFromAppointmentView(appoView);
List <UserView> practitioners = _controller.GetPractitionerFromAppointmentView(appoView);
if (clients.Count >= 2)
{
cmbbClient.Items.Add(clients[0].Name + " & " + clients[1].Name);
cmbbClient.SelectedIndex = cmbbClient.Items.IndexOf(clients[0].Name + " & " + clients[1].Name);
cmbbClient.IsEnabled = false;
}
else if (clients.Count == 1)
{
cmbbClient.Items.Add(clients[0].Name);
cmbbClient.SelectedIndex = cmbbClient.Items.IndexOf(clients[0].Name);
cmbbClient.IsEnabled = false;
}
foreach (UserView prac in practitioners)
{
cmbbPractitioner.Items.Add(prac.Name);
cmbbPractitioner.SelectedIndex = cmbbPractitioner.Items.IndexOf(prac.Name);
}
cmbbPractitioner.IsEnabled = false;
DepartmentView departmentView = _controller.GetDepartmentViewFromRoomId(appoView.RoomView.Id);
cmbbDepartment.SelectedIndex = cmbbDepartment.Items.IndexOf(departmentView.Name);
cmbbDepartment.IsEnabled = false;
dpAppointmentDate.SelectedDate = appoView.DateAndTime.Date;
cmbbAppointmentTime.SelectedIndex = cmbbAppointmentTime.Items.IndexOf(appoView.DateAndTime.ToString("H:mm"));
cmbbNotificationTime.SelectedIndex = cmbbNotificationTime.Items.IndexOf(appoView.NotificationTime.Days.ToString());
txtNotes.Text = appoView.Note;
cmbbAppointmentType.IsEnabled = false;
lblHiddenId.Content = appoView.Id;
if (appoView.EmailNotification == true)
{
cbEmail.IsChecked = true;
}
else if (appoView.EmailNotification == false)
{
cbEmail.IsChecked = false;
}
if (appoView.SMSNotification == true)
{
cbSMS.IsChecked = true;
}
else if (appoView.SMSNotification == false)
{
cbSMS.IsChecked = false;
}
}
public bool Exists(DepartmentView entity)
{
int intCount = 0;
if (entity.Dept_Id > 0) //Update Validation
{
intCount = adbContext.department.Where(w => w.Company_Id == entity.Company_Id && w.Dept_Id != entity.Dept_Id && (w.Dept_Code == entity.Dept_Code || w.Dept_Name == entity.Dept_Name)).Count();
}
else //Insert Validation
{
intCount = adbContext.department.Where(w => w.Company_Id == entity.Company_Id && (w.Dept_Code == entity.Dept_Code || w.Dept_Name == entity.Dept_Name)).Count();
}
return(intCount > 0 ? true : false);
}
static async Task Main(string[] args)
{
Console.WriteLine("...Starting, Company Termianl");
var serviceProvider = BuildServiceProvider();
var probs = serviceProvider.GetService <IConsoleProberties>();
ApplyConsoleProbs(probs);
var page = new DepartmentView(serviceProvider, probs);
await RunApp(page);
}
public void Save(DepartmentView viewTable)
{
if (viewTable.Id == null)
{
var domainTable = new DepartmentTable();
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
else
{
var domainTable = Find(viewTable.Id);
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
}
private void DoOpenDepartmentView(object obj)
{
if (obj == null)
{
return;
}
DepartmentViewModel dvm = new DepartmentViewModel((DepartmentModel)obj);
dvm.UpdateDepartmentEvent += MainModel.UpdateDepartment;
DepartmentView dView = new DepartmentView {
DataContext = dvm
};
dView.ShowDialog();
}
public ActionResult Edit(DepartmentView model)
{
if (ModelState.IsValid)
{
try
{
_Service.Save(model);
return(RedirectToAction("Index"));
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.GetOriginalException().Message);
}
}
ViewBag.DepartmentList = _Service.GetDropListDepartmentNull(model.ParentDepartmentId);
return(View(model));
}
// GET: Departments
public ActionResult Index()
{
var departments = db.Departments.ToList();
var views = new List <DepartmentView>();
foreach (var department in departments)
{
var view = new DepartmentView
{
DepartmentId = department.DepartmentId,
MunicipalityList = department.Municipalities.ToList(),
Name = department.Name,
};
views.Add(view);
}
return(View(views));
}
public DepartmentViewModel(int departmentId = 0)
{
using (var db = new DatabaseContext())
{
Department = (departmentId == 0)
? new Department()
: Department = db.Departments
.Include(x => x.Employees)
.ToList()
.FirstOrDefault(d => d.DepartmentId == departmentId);
}
View = new DepartmentView()
{
DataContext = this
};
}
