public ActionResult DeleteConfirmed(int id)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
int userIDselectInt = userIDselectVar.Single();
List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.projectID)
.ToList();
List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.taskOrderID)
.ToList();
var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int userTypeInt = userTypeSelect.First();
if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(10) &&
returnTaskOrdersIDlist.Contains(41)))
{
k2017orgStrL3Db k2017orgStrL3Db = db.k2017orgStrL3Dbs.Find(id);
db.k2017orgStrL3Dbs.Remove(k2017orgStrL3Db);
db.SaveChanges();
return(RedirectToAction("Index", "k2017orgAdmStructure", new { projectID = 10, taskOrderID = 41, Int1 = 1 }));
}
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult Edit([Bind(Include = "ID, projectID, taskOrderID, orgStrL1ID, orgStrL2ID, orgStrL3, createdDT, editedDT, createdByUserID")] k2017orgStrL3Db k2017orgStrL3Db)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
int userIDselectInt = userIDselectVar.Single();
List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.projectID)
.ToList();
List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.taskOrderID)
.ToList();
var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int userTypeInt = userTypeSelect.First();
if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(10) &&
returnTaskOrdersIDlist.Contains(41)))
{
if (ModelState.IsValid)
{
db.Entry(k2017orgStrL3Db).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "k2017orgAdmStructure", new { projectID = 10, taskOrderID = 41, Int1 = 1 }));
}
return(View(k2017orgStrL3Db));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
// GET: k2017orgStrL3Dbs/Delete/5
public ActionResult Delete(int?id)
{
string CurrentLoginID = User.Identity.GetUserId().ToString();
var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
int userIDselectInt = userIDselectVar.Single();
List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.projectID)
.ToList();
List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.taskOrderID)
.ToList();
var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int userTypeInt = userTypeSelect.First();
if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(10) &&
returnTaskOrdersIDlist.Contains(41)))
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
k2017orgStrL3Db k2017orgStrL3Db = db.k2017orgStrL3Dbs.Find(id);
if (k2017orgStrL3Db == null)
{
return(HttpNotFound());
}
return(View(k2017orgStrL3Db));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
// GET: k2017orgStrL3Dbs/Edit/5
public ActionResult Edit(int?id)
{
System.Diagnostics.Debug.WriteLine(id);
string CurrentLoginID = User.Identity.GetUserId().ToString();
var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
int userIDselectInt = userIDselectVar.Single();
List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.projectID)
.ToList();
List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
.Select(s => s.taskOrderID)
.ToList();
var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
int userTypeInt = userTypeSelect.First();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
k2017orgStrL3Db k2017orgStrL3Db = db.k2017orgStrL3Dbs.Find(id);
if (k2017orgStrL3Db == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(10) &&
returnTaskOrdersIDlist.Contains(41)))
{
ViewBag.currUL310 = User.Identity.GetUserId().ToString();
ViewBag.currDT310 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ViewBag.proj300 = new SelectList(db.clientsProjectsDbs.Where(s => s.ID == 1 || s.ID == 10)
.OrderBy(s => s.ID), "ID", "projectName");
ViewBag.task300 = new SelectList(db.taskOrdersDbs.Where(s => s.ID == 1 || s.ID == 41)
.OrderBy(s => s.ID), "ID", "taskOrder");
ViewBag.stL1300 = new SelectList(db.k2017orgStrL1Dbs.OrderBy(s => s.ID), "ID", "orgStrL1");
var It02 = db.k2017orgStrL3Dbs.Where(s => s.ID == id)
.Select(s => s.orgStrL1ID)
.First();
ViewBag.stL2300 = new SelectList(db.k2017orgStrL2Dbs.Where(s => s.ID == 1 || s.orgStrL1ID == It02)
.OrderBy(s => s.ID), "ID", "orgStrL2");
var Item32 = from m in db.k2017orgStrL3Dbs where m.ID == id select m.createdByUserID;
string Item322 = Item32.Single();
var Item2110 = from m in db.agentsDbs where m.userID == Item322 select m.agentName;
string ItemID200 = Item2110.Single();
ViewBag.agnm301 = ItemID200;
return(View(k2017orgStrL3Db));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}