private void inputButton_Click(object sender, EventArgs e) { LoadingScreenToogle(); using (MydataEntities1 db = new MydataEntities1()) { var obj = db.Userrs.Where(a => a.username.Equals(usernameInput.Text) && a.password.Equals(passwordInput.Text)).FirstOrDefault(); if (obj != null) { LoadingScreenToogle(); if (obj.userType != 3) { MessageBox.Show("Turite būti sandėlio darbuotojas, kad galėtumėte prisijungti.", "Klaida"); } else { BaseForm form = new BaseForm(obj.ID); form.Show(); Hide(); } } else { LoadingScreenToogle(); MessageBox.Show("Įvedėte neteisingą prisijungimo vardą arba slaptažodį.", "Klaida"); usernameInput.Text = ""; passwordInput.Text = ""; } } }
public ActionResult Login(Userr objUser) { if (ModelState.IsValid) { using (MydataEntities1 db = new MydataEntities1()) { var UserN = objUser.username; var UserP = objUser.password; var obj = db.Userrs.Where(a => a.username.Equals(UserN) && a.password.Equals(UserP)).FirstOrDefault(); if (obj != null) { Session["ID"] = obj.ID.ToString(); Session["username"] = obj.username.ToString(); Session["userType"] = obj.userType; if (obj.userType == 1) { return(RedirectToAction("UserDashBoard")); } if (obj.userType == 2) { return(RedirectToAction("Index", "CustumerOrders", new { area = "Index" })); } if (obj.userType == 3) { return(RedirectToAction("WorkerDashBoard")); } } } } return(View(objUser)); }
public static OrderJob GetOrderJob(int workerID) { using (MydataEntities1 db = new MydataEntities1()) { var worker = db.Userrs.FirstOrDefault(a => a.ID == workerID); var jobs = db.JobWorkers.Where(a => a.fk_UserID == worker.ID).ToList(); OrderJob currentJob = null; foreach (var item in jobs) { var jobInList = db.OrderJobs.FirstOrDefault(a => a.status == 1 && a.id_OrderJob == item.fk_OrderJobid_OrderJob); if (jobInList == null) { continue; } currentJob = jobInList; break; } return(currentJob); } }
public static Job GetJobDescription(OrderJob currentJob) { if (currentJob == null) { return(null); } using (MydataEntities1 db = new MydataEntities1()) { return(db.Jobs.FirstOrDefault(a => a.workNumer == currentJob.fk_JobworkNumer)); } }