protected void btnSave_Click(object sender, EventArgs e)
{
try
{
InitBUS();
string message = checkInput();
if (message == "")
{
DepartmentDTO dpDTO = new DepartmentDTO();
dpDTO.Name = this.txtDepartment.Text;
dpDTO.Description = this.txtDescription.Text;
dpDTO.UserId = getUserLogin().UserId; // Mac dinh la 1, khong quan ly
dpDTO.UserType = int.Parse(this.dropTypeUser.SelectedItem.Value.ToString());
ConnectionData.OpenMyConnection();
dpBUS.tblDepartment_insert(dpDTO);
Visible(false);
pnSuccess.Visible = true;
lblSuccess.Text = "Bạn đã thêm thành công!";
LoadDepartmentList();
ConnectionData.CloseMyConnection();
}
else
{
pnSuccess.Visible = false;
pnError.Visible = true;
lblError.Text = message;
}
}
catch (Exception ex)
{
logs.Error(userLogin.Username + "-Client - btnSave_Click", ex);
}
}
public static Department MapFromDTO(DepartmentDTO dto)
{
Department Department = new Department();
Department.DepartmentID = dto.DepartmentID;
Department.DepartmentName = dto.DepartmentName;
Department.ParentDepartment = dto.ParentDepartmentId == null ? null : ManagerFactory.DepartmentManager.GetDepartment(dto.ParentDepartmentId);
return Department;
}
public static DepartmentDTO MapToDTO(Department model)
{
DepartmentDTO dto = new DepartmentDTO();
dto.DepartmentID = model.DepartmentID;
dto.DepartmentName = model.DepartmentName;
dto.ParentDepartmentId = model.ParentDepartment ==null?null:model.ParentDepartment.DepartmentID;
dto.ParentDepartmentName = model.ParentDepartment==null?null:model.ParentDepartment.DepartmentName;
return dto;
}
public void tblDepartment_insert(DepartmentDTO dt)
{
string sql = "INSERT INTO tblDepartment(Name, Description, Role) "+
"VALUES(@Name, @Description, @Role)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description;
cmd.Parameters.Add("@Role", SqlDbType.Int).Value = dt.Role;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblDepartment_Update(DepartmentDTO dt)
{
string sql = "UPDATE tblDepartment SET "+
"Name = @Name, " +
"Description = @Description, "+
"Role = @Role WHERE ID = @ID";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = dt.ID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description;
cmd.Parameters.Add("@Role", SqlDbType.Int).Value = dt.Role;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public ActionResult DepartMentEdit(string Id)
{
var departmentDomain = CommonSrv.LoadObjectById(typeof(Department), Id) as Gecko.Security.Domain.Department;
DepartmentDTO departmentDTO = new DepartmentDTO();
departmentDTO.Id = departmentDomain.Id;
departmentDTO.Name = departmentDomain.Name;
departmentDTO.OrderId = departmentDomain.OrderId;
departmentDTO.Phone = departmentDomain.Phone;
departmentDTO.ExtNumber = departmentDomain.ExtNumber;
departmentDTO.Fax = departmentDomain.Fax;
departmentDTO.Remark = departmentDomain.Remark;
departmentDTO.ParentDepartmentId = departmentDomain.ParentDepartment != null ? departmentDomain.ParentDepartment.Id : null;
return(View("DepartMentInfo", departmentDTO));
}
public async Task <IActionResult> Edit(DepartmentDTO departmentDTO)
{
if (ModelState.IsValid)
{
var deparment = _mapper.Map <Department>(departmentDTO);
await _departmentService.Update(deparment);
return(RedirectToAction(nameof(Index)));
}
var data = await _instructorService.GetAll();
ViewBag.Instructors = data.Select(x => _mapper.Map <InstructorDTO>(x)).ToList();
return(View(departmentDTO));
}
/// <summary>
/// 更新部门。
/// </summary>
/// <param name="dto">待更新部门的信息。</param>
public static void UpdateDepartment(DepartmentDTO dto)
{
Db.SessionFactory.EvictQueries("Department");
Department d = Db.Session.Load(typeof(Department), dto.Id) as Department;
d.Name = dto.Name;
d.Phone = dto.Phone;
d.ExtNumber = dto.ExtNumber;
d.Fax = dto.Fax;
d.Remark = dto.Remark;
d.OrderId = dto.OrderId;
Db.TransUpdate(d);
}
public async Task <IHttpActionResult> Update([FromBody] DepartmentDTO DepartmentDto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var entity = await DepartmentService.FindOneAsync(DepartmentDto.Id);
entity = DepartmentDto.ToEntity(entity);
entity.LastUserId = User.Identity.GetUserId();
entity.LastTime = DateTime.Now;
await DepartmentService.UpdateAsync(entity);
return(Ok(entity.ToModel()));
}
public IEnumerable <DepartmentDTO> GetDeptPlanOfUser()
{
List <DepartmentDTO> result = new List <DepartmentDTO>();
SessionManager.DoWork(session =>
{
Staff staff = ControllerHelpers.GetCurrentStaff(session);
if (staff.Department != null)
{
DepartmentDTO pd = staff.Department.Map <DepartmentDTO>();
result.Add(pd);
}
});
return(result);
}
public async Task <XElement> GetDepartments(string sessionKey, long requestId)
{
#region Заглушка
var hubConn = new HubConnection(Settings.Default.ResponseHubUrl);
var hubProxy = hubConn.CreateHubProxy("ResponseHub");
await hubConn.Start();
var result = DepartmentDTO.ArrayToXElement(new DepartmentDTO[]
{
new DepartmentDTO()
{
Id = Guid.NewGuid(),
Name = "ОП З-1",
},
new DepartmentDTO()
{
Id = Guid.NewGuid(),
Name = "ОП З-2",
},
new DepartmentDTO()
{
Id = Guid.NewGuid(),
Name = "Служба клиентского сервиса"
},
new DepartmentDTO()
{
Id = Guid.NewGuid(),
Name = "Закупки"
},
new DepartmentDTO()
{
Id = Guid.NewGuid(),
Name = "Бухгалтерия"
},
new DepartmentDTO()
{
Id = Guid.NewGuid(),
Name = "Юридический отдел"
}
});
result.Add(new XElement("rc", 0));
result.Add(new XElement("msg", ""));
hubProxy.Invoke("OperationCallback", sessionKey, requestId, result);
return(zapad.Model.API.ReturnCodes.BuildRcAnswer(0, "Успешно"));
#endregion
}
public IActionResult GetDepartments(Guid id)
{
List <DepartmentDTO> departmentsDTO = new List <DepartmentDTO>();
IEnumerable <Unit> departments = db.Units.Where(a => a.MailingGroupId == id).Where(t => t.Deleted == false);
foreach (var d in departments)
{
DepartmentDTO departmentDTO = new DepartmentDTO();
departmentDTO.Id = d.Id;
departmentDTO.FullTitle = GetFullOrgName(d.UnitEmployeeDbId);
departmentDTO.UnitEmployeeDbId = d.UnitEmployeeDbId;
departmentsDTO.Add(departmentDTO);
}
return(new ObjectResult(departmentsDTO));
}
public DepartmentDTO GetById(int departmentId)
{
try
{
DepartmentDTO Department = new DepartmentDTO();
Mapper.Map <Department, DepartmentDTO>(_repository
.Query()
.SelectQueryable()
.Where(c => c.Id == departmentId).FirstOrDefault(), Department);
return(Department);
}
catch (Exception ex)
{
throw ex;
}
}
public List <DepartmentDTO> getDataList()
{
string query = ("SELECT * FROM DEPARTMENT");
DataTable data = DataProvider.Instance.ExecuteQuery(query);
List <DepartmentDTO> deptListResult = new List <DepartmentDTO>();
foreach (DataRow item in data.Rows)
{
DepartmentDTO deptDTO = new DepartmentDTO(item);
deptListResult.Add(deptDTO);
}
return(deptListResult);
}
public ActionResult DepartmentCreateClose(DepartmentDTO data)
{
try
{
DepartmentDTO resDeptDTO = new DepartmentDTO();
resDeptDTO = _departmentServices.InsertDepartment(data);
ViewBag.Success = "New Deparment added";
ModelState.Clear();
return(View("Departments", _departmentServices.GetDepartmentlist()));
}
catch (Exception Ex)
{
ViewBag.error = Ex.Message;
return(View(data));
}
}
public async Task <IHttpActionResult> Post(DepartmentDTO departmentDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var department = mapper.Map <Department>(departmentDTO);
department = await departmentService.Insert(department);
return(Ok(department));
}
catch (Exception ex) { return(InternalServerError(ex)); }
}
public IActionResult Details(int id)
{
var foundDepartments = _db.Departments.Find(id);
if (foundDepartments == null)
{
return(NotFound());
}
//map and return DTO
DepartmentDTO departmentDTO = new DepartmentDTO();
departmentDTO.Description = foundDepartments.Description;
return(Ok(departmentDTO));
}
public static Department Convert(this DepartmentDTO departmentDto)
{
return(new Department
{
ItemId = departmentDto.ItemId,
IsDeleted = departmentDto.IsDeleted,
Updated = departmentDto.Updated,
CorrectorId = departmentDto.CorrectorId,
ShortName = departmentDto.Name,
FullName = departmentDto.FullName,
Address = departmentDto.Address,
Phone = departmentDto.Phone,
Fax = departmentDto.Fax,
Email = departmentDto.Email,
Website = departmentDto.Website
});
}
public async Task PostDepartment([FromBody] DepartmentDTO departmentDTO)
{
try
{
var dept = new Department
{
Name = departmentDTO.Name
};
await _unitOfWork.Department.AddDepartmentAsync(dept);
_unitOfWork.Department.Save();
}
catch (Exception ex)
{
throw ex;
}
}
public DepartmentDTO CreateDepartment(DepartmentDTO department)
{
var newObj = new Departments
{
DepartmentId = department.DepartmentID,
Name = department.Name,
Budget = department.Budget,
CreatedDate = department.CreatedDate
};
Database.Departments.Add(newObj);
Database.SaveChanges();
department.DepartmentID = newObj.DepartmentId;
return(department);
}
public ActionResult Create(DepartmentDTO dept)
{
if (ModelState.IsValid)
{
dept.CreatedBy = dept.ModifiedBy = this.User.Id;
dept = this._IDepartmentService.Create(dept);
var account = new AccountDTO();
account.CreatedBy = account.ModifiedBy = this.User.Id;
account.Balance = 0m;
account.DepartmentId = dept.Id;
this._IAccountService.Create(account);
return(RedirectToAction("Index"));
}
this.DataBind();
return(View());
}
// GET: Departments/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepartmentDTO department = _dataAccess.GetDepartment(id.GetValueOrDefault());
if (department == null)
{
return(HttpNotFound());
}
var model = Mapper.Map <DepartmentViewModel>(department);
return(View(model));
}
public void _GetChildOfTree(ref DepartmentDTO node, List <DepartmentDTO> rawList)
{
long id = node.Id;
var lstChild = rawList.Where(x => x.ParentId == id).ToList();
if (lstChild.Count > 0)
{
node.Child = new List <DepartmentDTO>();
node.Child.AddRange(lstChild);
for (int i = 0; i < lstChild.Count; i++)
{
var item = node.Child[i];
_GetChildOfTree(ref item, rawList);
node.Child[i] = item;
}
}
}
public ActionResult Edit(int id, DepartmentViewModel departmentViewModel)
{
if (ModelState.IsValid)
{
var facultyId = _facultyManager.GetAll().Where(t => t.NameOfFaculty.Equals(departmentViewModel.Faculty)).ToList()
.First().Id;
var department = new DepartmentDTO
{
Id = departmentViewModel.Id,
NameOfDepartment = departmentViewModel.NameOfDepartment,
FacultyId = facultyId
};
_departmentManager.Update(department);
return(RedirectToAction(nameof(Index)));
}
return(View());
}
public ActionResult AddDepartment(DepartmentViewModel model)
{
var counter = departmentService.GetDepartments().Last();
var counterId = counter.DepartmentId + 1;
DepartmentDTO newDep = new DepartmentDTO
{
DepartmentId = counterId,
Name = model.Name,
Description = model.Description
};
departmentService.AddDepartment(newDep);
return(RedirectToAction("Index", "Department"));
}
public List <DepartmentDTO> getDepartment()
{
string sql = "SELECT * FROM BOPHAN";
DataTable data = ConnectionDB.getData(sql);
List <DepartmentDTO> list = new List <DepartmentDTO>();
for (int i = 0; i < data.Rows.Count; i++)
{
DepartmentDTO department = new DepartmentDTO();
department.iMaBP = data.Rows[i]["MaBP"].ToString();
department.iTenBP = data.Rows[i]["TenBP"].ToString();
department.iGhiChu = data.Rows[i]["GhiChu"].ToString();
department.iActive = bool.Parse(data.Rows[i]["Active"].ToString());
list.Add(department);
}
return(list);
}
public string GetChildren(Guid?partntId, List <DepartmentDTO> departmentList)
{
var department = new DepartmentDTO();
//var partnt = departmentList.Find(item => !item.ParentId.HasValue);
var htmlString = new StringBuilder();
var partntItem = departmentList.Find(model => model.Id == partntId);
if (partntItem != null)
{
htmlString.Append("<li>");
htmlString.Append(string.Format("<a id='{1}' >{0}</a>", partntItem.Name, partntItem.Id));
htmlString.Append("</li>");
}
this.GetItems(partntId, departmentList, htmlString);
return(htmlString.ToString());
}
//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();
#endregion
#region Department
/// <summary>
///
/// </summary>
/// <param name="charge"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveDepartment(DepartmentDTO department, string operation)
{
DataTable dataTable = new DataTable();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
MessageDTO message = new MessageDTO();
try
{
connector.BeginTransaction();
//Todos los registros
object[] parameters = new object[] { department.DepartmentId, department.Company.CompanyId,
department.SpendingCenter.SpendingCenterId,
department.User.UserId, department.DepartmentDescription,
department.DepartmentStatus, operation };
//connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveDepartment", parameters);
dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveDepartment", parameters);
foreach (DataRow row in dataTable.Rows)
{
message.ErrorCode = row["ERROR_NUMBER"].ToString();
message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
}
if (message.ErrorCode == "0")
{
connector.Commit();
}
else
{
connector.RollBack();
}
}
catch (Exception exception)
{
message.ErrorCode = "-1";
message.ErrorMessage = exception.ToString();
connector.RollBack();
}
finally
{
connector.Dispose();
}
return(message);
}
public DepartmentDTO InsertOrUpdateDepartment(DepartmentDTO departmentDTO)
{
if (departmentDTO.Id > 0) ///Update Department
{
///Get Department entity from database by id
var _Department = dbcontext.Departments.Find(departmentDTO.Id);
if (_Department != null) ///if Exist
{
try
{
///Mapp new values from DepartmentDTO to Department
var mapped_Department = mapper.Map <DepartmentDTO, Department>(departmentDTO, _Department);
dbcontext.Departments.Update(mapped_Department);
dbcontext.SaveChanges();
// return true;
return(departmentDTO);
}
catch (Exception x)
{
return(null);
}
}
else
{
return(null);
}
}
else
{
try
{
var mappedDepartment = mapper.Map <Department>(departmentDTO);
dbcontext.Departments.Add(mappedDepartment);
dbcontext.SaveChanges();
// return inserted object ;
return(departmentDTO);
}
catch (Exception e)
{
return(null);
//return false;
}
}
}
public List <DepartmentDTO> GetDepartment()
{
using (UnitOfWork uow = new UnitOfWork())
{
var departments = uow.Departments.List();
List <DepartmentDTO> departmentList = new List <DepartmentDTO>();
foreach (var item in departments)
{
DepartmentDTO department = Mapper.Map <Department, DepartmentDTO>(item);
departmentList.Add(department);
}
return(departmentList);
}
}
public DepartmentDTO Add(DepartmentDTO itemDto)
{
var model = itemDto.ToModel();
model.Id = IdentityGenerator.NewSequentialGuid();
model.Created = DateTime.UtcNow;
// 数据验证
this.ValidateModel(model);
_Repository.Add(model);
this.OperationLog(HrMessagesResources.Add_Department, model.ToDto(), null);
//commit the unit of work
_Repository.UnitOfWork.Commit();
return(model.ToDto());
}
public DepartmentDTO GetDepartmentByDptName(string department_name)//按科室名查找
{
using (MyContext ctx = new MyContext())
{
var s = ctx.Departments.SingleOrDefault(e => e.dept_name == department_name);
if (s == null)
{
return(null);
}
DepartmentDTO dto = new DepartmentDTO();
dto.dept_name = s.dept_name;
dto.dir_name = s.dir_name;
dto.dir_ID = s.dir_ID;
dto.room_ID = s.room_ID;
dto.people_num = s.people_num;
return(dto);
}
}
public async Task <ActionResult <DepartmentDTO> > GetDepartment(int id)
{
DepartmentDTO departmentDTO = new DepartmentDTO();
var department = await _context.Departments.FindAsync(id);
if (department == null)
{
return(NotFound());
}
departmentDTO.Id = department.Id;
departmentDTO.DeptCode = department.DeptCode;
departmentDTO.DeptName = department.DeptName;
departmentDTO.CostCentreId = department.CostCentreId;
return(departmentDTO);
}
public DepartmentDTO Put(DepartmentDTO obj)
{
SessionManager.DoWork(session =>
{
Staff st = session.Query <Staff>().SingleOrDefault(a => a.Id == obj.StaffId);
StaffRole str = st.StaffRoles.SingleOrDefault(a => a.Id == obj.StaffRoleId);
if (str != null)
{
st.StaffRoles.Remove(str);
}
st.StaffRoles.Add(new StaffRole()
{
Id = obj.StaffRoleId
});
session.SaveOrUpdate(st);
});
return(obj);
}
public async Task <DepartmentDTO> GetDepartment(int id)
{
try
{
var deptFromDb = await _unitOfWork.Department.GetDepartmentAsync(id);
var dept = new DepartmentDTO
{
Name = deptFromDb.Name,
Id = deptFromDb.Id
};
return(dept);
}
catch (Exception ex)
{
throw ex;
}
}
public void tblDepartment_Update(DepartmentDTO dt)
{
dpmDAO.tblDepartment_Update(dt);
}
public void tblDepartment_insert(DepartmentDTO dt)
{
dpmDAO.tblDepartment_insert(dt);
}
public void tblDepartment_insert(DepartmentDTO dt)
{
//string sql = "INSERT INTO tblDepartment(Name, Description, UserId,UserType) " +
// "VALUES(@Name, @Description, @UserId,@UserType)";
//SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
//cmd.CommandType = CommandType.Text;
//cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name;
//cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description;
//cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = dt.UserId;
//cmd.Parameters.Add("@UserType", SqlDbType.Int).Value = dt.UserType;
//cmd.ExecuteNonQuery();
//cmd.Dispose();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "pro_add_tblDeparment";
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description;
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = dt.UserId;
cmd.Parameters.Add("@UserType", SqlDbType.Int).Value = dt.UserType;
cmd.Connection = ConnectionData._MyConnection;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
//ConnectionData._MyConnection.Dispose();
}
}
