public ActionResult RLeader(String email) { var p = db.projecttable.Find(proid); var x = db.usertable.Single(e => e.Email == email); int ooo = (int)Session["id"]; var u = db.usertable.Find(ooo); try { var check = db.drrequesttable.Single(e => e.projects.projectid == proid & e.reciver.userid == x.userid); db.Entry(check).Reference("reciver").CurrentValue = x; db.SaveChanges(); } catch { drrequest r = new drrequest(); r.projects = p; r.Sender = u; r.reciver = x; r.request = "can you join me this project"; r.status = "non seen"; db.drrequesttable.Add(r); db.SaveChanges(); } return(RedirectToAction("MDProfile")); }
public ActionResult Accept(int drid) { int ooo = (int)Session["id"]; drrequest d = db.drrequesttable.Find(drid); db.Entry(d).Reference("Sender").Load(); db.Entry(d).Reference("projects").Load(); user u = db.usertable.Find(d.Sender.userid); project p = db.projecttable.Find(d.projects.projectid); d.status = "Accept"; db.SaveChanges(); p.startdate = d.startdate; p.enddate = d.enddate; p.price = d.price; db.Entry(p).Reference("Manager").CurrentValue = u; p.status = "signed"; db.SaveChanges(); var request = from e in db.drrequesttable where e.projects.projectid == d.projects.projectid & e.status == "non seen" select e; foreach (var k in request.ToList()) { db.drrequesttable.Remove(k); db.SaveChanges(); } return(RedirectToAction("DeliveredTable")); }
public ActionResult MDControlProject(String startday, String startmonth, String startyear, String endday, String endmonth, String endyear, String price, String status) { int ooo = (int)Session["id"]; String startdate = startday + "/" + startmonth + "/" + startyear; String enddate = endday + "/" + endmonth + "/" + endyear; project p = db.projecttable.Find(proid); p.status = status; db.SaveChanges(); db.Entry(p).Reference("Customer").Load(); user Customer = db.usertable.Find(p.Customer.userid); user Manager = db.usertable.Find(ooo); drrequest r = new drrequest(); r.price = Int32.Parse(price); r.Sender = Manager; r.reciver = Customer; r.request = "can you accept my change"; r.status = "not seen"; r.startdate = startdate; r.enddate = enddate; r.projects = p; db.drrequesttable.Add(r); db.SaveChanges(); return(RedirectToAction("MDProfile")); }
public ActionResult Mdsign(String startday, String startmonth, String startyear, String endday, String endmonth, String endyear, int price, int id) { int ooo = (int)Session["id"]; String startdate = startday + "/" + startmonth + "/" + startyear; String enddate = endday + "/" + endmonth + "/" + endyear; project p = db.projecttable.Find(id); db.Entry(p).Reference("Customer").Load(); user u = db.usertable.Find(ooo); user c = db.usertable.Find(p.Customer.userid); drrequest dr = new drrequest(); dr.Sender = u; dr.projects = p; dr.reciver = c; dr.status = "non seen"; dr.request = "can you accept my request to sign this project"; dr.price = price; dr.startdate = startdate; dr.enddate = enddate; db.drrequesttable.Add(dr); db.SaveChanges(); return(RedirectToAction("index")); }
public ActionResult Refuse(int drid) { drrequest d = db.drrequesttable.Find(drid); d.status = "Refuse"; db.SaveChanges(); return(RedirectToAction("DeliveredTable")); }
public ActionResult Refuserequest(int id) { int i = Int32.Parse(WelcomeController.Tempid); var x = from e in db.usertable join p in db.usertable on e.userid equals p.userid where e.userid == i select new viewmodel { u = e }; ViewData["info"] = x.ToList(); drrequest d = db.drrequesttable.Find(id); d.status = "refuse"; db.SaveChanges(); return(RedirectToAction("MTRequests")); }
public ActionResult RefuseRequest(int poid, int drid) { int ooo = (int)Session["id"]; var x = from e in db.usertable join p in db.usertable on e.userid equals p.userid where e.userid == ooo select new viewmodel { u = e }; ViewData["mdinfo"] = x.ToList(); drrequest d = db.drrequesttable.Find(drid); d.status = "Refuse"; db.SaveChanges(); return(RedirectToAction("TeamleaderRequests")); }
public ActionResult MDAddTrainee(int pid, String[] train) { var p = db.projecttable.Find(proid); int ooo = (int)Session["id"]; var u = db.usertable.Find(ooo); foreach (var x in train) { var t = db.usertable.Single(e => e.Email == x); drrequest r = new drrequest(); r.projects = p; r.Sender = u; r.reciver = t; r.request = "can you join me this project"; r.status = "not seen"; db.drrequesttable.Add(r); db.SaveChanges(); } return(RedirectToAction("MDProfile")); }
public ActionResult AcceptRequest(int poid, int drid) { int ooo = (int)Session["id"]; var x = from e in db.usertable join p in db.usertable on e.userid equals p.userid where e.userid == ooo select new viewmodel { u = e }; ViewData["mdinfo"] = x.ToList(); drrequest d = db.drrequesttable.Find(drid); d.status = "Accept"; db.SaveChanges(); project pp = db.projecttable.Find(poid); user u = db.usertable.Find(ooo); db.Entry(pp).Reference("leader").CurrentValue = u; db.SaveChanges(); return(RedirectToAction("TeamleaderRequests")); }
public ActionResult Acceptrequest(int id, int pid) { int i = Int32.Parse(WelcomeController.Tempid); var x = from e in db.usertable join p in db.usertable on e.userid equals p.userid where e.userid == i select new viewmodel { u = e }; ViewData["info"] = x.ToList(); workson w = new workson(); user trainee = db.usertable.Find(i); project pro = db.projecttable.Find(pid); w.trainee = trainee; w.workignproject = pro; db.worksontable.Add(w); db.SaveChanges(); drrequest d = db.drrequesttable.Find(id); d.status = "accept"; db.SaveChanges(); return(RedirectToAction("MTRequests")); }