public ActionResult Edit(LeaveYearsDTOs Data, int id)
{
try
{
if (ModelState.IsValid)
{
_LeaveSetupRepo.UpdateLeaveYear(Data);
Session["sucess"] = "Data Updated Sucessfully";
return(RedirectToAction("List"));
}
else
{
LeaveYearsDTOs Result = _LeaveSetupRepo.LeaveYearList().Where(x => x.YearId == id).FirstOrDefault();
Result.Isactive = (bool)Result.YearCurrent;
return(View(Result));
}
}
catch (Exception Ex)
{
Session["error"] = Ex.Message;
LeaveYearsDTOs Result = _LeaveSetupRepo.LeaveYearList().Where(x => x.YearId == id).FirstOrDefault();
Result.Isactive = (bool)Result.YearCurrent;
return(View(Result));
}
}
public void LeaveYearCreate(LeaveYearsDTOs Record)
{
LeaveYear Data = LeaveYearsMapper.LeaveYearsDtoToLeaveYears(Record);
Data.YearCurrent = Record.Isactive;
NepaliDate StartNepali = GeneralServices.GetNepaliDate(Convert.ToDateTime(Data.YearStartDate));
NepaliDate EndNepali = GeneralServices.GetNepaliDate(Convert.ToDateTime(Data.YearEndDate));
Data.YearStartDateNp = StartNepali.npDate;
Data.YearEndDateNp = EndNepali.npDate;
_unitOfWork.LeaveYearRepository.Create(Data);
}
public ActionResult Edit(int id)
{
try
{
LeaveYearsDTOs Result = _LeaveSetupRepo.LeaveYearList().Where(x => x.YearId == id).FirstOrDefault();
Result.Isactive = (bool)Result.YearCurrent;
return(View(Result));
}
catch (Exception Ex)
{
Session["error"] = Ex.Message;
return(RedirectToAction("List"));
}
}
public static LeaveYear LeaveYearsDtoToLeaveYears(LeaveYearsDTOs Record)
{
LeaveYear Result = new LeaveYear()
{
YearId = Record.YearId,
YearCurrent = Record.YearCurrent,
YearName = Record.YearName,
YearStartDate = Convert.ToDateTime(Record.YearStartDate),
YearEndDate = Record.YearEndDate,
YearEndDateNp = Record.YearEndDateNp,
YearStartDateNp = Record.YearStartDateNp
};
return(Result);
}
public ActionResult Create(LeaveYearsDTOs Data)
{
try
{
if (ModelState.IsValid)
{
_LeaveSetupRepo.LeaveYearCreate(Data);
Session["sucess"] = "Data Inserted Sucessfully";
return(RedirectToAction("List"));
}
else
{
return(View());
}
}
catch (Exception Ex)
{
Session["error"] = Ex.Message;
return(View());
}
}
public static List <LeaveYearsDTOs> LeaveYearsListToLeaveYearsDtosList(List <LeaveYear> Record)
{
List <LeaveYearsDTOs> Result = new List <LeaveYearsDTOs>();
foreach (var Item in Record)
{
LeaveYearsDTOs single = new LeaveYearsDTOs()
{
YearId = Item.YearId,
YearCurrent = Item.YearCurrent,
YearName = Convert.ToInt32(Item.YearName),
YearStartDate = Item.YearStartDate,
YearEndDate = Convert.ToDateTime(Item.YearEndDate),
YearEndDateNp = Item.YearEndDateNp,
YearStartDateNp = Item.YearStartDateNp
};
Result.Add(single);
}
return(Result);
}
public LeaveApplicationDTOs ValidateLeave(LeaveApplicationDTOs Record)
{
List <string> Error = new List <string>();
IEnumerable <LeaveBalance> data = _LeaveApp.LeaveBalanceList(null, Record.LeaveEmpCode);
LeaveYearsDTOs LeaveYear = _LeaveSetUp.LeaveYearList().Where(X => X.YearCurrent == true).FirstOrDefault();
decimal Applydays = Convert.ToDecimal((Convert.ToDateTime(Record.LeaveEndDate) - Record.LeaveStartDate).TotalDays) + 1;
decimal leavebalance = Convert.ToDecimal(data.Where(x => x.LeaveTypeId == Record.LeaveTypeId).Select(x => x.Leave_Balance).FirstOrDefault());
Record.LeaveDays = Applydays;
if (Record.IsHalfDay == true)
{
Record.LeaveDaysType = "H";
Applydays = Convert.ToDecimal(0.5);
Record.LeaveDays = Applydays;
if (String.IsNullOrEmpty(Record.LeaveDaysPart))
{
Error.Add("Leave Day Part is not selected.");
}
}
if (Applydays > leavebalance)
{
Error.Add("You do not have enough leave balance for this leave type.");
}
if (Record.LeaveStartDate > Record.LeaveEndDate)
{
Error.Add("The start Date is greater than the End Date.");
}
if (Record.LeaveStartDate < LeaveYear.YearStartDate || Record.LeaveStartDate > LeaveYear.YearEndDate)
{
Error.Add("Leave Start date and end date should be between " + Convert.ToDateTime(LeaveYear.YearStartDate).ToShortDateString() + " and " + Convert.ToDateTime(LeaveYear.YearEndDate).ToShortDateString());
}
else if (Record.LeaveEndDate < LeaveYear.YearStartDate || Record.LeaveEndDate > LeaveYear.YearEndDate)
{
Error.Add("Leave Start date and end date should be between " + Convert.ToDateTime(LeaveYear.YearStartDate).ToShortDateString() + " and " + Convert.ToDateTime(LeaveYear.YearEndDate).ToShortDateString());
}
if (Record.LeaveApproverEmpCode == 0 || Record.RecommededEmpCode == 0)
{
Error.Add("Please choose both Recommender and Approver to apply leave");
}
if (Record.LeaveApproverEmpCode == Record.RecommededEmpCode)
{
// Error.Add("Recommender and Approver can not be same person");
}
/**
* select * from LeaveApplications where LeaveEmpCode = 6300 AND RecommendStatus IN(1,2) and LeaveStatus in(1,2)
* AND(('start_date' between LeaveStartDate and LeaveEndDate) OR ('end_date' between LeaveStartDate and LeaveEndDate) )
*
**/
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_LeaveApplyDuplicationCheck", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@empCode", Record.LeaveEmpCode);
cmd.Parameters.AddWithValue("@startdate", Record.LeaveStartDate);
cmd.Parameters.AddWithValue("@endDate", Record.LeaveEndDate);
var cnt = Convert.ToInt32(cmd.ExecuteScalar());
if (cnt > 0)
{
Error.Add("You have alread applied leave for these dates");
}
Record.LeaveYearId = LeaveYear.YearId;
if (Record.RecommendStatus == 2)
{
Record.RecommendStatusDate = DateTime.Now;
}
Record.ApproverList = _DynamicSelectList.GetApproverSelectList(Record.LeaveEmpCode).ToList();
Record.PaidLeave = Convert.ToBoolean(_LeaveSetUp.LeaveTypeList().Where(x => x.LeaveTypeId == Record.LeaveTypeId).Select(x => x.IsPayable).FirstOrDefault());
Record.ErrorList = Error;
return(Record);
}
