public JsonResult GetSchRequisitionForProbChallanByChallanId(Int32 InChallanId) { List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>(); try { DataTable dt = objDbTrx.GetSchRequisitionForProbChallanById(InChallanId); if (dt.Rows.Count > 0) { for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++) { SchRequisitionView objSchRequisitionView = new SchRequisitionView(); objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString()); objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString()); objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy"); objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString()); objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString()); objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString()); objSchRequisitionView.RemainQuantity = Convert.ToInt32(dt.Rows[iCnt]["REMAIN_QTY"].ToString()); objSchRequisitionViewList.Add(objSchRequisitionView); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet)); }
public JsonResult GetSchRequisitionForProbChallan(Int16 InCircleID, Int16 InLanguageId, string BookCode) { List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>(); try { Int16 CircleId = InCircleID; Int16 LanguageId = InLanguageId; Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId); DataTable dt = objDbTrx.Sp_SchRequisitionForProbChallan(CircleId, AccadYear, InLanguageId, BookCode); if (dt.Rows.Count > 0) { for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++) { SchRequisitionView objSchRequisitionView = new SchRequisitionView(); objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString()); objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString()); objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy"); objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString()); objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString()); objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString()); objSchRequisitionView.RemainQuantity = Convert.ToInt32(dt.Rows[iCnt]["REMAIN_QTY"].ToString()); objSchRequisitionViewList.Add(objSchRequisitionView); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { ViewBag.Active = "SchRequisionView"; SchRequisitionView objSchRequisitionView = new SchRequisitionView(); objSchRequisitionView.StartDate = Convert.ToDateTime(DateTime.Now).ToString("dd-MMM-yyyy"); objSchRequisitionView.EndDate = Convert.ToDateTime(DateTime.Now).ToString("dd-MMM-yyyy"); return(View(objSchRequisitionView)); }
public ActionResult GetSchRequisionViewListData(string startDate, string endDate, string circleId = "") { List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>(); try { Int16 CircleId = default(short); if (!string.IsNullOrWhiteSpace(circleId) && circleId != "-1") { CircleId = Convert.ToInt16(circleId); } else { CircleId = Convert.ToInt16(GlobalSettings.oUserData.CircleID); } Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId); //DataTable dt = objDbTrx.GetSchRequisitionViewDataByCercleId(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), CircleId, AccadYear); DataTable dt = objDbTrx.GetRequisitionViewNew(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), CircleId, AccadYear); if (dt.Rows.Count > 0) { for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++) { SchRequisitionView objSchRequisitionView = new SchRequisitionView(); objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString()); objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString()); objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy"); objSchRequisitionView.SaveStatus = Convert.ToInt16(dt.Rows[iCnt]["SAVE_STATUS"].ToString()); objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString()); objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString()); objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString()); objSchRequisitionView.Category = Convert.ToString(dt.Rows[iCnt]["BOOK_CATEGORY"].ToString()); objSchRequisitionView.LastUpdatedBy = Convert.ToString(dt.Rows[iCnt]["UPDATED_BY"].ToString()); objSchRequisitionView.LastUpdatedOn = Convert.ToDateTime(dt.Rows[iCnt]["UPDATED_TS"].ToString()).ToString("dd-MMM-yyyy"); objSchRequisitionView.ISAPPROVED = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED"].ToString()); objSchRequisitionView.ISAPPROVED_DIST = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_DIST"].ToString()); objSchRequisitionView.ISAPPROVED_ADMIN = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_ADMIN"].ToString()); objSchRequisitionViewList.Add(objSchRequisitionView); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet)); // return View(); }
public ActionResult GetSchRequisionViewListData(string startDate, string endDate, string districtId = "", string circleId = "", int isapproved = 0) { List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>(); try { int CircleId = default(int); int DistrictId = default(int); int.TryParse(districtId, out DistrictId); string usertype = string.Empty; try { usertype = (GlobalSettings.oUserData).UserType; } catch { } if (!string.IsNullOrWhiteSpace(circleId)) { CircleId = Convert.ToInt32(circleId); } else { if (usertype != "2") { CircleId = Convert.ToInt32(!string.IsNullOrWhiteSpace(GlobalSettings.oUserData.CircleID) ? GlobalSettings.oUserData.CircleID : "-1"); } else { CircleId = -1; } } int IsForAdminApproval = default(int); int AdminApprovalstatus = default(int); int AccadYear = Convert.ToInt32(GlobalSettings.oUserData.AcademicYearId); // DataTable dt = objDbTrx.GetRequisitionViewNewForApproval(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), DistrictId, CircleId, (usertype == "5" ? isapproved : 0), AccadYear, IsForDistApproval: (usertype == "5" ? 0 : (usertype == "2" ? 1 : 0)), DistApprovalstatus: (usertype == "2" ? isapproved : 0)); DataTable dt = objDbTrx.GetRequisitionViewNewForApproval(Convert.ToDateTime(startDate + " 00:00:00.000") , Convert.ToDateTime(endDate + " 23:59:59.999"), DistrictId, CircleId , (usertype == "5" ? isapproved : 0), AccadYear, IsForDistApproval: (usertype == "5" ? 0 : (usertype == "2" ? 1 : 0)) , DistApprovalstatus: (usertype == "2" ? isapproved : 0), IsForAdminApproval: (usertype == "5" ? 0 : (usertype == "3" ? 1 : 0)), AdminApprovalstatus: (usertype == "5" ? 0 : (usertype == "3" ? isapproved : 0))); if (dt.Rows.Count > 0) { for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++) { var pp = dt.Rows[iCnt]["ISAPPROVED_ADMIN"]; Console.WriteLine(pp); SchRequisitionView objSchRequisitionView = new SchRequisitionView(); objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString()); try { objSchRequisitionView.ISAPPROVED = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED"].ToString()); objSchRequisitionView.APPROVED_BY = dt.Rows[iCnt]["APPROVED_BY"].ToString(); if (!string.IsNullOrWhiteSpace(dt.Rows[iCnt]["APPROVED_TS"].ToString())) { objSchRequisitionView.APPROVED_TS = Convert.ToDateTime(dt.Rows[iCnt]["APPROVED_TS"].ToString()); } } catch { continue; } try { objSchRequisitionView.ISAPPROVED_DIST = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_DIST"].ToString()); objSchRequisitionView.APPROVED_BY_DIST = dt.Rows[iCnt]["APPROVED_BY_DIST"].ToString(); if (!string.IsNullOrWhiteSpace(dt.Rows[iCnt]["APPROVED_TS_DIST"].ToString())) { objSchRequisitionView.APPROVED_TS_DIST = Convert.ToDateTime(dt.Rows[iCnt]["APPROVED_TS_DIST"].ToString()); } } catch { continue; } objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString()); objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy"); objSchRequisitionView.SaveStatus = Convert.ToInt16(dt.Rows[iCnt]["SAVE_STATUS"].ToString()); objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString()); objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString()); objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString()); objSchRequisitionView.Category = Convert.ToString(dt.Rows[iCnt]["BOOK_CATEGORY"].ToString()); objSchRequisitionView.LastUpdatedBy = Convert.ToString(dt.Rows[iCnt]["UPDATED_BY"].ToString()); objSchRequisitionView.LastUpdatedOn = Convert.ToDateTime(dt.Rows[iCnt]["UPDATED_TS"].ToString()).ToString("dd-MMM-yyyy"); // 4.12.18 Admin approval section try { objSchRequisitionView.ISAPPROVED_ADMIN = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_ADMIN"].ToString()); } catch { continue; } objSchRequisitionViewList.Add(objSchRequisitionView); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } //return Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet); return(PartialView("_ReqList", objSchRequisitionViewList)); }