public ActionResult PrequalifiedApplications() { var nvOdata = WsConfig.ODataObj(); var preqlflines = nvOdata.PrequalifiedSuppliers.Where(r => r.Contact_No == Convert.ToString(Session["contactNo"]) && r.Pre_Qualified == false); return(View(preqlflines)); }
public ActionResult AcceptedPreQualification() { var nvOdata = WsConfig.ODataObj(); var acceptedPreq = nvOdata.PrequalifiedSuppliers.Where(r => r.Contact_No == Convert.ToString(Session["contactNo"]) && r.Pre_Qualified == true); return(View(acceptedPreq)); }
public ActionResult SupplierCategory() { var nvOdata = WsConfig.ODataObj(); var supplierlines = nvOdata.SupplyCategoryHeader.Where(r => r.Fiscal_Year == Convert.ToString(Session["currentYear"])).ToList(); return(View(supplierlines)); }
public JsonResult SelectedPosta(string postcode) { var nvOdata = WsConfig.ODataObj(); var mycity = nvOdata.postcodes.Where(c => c.Code == postcode).ToList(); var result = mycity.FirstOrDefault(); if (result != null) { return(Json(result.City, JsonRequestBehavior.AllowGet)); } return(Json("notfound", JsonRequestBehavior.AllowGet)); }
private static List <SelectListItem> Country() { var nvOdata = WsConfig.ODataObj(); var myCountry = nvOdata.Countries.ToList(); List <SelectListItem> countryitems = myCountry.Select(nchi => new SelectListItem { Text = nchi.Code, Value = nchi.Name }).ToList(); return(countryitems); }
private static List <SelectListItem> PostalCode() { var nvOdata = WsConfig.ODataObj(); var myPostcode = nvOdata.postcodes.ToList(); List <SelectListItem> postalitems = myPostcode.Select(posta => new SelectListItem { Text = posta.Code, Value = posta.Code }).ToList(); return(postalitems); }
private static List <SelectListItem> SupplierCategories() { var nvOdata = WsConfig.ODataObj(); var mySupplyCats = nvOdata.SupplierCategories.ToList(); List <SelectListItem> supplierItems = mySupplyCats.Select(supplier => new SelectListItem { Text = supplier.Description, Value = supplier.Category_Code }).ToList(); return(supplierItems); }
//protected void GetmeYears() //{ // // Clear items: // ddlYears.Items.Clear(); // // Add default item to the list // ddlYears.Items.Add("--Select Year--"); // // Start loop // for (int i = 0; i < 20; i++) // { // // For each pass add an item // // Add a number of years (negative, which will subtract) to current year // ddlYears.Items.Add(DateTime.Now.AddYears(-i).Year.ToString()); // } //} private static List <SelectListItem> FiscalYear() { var nvOdata = WsConfig.ODataObj(); var myYears = nvOdata.FiscalYears.ToList(); List <SelectListItem> yearItems = myYears.Select(myyear => new SelectListItem { Text = myyear.Code, Value = myyear.Code }).ToList(); return(yearItems); }
public JsonResult CheckLogin(string myUsername, string myPassword) { try { var nvOdata = WsConfig.ODataObj(); if (string.IsNullOrWhiteSpace(myUsername)) { return(Json("UsernameEmpty", JsonRequestBehavior.AllowGet)); } if (string.IsNullOrWhiteSpace(myPassword)) { return(Json("PasswordEmpty", JsonRequestBehavior.AllowGet)); } var loginresult = nvOdata.PortalUsers.Where(o => o.Email == myUsername); var result = loginresult.FirstOrDefault(); if (result != null) { Session["userNo"] = result.CustomerNo; if (result.Password != EncryptP(myPassword)) { return(Json("PasswordMismatched", JsonRequestBehavior.AllowGet)); } var contactDetails = nvOdata.contacts.Where(m => m.E_Mail == myUsername).ToList().SingleOrDefault(); if (contactDetails != null) { //set Sessions here Session["name"] = contactDetails.Name; Session["email"] = contactDetails.E_Mail; Session["password"] = contactDetails.password; Session["contactNo"] = contactDetails.No; Session["currentYear"] = WsConfig.EProcWebRef.GetCurrentYear(); } //check if the are in Vendor table var vendorcollection = nvOdata.Vendors.Where(t => t.Primary_Contact_No == (string)Session["contactNo"]).ToList(); if (result.isAdmin == true && result.ActivatedAsVendor == true) { Session["isAdmin"] = "administrator"; foreach (var vend in vendorcollection) { Session["vendorNo"] = vend.No; } CountApplicationsInfo((string)Session["vendorNo"]); return(Json("Loginadmin", JsonRequestBehavior.AllowGet)); } if (result.isAdmin == false && result.ActivatedAsVendor == true) { Session["isAdmin"] = "customer"; foreach (var vend in vendorcollection) { Session["vendorNo"] = vend.No; } return(Json("Logincustomer", JsonRequestBehavior.AllowGet)); } if (result.isAdmin == false && result.ActivatedAsVendor == false) { Session["isAdmin"] = "contact"; Session["vendorNo"] = null; return(Json("Logincontact", JsonRequestBehavior.AllowGet)); } } return(Json("InvalidLogin", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }