public ResultDTO CreateDepartment(BusinessEntities.DepartmentEntity departmentEntity)
{
//CodeGenerator code = new CodeGenerator();
//var res = String.Empty;
//var result = _unitOfWork.DepartmentRepository.GetMany(x => x.DepartmentId == departmentEntity.DepartmentId);
//if (result.Count() > 0)
//{
// res = (from c in result
// orderby c.DepartmentId descending
// select c).Take(1).First().DepartmentCode;
//}
//var last = res != null ? code.NumberFromExcelColumn(res) : 0;
//var DepartmentCode = code.GenerateSequence(last);
var result = new ResultDTO {
IsSuccess = false
};
var isExist = _unitOfWork.DepartmentRepository.GetManyQueryable(c => c.DepartmentName.ToLower() == departmentEntity.DepartmentName.ToLower() && c.CompanyId == departmentEntity.CompanyId).Count() > 0;
if (!isExist)
{
using (var scope = new TransactionScope())
{
var department = new DataModel.Department
{
DepartmentName = departmentEntity.DepartmentName,
DepartmentCode = departmentEntity.DepartmentCode,
CompanyId = departmentEntity.CompanyId,
ParentId = departmentEntity.ParentId,
IsActive = true,
CreatedBy = departmentEntity.CreatedBy,
CreatedOn = DateTime.Now,
ModifiedBy = departmentEntity.CreatedBy,
ModifiedOn = DateTime.Now,
};
_unitOfWork.DepartmentRepository.Insert(department);
_unitOfWork.Save();
scope.Complete();
result.IsSuccess = true;
result.Message = "Inserted Department Successfully";
}
}
else
{
result.IsSuccess = false;
result.Message = "Department name already exist";
}
return(result);
}
public ResultDTO UpdateDepartment(int DepartmentId, BusinessEntities.DepartmentEntity departmentEntity)
{
var result = new ResultDTO {
IsSuccess = false
};
if (departmentEntity != null)
{
var isExist = _unitOfWork.DepartmentRepository.GetManyQueryable(c => c.DepartmentName.ToLower() == departmentEntity.DepartmentName.ToLower() && c.DepartmentCode == departmentEntity.DepartmentCode && c.CompanyId == departmentEntity.CompanyId).Count() > 0;
if (!isExist)
{
using (var scope = new TransactionScope())
{
var department = _unitOfWork.DepartmentRepository.GetByID(DepartmentId);
if (departmentEntity != null)
{
department.DepartmentId = departmentEntity.DepartmentId;
department.DepartmentName = departmentEntity.DepartmentName;
department.DepartmentCode = departmentEntity.DepartmentCode;
department.CompanyId = departmentEntity.CompanyId;
department.ParentId = departmentEntity.ParentId;
department.IsActive = true;
department.ModifiedBy = departmentEntity.ModifiedBy;
department.ModifiedOn = DateTime.Now;
_unitOfWork.DepartmentRepository.Update(department);
_unitOfWork.Save();
scope.Complete();
result.IsSuccess = true;
result.Message = "Updated Department Successfully";
}
}
}
else
{
result.IsSuccess = false;
result.Message = "Designation name already exist";
}
}
return(result);
}
