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