public ActionResult SaveRequest(RequestTable model) { try { if (ModelState.IsValid || model != null) { if (model.ID_Request > 0) { var EditRequest = db.RequestTables.Where(a => a.ID_Request == model.ID_Request).FirstOrDefault(); if (EditRequest != null) { EditRequest.Title = model.Title; EditRequest.Description = model.Description; EditRequest.RequestDateArrival = model.RequestDateArrival; EditRequest.RequestFinished = model.RequestFinished; EditRequest.Status.Title = model.Status.Title; EditRequest.Status.Description = model.Status.Description; } db.SaveChanges(); } } } catch (Exception ex) { return(View("Error")); } return(RedirectToAction("ListRequests")); }
public string Put(int id, [FromBody] Request obj) { SessionFactory sessionsFactory = new SessionFactory(); SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance(); var list = Request.Headers.ToList(); var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty); if (token == null) { return("NOT LOGED"); } var dispatcher = instance.SelectDispatcherSession(token); var driver = instance.SelectDriverSession(token); var manager = instance.SelectManagerSession(token); if (dispatcher == null && driver == null && manager == null) { return("NOT EXISTING USER"); } else if (obj == null) { return("NO OBJECT"); } RequestFactory requestFactory = new RequestFactory(); RequestTable <Request> instanceRequest = (RequestTable <Request>)requestFactory.GetRequestInstance(); instanceRequest.Update(obj); return("OK"); }
public IEnumerable <Request> Get() { RequestFactory requestFactory = new RequestFactory(); RequestTable <Request> instance = (RequestTable <Request>)requestFactory.GetRequestInstance(); return(instance.Select()); }
public Request Get(int id) { RequestFactory requestFactory = new RequestFactory(); RequestTable <Request> instance = (RequestTable <Request>)requestFactory.GetRequestInstance(); return(instance.Select(id)); }
public ActionResult DeleteConfirmed(int id) { RequestTable requestTable = db.RequestTables.Find(id); db.RequestTables.Remove(requestTable); db.SaveChanges(); return(RedirectToAction("Index")); }
//Downloads the file public FileResult DownloadFile(int idRequest) { RequestTable request = db.RequestTables.Find(idRequest); var fileName = request.FileName; byte[] bytes = request.FileData; var fileType = request.FileType; return(File(bytes, fileType, fileName)); }
//Check if on click to download button you have a file to download... //if you do than redirects you to download actionresult... //if not than it redirects you to the same page public RedirectToRouteResult IfDownload(int id) { RequestTable request = db.RequestTables.Find(id); if (request.FileName != null) { return(RedirectToAction("DownloadFile", new { idRequest = id })); } return(RedirectToAction("ListRequests")); }
public ActionResult Edit([Bind(Include = "Id,BookName,Location,RequestedBy,Daterequested")] RequestTable requestTable) { if (ModelState.IsValid) { db.Entry(requestTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id = new SelectList(db.Books, "Id", "Name", requestTable.Id); ViewBag.Id = new SelectList(db.StatesTables, "Id", "State", requestTable.Id); return(View(requestTable)); }
// GET: RequestTables/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RequestTable requestTable = db.RequestTables.Find(id); if (requestTable == null) { return(HttpNotFound()); } return(View(requestTable)); }
//Deletes the request public ActionResult DeleteReq(int id) { RequestTable request = db.RequestTables.Find(id); if (request == null) { return(View("Error")); } db.RequestTables.Remove(request); db.SaveChanges(); return(RedirectToAction("ListRequests")); }
public JsonResult Save(RequestTable request /*RequestDetail rd*/) { bool status = false; DateTime dateOrg; var isValidDate = DateTime.TryParseExact(request.RequestDateString, "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrg); if (isValidDate) { request.RequestDate = dateOrg; } if (ModelState.IsValid) { using (MainDBEntities mainDB = new MainDBEntities()) { //var isValidModel = TryUpdateModel(request); if (request.RequestID > 0 /*|| request.StatusID == 1*/) { //edycja var s = mainDB.RequestTables.Where(a => a.RequestID == request.RequestID).FirstOrDefault(); if (s != null) { s.RequestID = request.RequestID; s.RequestDate = request.RequestDate; s.Title = request.Title; s.ClientID = request.ClientID; s.TypeID = request.TypeID; s.StatusID = request.StatusID; s.UserID = request.UserID; s.Description = request.Description; } } else /*if(isValidModel)*/ { //zapis mainDB.RequestTables.Add(request); //mainDB.RequestDetails.Add(rd); } mainDB.SaveChanges(); status = true; } } RedirectToAction("index", "Request"); return(new JsonResult { Data = new { status = status } }); }
// GET: RequestTables/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RequestTable requestTable = db.RequestTables.Find(id); if (requestTable == null) { return(HttpNotFound()); } ViewBag.Id = new SelectList(db.Books, "Id", "Name", requestTable.Id); ViewBag.Id = new SelectList(db.StatesTables, "Id", "State", requestTable.Id); return(View(requestTable)); }
protected void btnRent_Click(object sender, EventArgs e) { RequestRepository repo = new RequestRepository(); string uid = Request.QueryString["uid"]; RequestTable req = new RequestTable(); string st = Session["UserID"].ToString(); req.UserID = int.Parse(st); req.MovieID = Convert.ToInt64(uid); repo.AddRequest(req); req.Date = DateTime.Now; btnRent.Visible = false; Label2.Visible = true; Label3.Visible = true; btnRent.Visible = false; }
/// <summary> /// 添加表 /// </summary> private void addPage() { string errmsg = ""; string data = Request["data"]; RequestTable info = ObjectSerializeHelper.JsonToObject <RequestTable>(data); string usercode = info.usercode; string pagename = info.pagename; // string gader = info.gader; //审核等级 BLLUserManage mybll = new BLLUserManage(); bool result = mybll.addPage(pagename, usercode, info.审核用户, ref errmsg); if (result) { Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "")); Response.End(); } else { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } }
public ActionResult SavingNewRequest(RequestTable modelReq, HttpPostedFileBase postedFile) { if (!ModelState.IsValid) { return(View("NewRequest")); } else if (postedFile == null || postedFile.ContentLength < 0) { try { var StatusRequest = new Status(); StatusRequest.Title = modelReq.Status.Title; StatusRequest.Description = modelReq.Status.Description; db.Status.Add(StatusRequest); db.SaveChanges(); var idStatus = StatusRequest.ID_Status; var EditRequest = new RequestTable(); EditRequest.Title = modelReq.Title; EditRequest.Description = modelReq.Description; EditRequest.RequestDateArrival = modelReq.RequestDateArrival; EditRequest.RequestRegistered = DateTime.Now.ToString(); EditRequest.RequestFinished = modelReq.RequestFinished; EditRequest.ID_Status = idStatus; db.RequestTables.Add(EditRequest); int row = db.SaveChanges(); return(RedirectToAction("ListRequests")); } catch (Exception ex) { return(View("Error")); } } else { try { int fileSize = postedFile.ContentLength; string filetype = postedFile.ContentType; var fileName = Path.GetFileName(postedFile.FileName); byte[] bytes = new byte[fileSize]; postedFile.InputStream.Read(bytes, 0, fileSize); var StatusRequest = new Status(); StatusRequest.Title = modelReq.Status.Title; StatusRequest.Description = modelReq.Status.Description; db.Status.Add(StatusRequest); db.SaveChanges(); var idStatus = StatusRequest.ID_Status; var EditRequest = new RequestTable(); EditRequest.Title = modelReq.Title; EditRequest.Description = modelReq.Description; EditRequest.RequestDateArrival = modelReq.RequestDateArrival; EditRequest.RequestRegistered = DateTime.Now.ToString(); EditRequest.RequestFinished = modelReq.RequestFinished; EditRequest.FileName = fileName; EditRequest.FileData = bytes; EditRequest.FileType = filetype; EditRequest.ID_Status = idStatus; db.RequestTables.Add(EditRequest); int row = db.SaveChanges(); return(RedirectToAction("ListRequests")); } catch (Exception e) { return(View("Error")); } } }
//Edit View public ActionResult EditRequest(int?id) { RequestTable EditRequest = db.RequestTables.Where(r => r.ID_Request == id).FirstOrDefault(); return(View(EditRequest)); }
public Overview Get() { SessionFactory sessionsFactory = new SessionFactory(); SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance(); var list = Request.Headers.ToList(); var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty); if (token == null) { return(new Overview()); } var dispatcher = instance.SelectDispatcherSession(token); var driver = instance.SelectDriverSession(token); var manager = instance.SelectManagerSession(token); if (dispatcher == null && driver == null && manager == null) { return(new Overview()); } Overview obj = new Overview(); RequestFactory requestFactory = new RequestFactory(); RequestTable <Request> instanceRequest = (RequestTable <Request>)requestFactory.GetRequestInstance(); var requests = instanceRequest.Select(); obj.acceptedRequests = requests.Where(r => r.state == RequestState.ACCEPTED).Count(); obj.declinedRequests = requests.Where(r => r.state == RequestState.DECLINED).Count(); obj.newRequests = requests.Where(r => r.state == RequestState.NEW).Count(); decimal salary = 0; DriverFactory driverFactory = new DriverFactory(); DriverTable <Driver> instanceDriver = (DriverTable <Driver>)driverFactory.GetDriverInstance(); var listDrivers = instanceDriver.Select(); obj.driverCount = listDrivers.Count(); salary += listDrivers.Sum(dr => dr.salary); DispatcherFactory dispatcherFactory = new DispatcherFactory(); DispatcherTable <Dispatcher> instanceDispatcher = (DispatcherTable <Dispatcher>)dispatcherFactory.GetDispatcherInstance(); var listDispatchers = instanceDispatcher.Select(); obj.dispatcherCount = listDispatchers.Count(); salary += listDispatchers.Sum(dis => dis.salary); obj.monthSalary = salary; VehicleFactory vehicleFactory = new VehicleFactory(); var instanceVehicle = vehicleFactory.GetVehicleInstance(); obj.vehicleCount = instanceVehicle.Select().Count(); FailureFactory failureFactory = new FailureFactory(); FailureTable <Failure> instanceFailure = (FailureTable <Failure>)failureFactory.GetFailureInstance(); var listFailures = instanceFailure.Select(); DateTime lastMonth = DateTime.Now.AddMonths(-1); obj.failurestInLastMonth = listFailures.Where(d => d.created > lastMonth).Count(); obj.failures = listFailures.Count(); return(obj); }