public IEnumerable <Product> GetAllProducts()
{
Database1 db = new Database1();
IEnumerable <Product> products = db.Products.ToList();
return(products);
}
// GET: request
// GET: request
public ActionResult projm()
{
try
{
Database1 m = new Database1();
int j = (int)Session["pm"];
string log = m.logins.Where(i => i.loginid == j).Select(i => i.job).FirstOrDefault();
ViewBag.msg = m.logins.Where(i => i.loginid == j).Select(i => i.username).FirstOrDefault();
if (log == "PM")
{
var domains = m.trainers.Select(i => i.domain).Distinct();
foreach (var i in domains)
{
c.dm.Add(new SelectListItem()
{
Text = i.ToString(), Value = i.ToString()
});
}
return(View(c));
}
else
{
return(Redirect("/main/Login"));
}
}
catch (Exception)
{
return(Redirect("/main/Login"));
}
}
public IActionResult Index()
{
/*
* var cliente = new Cliente() { Nome = "Danilo", Telefone = "11976144154" };
* var db = new Database1();
* db.Clientes.Add(cliente);
* db.SaveChanges();
*/
//var db = new Database1();
//var clientes = db.Clientes.Where(c => c.Nome.Contains("D")).ToList();
//var clientes = db.Clientes.ToList();
//var clientes = Cliente.Todos();
//new Cliente() { Nome = "ssss" }.Salvar();
//db.Database.ExecuteSqlCommand("");
ViewBag.Clientes = Cliente.Todos();
var db = new Database1();
var entryPoint = (from clientes in db.Clientes
join pedidos in db.Pedidos on clientes.Id equals pedidos.ClienteId
where clientes.Nome.Contains("D")
select new
{
PedidoId = pedidos.Id,
ClienteNome = clientes.Nome,
}).Take(10);
return(View());
}
public override global::System.Data.DataSet Clone()
{
Database1 cln = ((Database1)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public ActionResult onhold(int id)
{
Database1 m = new Database1();
request r = m.requests.Where(i => i.reqid == id).FirstOrDefault();
r.status = "onhold";
m.SaveChanges();
return(Redirect("/request/dashboard"));
}
public ActionResult edit(int qid, int tn, int room)
{
Database1 m = new Database1();
request r = m.requests.Where(i => i.reqid == qid).FirstOrDefault();
r.tid = tn;
r.room = room;
r.status = "Submitted";
m.SaveChanges();
return(RedirectToAction("dashboard", "request"));
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
Database1 ds = new Database1();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public ActionResult details(int id)
{
Database1 m = new Database1();
Class1 c = new Class1();
var result = m.requests.Where(i => i.reqid == id).FirstOrDefault();
c.ctid = result.tid;
c.csdate = result.sdate;
c.cedate = result.edate;
c.croom = result.room;
c.cexename = m.trainers.Where(i => i.tid == result.tid).Select(i => i.tname).FirstOrDefault();
ViewBag.pmreqiq = id;
return(View(c));
}
public ActionResult projm(string req, string dom, DateTime sd, DateTime edn)
{
Database1 m = new Database1();
request r = new request();
r.domain = dom;
r.reqname = req;
r.sdate = sd;
r.edate = edn;
r.status = "Requested";
r.pmid = (int)Session["pm"];
m.requests.Add(r);
m.SaveChanges();
return(RedirectToAction("dashboard"));
}
public ActionResult confirm(int id)
{
try
{
Database1 m = new Database1();
request r = m.requests.Where(i => i.reqid == id).FirstOrDefault();
r.status = "Confirmed";
m.SaveChanges();
return(Redirect("dashboard"));
}
catch (Exception)
{
return(Redirect("/main/Login"));
}
}
public ActionResult dashboard()
{
List <Class1> l = new List <Class1>();
try
{
Database1 m = new Database1();
Class1 c = new Class1();
int j = (int)Session["pm"];
string log = m.logins.Where(i => i.loginid == j).Select(i => i.job).FirstOrDefault();
ViewBag.job = log;
ViewBag.msg = m.logins.Where(i => i.loginid == j).Select(i => i.username).FirstOrDefault();
if (log != null)
{
var con = m.requests.Select(i => i);
if (log == "PM")
{
con = m.requests.Where(i => i.pmid == j).Select(i => i);
}
else if (log == "TRAINER")
{
var x = m.logins.Where(i => i.loginid == j).FirstOrDefault();
var y = m.trainers.Where(i => i.tname == x.username).Select(i => i).FirstOrDefault();
con = m.requests.Where(i => i.tid == y.tid && (i.status == "Confirmed" || i.status == "onprocess" || i.status == "onhold" || i.status == "completed"));
}
foreach (var i in con)
{
l.Add(new Class1()
{
creqid = i.reqid, creqname = i.reqname, cdomain = i.domain, cstatus = i.status,
});
}
}
else
{
return(Redirect("/main/Login"));
}
}
catch (Exception)
{
return(Redirect("/main/Login"));
}
return(View(l));
}
private async Task StuQueryComplete(IDialogContext context, IAwaitable <StuQueryForm> result)
{
StuQueryForm form = null;
try
{
form = await result;
}
catch (OperationCanceledException)
{
}
if (form == null)
{
await context.PostAsync("You Canceled the form.");
}
if (form != null)
{
List <Student> students = Database1.GetStudents(form.StudentID);
if (students == null || students.Count == 0)
{
await context.PostAsync($"Sorry, could not find Students for ID {form.StudentID} ");
return;
}
StringBuilder sb1 = new StringBuilder();
sb1.Append($"Hi There! I was able to find **{students.Count.ToString()}** Course(s) \n\n");
sb1.Append("--- \n\n");
foreach (Student student in students)
{
// sb.Append($"You are enrolled in **{student.courseID}**\n\n");
sb1.Append($"* Student id is **{student.StudentID}** ; Course is **{student.courseID}** \n\n");
}
var message = $"Looking for courses {form.StudentID} ";
// var message1 = $"Looking for students {form.courseID}";
await context.PostAsync(sb1.ToString());
}
context.Wait(MessageReceived);
}
public ActionResult Registration()
{
Database1 db = new Database1();
List<MyClass> MyClassList = new List<MyClass>();
var details = (from c in db.Car
join u in db.User on c.id_car equals u.id_car
select new { c.id_car, c.id_city, c.car_name, u.id_user,u.name_user }).ToList();
foreach (var item in details)
{
MyClass mC = new MyClass();
mC.id_car = item.id_car;
mC.id_city = item.id_city;
mC.car_name = item.car_name;
mC.id_user = item.id_user;
mC.name_user = item.name_user;
MyClassList.Add(mC); MyClassList.Add(mC);
}
return View(MyClassList);
}
public ActionResult edit(int id, string dom)
{
ViewBag.id = id;
Database1 m = new Database1();
Class1 c = new Class1();
var req = m.requests.Where(i => i.reqid == id).FirstOrDefault();
c.cpmname = m.logins.Where(i => i.loginid == req.pmid).Select(i => i.username).FirstOrDefault();
c.csdate = req.sdate;
c.cedate = req.edate;
var det = m.trainers.Where(i => i.domain == dom).Select(i => i);
foreach (var i in det)
{
c.lm.Add(new SelectListItem()
{
Text = i.tname, Value = i.tid.ToString()
});
}
return(View(c));
}
// GET: Ind
public ActionResult spoc()
{
try
{
Database1 m = new Database1();
int j = (int)Session["pm"];
string log = m.logins.Where(i => i.loginid == j).Select(i => i.job).FirstOrDefault();
ViewBag.msg = m.logins.Where(i => i.loginid == j).Select(i => i.username).FirstOrDefault();
if (log == "SPOC")
{
}
else
{
return(Redirect("/main/Login"));
}
}
catch (Exception)
{
return(Redirect("/main/Login"));
}
return(View());
}
public ActionResult Login(string Uname, string pwd)
{
Database1 m = new Database1();
int log = m.logins.Where(i => i.username == Uname && i.password == pwd).Select(i => i.loginid).FirstOrDefault();
string job = m.logins.Where(i => i.username == Uname && i.password == pwd).Select(i => i.job).FirstOrDefault();
if (log != 0 && job == "PM")
{
Session["pm"] = log;
return(Redirect("/request/projm"));
}
if (log != 0 && job == "SPOC")
{
Session["pm"] = log;
return(Redirect("/Ind/spoc"));
}
if (log != 0 && job == "TRAINER")
{
Session["pm"] = log;
return(Redirect("/train/train"));
}
return(View("Login"));
}
public void Setup()
{
this.dataBase = new Database1();
}
public void Ctor_ThrowException_WhenDatbaseExceeded()
{
Assert.Throws <InvalidOperationException>(() =>
this.dataBase = new Database.Database1(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17));
}
