public ActionResult SubmitServiceRequest(string DateDue, string VendorType, string Details) { ServiceRequest x = new ServiceRequest(); List <int> y = new List <int>(); y.Add(1); y.Add(2); using (var db = new AFEWellBookDB()) { x.OperatorID = 1; x.DateDue = Convert.ToDateTime(DateDue); x.DatePosted = DateTime.Now; x.StatusID = (int)ServiceRequestModel.ServiceStatus.OPEN; x.VendorIDList = y; x.Details = Details; db.Insert(x, "ServiceRequest", "AFEWellBook"); } return(Json(x, JsonRequestBehavior.AllowGet)); }
public JsonResult GetSubCategories(int categoryID) { using (var db = new AFEWellBookDB()) { var subCategories = 9; //get em where categoryID = categoryID return(Json(subCategories, JsonRequestBehavior.AllowGet)); } }
public ActionResult Validate(string Username, string Password) { using (var db = new AFEWellBookDB()) { if (db.Users.Any(p => p.UserName == Username && p.UserPassword == Password)) { var x = 9; } } return(View()); }
public JsonResult GetCategories() { Dictionary <int, string> categories = new Dictionary <int, string>(); using (var db = new AFEWellBookDB()) { foreach (var x in db.Categories) { categories.Add(x.CategoryID, x.NameX); } } return(Json(categories, JsonRequestBehavior.AllowGet)); }
public JsonResult GetServiceRequests(int vendorID) { List <ServiceRequest> serviceRequests = new List <ServiceRequest>(); using (var db = new AFEWellBookDB()) { var v = db.Vendors; var x = db.ServiceRequests.Where(s => s.VendorIDList.Contains(vendorID)); foreach (var serveReq in x) { serviceRequests.Add(serveReq); } } return(Json(serviceRequests, JsonRequestBehavior.AllowGet)); }
public ActionResult AcceptQuote(int serviceRequestID, int quoteID) { using (var db = new AFEWellBookDB()) { db.ServiceRequests.Where(s => s.ServiceRequestID == serviceRequestID).FirstOrDefault().AcceptedVendorID = db.Quotes.Where(q => q.QuoteID == quoteID).FirstOrDefault().VendorID; db.ServiceRequests.Where(s => s.ServiceRequestID == serviceRequestID).FirstOrDefault().StatusID = 3; db.Quotes.Where(q => q.QuoteID == quoteID).FirstOrDefault().StatusID = 4; db.Update(db.ServiceRequests); } return(View()); }
public ActionResult Validate(string Username, string Password) { bool isValid = false; int UserID = 0; using (var db = new AFEWellBookDB()) { if (db.Users.Any(p => p.UserName == Username && p.UserPassword == Password)) { isValid = true; UserID = db.Users.Where(x => x.UserName == Username).Select(x => x.UserID).FirstOrDefault(); } } return(Json(new { isValid = "isValid", UserID = "UserID" }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPendingServiceRequests() { List <ServiceRequest> serviceRequests = new List <ServiceRequest>(); using (var db = new AFEWellBookDB()) { var sreq = from sr in db.ServiceRequests join q in db.Quotes on sr.ServiceRequestID equals q.ServiceRequestID where q.StatusID == 2 //&& sr.OperatorID == THIS OPERATOR select sr; foreach (var s in sreq) { serviceRequests.Add(s); } } return(Json(serviceRequests, JsonRequestBehavior.AllowGet)); }
public ActionResult PlaceQuote(int serviceRequestID, string quoteAmt) { Quote x = new Quote(); using (var db = new AFEWellBookDB()) { x.QuoteAmount = Convert.ToDouble(quoteAmt); x.ServiceRequestID = serviceRequestID; x.StatusID = 2; x.DateSubmitted = DateTime.Now; //TODO: WRITE TO DOCUMENT TABLE //x.DocumentID //x.VendorID = THIS VENDOR db.Insert(x, "ServiceRequest", "AFEWellBook"); } return(View()); }