public HttpResponseMessage UpdateDivisionInfo(HttpRequestMessage reqObject) { int result = 0; _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData); bool IsValid = ModelValidation.TryValidateModel(_DivisionInfo, out _modelErrorMsg); if (IsValid) { result = _IDivisionInfoService.UpdateDivisionInfo(_DivisionInfo); } } if (!string.IsNullOrWhiteSpace(_modelErrorMsg)) { _serviceResponse = _IDataManipulation.SetResponseObject(result, _modelErrorMsg); } else if (result == 1) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been updated successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been updated"); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public HttpResponseMessage GetDivisionInfoById(HttpRequestMessage reqObject) { string AccountStatusId = string.Empty; _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData); AccountStatusId = _DivisionInfo.DivisionId; } if (!string.IsNullOrWhiteSpace(AccountStatusId)) { _DivisionInfo = new DivisionInfo(); _DivisionInfo = _IDivisionInfoService.GetDivisionInfoById(AccountStatusId); } if (_DivisionInfo != null) { _serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "information has been fetched successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "Account Status Setup Not Found..."); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public HttpResponseMessage DeleteDivisionInfo(HttpRequestMessage reqObject) { int result = 0; _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData); } if (_DivisionInfo == null || string.IsNullOrWhiteSpace(_DivisionInfo.DivisionId)) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "Account Status Setup Id Not Found..."); _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); } result = _IDivisionInfoService.DeleteDivisionInfo(_DivisionInfo); if (result == 1) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been deleted successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been deleted"); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public int AddDivisionInfo(DivisionInfo _DivisionInfo) { try { var _max = _IUoW.Repository <DivisionInfo>().GetMaxValue(x => x.DivisionId) + 1; _DivisionInfo.DivisionId = _max.ToString().PadLeft(3, '0'); _DivisionInfo.AuthStatusId = "A"; _DivisionInfo.LastAction = "ADD"; _DivisionInfo.MakeDT = System.DateTime.Now; _DivisionInfo.MakeBy = "mtaka"; var result = _IUoW.Repository <DivisionInfo>().Add(_DivisionInfo); #region Auth Log if (result == 1) { _IAuthLogService = new AuthLogService(); long _outMaxSlAuthLogDtl = 0; result = _IAuthLogService.AddAuthLog(_IUoW, null, _DivisionInfo, "ADD", "0001", "090101003", 1, "DivisionInfo", "MTK_CP_DIVISION_INFO", "DivisionId", _DivisionInfo.DivisionId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl); } #endregion if (result == 1) { _IUoW.Commit(); } return(result); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddDivisionInfo(obj)", string.Empty); return(0); } }
public void AddCommandTest(bool isAdmin) { using (var modelContext = new TestModelContext()) { var userId = 100; var now = DateTime.Now; var entity = new DivisionInfo { DivisionID = 1 }; var securityContext = new TestSecurityContext(userId, isAdmin); var command = new AddCommand <DivisionInfo> (modelContext, securityContext); command.Add(entity, now); var entityLoaded = modelContext .QueryWhere <DivisionInfo> (d => d.DivisionID == entity.DivisionID) .SingleOrDefault(); Assert.Equal(isAdmin, null != entityLoaded); if (entityLoaded != null) { Assert.Equal(now, entityLoaded.CreatedOnDate); Assert.Equal(now, entityLoaded.LastModifiedOnDate); Assert.Equal(userId, entityLoaded.CreatedByUserId); Assert.Equal(userId, entityLoaded.LastModifiedByUserId); } } }
public ActionResult DeleteConfirmed(int id) { DivisionInfo divisionInfo = db.DivisionInfoes.Find(id); db.DivisionInfoes.Remove(divisionInfo); db.SaveChanges(); return(RedirectToAction("Index")); }
public SubDivisionViewModel (DivisionInfo division, ViewModelContext context) { Context = context; Title = division.Title; HomePage = division.HomePage; StartDate = division.StartDate; EndDate = division.EndDate; }
public ActionResult Edit([Bind(Include = "DivisionId,DivisionName,DivisionCode,DivisionDesc")] DivisionInfo divisionInfo) { if (ModelState.IsValid) { db.Entry(divisionInfo).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("CreateAndView")); } return(View(divisionInfo)); }
public int UpdateDivisionInfo(DivisionInfo aDivisionInfo) { int rowAffected = 0; string query = "UPDATE DivisionInfo SET DivisionName='" + aDivisionInfo.DivisionName + "' WHERE Id='" + aDivisionInfo.Id + "'"; Connection.Open(); Command = new SqlCommand(query, Connection); rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public int SaveDivisionName(DivisionInfo aDivisionInfo) { int rowAffected = 0; string query = "INSERT INTO DivisionInfo VALUES('" + aDivisionInfo.DivisionName + "',GETDATE() )"; Connection.Open(); Command = new SqlCommand(query, Connection); rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public ActionResult Create([Bind(Include = "DivisionId,DivisionName,DivisionCode,DivisionDesc")] DivisionInfo divisionInfo) { if (ModelState.IsValid) { db.DivisionInfoes.Add(divisionInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(divisionInfo)); }
public ApiResult <DivisionResp> GetByCityId(long cityId) { DivisionInfo division = _divisionQueryService.QueryByCityId(cityId); if (division == null) { return(new ApiResult <DivisionResp>(ResultStatus.SUCCESS, default(DivisionResp))); } return(new ApiResult <DivisionResp>(ResultStatus.SUCCESS, Mapper.Map <DivisionInfo, DivisionResp>(division))); }
protected IEnumerable <OccupiedPositionInfo> GetOccupiedPositions() { var division1 = new DivisionInfo { DivisionID = 1 }; var division2 = new DivisionInfo { DivisionID = 2 }; var division3 = new DivisionInfo { DivisionID = 3, EndDate = DateTime.Today }; var position11 = new PositionInfo { PositionID = 11, Title = "Director", ShortTitle = "Chief" }; var position12 = new PositionInfo { PositionID = 12, Title = "Manager" }; var position13 = new PositionInfo { PositionID = 13, Title = "Consultant" }; return(new List <OccupiedPositionInfo> { new OccupiedPositionInfo { DivisionID = 1, Division = division1, PositionID = 11, Position = position11 }, new OccupiedPositionInfo { DivisionID = 2, Division = division2, PositionID = 12, Position = position12, TitleSuffix = "(main)" }, new OccupiedPositionInfo { DivisionID = 1, Division = division1, PositionID = 13, Position = position13 }, new OccupiedPositionInfo { DivisionID = 3, Division = division3, PositionID = 11, Position = position11 } }); }
// GET: DivisionInfoes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DivisionInfo divisionInfo = db.DivisionInfoes.Find(id); if (divisionInfo == null) { return(HttpNotFound()); } return(View(divisionInfo)); }
public ActionResult CreateAndView(DivisionInfo DivisionInfoes) { if (ModelState.IsValid) { db.DivisionInfoes.Add(DivisionInfoes); db.SaveChanges(); return(RedirectToAction("CreateAndView", "DivisionInfoes")); } List <DivisionInfo> objDivisionInfoList = new List <DivisionInfo>(); objDivisionInfoList = db.DivisionInfoes.ToList(); ViewBag.DivisionInfo = objDivisionInfoList; return(View(DivisionInfoes)); }
public int UpdateDivisionInfo(DivisionInfo _DivisionInfo) { try { int result = 0; bool IsRecordExist; if (!string.IsNullOrWhiteSpace(_DivisionInfo.DivisionId)) { IsRecordExist = _IUoW.Repository <DivisionInfo>().IsRecordExist(x => x.DivisionId == _DivisionInfo.DivisionId); if (IsRecordExist) { var _oldDivisionInfo = _IUoW.Repository <DivisionInfo>().GetBy(x => x.DivisionId == _DivisionInfo.DivisionId); var _oldDivisionInfoForLog = ObjectCopier.DeepCopy(_oldDivisionInfo); _oldDivisionInfo.AuthStatusId = _DivisionInfo.AuthStatusId = "U"; _oldDivisionInfo.LastAction = _DivisionInfo.LastAction = "EDT"; _oldDivisionInfo.LastUpdateDT = _DivisionInfo.LastUpdateDT = System.DateTime.Now; _DivisionInfo.MakeBy = "mtaka"; result = _IUoW.Repository <DivisionInfo>().Update(_oldDivisionInfo); #region Testing Purpose #endregion #region Auth Log if (result == 1) { _IAuthLogService = new AuthLogService(); long _outMaxSlAuthLogDtl = 0; result = _IAuthLogService.AddAuthLog(_IUoW, _oldDivisionInfoForLog, _DivisionInfo, "EDT", "0001", "090101003", 1, "DivisionInfo", "MTK_CP_DIVISION_INFO", "DivisionId", _DivisionInfo.DivisionId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl); } #endregion if (result == 1) { _IUoW.Commit(); } return(result); } } return(result); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "UpdateDivisionInfo(obj)", string.Empty); return(0); } }
public bool IsDivisionNameExist(DivisionInfo aDivisionInfo) { string query = "SELECT * FROM DivisionInfo WHERE DivisionName='" + aDivisionInfo.DivisionName + "'"; Connection.Open(); Command = new SqlCommand(query, Connection); Reader = Command.ExecuteReader(); if (Reader.HasRows) { return(true); } Reader.Close(); Connection.Close(); return(false); }
public void DeleteCommandTest(bool isAdmin) { using (var modelContext = new TestModelContext()) { var entity = new DivisionInfo { DivisionID = 1 }; modelContext.Add(entity); var securityContext = new TestSecurityContext(1, isAdmin); var command = new DeleteCommand <DivisionInfo> (modelContext, securityContext); command.Delete(entity); Assert.Equal(isAdmin, null == modelContext .QueryOne <DivisionInfo> (d => d.DivisionID == entity.DivisionID) .SingleOrDefault()); } }
public DivisionInfo GetDivisionInfoBy(DivisionInfo _DivisionInfo) { try { if (_DivisionInfo == null) { return(_DivisionInfo); } return(_IUoW.Repository <DivisionInfo>().GetBy(x => x.DivisionId == _DivisionInfo.DivisionId && x.AuthStatusId == "A" && x.LastAction != "DEL")); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetDivisionInfoBy(obj)", string.Empty); return(null); } }
public HttpResponseMessage GetDivisionInfoBy(HttpRequestMessage reqObject) { _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData); _DivisionInfo = _IDivisionInfoService.GetDivisionInfoBy(_DivisionInfo); } if (_DivisionInfo != null) { _serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "information has been fetched successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "Account Status Setup Not Found..."); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
public void CalculateLevelAndPathTest() { var root1 = new DivisionInfo { DivisionID = 1, Title = "Root1" }; var root1_child1 = new DivisionInfo { DivisionID = 2, ParentDivisionID = 1, Title = "Root1.Child1" }; var root1_child2 = new DivisionInfo { DivisionID = 3, ParentDivisionID = 2, Title = "Root1.Child2" }; var root1_child1_child1 = new DivisionInfo { DivisionID = 4, ParentDivisionID = 1, Title = "Root1.Child1.Child1" }; root1.SubDivisions = new List <DivisionInfo> { root1_child1, root1_child2 }; root1_child1.SubDivisions = new List <DivisionInfo> { root1_child1_child1 }; var divisions = new List <DivisionInfo> { root1, root1_child1, root1_child2, root1_child1_child1 }; var calculatedDivisions = divisions.CalculateLevelAndPath(); // check paths Assert.Equal("/0000000001", calculatedDivisions.Single(cd => cd.DivisionID == 1).Path); Assert.Equal("/0000000001/0000000002", calculatedDivisions.Single(cd => cd.DivisionID == 2).Path); Assert.Equal("/0000000001/0000000003", calculatedDivisions.Single(cd => cd.DivisionID == 3).Path); Assert.Equal("/0000000001/0000000002/0000000004", calculatedDivisions.Single(cd => cd.DivisionID == 4).Path); // check level Assert.Equal(0, calculatedDivisions.Single(cd => cd.DivisionID == 1).Level); Assert.Equal(2, calculatedDivisions.Single(cd => cd.DivisionID == 4).Level); }
public string SaveDivisionName(DivisionInfo aDivisionInfo) { bool isDivisionNameExist = _divisionInfoGateway.IsDivisionNameExist(aDivisionInfo); if (!isDivisionNameExist) { int rowAffected = _divisionInfoGateway.SaveDivisionName(aDivisionInfo); if (rowAffected > 0) { return("success"); } else { return("failed"); } } else { return("exist"); } }
public string UpdateDivisionInfo(DivisionInfo aDivisionInfo) { bool isDivisionNameExist = _divisionInfoGateway.IsDivisionNameExist(aDivisionInfo); if (!isDivisionNameExist) { int rowAffected = _divisionInfoGateway.UpdateDivisionInfo(aDivisionInfo); if (rowAffected > 0) { return("update"); } else { return("failed"); } } else { return("exist"); } }
public DivisionInfo GetDivisionDataById(int id) { DivisionInfo aDivisionInfo = null; string query = "SELECT * FROM DivisionInfo WHERE Id='" + id + "'"; Connection.Open(); Command = new SqlCommand(query, Connection); Reader = Command.ExecuteReader(); if (Reader.HasRows) { Reader.Read(); aDivisionInfo = new DivisionInfo { DivisionName = Reader["DivisionName"].ToString(), }; Reader.Close(); } Connection.Close(); return(aDivisionInfo); }
public List <DivisionInfo> GetAllDivisionInfo() { try { List <DivisionInfo> OBJ_LIST_DivisionInfo = new List <DivisionInfo>(); var _ListDivisionInfo = _IUoW.Repository <DivisionInfo>().Get(x => x.AuthStatusId == "A" && x.LastAction != "DEL").OrderByDescending(x => x.DivisionId); foreach (var item in _ListDivisionInfo) { DivisionInfo OBJ_DivisionInfo = new DivisionInfo(); CountryInfoService OBJ_CountryInfoService = new CountryInfoService(); OBJ_DivisionInfo.DivisionId = item.DivisionId; OBJ_DivisionInfo.DivisionNm = item.DivisionNm; OBJ_DivisionInfo.DivisionShortNm = item.DivisionShortNm; OBJ_DivisionInfo.CountryId = item.CountryId; foreach (var item1 in OBJ_CountryInfoService.GetCountryInfoForDD()) { if (item1.Value == OBJ_DivisionInfo.CountryId) { OBJ_DivisionInfo.CountryNm = item1.Text; } } OBJ_DivisionInfo.AuthStatusId = item.AuthStatusId; OBJ_DivisionInfo.LastAction = item.LastAction; OBJ_DivisionInfo.LastUpdateDT = item.LastUpdateDT; OBJ_DivisionInfo.MakeBy = item.MakeBy; OBJ_DivisionInfo.MakeDT = item.MakeDT; OBJ_DivisionInfo.TransDT = item.TransDT; OBJ_LIST_DivisionInfo.Add(OBJ_DivisionInfo); } return(OBJ_LIST_DivisionInfo); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetAllDivisionInfo()", string.Empty); return(null); } }
public List <DivisionInfo> GetAllDivision() { List <DivisionInfo> aDivisionInfos = null; string query = "SELECT * FROM DivisionInfo ORDER BY Id DESC"; Connection.Open(); Command = new SqlCommand(query, Connection); Reader = Command.ExecuteReader(); if (Reader.HasRows) { aDivisionInfos = new List <DivisionInfo>(); while (Reader.Read()) { DivisionInfo aInfo = new DivisionInfo(); aInfo.Id = (int)Reader["Id"]; aInfo.DivisionName = Reader["DivisionName"].ToString(); aDivisionInfos.Add(aInfo); } Reader.Close(); } Connection.Close(); return(aDivisionInfos); }
public string UploadUserFromADtoIOT(string username, string empCode, string UploadBy) { string result = ""; DataTable dTable = new DataTable(); SqlCommand sql = new SqlCommand(); sql.CommandText = @"SELECT username"; sql.CommandText += @" WHERE username=@username"; sql.Parameters.Add(new SqlParameter("@username", username)); dTable = oConn.Query(sql); if (dTable.Rows.Count > 0) { return("Error: This Username already exists in this system. If forgot your password please click 'Lost your password?' bellow."); } string FirstName = ""; string LastName = ""; string FullName = ""; string Department = ""; string Position = ""; string Email = ""; EmployeeInfo oEmp = new EmployeeInfo(); if (empCode != "") { oEmp = oHRService.GetEmployeeData(empCode); if (oEmp != null) { NameInfo oNameInfo = new NameInfo(); oNameInfo = oEmp.NameInEng; if (oNameInfo != null) { FirstName = oNameInfo.Name; LastName = oNameInfo.Surname; FullName = FirstName + " " + LastName; } DivisionInfo oDivision = new DivisionInfo(); oDivision = oEmp.Division; if (oDivision != null) { Department = oDivision.Name; } PositionInfo oPosition = new PositionInfo(); oPosition = oEmp.Position; if (oPosition != null) { Position = oPosition.NameEng; } } Email = oEmp.Email; } else { } try { sql = new SqlCommand(); sql.CommandText = @"INSERT INTO userList VALUES(@username,@password,@firstname,@lastname,@empCode,@department"; sql.CommandText += @",@position,@email,@active,@createby,@createdate,@updateby,@updatedate)"; sql.Parameters.Add(new SqlParameter("@username", username)); sql.Parameters.Add(new SqlParameter("@password", "")); sql.Parameters.Add(new SqlParameter("@firstname", FirstName)); sql.Parameters.Add(new SqlParameter("@lastname", LastName)); sql.Parameters.Add(new SqlParameter("@empCode", empCode)); sql.Parameters.Add(new SqlParameter("@department", Department)); sql.Parameters.Add(new SqlParameter("@position", Position)); sql.Parameters.Add(new SqlParameter("@email", Email)); sql.Parameters.Add(new SqlParameter("@active", 1)); sql.Parameters.Add(new SqlParameter("@createby", UploadBy)); sql.Parameters.Add(new SqlParameter("@createdate", DateTime.Now)); sql.Parameters.Add(new SqlParameter("@updateby", UploadBy)); sql.Parameters.Add(new SqlParameter("@updatedate", DateTime.Now)); oConn.ExecuteCommand(sql); } catch (Exception) { } return(result); }
public DivisionObrnadzorViewModel (DivisionInfo division, ViewModelContext context) { CopyCstor.Copy<DivisionInfo> (division, this); Context = context; }
public DivisionObrnadzorViewModel(DivisionInfo division, ViewModelContext <DivisionDirectorySettings> context) { CopyCstor.Copy <DivisionInfo> (division, this); Context = context; }