public List <DesignationDTO> Designation() { using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "select DesignationId,DesignationDescription from designation where Active=1"; command.Connection = dbSvc.GetConnection() as MySqlConnection; _dtData = new DataTable(); MySqlDataAdapter msDa = new MySqlDataAdapter(command); msDa.Fill(_dtData); List <DesignationDTO> lstDesignation = new List <DesignationDTO>(); if (_dtData != null && _dtData.Rows.Count > 0) { DesignationDTO designationDTO = null; foreach (DataRow dr in _dtData.Rows) { designationDTO = new DesignationDTO(); designationDTO.DesignationId = (int)dr["DesignationId"]; designationDTO.DesignationDescription = dr["DesignationDescription"].ToString(); lstDesignation.Add(designationDTO); } } return(lstDesignation); } catch (Exception exp) { throw exp; } } }
public ActionResult DesignationCreate(DesignationDTO data) { try { if (!ModelState.IsValid) { return(View(data)); } DesignationDTO resDesgDTO = new DesignationDTO(); resDesgDTO = _designationServices.InsertDesignation(data); ViewBag.designationList = _designationServices.GetDesignationList(); ViewBag.levelList = _levelService.GetLevellist(); List <SelectListItem> GradeList = new List <SelectListItem>(); ViewBag.gradeList = GradeList; ViewBag.success = String.Format("The designation with code {0} has been inserted.", resDesgDTO.DesgCode); ModelState.Clear(); return(View()); } catch (Exception Ex) { ViewBag.error = Ex.Message; return(View()); } }
public int UpdateDesignation(DesignationDTO data) { Designation desg = DesignationRequestFormatter.ConvertRespondentInfoFromDTO(data); var response = _unitOfWork.DesignationRepository.Update(desg); _unitOfWork.Save(); return(response); }
public ActionResult DesignationEdit(int DesgId) { ViewBag.designationList = _designationServices.GetDesignationList(); ViewBag.levelList = _levelService.GetLevellist(); DesignationDTO DesignationListById = _designationServices.GetDesignationById(DesgId); return(View(DesignationListById)); }
public SelectList getDesignationDropDown() { List <DesignationDTO> rDto = _ddlRepo.Designation(); DesignationDTO dDesg = new DesignationDTO(); dDesg.DesignationId = -1; dDesg.DesignationDescription = ""; rDto.Insert(0, dDesg); return(new SelectList(rDto, "DesignationId", "DesignationDescription")); }
public ActionResult DesignationEdit(DesignationDTO data) { ViewBag.designationList = _designationServices.GetDesignationList(); ViewBag.levelList = _levelService.GetLevellist(); int reDesg = _designationServices.UpdateDesignation(data); ViewBag.Success = "Designation updated successfully"; ModelState.Clear(); return(View(data)); }
public ActionResult Edit(DesignationDTO objDesignationMasterDTO) { objDesignationMasterDTO.ModifiedBy = Convert.ToInt32(Session["UserID"]); DateTime timeUtc = System.DateTime.UtcNow; TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone); objDesignationMasterDTO.ModifiedDate = cstTime; objIDesignationMaster.UpdateDesignation(objDesignationMasterDTO); TempData["MessageUpdate"] = "Designation Updated Successfully."; return(RedirectToAction("Details")); }
public ActionResult DesignationCreateClose(DesignationDTO data) { try { DesignationDTO resDeptDTO = new DesignationDTO(); resDeptDTO = _designationServices.InsertDesignation(data); ViewBag.Success = "New Designation created successfully"; ModelState.Clear(); return(View("Designations", _designationServices.GetDesignationList())); } catch (Exception Ex) { ViewBag.error = Ex.Message; return(View(data)); } }
public void InsertDesignation(DesignationDTO desgnation) { con.Open(); var para = new DynamicParameters(); para.Add("@DesignationId", desgnation.DesignationId); // Normal Parameters para.Add("@Designation", desgnation.Designation); para.Add("@CreatedDate", desgnation.CreatedDate); para.Add("@CreatedBy", desgnation.CreatedBy); para.Add("@ModifiedDate", desgnation.ModifiedDate); para.Add("@ModifiedBy", desgnation.ModifiedBy); para.Add("@DeleteStatus", "ACTIVE"); var value = con.Query <int>("SP_Insert_Update_DesignationMaster", para, null, true, 0, CommandType.StoredProcedure); con.Close(); }
public void UpdateDesignation(DesignationDTO desgnation) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString())) { con.Open(); var para = new DynamicParameters(); para.Add("@DesignationId", desgnation.DesignationId); // Normal Parameters para.Add("@Designation", desgnation.Designation); para.Add("@CreatedDate", desgnation.CreatedDate); para.Add("@CreatedBy", desgnation.CreatedBy); para.Add("@ModifiedDate", desgnation.ModifiedDate); para.Add("@ModifiedBy", desgnation.ModifiedBy); para.Add("@DeleteStatus", "ACTIVE"); var value = con.Query <int>("SP_Insert_Update_DesignationMaster", para, null, true, 0, CommandType.StoredProcedure); con.Close(); } }
public DesignationDTO InsertDesignation(DesignationDTO data) { Designation desg = DesignationRequestFormatter.ConvertRespondentInfoFromDTO(data); _desg.LeaveApprove = desg.LeaveApprove; _desg.DesgCode = desg.DesgCode; _desg.DesgLevelId = desg.DesgLevelId; _desg.DesgMaxPeriodDays = desg.DesgMaxPeriodDays; _desg.DesgOrder = desg.DesgOrder; _desg.LeaveRecommendation = desg.LeaveRecommendation; _desg.AttendanceApprove = desg.AttendanceApprove; _desg.AttendanceRecommendation = desg.AttendanceRecommendation; _desg.DesgShortCode = desg.DesgShortCode; _desg.DsgId = desg.DsgId; _desg.DsgName = desg.DsgName; _desg.DsgParentId = desg.DsgParentId; return(DesignationRequestFormatter.ConvertRespondentInfoToDTO(_unitOfWork.DesignationRepository.Create(desg))); }
public DesignationDTO GetDesignationById(int desgId) { var designationList = _unitOfWork.DesignationRepository.All(); DesignationDTO list = (from desg in designationList select new DesignationDTO { LeaveApprove = desg.LeaveApprove, DesgCode = desg.DesgCode, DesgLevelId = desg.DesgLevelId, DesgMaxPeriodDays = desg.DesgMaxPeriodDays, DesgOrder = desg.DesgOrder, LeaveRecommendation = desg.LeaveRecommendation, AttendanceApprove = desg.AttendanceApprove, AttendanceRecommendation = desg.AttendanceRecommendation, DesgShortCode = desg.DesgShortCode, DsgId = desg.DsgId, DsgName = desg.DsgName, DsgParentId = desg.DsgParentId }).Where(x => x.DsgId == desgId).FirstOrDefault(); return(list); }
public Result Save(DesignationDTO obj) { try { using (DbCommand cmd = Common.dbConn.GetStoredProcCommand("MSTDesigSave")) { Common.dbConn.AddInParameter(cmd, "Id", DbType.Int32, obj.Id); Common.dbConn.AddInParameter(cmd, "Designation", DbType.String, obj.Designation); Common.dbConn.ExecuteNonQuery(cmd); return(new Result { Id = 1, Message = "Saved", ResultStatus = OperationStatus.SavedSuccessFully }); } } catch (Exception exception) { throw exception; } return(null); }
public ActionResult Create(DesignationDTO objDesignationMasterDTO) { if (ModelState.IsValid) { objDesignationMasterDTO.CreatedBy = Convert.ToInt32(Session["UserID"]); DateTime timeUtc = System.DateTime.UtcNow; TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone); objDesignationMasterDTO.CreatedDate = cstTime; objIDesignationMaster.InsertDesignation(objDesignationMasterDTO); TempData["MessageRegistration"] = "Data Saved Successfully!"; return(RedirectToAction("Create")); } else { // TempData["MessageRegistration"] = "Please enter Division Name!"; ModelState.AddModelError("", "Please enter Designation Name "); } // ModelState.Remove("DivisionName"); return(View(objDesignationMasterDTO)); }
public static Designation ConvertRespondentInfoFromDTO(DesignationDTO desg) { AutoMapper.Mapper.CreateMap <DesignationDTO, Designation>().ConvertUsing( m => { return(new Designation { DesgCode = m.DesgCode, DsgName = m.DsgName, DsgId = m.DsgId, DsgParentId = m.DsgParentId, DesgLevelId = m.DesgLevelId, DesgMaxPeriodDays = m.DesgMaxPeriodDays, DesgOrder = m.DesgOrder, LeaveApprove = m.LeaveApprove, LeaveRecommendation = m.LeaveRecommendation, AttendanceApprove = m.AttendanceApprove, AttendanceRecommendation = m.AttendanceRecommendation, DesgShortCode = m.DesgShortCode }); }); return(AutoMapper.Mapper.Map <DesignationDTO, Designation>(desg)); }
public Result Save(ERPDTOBase obj) { DesignationDTO accountGroup = obj as DesignationDTO; return(new DesignationDAL().Save(accountGroup)); }