public ActionResult DeleteConfirmed(int id)
{
DriverTransactions driverTransactions = db.driverTransactionsObj.Find(id);
db.driverTransactionsObj.Remove(driverTransactions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "UserDetailsKey,TransactionsKey")] DriverTransactions driverTransactions)
{
if (ModelState.IsValid)
{
db.Entry(driverTransactions).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey", driverTransactions.TransactionsKey);
ViewBag.UserDetailsKey = new SelectList(db.userDetails, "UserDetailsKey", "Username", driverTransactions.UserDetailsKey);
return(View(driverTransactions));
}
// GET: DriverTransactions/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DriverTransactions driverTransactions = db.driverTransactionsObj.Find(id);
if (driverTransactions == null)
{
return(HttpNotFound());
}
return(View(driverTransactions));
}
// GET: DriverTransactions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DriverTransactions driverTransactions = db.driverTransactionsObj.Find(id);
if (driverTransactions == null)
{
return(HttpNotFound());
}
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey", driverTransactions.TransactionsKey);
ViewBag.UserDetailsKey = new SelectList(db.userDetails, "UserDetailsKey", "Username", driverTransactions.UserDetailsKey);
return(View(driverTransactions));
}
public ActionResult assignDriver(DriverTransactions driver)
{
int counter = 0;
int counter2 = 0;
var frmdb = (from gh in db.driverTransactionsObj
where gh.TransactionsKey == driver.TransactionsKey
select gh.TransactionsKey).ToList();
var frmdb2 = (from gh in db.driverTransactionsObj
where gh.TransactionsKey == driver.TransactionsKey && gh.UserDetailsKey == driver.UserDetailsKey
select gh.TransactionsKey).ToList();
foreach (var itm in frmdb)
{
counter++;
}
foreach (var itm in frmdb2)
{
counter2++;
}
if (counter2 < 1)
{
if (counter > 2)
{
ViewBag.message = "The Job you selected already has two drivers";
}
else if (ModelState.IsValid)
{
db.driverTransactionsObj.Add(driver);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
}
ViewBag.UserKey = new SelectList(db.userDetails, "UserKey", "UserName");
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey");
return(PartialView("_assignDriver"));
}
public ActionResult Create([Bind(Include = "UserDetailsKey,TransactionsKey")] DriverTransactions driverTransactions)
{
if (ModelState.IsValid)
{
if (driverTransactions.DriverAvailabilityChecker() == false)
{
if (driverTransactions.DriverChecker() == true)
{
ViewBag.message = "Driver you selected is not available until " + driverTransactions.DriverAvailabilityDate().Date;
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey", driverTransactions.TransactionsKey);
ViewBag.UserDetailsKey = new SelectList(db.userDetails, "UserDetailsKey", "Username", driverTransactions.UserDetailsKey);
return(View(driverTransactions));
}
else
{
db.driverTransactionsObj.Add(driverTransactions);
db.SaveChanges();
ViewBag.message = " The Driver has been assigned";
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey", driverTransactions.TransactionsKey);
ViewBag.UserDetailsKey = new SelectList(db.userDetails, "UserDetailsKey", "Username", driverTransactions.UserDetailsKey);
return(View(driverTransactions));
}
}
else
{
ViewBag.message = " The Driver you selected is already assigned to this task";
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey", driverTransactions.TransactionsKey);
ViewBag.UserDetailsKey = new SelectList(db.userDetails, "UserDetailsKey", "Username", driverTransactions.UserDetailsKey);
return(View(driverTransactions));
}
}
ViewBag.TransactionsKey = new SelectList(db.transactions, "TransactionsKey", "TransactionsKey", driverTransactions.TransactionsKey);
ViewBag.UserDetailsKey = new SelectList(db.userDetails, "UserDetailsKey", "Username", driverTransactions.UserDetailsKey);
return(View(driverTransactions));
}
