// GET: AttendancyEntireYear
public ActionResult Index()
{
int EmpCode = Convert.ToInt32(Session["EmpCode"]);
int FiscalYear = Convert.ToInt32(Request["fyId"]);
if (FiscalYear == 0)
{
FiscalYear = _fiscalService.GetCurrentFyId();
}
ViewBag.fsId = FiscalYear;
ViewBag.FiscalsDropdown = _fiscalService.GetFiscalDropDown();
EmployeeEditViewModel EmpDetails = _employeeServices.GetEmployeeByID(EmpCode);
ViewBag.EmpDetails = EmpDetails;
AttendanceEntireYearViewModel record = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 4);
ViewBag.FirstMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 4);
ViewBag.SecondMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 5);
ViewBag.SecondMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 5);
ViewBag.ThirdMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 6);
ViewBag.ThirdMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 6);
ViewBag.FourthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 7);
ViewBag.FourthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 7);
ViewBag.FivethMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 8);
ViewBag.FivethMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 8);
ViewBag.SixthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 9);
ViewBag.SisthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 9);
ViewBag.SeventhMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 10);
ViewBag.SeventhMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 10);
ViewBag.EightthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 11);
ViewBag.EightthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 11);
ViewBag.NinethMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 12);
ViewBag.NinethMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 12);
ViewBag.TenthMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 1);
ViewBag.TenthMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 1);
ViewBag.EleventhMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 2);
ViewBag.EleventMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 2);
ViewBag.TwelevethMonth = _reportServices.AttendanceEntireYearReport(EmpCode, FiscalYear, 3);
ViewBag.TwelevethMonthSummary = _reportServices.AttendanceEntireYearReportSummary(EmpCode, FiscalYear, 3);
return(View("../AttendanceReport/MyYearlyAttendance", record));
}
public AttendanceEntireYearViewModel AttendanceEntireYearReport(int Empcode, int FiscalYear, int NepaliMonth)
{
AttendanceEntireYearViewModel EntireData = new AttendanceEntireYearViewModel();
var conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_AttendanceEntireYearReport", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FiscalYear", FiscalYear);
cmd.Parameters.AddWithValue("@NepaliMonth", NepaliMonth);
cmd.Parameters.AddWithValue("@Empcode", Empcode);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string sdate = null;
string edate = null;
List <AttendanceDailyDetails> DailyData = new List <AttendanceDailyDetails>();
foreach (DataRow row in dt.Rows)
{
// sdate = row["eng_start_date"].ToString();
// edate = row["eng_end_date"].ToString();
//EntireData.Empcode = Convert.ToInt32(row["AttEmpCode"].ToString());
AttendanceDailyDetails single = new AttendanceDailyDetails();
var attstatus = "";
single.AttDate = Convert.ToDateTime(row["AttDate"].ToString());
single.CheckInTime = row["AttCheckIn"].ToString();
single.CheckOutTime = row["AttCheckOut"].ToString();
single.Holiday = (row["IsHoliday"].ToString() == "") ? "0" : row["IsHoliday"].ToString();
single.Weekend = (row["IsWeekend"].ToString() == "") ? "0" : row["IsWeekend"].ToString();
single.Leave = (row["IsLeave"].ToString() == "") ? "0" : row["IsLeave"].ToString();
single.Training = (row["IsTraining"].ToString() == "") ? "0" : row["IsTraining"].ToString();
single.OfficialVisit = (row["IsOfficialVisit"].ToString() == "") ? "0" : row["IsOfficialVisit"].ToString();
single.CheckAbsent = row["CheckAbsent"].ToString();
single.Isabsent = (row["Isabsent"].ToString() == "") ? "0" : row["Isabsent"].ToString();
single.LeaveTypeName = (row["leaveTpeName"].ToString() == "") ? "" : row["leaveTpeName"].ToString();
if (Convert.ToInt32(single.Holiday) > 0)
{
attstatus = "H";
}
if (Convert.ToBoolean(single.Weekend))
{
attstatus = attstatus + "W";
}
if (Convert.ToInt32(single.Leave) > 0)
{
attstatus = attstatus + "L";
}
if (Convert.ToBoolean(single.Training))
{
attstatus = attstatus + "T";
}
if (Convert.ToInt32(single.OfficialVisit) > 0)
{
attstatus = attstatus + "K";
}
if (Convert.ToBoolean(single.Isabsent) == true && single.CheckAbsent == "0")
{
attstatus = "A";
}
single.AttStatus = attstatus;
DailyData.Add(single);
}
EntireData.DailyData = DailyData;
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
return(EntireData);
}
