public static List <LeaveAssignedDTOs> LeaveAssignedLeaveAssignedDtoList(List <LeaveAssigned> Record)
{
List <LeaveAssignedDTOs> Result = new List <LeaveAssignedDTOs>();
foreach (var Item in Record)
{
LeaveAssignedDTOs single = new LeaveAssignedDTOs()
{
AssignedId = Item.AssignedId,
AssignedDays = Convert.ToDecimal(Item.AssignedDays),
AssignedLeaveYearId = Convert.ToInt32(Item.AssignedLeaveYearId),
AssignedRemarks = Item.AssignedRemarks,
AssignEmpCode = Item.AssignEmpCode,
AssignLeaveTypeId = Item.AssignLeaveTypeId,
LeaveGainedMonth = Convert.ToInt32(Item.LeaveGainedMonth),
LeaveType = new LeaveType
{
IsPayable = Item.LeaveType.IsPayable,
Gender = Item.LeaveType.Gender,
HalfdayAllow = Item.LeaveType.HalfdayAllow,
IsCashable = Item.LeaveType.IsCashable,
IsTransferable = Item.LeaveType.IsTransferable,
LeaveApplyBefore = Item.LeaveType.LeaveApplyBefore,
LeaveAssigneds = Item.LeaveType.LeaveAssigneds,
LeaveCalculation = Item.LeaveType.LeaveCalculation,
LeaveDeductionPriority = Item.LeaveType.LeaveDeductionPriority,
LeaveRuleDetails = Item.LeaveType.LeaveRuleDetails,
LeaveTypeId = Item.LeaveType.LeaveTypeId,
LeaveTypeAssignment = Item.LeaveType.LeaveTypeAssignment,
LeaveTypeDescription = Item.LeaveType.LeaveTypeDescription,
LeaveTypeName = Item.LeaveType.LeaveTypeName,
MaritalStatus = Item.LeaveType.MaritalStatus,
MaxCashable = Item.LeaveType.MaxCashable,
MaxTransferable = Item.LeaveType.MaxTransferable,
NumberOfTime = Item.LeaveType.NumberOfTime,
LeaveType1 = Item.LeaveType.LeaveType1,
ProRataLeaveRatio = Item.LeaveType.ProRataLeaveRatio
},
LeaveYear = new LeaveYear
{
YearId = Item.LeaveYear.YearId,
LeaveAssigneds = Item.LeaveYear.LeaveAssigneds,
YearCurrent = Item.LeaveYear.YearCurrent,
YearEndDate = Item.LeaveYear.YearEndDate,
YearEndDateNp = Item.LeaveYear.YearEndDateNp,
YearName = Item.LeaveYear.YearName,
YearStartDate = Item.LeaveYear.YearStartDate,
YearStartDateNp = Item.LeaveYear.YearStartDateNp,
}
};
Result.Add(single);
}
return(Result);
}
public static LeaveAssigned LeaveAsignedDTOtoLeaveAssign(LeaveAssignedDTOs Record)
{
LeaveAssigned result = new LeaveAssigned()
{
AssignedId = Record.AssignedId,
AssignedDays = Record.AssignedDays,
AssignedLeaveYearId = Record.AssignedLeaveYearId,
AssignedRemarks = Record.AssignedRemarks,
AssignEmpCode = Record.AssignEmpCode,
AssignLeaveTypeId = Record.AssignLeaveTypeId,
LeaveGainedMonth = Record.LeaveGainedMonth,
};
return(result);
}
public ActionResult LeaveAssign(int Id)
{
ViewBag.SideBar = _moduleService.AdminEmployeeDetailsMenu(Id);
try
{
LeaveAssignedDTOs Result = _LeaveAddAdmin.LeaveAssignCreateInfo(Id);
Result.AssignEmpCode = Id;
return(View(Result));
}
catch (Exception Ex)
{
Session["error"] = Ex.Message;
return(View());
}
}
public static LeaveAssignedDTOs LaveAssignToLeaveAssignDTO(LeaveAssigned Record)
{
LeaveAssignedDTOs result = new LeaveAssignedDTOs()
{
AssignedId = Record.AssignedId,
AssignedDays = Convert.ToDecimal(Record.AssignedDays),
AssignedLeaveYearId = Convert.ToInt32(Record.AssignedLeaveYearId),
AssignedRemarks = Record.AssignedRemarks,
AssignEmpCode = Record.AssignEmpCode,
AssignLeaveTypeId = Record.AssignLeaveTypeId,
LeaveGainedMonth = Convert.ToInt32(Record.LeaveGainedMonth),
LeaveType = new LeaveType
{
IsPayable = Record.LeaveType.IsPayable,
Gender = Record.LeaveType.Gender,
HalfdayAllow = Record.LeaveType.HalfdayAllow,
IsCashable = Record.LeaveType.IsCashable,
IsTransferable = Record.LeaveType.IsTransferable,
LeaveApplyBefore = Record.LeaveType.LeaveApplyBefore,
LeaveCalculation = Record.LeaveType.LeaveCalculation,
LeaveDeductionPriority = Record.LeaveType.LeaveDeductionPriority,
LeaveRuleDetails = Record.LeaveType.LeaveRuleDetails,
LeaveTypeId = Record.LeaveType.LeaveTypeId,
LeaveTypeAssignment = Record.LeaveType.LeaveTypeAssignment,
LeaveTypeDescription = Record.LeaveType.LeaveTypeDescription,
LeaveTypeName = Record.LeaveType.LeaveTypeName,
MaritalStatus = Record.LeaveType.MaritalStatus,
MaxCashable = Record.LeaveType.MaxCashable,
MaxTransferable = Record.LeaveType.MaxTransferable,
NumberOfTime = Record.LeaveType.NumberOfTime,
LeaveType1 = Record.LeaveType.LeaveType1,
ProRataLeaveRatio = Record.LeaveType.ProRataLeaveRatio
},
LeaveYear = new LeaveYear
{
YearId = Record.LeaveYear.YearId,
LeaveAssigneds = Record.LeaveYear.LeaveAssigneds,
YearCurrent = Record.LeaveYear.YearCurrent,
YearEndDate = Record.LeaveYear.YearEndDate,
YearEndDateNp = Record.LeaveYear.YearEndDateNp,
YearName = Record.LeaveYear.YearName,
YearStartDate = Record.LeaveYear.YearStartDate,
YearStartDateNp = Record.LeaveYear.YearStartDateNp,
}
};
return(result);
}
public ActionResult LeaveAssign(int Id, LeaveAssignedDTOs data)
{
try
{
_LeaveAddAdmin.CreateLeaveAssign(data);
//data.NepaliMonth = _LeaveAddAdmin.LeaveAssignCreateInfo(Id).NepaliMonth;
//data = _LeaveAddAdmin.LeaveAssignCreateInfo(Id);
return(RedirectToAction("LeaveAssign", new { Id = Id }));
}
catch (Exception Ex)
{
Session["error"] = Ex.Message;
LeaveAssignedDTOs Result = _LeaveAddAdmin.LeaveAssignCreateInfo(Id);
//data.NepaliMonth = _LeaveAddAdmin.LeaveAssignCreateInfo(Id).NepaliMonth;
return(View(Result));
}
}
public void CreateLeaveAssign(LeaveAssignedDTOs data)
{
int CurrentYear = _unitOfWork.LeaveYearRepository.All().Where(x => x.YearCurrent == true).Select(x => x.YearId).FirstOrDefault();
foreach (LeaveAssignedList Item in data.LeaveAssignedList)
{
if (Item.LeaveGainedMonth <= 1)
{
LeaveAssigned Record = _unitOfWork.LeaveAssignedRepository.Get(x => x.LeaveGainedMonth == Item.LeaveGainedMonth && x.AssignEmpCode == data.AssignEmpCode && x.AssignedLeaveYearId == CurrentYear && x.AssignLeaveTypeId == 1).FirstOrDefault();
if (Record != null)
{
Record.AssignedDays = Item.HomeLeaveBalance;
_unitOfWork.LeaveAssignedRepository.Update(Record);
}
else
{
Record = new LeaveAssigned();
Record.AssignedDays = Item.HomeLeaveBalance;
Record.AssignedLeaveYearId = CurrentYear;
Record.LeaveGainedMonth = Item.LeaveGainedMonth;
Record.AssignedRemarks = "0";
Record.AssignLeaveTypeId = 1;
Record.AssignEmpCode = data.AssignEmpCode;
_unitOfWork.LeaveAssignedRepository.Create(Record);
}
Record = _unitOfWork.LeaveAssignedRepository.Get(x => x.LeaveGainedMonth == Item.LeaveGainedMonth && x.AssignEmpCode == data.AssignEmpCode && x.AssignedLeaveYearId == CurrentYear && x.AssignLeaveTypeId == 2).FirstOrDefault();
if (Record != null)
{
Record.AssignedDays = Item.SickLeaveBalance;
_unitOfWork.LeaveAssignedRepository.Update(Record);
}
else
{
Record = new LeaveAssigned();
Record.AssignedDays = Item.SickLeaveBalance;
Record.AssignedLeaveYearId = CurrentYear;
Record.LeaveGainedMonth = Item.LeaveGainedMonth;
Record.AssignedRemarks = "0";
Record.AssignLeaveTypeId = 2;
Record.AssignEmpCode = data.AssignEmpCode;
_unitOfWork.LeaveAssignedRepository.Create(Record);
}
Record = _unitOfWork.LeaveAssignedRepository.Get(x => x.LeaveGainedMonth == Item.LeaveGainedMonth && x.AssignEmpCode == data.AssignEmpCode && x.AssignedLeaveYearId == CurrentYear && x.AssignLeaveTypeId == 3).FirstOrDefault();
if (Record != null)
{
Record.AssignedDays = Item.CasualLeaveBalance;
_unitOfWork.LeaveAssignedRepository.Update(Record);
}
else
{
Record = new LeaveAssigned();
Record.AssignedDays = Item.CasualLeaveBalance;
Record.AssignedLeaveYearId = CurrentYear;
Record.LeaveGainedMonth = Item.LeaveGainedMonth;
Record.AssignedRemarks = "0";
Record.AssignLeaveTypeId = 3;
Record.AssignEmpCode = data.AssignEmpCode;
_unitOfWork.LeaveAssignedRepository.Create(Record);
}
}
else
{
LeaveAssigned Record = _unitOfWork.LeaveAssignedRepository.Get(x => x.LeaveGainedMonth == Item.LeaveGainedMonth && x.AssignEmpCode == data.AssignEmpCode && x.AssignedLeaveYearId == CurrentYear && x.AssignLeaveTypeId == 1).FirstOrDefault();
if (Record != null)
{
Record.AssignedDays = Item.HomeLeaveBalance;
_unitOfWork.LeaveAssignedRepository.Update(Record);
}
else
{
Record = new LeaveAssigned();
Record.AssignedDays = Item.HomeLeaveBalance;
Record.AssignedLeaveYearId = CurrentYear;
Record.LeaveGainedMonth = Item.LeaveGainedMonth;
Record.AssignedRemarks = "0";
Record.AssignLeaveTypeId = 1;
Record.AssignEmpCode = data.AssignEmpCode;
_unitOfWork.LeaveAssignedRepository.Create(Record);
}
}
}
}
public LeaveAssignedDTOs LeaveAssignCreateInfo(int empcode)
{
int CurrentYear = _unitOfWork.LeaveYearRepository.All().Where(x => x.YearCurrent == true).Select(x => x.YearId).FirstOrDefault();
List <LeaveAssigned> data = _unitOfWork.LeaveAssignedRepository.All().Where(x => x.AssignEmpCode == empcode && x.AssignedLeaveYearId == CurrentYear && x.LeaveGainedMonth == 0).ToList();
LeaveAssignedDTOs Result = new LeaveAssignedDTOs();
Result.HomeBalance = Convert.ToDecimal(data.Where(x => x.AssignLeaveTypeId == 1).Select(x => x.AssignedDays).FirstOrDefault());
Result.SickLeaveBalance = Convert.ToDecimal(data.Where(x => x.AssignLeaveTypeId == 2).Select(x => x.AssignedDays).FirstOrDefault());
Result.NepaliMonth = StaticSelectList.GetnepaliMonth().ToList();
decimal HomeLeaveBalance = 0;
decimal SickLeaveBalance = 0;
decimal CasualLeaveBalance = 0;
List <LeaveAssignedList> AssignedList = new List <LeaveAssignedList>();
if (data.Count != 0)
{
LeaveAssignedList Item = new LeaveAssignedList();
Item.MonthName = "Previous year leave balance";
LeaveAssigned Leave = data.Where(x => x.AssignLeaveTypeId == 1).FirstOrDefault();
if (Leave != null)
{
HomeLeaveBalance = Convert.ToDecimal(Leave.AssignedDays);
}
else
{
HomeLeaveBalance = 0;
}
Leave = data.Where(x => x.AssignLeaveTypeId == 2).FirstOrDefault();
if (Leave != null)
{
SickLeaveBalance = Convert.ToDecimal(Leave.AssignedDays);
}
Item.HomeLeaveBalance = HomeLeaveBalance;
Item.SickLeaveBalance = SickLeaveBalance;
Item.CasualLeaveBalance = CasualLeaveBalance;
Item.LeaveGainedMonth = 0;
AssignedList.Add(Item);
}
else
{
LeaveAssignedList Item = new LeaveAssignedList();
Item.MonthName = "Previous year leave balance";
Item.HomeLeaveBalance = HomeLeaveBalance;
Item.SickLeaveBalance = SickLeaveBalance;
Item.CasualLeaveBalance = CasualLeaveBalance;
Item.LeaveGainedMonth = 0;
AssignedList.Add(Item);
}
List <CalenderMonth> Months = _unitOfWork.CalenderMonthRepository.All().OrderBy(x => x.MonthCode).ToList();
List <LeaveAssigned> Assigns = _unitOfWork.LeaveAssignedRepository.Get(x => x.AssignEmpCode == empcode && x.AssignedLeaveYearId == CurrentYear && x.LeaveGainedMonth != 0).ToList();
foreach (CalenderMonth Month in Months)
{
HomeLeaveBalance = 0;
SickLeaveBalance = 0;
CasualLeaveBalance = 0;
LeaveAssignedList Item = new LeaveAssignedList();
Item.MonthName = Month.MonthNameNp;
LeaveAssigned Leave = Assigns.Where(x => x.AssignLeaveTypeId == 1 && x.LeaveGainedMonth == Month.MonthCode).FirstOrDefault();
if (Leave != null)
{
HomeLeaveBalance = Convert.ToDecimal(Leave.AssignedDays);
}
Leave = Assigns.Where(x => x.AssignLeaveTypeId == 2 && x.LeaveGainedMonth == Month.MonthCode).FirstOrDefault();
if (Leave != null)
{
SickLeaveBalance = Convert.ToDecimal(Leave.AssignedDays);
}
Leave = Assigns.Where(x => x.AssignLeaveTypeId == 3 && x.LeaveGainedMonth == Month.MonthCode).FirstOrDefault();
if (Leave != null)
{
CasualLeaveBalance = Convert.ToDecimal(Leave.AssignedDays);
}
Item.MonthId = Month.MonthId;
Item.HomeLeaveBalance = HomeLeaveBalance;
Item.SickLeaveBalance = SickLeaveBalance;
Item.CasualLeaveBalance = CasualLeaveBalance;
Item.LeaveGainedMonth = Month.MonthCode;
AssignedList.Add(Item);
}
Result.LeaveAssignedList = AssignedList;
return(Result);
}
