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"));
}
