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)); }