public ActionResult ShowProcess() { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { fuelrmEntities db = new fuelrmEntities(); var procquery = (from proc in db.ProcessContent join procj in db.ProcessINFO on proc.ID equals procj.ContentID join car in db.CarInfo on procj.CarID equals car.ID select new GetRecords { Branch = car.CarBranch, Model = car.Model, Color = car.Color, Time = procj.Time, LicencePlate = car.LicencePlate, Description = procj.Description, Explain = proc.Description, ProcID = procj.ID, }).ToList(); return(View(procquery)); } }
public ActionResult Submit(FormCollection form) { fuelrmEntities db = new fuelrmEntities(); Admins admin = new Admins(); admin.Username = form["uname"]; if (db.Admins.Any(x => x.Username == admin.Username)) { var alert = "Username is already exist"; ViewBag.Message = alert; return(View()); } admin.Password = form["pass"]; admin.Email = form["email"]; if (db.Admins.Any(x => x.Email == admin.Email)) { var alert = "Email is already exist"; ViewBag.EMessage = alert; return(View()); } db.Admins.Add(admin); db.SaveChanges(); return(RedirectToAction("Index", "YoneticiGiris")); }
// GET: Process public ActionResult TakeProcess(int id) { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { fuelrmEntities db = new fuelrmEntities(); var carname = (from n in db.CarInfo where n.ID == id select n).FirstOrDefault(); List <SelectListItem> prods = (from i in db.URUNLISTEM.ToList() select new SelectListItem { Text = i.PRODUCT_NAME, Value = i.PRODUCT_CODE.ToString() }).ToList(); List <SelectListItem> types = (from i in db.URUNLISTEM.ToList() select new SelectListItem { Text = i.PRODUCT_TYPE, Value = i.PRODUCT_CODE.ToString() }).ToList(); ViewBag.Types = types; ViewBag.Products = prods; ViewBag.name = carname.CarBranch; ViewBag.model = carname.Model; ViewBag.licence = carname.LicencePlate; TempData["id"] = id; return(View()); } }
public ActionResult RePassword(FormCollection form) { var time = DateTime.Now; fuelrmEntities db = new fuelrmEntities(); var asc = (from i in db.Password_LOG orderby i.ID select i.TİME).FirstOrDefault(); DateTime logabletime = asc.AddMinutes(5); if (logabletime < time) { Password_LOG log = new Password_LOG(); string g = Guid.NewGuid().ToString(); log.TİME = DateTime.Now; log.GUİD = g; db.Password_LOG.Add(log); var id = Convert.ToInt32(form["adminid"]); var admin = db.Admins.Find(id); admin.Guid = g; admin.Password = form["newpass"]; db.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("SendEmail")); } }
public ActionResult ProcessModal(int id) { fuelrmEntities db = new fuelrmEntities(); var procinf = db.ProcessINFO.Find(id); var proccont = db.ProcessContent.Find(procinf.ContentID); return(PartialView(proccont)); }
public ActionResult RePassword(int id) { fuelrmEntities db = new fuelrmEntities(); ViewBag.ID = id; return(View()); }
public ActionResult SendEmail(int id) { fuelrmEntities db = new fuelrmEntities(); var name = db.Users.Find(id); ViewBag.Name = name.Name; ViewBag.ID = id; return(View()); }
public ActionResult DeleteProcess(int id) { fuelrmEntities db = new fuelrmEntities(); var pcsi = db.ProcessINFO.Find(id); var pcsc = (from cont in db.ProcessContent where cont.ID == pcsi.ContentID select cont).FirstOrDefault(); var inff = pcsc.ID; var info = db.ProcessContent.Find(inff); db.ProcessContent.Remove(info); db.ProcessINFO.Remove(pcsi); db.SaveChanges(); return(RedirectToAction("ShowProcess")); }
public ActionResult Edit() { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { fuelrmEntities db = new fuelrmEntities(); UserModel u = new UserModel(); return(View(u)); } }
public ActionResult Add(FormCollection form) { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { fuelrmEntities db = new fuelrmEntities(); string name = form["name"]; string surname = form["surname"]; var q = (from us in db.Users where us.Name == name && us.Surname == surname select us).Any(); if (q == true) { var exus = (from uss in db.Users where uss.Name == name && uss.Surname == surname select uss).FirstOrDefault(); var excars = (from carss in db.CarInfo where carss.UserID == exus.ID select carss).ToList(); foreach (var i in excars) { i.IsDelete = false; } exus.IsDeleted = false; db.SaveChanges(); } else { Users user = new Users(); user.Name = form["name"]; user.Surname = form["surname"]; user.Telephone = form["tel"]; user.Email = form["email"]; user.IsDeleted = false; db.Users.Add(user); db.SaveChanges(); } return(RedirectToAction("CusList")); } }
public ActionResult SendBill(int?id) { fuelrmEntities db = new fuelrmEntities(); var process = db.ProcessINFO.Find(id); var carid = (from i in db.CarInfo where i.ID == process.CarID select i.ID).FirstOrDefault(); var car = db.CarInfo.Find(carid); var user = db.Users.Find(car.UserID); var admin = db.Admins.Find(process.AdminID); string adsubject = "Bill"; string admmessage = "Time: " + process.Time + Environment.NewLine + "Your car is: " + car.CarBranch + " " + car.Model + " " + car.Color + " " + car.LicencePlate + " " + Environment.NewLine + "Your process: " + process.Description + Environment.NewLine + "Worker who did your work: " + admin.Username; var receiver = user.Email; string subject = adsubject; string message = admmessage; var senderEmail = new MailAddress("*****@*****.**", "Atilay"); var receiverEmail = new MailAddress(receiver, "Customer"); var password = "******"; var sub = subject; var body = message; var smtp = new SmtpClient { Host = "smtp.office365.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new System.Net.NetworkCredential(senderEmail.Address, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = subject, Body = body }) { smtp.Send(mess); } return(RedirectToAction("ShowProcess")); }
public ActionResult EditCar(int id) { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { fuelrmEntities db = new fuelrmEntities(); var a = db.CarInfo.Find(id); TempData["id"] = a.ID; CarModel u = new CarModel(); return(View(u)); } }
public ActionResult SendEmail(FormCollection form) { fuelrmEntities db = new fuelrmEntities(); var receiver = form["email"]; var q = (from i in db.Admins where i.Email == receiver select i.Email).Any(); if (q == true) { var adminid = (from i in db.Admins where i.Email == receiver select i.ID).FirstOrDefault(); var subject = "REPASSWORD"; var message = "localhost:55251/YoneticiGiris/RePassword/" + adminid; var senderEmail = new MailAddress("*****@*****.**", "Atilay"); var receiverEmail = new MailAddress(receiver, "Receiver"); var password = "******"; var sub = subject; var body = message; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new System.Net.NetworkCredential(senderEmail.Address, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = subject, Body = body }) { smtp.Send(mess); } return(View()); } else { return(RedirectToAction("Index")); } }
public ActionResult CusList() { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { fuelrmEntities db = new fuelrmEntities(); var q = (from users in db.Users where users.IsDeleted == false select users).ToList(); return(View(q)); } }
public ActionResult Authorize(FormCollection form) { using (fuelrmEntities db = new fuelrmEntities()) { var a = form["uname"].Trim(); var b = form["pass"].Trim(); var v = db.Admins.Where(x => x.Username.Equals(a) && x.Password.Equals(b)).FirstOrDefault(); if (v == null) { return(RedirectToAction("Submit", "YeniYonetici")); } else { Session["UserID"] = v.ID; return(RedirectToAction("Index", "Musteri")); } } }
public ActionResult AddProcess(ProcessModel p) { if (Session["UserID"] == null) { return(RedirectToAction("Index", "YoneticiGiris")); } else { var cid = Convert.ToInt32(TempData["id"]); fuelrmEntities db = new fuelrmEntities(); ProcessContent content = new ProcessContent(); content.Description = p.details; content.ProuctID = p.productid; content.Type = p.type; var prodname = (from i in db.URUNLISTEM where i.PRODUCT_CODE == p.productid.ToString() select i ).FirstOrDefault(); content.ProductName = prodname.PRODUCT_NAME; db.ProcessContent.Add(content); ProcessINFO process = new ProcessINFO(); process.ContentID = content.ID; process.Description = p.describtion; process.Time = DateTime.Now; process.AdminID = Convert.ToInt32(Session["UserID"]); process.CarID = Convert.ToInt32(cid); db.ProcessINFO.Add(process); db.SaveChanges(); var query = (from car in db.CarInfo where car.ID == cid select car.UserID).FirstOrDefault(); return(RedirectToAction("TakeProcess", new { id = cid })); } // return RedirectToAction("CarList","Musteri", new { id = query}); }
public ActionResult SendEmail(FormCollection form) { fuelrmEntities db = new fuelrmEntities(); string adsubject = "RepairInformation"; string admmessage = form["message"]; var id = Convert.ToInt32(form["id"]); var receiver = (from i in db.Users where i.ID == id select i.Email).FirstOrDefault(); string subject = adsubject; string message = admmessage; var senderEmail = new MailAddress("*****@*****.**", "Atilay"); var receiverEmail = new MailAddress(receiver, "Customer"); var password = "******"; var sub = subject; var body = message; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new System.Net.NetworkCredential(senderEmail.Address, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = subject, Body = body }) { smtp.Send(mess); } return(RedirectToAction("CusList")); }