public ActionResult DeleteConfirmed(int id)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int usID102 = usID101.First();
if (usID102 == 2)
{
connTypeDb connTypeDb = db.connTypeDbs.Find(id);
db.connTypeDbs.Remove(connTypeDb);
db.SaveChanges();
return(RedirectToAction("Index", "connType", new { projectID = 6, taskOrderID = 32, Int1 = 1 }));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
// GET: connTypeDbs/Edit/5
public ActionResult Edit(int?id)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int usID102 = usID101.First();
if (usID102 == 2)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
connTypeDb connTypeDb = db.connTypeDbs.Find(id);
if (connTypeDb == null)
{
return(HttpNotFound());
}
ViewBag.clientsDb = new SelectList(db.clientsDbs, "ID", "clientName");
var int101 = from s in db.connTypeDbs where s.ID == id select s.clientID;
int int102 = int101.Single();
var int201 = from s in db.connTypeDbs where s.ID == id select s.projectID;
int int202 = int201.Single();
ViewBag.clientsProjectsDb = new SelectList(db.clientsProjectsDbs.Where(s => s.ID == 1 || s.clientID == int102)
.OrderBy(s => s.ID), "ID", "projectName");
ViewBag.taskOrdersDb = new SelectList(db.taskOrdersDbs.Where(s => s.ID == 1 || (s.clientID == int102 && s.projectID == int202))
.OrderBy(s => s.ID), "ID", "taskOrder");
ViewBag.currentUserLoginID = User.Identity.GetUserId().ToString();
ViewBag.currentTimeDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
return(View(connTypeDb));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult Edit([Bind(Include = "ID, clientID, projectID, taskOrderID, connType, createdDT, editedDT, createdByUserID")] connTypeDb connTypeDb)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int usID102 = usID101.First();
if (usID102 == 2)
{
if (ModelState.IsValid)
{
db.Entry(connTypeDb).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "connType", new { projectID = 6, taskOrderID = 32, Int1 = 1 }));
}
return(View(connTypeDb));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
// GET: connTypeDbs/Delete/5
public ActionResult Delete(int?id)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int usID102 = usID101.First();
if (usID102 == 2)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
connTypeDb connTypeDb = db.connTypeDbs.Find(id);
if (connTypeDb == null)
{
return(HttpNotFound());
}
return(View(connTypeDb));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
