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