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);
}
