public ActionResult AddFinancialReference(AttendanceDetail objAD)
{
HRMDB objHRMEmp = new HRMDB();
var data = (from x in objHRMEmp.FinancialYearDetails.Where(x => x.FinancialId == objAD.financialId) select x).SingleOrDefault();
int count = (from x in objHRMEmp.LeaveDetails where x.Status == true && x.Id == objAD.Id select x).Count();
DateTime enddate = Convert.ToDateTime(data.YearEnd);
DateTime joindate = Convert.ToDateTime(objAD.JoiningDate);
string nonworkingdays = data.NonWorkingDays;
string totaldays = enddate.Subtract(joindate).TotalDays.ToString();
int totaldaysafternonworkingdays = int.Parse(totaldays) - int.Parse(nonworkingdays);
string totalleaves = count.ToString();
int totalworkingdays = (totaldaysafternonworkingdays) - int.Parse(count.ToString());
DateTime currentdate = DateTime.Now;
string totalworkingdaystilldate = currentdate.Subtract(joindate).TotalDays.ToString();
objAD.Id = objAD.Id;
objAD.TotalDays = totaldaysafternonworkingdays.ToString();
objAD.TotalLeaves = totalleaves;
objAD.TotalWorkingDays = totalworkingdays.ToString();
objAD.TotalWorkingDaysTillDate = totalworkingdaystilldate;
objAD.financialId = data.FinancialId.ToString();
objEmpBLL.AddFinancialReference(objAD);
return(View());
}
