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