public JsonResult GeDARList(long?LocationId, int?TastType, long?EmployeeId, string FromDate, string ToDate, string FromTime, string ToTime) { eTracLoginModel ObjLoginModel = null; DARManager objDARDetailsList = new DARManager(); var details = new List <WorkRequestAssignmentModelList>(); long UserId = 0; string sord = null; String sidx = null; string txtSearch = ""; GlobalAdminManager _GlobalAdminManager = new GlobalAdminManager(); if (Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(Session["eTrac"]); UserId = ObjLoginModel.UserId; if (LocationId == 0) { LocationId = Convert.ToInt32(ObjLoginModel.LocationID); UserId = ObjLoginModel.UserId; } } //Getting client date time. var clientdt = DateTime.UtcNow.GetClientDateTimeNow(); //flag status for if user filter record in time span so to date is till midnight. bool isUTCDay = true; //Fetching record like 2017-06-11T00:00:00-04:00 to 2017-06-12T00:0000-04:00 string fromDate = (FromDate == null || FromDate == " " || FromDate == "") ? clientdt.Date.ToString() : FromDate; string toDate = (ToDate == null || ToDate == " " || ToDate == "") ? clientdt.AddDays(1).Date.ToString() : ToDate; //maintaining flag if interval date come then need to fetch record till midnight of todate day if (ToDate != null && ToDate != "" && FromDate != "null") { DateTime tt = Convert.ToDateTime(toDate); if (tt.ToLongTimeString() == "12:00:00 AM") { isUTCDay = false; } } if (fromDate != null && toDate != null) { DateTime frmd = Convert.ToDateTime(fromDate); DateTime tod = Convert.ToDateTime(toDate); ////if interval date come then need to fetch record till midnight of todate day if ((frmd.Date != tod.Date) && (tod.ToLongTimeString() == "12:00:00 AM") && isUTCDay == false) { tod = tod.AddDays(1).Date; toDate = tod.ToString(); } if ((frmd.Date == tod.Date) && (tod.ToLongTimeString() == "12:00:00 AM")) { tod = tod.AddDays(1).Date; toDate = tod.ToString(); } } //Converting datetime from userTZ to UTC fromDate = Convert.ToDateTime(fromDate).ConvertClientTZtoUTC().ToString(); toDate = Convert.ToDateTime(toDate).ConvertClientTZtoUTC().ToString(); int?rows = 20; int?page = 1; sord = string.IsNullOrEmpty(sord) ? "desc" : sord; sidx = string.IsNullOrEmpty(sidx) ? "CreatedDate" : sidx; var obj_Common_B = new Common_B(); ObjectParameter paramTotalRecords = new ObjectParameter("TotalRecords", typeof(int)); var data = objDARDetailsList.GetDARDetails(UserId, LocationId, EmployeeId, TastType, page, rows, sord, sord, txtSearch, paramTotalRecords, fromDate, toDate); if (data.Count() > 0) { return(Json(data, JsonRequestBehavior.AllowGet)); } else { return(Json(data, JsonRequestBehavior.AllowGet)); } }
public void ProcessRequest(HttpContext context) { HttpRequest request = context.Request; HttpResponse response = context.Response; try { DARManager objDARDetailsList = new DARManager(); eTracLoginModel ObjLoginModel = null; System.Collections.Specialized.NameValueCollection forms = context.Request.Form; long?locationId = null; long?userId = null; long loginUserId = 0; if (Convert.ToInt64(request["empId"]) != 0) { userId = Convert.ToInt64(request["empId"]); } else { userId = null; } int?taskType = null; if (Convert.ToInt32(request["taskType"]) != 0) { taskType = Convert.ToInt32(request["taskType"]); } else { taskType = null; } //(Convert.ToInt64(request["empId"])!=0) ? Convert.ToInt64(request["empId"]) : null; string _search = request["_search"]; string textSearch = request["txtSearch"] ?? ""; int numberOfRows = Convert.ToInt32(request["rows"]); int pageIndex = Convert.ToInt32(request["page"]); string sortColumnName = request["sidx"]; string sortOrderBy = request["sord"]; //Getting client date time. var clientdt = DateTime.UtcNow.GetClientDateTimeNow(); //flag status for if user filter record in time span so to date is till midnight. bool isUTCDay = true; //Fetching record like 2017-06-11T00:00:00-04:00 to 2017-06-12T00:0000-04:00 string fromDate = (request["fromDate"] == null || request["fromDate"] == " " || request["fromDate"] == "") ? clientdt.Date.ToString(): request["fromDate"]; string toDate = (request["toDate"] == null || request["toDate"] == " " || request["toDate"] == "") ? clientdt.AddDays(1).Date.ToString(): request["toDate"]; //maintaining flag if interval date come then need to fetch record till midnight of todate day if (request["toDate"] != null && request["toDate"] != "" && request["fromDate"] != "null") { DateTime tt = Convert.ToDateTime(toDate); if (tt.ToLongTimeString() == "12:00:00 AM") { isUTCDay = false; } } if (fromDate != null && toDate != null) { DateTime frmd = Convert.ToDateTime(fromDate); DateTime tod = Convert.ToDateTime(toDate); ////if interval date come then need to fetch record till midnight of todate day if ((frmd.Date != tod.Date) && (tod.ToLongTimeString() == "12:00:00 AM") && isUTCDay == false) { tod = tod.AddDays(1).Date; toDate = tod.ToString(); } if ((frmd.Date == tod.Date) && (tod.ToLongTimeString() == "12:00:00 AM")) { tod = tod.AddDays(1).Date; toDate = tod.ToString(); } } if (context.Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(context.Session["eTrac"]); locationId = ObjLoginModel.LocationID; loginUserId = ObjLoginModel.UserId; //Added by Bhushan due to useid is null in Sp. It will not return created on due joinon the basis of userid. } //Converting datetime from userTZ to UTC fromDate = Convert.ToDateTime(fromDate).ConvertClientTZtoUTC().ToString(); toDate = Convert.ToDateTime(toDate).ConvertClientTZtoUTC().ToString(); ObjectParameter totalRecords = new ObjectParameter("TotalRecords", typeof(int)); var darDetailsList = objDARDetailsList.GetDARDetails(loginUserId, locationId, userId, taskType, pageIndex, numberOfRows, sortColumnName, sortOrderBy, textSearch, totalRecords, fromDate, toDate); if (darDetailsList.Count() > 0) { string output = BuildJQGridResults(darDetailsList, numberOfRows, pageIndex, Convert.ToInt32(totalRecords.Value)); response.Write(output); } else { JQGridResults result = new JQGridResults(); List <JQGridRow> rows = new List <JQGridRow>(); result.rows = rows.ToArray(); result.page = 0; result.total = 0; result.records = 0; response.Write(new JavaScriptSerializer().Serialize(result)); } } catch (Exception ex) { Exception_B.exceptionHandel_Runtime(ex, "public void ProcessRequest(HttpContext context)-DARDetails.ashx", "context", context.ToString()); JQGridResults result = new JQGridResults(); List <JQGridRow> rows = new List <JQGridRow>(); result.rows = rows.ToArray(); result.page = 0; result.total = 0; result.records = 0; response.Write(new JavaScriptSerializer().Serialize(result)); } }