public ActionResult Index(int?page, string UPNO, string currentFilterUP, int filterBonderId = 0, int BONDERID = 0) { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"].ToString(); TempData.Remove("Message"); } var ups = db.UPs.Include(u => u.BONDER); int pageSize = recordNumbers; int pageNumber = (page ?? 1); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { List <UP> initialUps = new List <UP>(); ViewBag.resultofbonderID = BONDERID; return(View(initialUps.ToList().ToPagedList(pageNumber, pageSize))); } if (UPNO != null || BONDERID != 0) { page = 1; } else { if (UPNO == null) { UPNO = currentFilterUP; } if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.filterBonderId = BONDERID; ViewBag.CurrentFilterUP = UPNO; if (loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; ups = db.UPs.Include(u => u.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; ups = db.UPs.Include(u => u.BONDER).Where(e => e.BONDERID == BONDERID); } if (UPNO != null) { ups = ups.Include(u => u.BONDER).Where(e => e.UPNO.Contains(UPNO)); } ViewBag.userBonderId = loggedinUser.BONDERID; if (BONDERID != 0) { if (loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; ups = db.UPs.Include(u => u.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; ups = db.UPs.Include(u => u.BONDER).Where(e => e.BONDERID == BONDERID); } if (UPNO != null) { ups = ups.Include(u => u.BONDER).Where(e => e.UPNO.Contains(UPNO)); } } return(View(ups.ToList().ToPagedList(pageNumber, pageSize))); }
public ActionResult createOrEditRequest(IList <EXBOND> exbonds, IList <ATTACHMENT> attachments, short ID = 0) { USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); if (TempData["isAnyAttachment"] != null) { bool isAnyAttachment = (bool)TempData["isAnyAttachment"]; if (!isAnyAttachment) { attachments = null; } } var files = Request.Files; //for (int i = 0; i < Request.Files.Count; i++) //{ // HttpPostedFileBase file = files[i]; // var fileName = Path.GetFileName(file.FileName); //} if (attachments != null) { foreach (ATTACHMENT attachment in attachments) { if (attachment != null && attachment.CONTENT == null && attachment.ID == 0 && attachment.NAME == null) { if (ID <= 0) { return(RedirectToAction("Create", new { error = "Please provide a valid file" })); } else { return(RedirectToAction("AddMoreAttachment", new { ID, errorMessage = "Please provide a valid file" })); } } } } bool attachmentValid = false; foreach (string extensions in GlobalConstants.extensions) { try { if (attachments.Any(item => item.CONTENT.EndsWith(extensions))) { attachmentValid = true; break; } } catch (Exception e) { attachmentValid = true; } } if (!attachmentValid) { if (ID <= 0) { return(RedirectToAction("Create", new { error = "Please provide a valid file" })); } else { return(RedirectToAction("Edit", new { ID, error = "Please provide a valid file" })); } } List <ATTACHMENT> newAttachmentList = new List <ATTACHMENT>(); if (attachments != null) { for (int i = 0; i < attachments.Count(); i++) { if (attachments[i].CONTENT != null) { newAttachmentList.Add(attachments[i]); } } } UPREQUEST uprequest = new UPREQUEST(); IList <EXBOND> exbondList = new List <EXBOND>(); bool flag = true; bool isanyselected = false; if (exbonds != null) { for (int i = 0; i < exbonds.Count(); i++) { int id = exbonds[i].ID; if (exbonds[i].IsSelected) { isanyselected = true; EXBOND exbond = db.EXBONDs.Find(id); int b2bCount = exbond.EXBONDBACKTOBACKs.Count(); if (exbond != null && b2bCount < 1) { flag = false; } else { uprequest.BONDERID = exbond.BONDERID; exbondList.Add(exbond); } } } } if (!isanyselected && ID <= 0) { return(RedirectToAction("Create", new { error = "Please select at least one exbond" })); } if (!flag && ID <= 0) { return(RedirectToAction("Create", new { error = "Sorry! please check all selected Exbond has at least one backtoback" })); } else { short lastInserted = 0; //if (ModelState.IsValid) //{ if (ID <= 0) { DateTime thisDay = DateTime.Today; uprequest.CREATEDDATE = thisDay; if (loggedinUser != null) { uprequest.CREATEDBY = loggedinUser.APPUSER.USERNAME; } uprequest.STATUS = 2; db.UPREQUESTs.Add(uprequest); db.SaveChanges(); lastInserted = db.UPREQUESTs.Max(item => item.ID); } else { uprequest = db.UPREQUESTs.Find(ID); UPREQUEST newRequest = new UPREQUEST(); newRequest.ID = ID; newRequest.BONDERID = uprequest.BONDERID; newRequest.STATUS = uprequest.STATUS; newRequest.MODIFIEDDATE = DateTime.Today; uprequest.CREATEDDATE = uprequest.CREATEDDATE; uprequest.CREATEDBY = uprequest.CREATEDBY; if (loggedinUser != null) { uprequest.MODIFIEDBY = loggedinUser.APPUSER.USERNAME; } using (var newdb2 = new OracleEntitiesConnStr()) { newdb2.Entry(newRequest).State = EntityState.Modified; newdb2.SaveChanges(); } lastInserted = ID; } for (int x = 0; x < exbondList.Count(); x++) { using (var db1 = new OracleEntitiesConnStr()) { UPEXBONDLIST upexbond = new UPEXBONDLIST(); upexbond.EXBONDID = exbondList[x].ID; upexbond.UPREQUESTID = lastInserted; db1.UPEXBONDLISTs.Add(upexbond); db1.SaveChanges(); } } for (int k = 0; k < newAttachmentList.Count(); k++) { string path = UploadedPath(files[k], newAttachmentList[k].CONTENT); attachments[k].CONTENT = path; using (var db2 = new OracleEntitiesConnStr()) { attachments[k].UPREQUESTID = lastInserted; db2.ATTACHMENTs.Add(attachments[k]); db2.SaveChanges(); } } // } if (ID <= 0) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Edit/" + ID)); } } }
public override void OnAuthorization(AuthorizationContext filterContext) { string idParam = ""; var descriptor = filterContext.ActionDescriptor; var actionName = descriptor.ActionName; var controllerName = descriptor.ControllerDescriptor.ControllerName; if (!filterContext.HttpContext.User.Identity.IsAuthenticated) { //if not logged, it will work as normal Authorize and redirect to the Login base.HandleUnauthorizedRequest(filterContext); return; } else if (!this.Roles.Split(',').Select(x => x.Trim()).Distinct().ToArray().Any(filterContext.HttpContext.User.IsInRole)) { // The user is not in any of the listed roles => // show the unauthorized view filterContext.Result = filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } try { idParam = filterContext.Controller.ValueProvider.GetValue("id").AttemptedValue; } catch (NullReferenceException ex) { return; } int id; string username = FormsAuthentication.Decrypt(HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name; APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.USERNAME.Equals(username, StringComparison.OrdinalIgnoreCase)); USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); if (int.TryParse(idParam, out id)) { if (System.Web.HttpContext.Current.User.IsInRole("Bonder")) { if (id != appuser.ID && controllerName.Equals("AppUser")) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } if (controllerName.Equals("ExBond")) { if (loggedinUser == null) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } else { EXBOND exbond = db.EXBONDs.SingleOrDefault(u => u.ID == id); if (exbond != null && exbond.BONDERID != loggedinUser.BONDERID) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } } } if (controllerName.Equals("InBond")) { if (loggedinUser == null) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } else { INBOND inbond = db.INBONDs.SingleOrDefault(u => u.ID == id); if (inbond != null && inbond.BONDERID != loggedinUser.BONDERID) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } } } /*if (controllerName.Equals("Back2BackLC")) * { * if (loggedinUser == null) * { * filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); * } * else * { * BACKTOBACKLC back2back = db.BACKTOBACKLCs.SingleOrDefault(u => u.ID == id); * if (back2back!=null && back2back.BONDERID != loggedinUser.BONDERID) * { * filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); * } * } * }*/ if (controllerName.Equals("UP")) { if (loggedinUser == null) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } } if (controllerName.Equals("UPRequest")) { if (loggedinUser == null) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } else { UPREQUEST uprequest = db.UPREQUESTs.SingleOrDefault(u => u.ID == id); if (uprequest != null && uprequest.BONDERID != loggedinUser.BONDERID) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Error", action = "AccessDenied" })); } } } } } }
public ActionResult Index(int?page, int filterBonderId = 0, int BONDERID = 0, int STATUSID = 0) { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"].ToString(); TempData.Remove("Message"); } ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); ViewBag.STATUSID = new List <SelectListItem> { new SelectListItem { Text = "Approved", Value = "20" }, new SelectListItem { Text = "Pending For Approval", Value = "2" }, new SelectListItem { Text = "Rejected", Value = "10" } }; int pageSize = recordNumbers; int pageNumber = (page ?? 1); USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); var uprequests = db.UPREQUESTs.OrderByDescending(r => r.ID); if (User.IsInRole("Bonder")) { BONDERID = (int)loggedinUser.BONDERID; } if (BONDERID == 0 && filterBonderId == 0) { List <UPREQUEST> request = new List <UPREQUEST>(); ViewBag.resultofbonderID = BONDERID; return(View(request.ToList().ToPagedList(pageNumber, pageSize))); } if (BONDERID != 0) { page = 1; } else { if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.filterBonderId = BONDERID; if (loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; uprequests = db.UPREQUESTs.Include(e => e.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID && e.STATUS == STATUSID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; uprequests = db.UPREQUESTs.Include(e => e.BONDER).Where(e => e.BONDERID == BONDERID && e.STATUS == STATUSID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } if (BONDERID != 0) { if (loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; uprequests = db.UPREQUESTs.Include(e => e.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID && e.STATUS == STATUSID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; uprequests = db.UPREQUESTs.Include(e => e.BONDER).Where(e => e.BONDERID == BONDERID && e.STATUS == STATUSID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; uprequests = uprequests.Where(i => i.BONDERID == loggedinUser.BONDERID && i.STATUS == STATUSID).OrderBy(i => i.BONDER.BONDERNAME).ThenByDescending(i => i.ID); } return(View(uprequests.ToPagedList(pageNumber, pageSize))); }
public ActionResult Create(int?page, int BONDERID = 0, int filterBonderId = 0) { TempData["isAnyAttachment"] = false; TempData.Keep(); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); int pageSize = recordNumbers; int pageNumber = (page ?? 1); var exbonds = db.EXBONDs.OrderByDescending(b => b.ID).Where(b => b.UPEXBONDLISTs.Count() < 1); var requestType = this.HttpContext.Request.RequestType; USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); ViewBag.error = Request.QueryString["error"]; ViewBag.requestID = (short)0; if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { List <EXBOND> exbond = new List <EXBOND>(); ViewBag.resultofbonderID = BONDERID; return(View("Exbondselector", exbond.ToList().ToPagedList(pageNumber, pageSize))); } if (BONDERID != 0) { page = 1; } else { if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.filterBonderId = BONDERID; if (requestType == "GET") { if (BONDERID > 0) { exbonds = db.EXBONDs.Where(u => u.BONDERID == BONDERID && u.UPEXBONDLISTs.Count() < 1).OrderByDescending(r => r.ID); ViewBag.resultofbonderID = BONDERID; } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; exbonds = exbonds.Where(i => i.BONDERID == loggedinUser.BONDERID && i.UPEXBONDLISTs.Count() < 1).OrderBy(i => i.BONDER.BONDERNAME).ThenByDescending(i => i.ID); } return(View("Exbondselector", exbonds.ToPagedList(pageNumber, pageSize))); } else if (requestType == "POST") { if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; exbonds = db.EXBONDs.Where(u => u.BONDERID == BONDERID && u.UPEXBONDLISTs.Count() < 1).OrderByDescending(r => r.ID); } } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; exbonds = exbonds.Where(i => i.BONDERID == loggedinUser.BONDERID && i.UPEXBONDLISTs.Count() < 1).OrderBy(i => i.BONDER.BONDERNAME).ThenByDescending(i => i.ID); } return(View("Exbondselector", exbonds.ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(int?page, string FromDate, string ToDate, int BONDERID = 0) { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); List <ANNUALENTLRAWMATERIAL> aerawmaterials = new List <ANNUALENTLRAWMATERIAL>(); int pageSize = recordNumbers; int pageNumber = (page ?? 1); USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); if (BONDERID == 0 && !User.IsInRole("Bonder")) { ViewBag.resultofbonderID = BONDERID; return(View(aerawmaterials.ToList().ToPagedList(pageNumber, pageSize))); } if (loggedinUser != null && loggedinUser.BONDERID != null) { BONDERID = (int)loggedinUser.BONDERID; } var annualentlrawmaterials = db.ANNUALENTLRAWMATERIALs.Include(a => a.MATERIAL).Include(a => a.MEASUREMENTUNIT); if ((FromDate == String.Empty || ToDate == String.Empty) && BONDERID != 0) { BONDREGISTRATION registrationInfo = db.BONDREGISTRATIONs.Where(br => br.BONDERSLNO == BONDERID).SingleOrDefault(); FromDate = registrationInfo.ISSUEDATE.ToString(); ToDate = registrationInfo.EXPIRYDATE.ToString(); } if ((FromDate != null && FromDate != String.Empty) && (ToDate != null && ToDate != String.Empty) && BONDERID != 0) { DateTime fromAEDate = Convert.ToDateTime(FromDate); DateTime toAEDate = Convert.ToDateTime(ToDate); annualentlrawmaterials = annualentlrawmaterials.Where(ae => ae.BONDERSLNO == BONDERID); if (annualentlrawmaterials != null) { foreach (var item in annualentlrawmaterials.ToList()) { var bonderAE = db.BONDERANNUALENTITLEMENTs.Where(bae => bae.AESLNO == item.AESLNO && bae.BONDERSLNO == item.BONDERSLNO && bae.ENTITLEFROM >= fromAEDate && bae.ENTITLETO <= toAEDate).Select(bae => new { From = bae.ENTITLEFROM, To = bae.ENTITLETO }).SingleOrDefault(); if (bonderAE != null && bonderAE.From != null && bonderAE.To != null) { item.ENTITLEFROM = bonderAE.From; item.ENTITLETO = bonderAE.To; aerawmaterials.Add(item); } } } ViewBag.resultofbonderID = BONDERID; ViewBag.CurrentFilterFrDate = FromDate; ViewBag.CurrentFilterToDate = ToDate; } else if ((FromDate == String.Empty || ToDate == String.Empty) && BONDERID != 0) { annualentlrawmaterials = annualentlrawmaterials.Where(ae => ae.BONDERSLNO == BONDERID); foreach (var item in annualentlrawmaterials.ToList()) { var bonderAE = db.BONDERANNUALENTITLEMENTs.Where(bae => bae.AESLNO == item.AESLNO && bae.BONDERSLNO == item.BONDERSLNO).Select(bae => new { From = bae.ENTITLEFROM, To = bae.ENTITLETO }).FirstOrDefault(); if (bonderAE != null && bonderAE.From != null && bonderAE.To != null) { item.ENTITLEFROM = bonderAE.From; item.ENTITLETO = bonderAE.To; aerawmaterials.Add(item); } } ViewBag.resultofbonderID = BONDERID; ViewBag.CurrentFilterFrDate = FromDate; ViewBag.CurrentFilterToDate = ToDate; } ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", ViewBag.resultofbonderID); return(View(aerawmaterials.ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(int?page, int filterBonderId = 0, int BONDERID = 0) { int pageSize = recordNumbers; int pageNumber = (page ?? 1); var annualentlrawmaterials = db.ANNUALENTLRAWMATERIALs.Include(a => a.MATERIAL).Include(a => a.MEASUREMENTUNIT); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { List <ANNUALENTLRAWMATERIAL> aerawmaterials = new List <ANNUALENTLRAWMATERIAL>(); ViewBag.resultofbonderID = BONDERID; return(View(aerawmaterials.ToList().ToPagedList(pageNumber, pageSize))); } USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); if (BONDERID != 0) { page = 1; } else { if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.filterBonderId = BONDERID; if (loggedinUser != null && loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; annualentlrawmaterials = db.ANNUALENTLRAWMATERIALs.Include(a => a.MATERIAL).Include(a => a.MEASUREMENTUNIT).Where(e => e.BONDERSLNO == loggedinUser.BONDERID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; annualentlrawmaterials = db.ANNUALENTLRAWMATERIALs.Include(a => a.MATERIAL).Include(a => a.MEASUREMENTUNIT).Where(e => e.BONDERSLNO == BONDERID); } if (BONDERID != 0) { if (loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; annualentlrawmaterials = db.ANNUALENTLRAWMATERIALs.Include(a => a.MATERIAL).Include(a => a.MEASUREMENTUNIT).Where(e => e.BONDERSLNO == loggedinUser.BONDERID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; annualentlrawmaterials = db.ANNUALENTLRAWMATERIALs.Include(a => a.MATERIAL).Include(a => a.MEASUREMENTUNIT).Where(e => e.BONDERSLNO == BONDERID); } } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; annualentlrawmaterials = annualentlrawmaterials.Where(i => i.BONDERSLNO == loggedinUser.BONDERID); } foreach (var item in annualentlrawmaterials.ToList()) { var bonderAE = db.BONDERANNUALENTITLEMENTs.Where(bae => bae.AESLNO == item.AESLNO && bae.BONDERSLNO == item.BONDERSLNO).Select(bae => new { From = bae.ENTITLEFROM, To = bae.ENTITLETO }).Single(); item.ENTITLEFROM = bonderAE.From; item.ENTITLETO = bonderAE.To; } ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", ViewBag.resultofbonderID); return(View(annualentlrawmaterials.ToList().ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(string LCNo, string FromDate, string ToDate, string currentFilterLC, String currentFilterFrDate, String currentFilterToDate, int?page, int filterBonderId = 0, int BONDERID = 0) { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"].ToString(); TempData.Remove("Message"); } var requestType = this.HttpContext.Request.RequestType; System.Diagnostics.Debug.WriteLine("requestType = " + requestType); USERPERMISSION loggedinUser = new SessionAttributeRetreival().getStoredUserPermission(); var backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER); int pageSize = recordNumbers; int pageNumber = (page ?? 1); if (LCNo != null || FromDate != null || ToDate != null || BONDERID != 0) { page = 1; } else { if (LCNo == null) { LCNo = currentFilterLC; } if (FromDate == null) { FromDate = currentFilterFrDate; } if (ToDate == null) { ToDate = currentFilterToDate; } if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.CurrentFilterLC = LCNo; ViewBag.CurrentFilterFrDate = FromDate; ViewBag.CurrentFilterToDate = ToDate; ViewBag.filterBonderId = BONDERID; ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); if ("GET" == requestType) { if (LCNo != null || FromDate != null || ToDate != null || BONDERID != 0) { ViewBag.resultofbonderID = BONDERID; backtobacklcs = GetBackToBackRolesBySearchCriterial(LCNo, FromDate, ToDate, loggedinUser, BONDERID); } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; backtobacklcs = backtobacklcs.Where(i => i.BONDERID == loggedinUser.BONDERID).OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER); } else if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { ViewBag.resultofbonderID = BONDERID; List <BACKTOBACKLC> backtobacklc = new List <BACKTOBACKLC>(); return(View(backtobacklc.ToPagedList(pageNumber, pageSize))); } return(View(backtobacklcs.ToList().ToPagedList(pageNumber, pageSize))); } else if ("POST" == requestType) { if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { ViewBag.resultofbonderID = BONDERID; List <BACKTOBACKLC> backtobacklc = new List <BACKTOBACKLC>(); return(View(backtobacklc.ToPagedList(pageNumber, pageSize))); } if (!string.IsNullOrEmpty(LCNo)) { LCNo = LCNo.Trim(); } System.Diagnostics.Debug.WriteLine("LCNo = " + LCNo + ", FromDate = " + FromDate + ", ToDate = " + ToDate); if (LCNo.Equals(String.Empty) && FromDate.Equals(String.Empty) && ToDate.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("if"); } else if ((LCNo != null && !LCNo.Equals(String.Empty)) && (FromDate != null && !FromDate.Equals(String.Empty)) && (ToDate != null && !ToDate.Equals(String.Empty))) { System.Diagnostics.Debug.WriteLine("else if 1"); DateTime fromLCDate = Convert.ToDateTime(FromDate); DateTime toLCDate = Convert.ToDateTime(ToDate); backtobacklcs = backtobacklcs.Where(b => b.LCNUMBER.Contains(LCNo) && (b.LCDATE >= fromLCDate && b.LCDATE <= toLCDate)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID); } else if ((FromDate != null && !FromDate.Equals(String.Empty)) && (ToDate != null && !ToDate.Equals(String.Empty))) { System.Diagnostics.Debug.WriteLine("else if 2"); DateTime fromLCDate = Convert.ToDateTime(FromDate); DateTime toLCDate = Convert.ToDateTime(ToDate); backtobacklcs = backtobacklcs.Where(b => (b.LCDATE >= fromLCDate && b.LCDATE <= toLCDate)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID); } else if (LCNo != null && !LCNo.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("else if 3"); backtobacklcs = backtobacklcs.Where(b => b.LCNUMBER.Contains(LCNo)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID); } else if (FromDate != null && !FromDate.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("else if 4"); DateTime fromLCDate = Convert.ToDateTime(FromDate); backtobacklcs = backtobacklcs.Where(b => b.LCDATE >= fromLCDate).OrderByDescending(b => b.ID); } else if (ToDate != null && !ToDate.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("else if 5"); DateTime toLCDate = Convert.ToDateTime(ToDate); backtobacklcs = backtobacklcs.Where(b => b.LCDATE <= toLCDate).OrderByDescending(b => b.ID); } if (loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; backtobacklcs = backtobacklcs.Where(e => e.BONDERID == loggedinUser.BONDERID).OrderByDescending(b => b.ID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; backtobacklcs = backtobacklcs.Where(e => e.BONDERID == BONDERID).OrderByDescending(b => b.ID); } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; backtobacklcs = backtobacklcs.Where(i => i.BONDERID == loggedinUser.BONDERID).OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER); } } else { // Error handel } pageSize = recordNumbers; pageNumber = (page ?? 1); return(View(backtobacklcs.ToPagedList(pageNumber, pageSize))); }