public RequisitionModel(RequisitionView entityView, bool isForIndex) { if (entityView != null) { this.BuyerId = entityView.BuyerId; this.BuyerName = entityView.BuyerName; this.CompanyId = entityView.CompanyId; this.CreateBy = entityView.CreateBy; this.CreateDate = entityView.CreateDate; this.Description = entityView.Description; this.Id = entityView.Id; this.RequisitionDate = entityView.RequisitionDate; this.RequisitionNo = entityView.RequisitionNo; this.SOBId = entityView.SOBId; this.UpdateBy = entityView.UpdateBy; this.UpdateDate = entityView.UpdateDate; } }
public ActionResult Index(String topLimit) { List <RequisitionView> lst_rq = new List <RequisitionView>(); try { Int64 TopLimitVal = 10; ViewBag.topLimit = TopLimitVal.ToString(); try { if (topLimit != "" && topLimit != null) { TopLimitVal = Convert.ToInt64(topLimit); ViewBag.topLimit = TopLimitVal.ToString(); Session["TopLimit"] = TopLimitVal; } else if (topLimit == "" || topLimit == null && Session["TopLimit"].ToString() != "") { TopLimitVal = Convert.ToInt64(Session["TopLimit"].ToString()); ViewBag.topLimit = TopLimitVal.ToString(); Session["TopLimit"] = ""; } else { ViewBag.topLimit = TopLimitVal.ToString(); Session["TopLimit"] = TopLimitVal; } } catch { TopLimitVal = 10; ViewBag.topLimit = TopLimitVal.ToString(); } string CircleId = "", CircleLock = "", ReqLockStartDate = "", ReqLockDate = "", defaultLock = "0"; try{ CircleId = GlobalSettings.oUserData.CircleID; //ReqLockStartDate = "07-Feb-"+ DateTime.Now.Year +" 00:00:00.000"; string[] formats = { "dd/MM/yyyy", "dd/M/yyyy", "d/M/yyyy", "d/MM/yyyy", "dd/MM/yy", "dd/M/yy", "d/M/yy", "d/MM/yy" }; DateTime dtF = DateTime.Now; DateTime.TryParseExact(ConfigurationManager.AppSettings["ReqLockStartDate"].ToString(), formats, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtF); ReqLockStartDate = dtF.ToString("dd-MMM-yyyy") + " 00:00:00.000"; } catch { CircleId = ""; CircleLock = ""; ReqLockDate = ""; } if (Convert.ToString(CircleId) != "") { DataTable dtReqView = objDbTrx.GetRequisitionViewDataByCercleId(Convert.ToInt32(CircleId), TopLimitVal); if (dtReqView.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtReqView.Rows.Count; iCnt++) { RequisitionView rq = new RequisitionView(); rq.requisitionid = Convert.ToInt64(dtReqView.Rows[iCnt]["REQUISITION_ID"].ToString()); rq.req_date = Convert.ToDateTime(dtReqView.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy hh:mm tt").ToUpper(); defaultLock = "1"; if (CircleLock == "1") { try { if (Convert.ToDateTime(rq.req_date) <= Convert.ToDateTime(ReqLockStartDate)) { defaultLock = "0"; rq.DeleteStatus = ""; rq.DeleteUrl = "#"; rq.requisition_stat = "Confirmed"; rq.url = "/RequisionView/Requisition?ReqSessionCode=" + Convert.ToString(dtReqView.Rows[iCnt]["REQUISITION_ID"].ToString()) + "&isConfirmed=1"; } } catch { defaultLock = "1"; } } if (defaultLock == "1") { rq.DeleteStatus = " Delete"; rq.DeleteUrl = "/RequisionView/DeleteReq?ReqSessionCode=" + Convert.ToString(dtReqView.Rows[iCnt]["REQUISITION_ID"].ToString()) + "&isConfirmed=0"; rq.requisition_stat = "Edit |"; rq.url = "/RequisionView/Requisition?ReqSessionCode=" + Convert.ToString(dtReqView.Rows[iCnt]["REQUISITION_ID"].ToString()) + ""; } rq.req_code = Convert.ToString(dtReqView.Rows[iCnt]["REQ_CODE"].ToString()); rq.school_name = Convert.ToString(dtReqView.Rows[iCnt]["SCHOOL_NAME"].ToString()); rq.school_code = Convert.ToString(dtReqView.Rows[iCnt]["SCHOOL_CODE"].ToString()); rq.language_name = Convert.ToString(dtReqView.Rows[iCnt]["LANGUAGE"].ToString()); rq.category_name = Convert.ToString(dtReqView.Rows[iCnt]["BOOK_CATEGORY"].ToString()); rq.topLimit = TopLimitVal; lst_rq.Add(rq); } } } else { return(RedirectToAction("Index", "CircleLogin")); } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } finally { } return(View(lst_rq)); }