public bool InsertDepartment(MS_Department Department)
{
string sql = " Insert into MS_Department (DepartmentName,DepartmentCode,OrganizationId,EnteredBy,EnteredDate," +
" LastUpdatedBy,LastUpdatedDate,IsDeleted,DeletedDate,DeletedBy) " +
" values " +
"(@DepartmentName,@DepartmentCode,@OrganizationId,@EnteredBy,@EnteredDate," +
"0,null,0,null,0)";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, Department);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
public bool UpdateDepartment(MS_Department Department)
{
string sql = " Update MS_Department set DepartmentName=@DepartmentName,DepartmentCode=@DepartmentCode,OrganizationId=@OrganizationId," +
" LastUpdatedBy=@LastUpdatedBy,LastUpdatedDate=@LastUpdatedDate" +
" where DepartmentId=@DepartmentId";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, Department);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
private void CreateSeed()
{
List <MS_Department> InitialDepartment = new List <MS_Department>();
List <String> listDepartment = new List <string>()
{
"FIN,Finance,08123456789,[email protected]",
"BM,Building Management,08123456788,[email protected]",
"CC,Call Center,08123456787,[email protected]",
"PSAS,PSAS,08123456786,[email protected]",
"BR,Bank Relation,08123456785,[email protected]",
"PG,Product General,081234567890,[email protected]"
};
foreach (var item in listDepartment)
{
var departmentSeparate = item.Split(',');
var departmentPush = new MS_Department()
{
departmentCode = departmentSeparate[0],
departmentName = departmentSeparate[1],
isActive = true,
departmentWhatsapp = departmentSeparate[2],
departmentEmail = departmentSeparate[3]
};
InitialDepartment.Add(departmentPush);
}
foreach (var department in InitialDepartment)
{
AddIfNotExists(department);
}
}
public void CreateMsDepartment(CreateOrUpdateMsDepartmentInput input)
{
Logger.Info("CreateMsDepartment() - Started.");
Logger.DebugFormat("CreateMsDepartment() - Start checking exiting code and name. Params sent:{0}" +
"departmentCode ={1}{0}" +
"departmentName ={2}"
, Environment.NewLine, input.departmentCode, input.departmentName);
var checkDepartmentCodeName = (from A in _msDepartmentRepo.GetAll()
where A.departmentCode == input.departmentCode || A.departmentName == input.departmentName
select A).Any();
Logger.DebugFormat("CreateMsDepartment() - End checking exiting code and name. Result: {0}", checkDepartmentCodeName);
if (!checkDepartmentCodeName)
{
var createMsdepartment = new MS_Department
{
departmentName = input.departmentName,
departmentCode = input.departmentCode,
departmentEmail = input.departmentEmail,
departmentWhatsapp = input.departmentWhatsapp,
isActive = input.isActive
};
try
{
Logger.DebugFormat("CreateMsDepartment() - Start insert depertment. Params sent:{0}" +
"departmentName = {1}{0}" +
"departmentCode = {2}{0}" +
"departmentEmail = {3}{0}" +
"departmentWhatsapp = {4}{0}" +
"isActive = {5}"
, Environment.NewLine, input.departmentName, input.departmentCode, input.departmentEmail, input.departmentWhatsapp, input.isActive);
_msDepartmentRepo.Insert(createMsdepartment);
CurrentUnitOfWork.SaveChanges(); //execution saved inside try
Logger.DebugFormat("CreateMsDepartment() - End insert department.");
}
catch (DataException ex)
{
Logger.ErrorFormat("CreateMsDepartment() ERROR DataException. Result = {0}", ex.Message);
throw new UserFriendlyException("Db Error: " + ex.Message);
}
catch (Exception ex)
{
Logger.ErrorFormat("CreateMsDepartment() ERROR Exception. Result = {0}", ex.Message);
throw new UserFriendlyException("Error: " + ex.Message);
}
}
else
{
Logger.ErrorFormat("CreateMsDepartment() ERROR . Result = {0}", "department Code or department Name Already Exist !");
throw new UserFriendlyException("Department Code or Department Name Already Exist !");
}
Logger.Info("CreateMsDepartment() - Finished.");
}
private void AddIfNotExists(MS_Department department)
{
if (_context.MS_Department.Any(l => l.departmentCode == department.departmentCode))
{
return;
}
_context.MS_Department.Add(department);
_context.SaveChanges();
}
// GET: Department/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MS_Department mS_Department = db.GetDepartmentById((int)id);
if (mS_Department == null)
{
return(HttpNotFound());
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", mS_Department.OrganizationId);
return(View(mS_Department));
}
public ActionResult Edit(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
MS_Department mS_Department = db.GetDepartmentById(Convert.ToInt32(frm["DepartmentId"]));
mS_Department.DepartmentName = frm["DepartmentName"];
mS_Department.DepartmentCode = frm["DepartmentCode"];
mS_Department.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
mS_Department.LastUpdatedBy = (User as CustomPrincipal).UserId;
mS_Department.LastUpdatedDate = DateTime.Now;
if (ModelState.IsValid)
{
db.UpdateDepartment(mS_Department);
return(RedirectToAction("Index"));
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", mS_Department.OrganizationId);
return(View(mS_Department));
}
