public ActionResult DeleteConfirmed(string 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(6) &&
returnTaskOrdersIDlist.Contains(61))
{
UHSUSAT1DISTRICTDb UHSUSAT1DISTRICTDb = opa.UHSUSAT1DISTRICTDbs.Find(id);
opa.UHSUSAT1DISTRICTDbs.Remove(UHSUSAT1DISTRICTDb);
opa.SaveChanges();
return(RedirectToAction("Index", "uhsuserDistrict", new { projectID = 6, taskOrderID = 61, Int1 = 1 }));
}
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
//[ValidateAntiForgeryToken]
public ActionResult EditEx(UHSUSAT1DISTRICTDb model)
{
//System.Diagnostics.Debug.WriteLine(model.ID);
//System.Diagnostics.Debug.WriteLine(item2);
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(6) &&
returnTaskOrdersIDlist.Contains(61)))
{
if (ModelState.IsValid)
{
try
{
opa.Entry(model).State = EntityState.Modified;
opa.SaveChanges();
int resp = 1;
return(Json(resp, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
int resp = 2;
return(Json(resp, JsonRequestBehavior.AllowGet));
throw (e);
}
}
else
{
int resp = 3;
return(Json(resp, JsonRequestBehavior.AllowGet));
}
}
else
{
int resp = 4;
return(Json(resp, JsonRequestBehavior.AllowGet));
}
}
//[ValidateAntiForgeryToken]
public ActionResult CreateNew(UHSUSAT1DISTRICTDb UHSUSAT1DISTRICTDb)
{
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(6) &&
returnTaskOrdersIDlist.Contains(61))
{
if (UHSUSAT1DISTRICTDb.MGRID == 0 || UHSUSAT1DISTRICTDb.DISTID == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
if (ModelState.IsValid)
{
try
{
opa.UHSUSAT1DISTRICTDbs.Add(UHSUSAT1DISTRICTDb);
opa.SaveChanges();
var conf = 1;
return(Json(conf, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(View(UHSUSAT1DISTRICTDb));
throw (e);
}
}
return(View(UHSUSAT1DISTRICTDb));
}
}
return(View(UHSUSAT1DISTRICTDb));
}
// GET: UHSUSAT1A360Db/Delete/5
public ActionResult Delete(string 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(6) &&
returnTaskOrdersIDlist.Contains(61))
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UHSUSAT1DISTRICTDb UHSUSAT1DISTRICTDb = opa.UHSUSAT1DISTRICTDbs.Find(id);
if (UHSUSAT1DISTRICTDb == null)
{
return(HttpNotFound());
}
return(View(UHSUSAT1DISTRICTDb));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
