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 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 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"));
}
public ActionResult Edit(UserModel data)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "YoneticiGiris"));
}
else
{
var us = db.Users.Find(data.id);
if (data.name == null || data.surname == null || Convert.ToString(data.tel) == null)
{
var alert = "You have fill all blanks";
ViewBag.Message = alert;
return(View());
}
else
{
us.Name = data.name;
us.Surname = data.surname;
us.Telephone = data.tel;
db.SaveChanges();
return(RedirectToAction("CusList"));
}
}
}
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 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});
}