public ActionResult Invoice() { HttpCookie myCookie = new HttpCookie("UInfo"); myCookie = Request.Cookies["UInfo"]; if (myCookie != null) { Hashtable hst = new Hashtable(); objTools = new Utility(); DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString()); ViewBag.Foto = DL.Foto; ViewBag.UserName = DL.FullName; ViewBag.ClientID = DL.ClientID; ViewBag.LastLogin = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy HH:mm:ss"); hst.Add("@ClientID", Convert.ToInt16(DL.ClientID)); ViewBag.TxtMenu = objTools.CreateMenu(hst, "[SP_UsersMenuLoad]"); DMSearchField DY = new DMSearchField(); DY.MonthList = objTools.GetMonths(); DY.YearList = objTools.GetYears(); return(View(DY)); } else { return(RedirectPermanent("/")); } }
public ActionResult HolidaySearch(DMSearchField data) { HttpCookie myCookie = new HttpCookie("UInfo"); myCookie = Request.Cookies["UInfo"]; if (myCookie != null) { Hashtable hst = new Hashtable(); List <DMHoliday> Holiday = new List <DMHoliday>(); DataTable dt = new DataTable(); DBA = new DBClass(); objTools = new Utility(); DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString()); hst.Add("@ClientID", Convert.ToInt16(DL.ClientID)); hst.Add("@Year", data.Searching.Year); hst.Add("@Month", data.Searching.Month); dt = DBA.GetDataTables("[SP_HolidayView]", hst); Holiday = dt.DataTableToList <DMHoliday>(); return(PartialView("_Holiday", Holiday)); } else { return(RedirectPermanent("/")); } }
public ActionResult WorkingTimeGroupSearch(DMSearchField data) { HttpCookie myCookie = new HttpCookie("UInfo"); myCookie = Request.Cookies["UInfo"]; if (myCookie != null) { try { DBA = new DBClass(); objTools = new Utility(); Hashtable hst = new Hashtable(); DataTable dt = new DataTable(); List <DMNewWorkingHour> Data = new List <DMNewWorkingHour>(); DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString()); hst.Add("@ClientID", Convert.ToInt16(DL.ClientID)); hst.Add("@BranchID", data.Searching.Key2); hst.Add("@Key", data.Searching.Key); dt = DBA.GetDataTables("[SP_AttendanceTimeGroup_View]", hst); Data = dt.DataTableToList <DMNewWorkingHour>(); return(PartialView("_WorkingTimeGroupList", Data)); } catch (Exception ex) { return(Json(new { isSuccess = false, msg = string.Format("Failed!<br/>" + ex.Message.ToString()), url = "/" }, JsonRequestBehavior.AllowGet)); } } else { return(RedirectPermanent("/")); } }
public ActionResult WorkingShiftGroupSearch(DMSearchField data) { HttpCookie myCookie = new HttpCookie("UInfo"); myCookie = Request.Cookies["UInfo"]; if (myCookie != null) { try { DBA = new DBClass(); objTools = new Utility(); Hashtable hst = new Hashtable(); DataTable dt = new DataTable(); DMGroupShiftList Data = new DMGroupShiftList(); List <DMGroupShiftHeader> ShiftHeader = new List <DMGroupShiftHeader>(); List <DMGroupShiftDetails> ShiftDetails = new List <DMGroupShiftDetails>(); DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString()); hst.Add("@ClientID", Convert.ToInt16(DL.ClientID)); hst.Add("@BranchID", data.Searching.Key2); hst.Add("@Key", data.Searching.Key); dt = DBA.GetDataTables("[SP_AttendanceShiftGroupHeader_View]", hst); ShiftHeader = dt.DataTableToList <DMGroupShiftHeader>(); dt.Clear(); hst.Clear(); for (int i = 0; i <= ShiftHeader.Count - 1; i++) { hst.Clear(); hst.Add("@ShiftID", ShiftHeader[i].ID); dt = DBA.GetDataTables("[SP_AttendanceShiftGroupDetails_View]", hst); for (int y = 0; y <= dt.Rows.Count - 1; y++) { ShiftDetails.Add(new DMGroupShiftDetails { ShiftID = Convert.ToInt32(dt.Rows[y][0].ToString()), WorkingHourID = Convert.ToInt32(dt.Rows[y][1].ToString()), WorkingDay = Convert.ToInt32(dt.Rows[y][2].ToString()), OffDay = Convert.ToInt32(dt.Rows[y][3].ToString()), CurrentIn = Convert.ToDateTime(dt.Rows[y][4].ToString()), CurrentOut = Convert.ToDateTime(dt.Rows[y][5].ToString()) }); } } Data.GroupShiftHeader = ShiftHeader; Data.GroupShiftDetails = ShiftDetails; return(PartialView("_GroupShiftList", Data)); } catch (Exception ex) { return(Json(new { isSuccess = false, msg = string.Format("Failed!<br/>" + ex.Message.ToString()), url = "/" }, JsonRequestBehavior.AllowGet)); } } else { return(RedirectPermanent("/")); } }
public ActionResult InvoiceSearch(DMSearchField data) { HttpCookie myCookie = new HttpCookie("UInfo"); myCookie = Request.Cookies["UInfo"]; if (myCookie != null) { objTools = new Utility(); DBA = new DBClass(); DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString()); List <DataModel.DMInvoiceList> InvList = new List <DMInvoiceList>(); DataTable Dt = new DataTable(); Hashtable hst = new Hashtable(); hst.Add("@Key", data.Searching.Key); hst.Add("@ClientID", DL.ClientID); hst.Add("@Month", data.Searching.Month); hst.Add("@Years", data.Searching.Year); Dt = DBA.GetDataTables("[SP_UsersInvoiceLoad]", hst); if (Dt.Rows.Count > 0) { InvList = Dt.DataTableToList <DMInvoiceList>(); return(PartialView("_InvoiceList", InvList)); } else { return(Json(new { isSuccess = false, msg = string.Format("No Record(s) found") }, JsonRequestBehavior.AllowGet)); } } else { return(RedirectPermanent("/")); } }