public int UpdateLeaveAssigned(LeaveAssignedDTO data) { try { var conn = DbConnectHelper.GetConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE LeaveAssigned SET AssignedDays=" + data.AssignedDays + " Where AssignEmpCode=" + data.AssignEmpCode + " and AssignLeaveTypeId=" + data.AssignLeaveTypeId + " and AssignedLeaveYearId=" + data.AssignedLeaveYearId, conn); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); da.Dispose(); cmd.Dispose(); conn.Close(); conn.Dispose(); if (dt.Rows.Count > 0) { return(0); } else { return(1); } } catch (Exception ex) { return(0); } }
public int InsertLeaveAssigned(LeaveAssignedDTO data) { try { LeaveAssigned dataToInsert = new LeaveAssigned(); dataToInsert = LeaveAssignRequestFormatters.ConvertRespondentInfoFromDTO(data); LeaveAssignRequestFormatters.ConvertRespondentInfoToDTO(_unitOfWork.LeaveAssignedRepository.Create(dataToInsert)); return(1); } catch (Exception Ex) { return(0); } }
public static LeaveAssigned ConvertRespondentInfoFromDTO(LeaveAssignedDTO leaveassign) { Mapper.CreateMap <LeaveAssignedDTO, LeaveAssigned>().ConvertUsing( m => { return(new LeaveAssigned { AssignedId = m.AssignedId, AssignedDays = m.AssignedDays, AssignedLeaveYearId = m.AssignedLeaveYearId, AssignEmpCode = m.AssignEmpCode, AssignLeaveTypeId = m.AssignLeaveTypeId }); }); return(Mapper.Map <LeaveAssignedDTO, LeaveAssigned>(leaveassign)); }
public ActionResult UpdateLeaveAssignDetails(LeaveRuleAddViewModel Ldvm, int Empcode) { List <LeaveAssignDetailViewModel> Data = Ldvm.UpdateResult; int count = Data.Count; foreach (var item in Ldvm.UpdateResult) { LeaveAssignedDTO lvt = new LeaveAssignedDTO(); lvt.AssignedDays = item.AddDays; lvt.AssignLeaveTypeId = item.LeaveTypeId; lvt.AssignEmpCode = Empcode; lvt.LeaveTakenDays = item.AddDays; lvt.AssignedLeaveYearId = item.LeaveYearId; if (item.IsAlreadyAssigned == true && item.IsEnable == false) { int isExist = _leaveAssigned.CheckLeaveExistence(Empcode, item.LeaveTypeId, item.LeaveYearId); if (isExist == 1) { int isDeleted = _leaveAssigned.DeleteLeaveAssignRules(item.AssignedId); } else { Session["Error"] = "This Leave is Alredy taken by Employee.so You Can not delete this Leave"; return(RedirectToAction("EmployeeLeaveAssignDetails", Empcode)); } } else if (item.IsAlreadyAssigned == true && item.AddDays != 0 && item.IsEnable == true) { int result = _leaveAssigned.UpdateLeaveAssigned(lvt); } else if (item.IsEnable == true && item.IsAlreadyAssigned == false) { lvt.LeaveTakenDays = 0; int result = _leaveAssigned.InsertLeaveAssigned(lvt); } } return(RedirectToAction("EmployeeLeaveAssignDetails", Empcode)); }
public LeaveAssignedDTO InsertLeaveAssigned(LeaveAssignedDTO lAsignDTO) { LeaveAssigned la = _unitOfWork.LeaveAssignedRepository.Create(LeaveRequestFormatter.ConvertRespondentInfoFromDTO(lAsignDTO)); return(LeaveRequestFormatter.ConvertRespondentInfoToDTO(la)); }
public static LeaveAssigned ConvertRespondentInfoFromDTO(LeaveAssignedDTO lAssignDTO) { Mapper.CreateMap <LeaveAssignedDTO, LeaveAssigned>(); return(Mapper.Map <LeaveAssignedDTO, LeaveAssigned>(lAssignDTO)); }