public JsonResult UpdateStatus(int id, string st)
{
try
{
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
RequestMaster rm = new RequestMaster();
var details = Entity.RequestMasters.Where(q => q.Id == id).FirstOrDefault();
if (st == "Accept")
{
details.Status = "Accept";
Entity.Entry(details).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
return(Json("Accept", JsonRequestBehavior.AllowGet));
}
else if (st == "Reject")
{
details.Status = "Reject";
Entity.Entry(details).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
return(Json("Reject", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Forgotque(FormCollection frm)
{
try
{
Chatpata_dabbaEntities1 EntityFile = new Chatpata_dabbaEntities1();
var email = Convert.ToString(frm["Email"]);
var user = EntityFile.CustomerMasters.Where(q => q.EmailID == email).FirstOrDefault();
//Session["UserID"]=details.CustId;
string pass = GenerateRandomPassword(6);
int chkmail = Mail.SendMail("Your New Password", pass, email);
user.Password = MD5Crypt.Encrypt(pass, "Dabba");
EntityFile.Entry(user).State = System.Data.Entity.EntityState.Modified;
EntityFile.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(RedirectToAction("Forgotpass_new", "Home"));
}
}
public ActionResult CodeRetrival()
{
try
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
DailyOrder DO = new DailyOrder();
var dbcode = Entity.DailyStatusChange().LastOrDefault();
var orderdetails = Entity.DailyOrders.Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).ToList();
var code = orderdetails.Where(q => Convert.ToDecimal(q.Code) == Convert.ToDecimal(dbcode.rcode) && q.OrderId == dbcode.OrderId).ToList();
if (code.Count == 0)
{
var Orders = Entity.DailyOrderData().Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).OrderBy(q => q.Status).ToList();
return(View(Orders));
}
else
{
code[0].Status = "Delivered";
Entity.Entry(code[0]).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
var Orders = Entity.DailyOrderData().Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).OrderBy(q => q.Status).ToList();
return(View(Orders));
}
}
catch (Exception e)
{
throw e;
}
}
public JsonResult UpdateOrderStatus(int id)
{
try
{
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
OrderMaster OM = new OrderMaster();
var details = Entity.OrderMasters.Where(q => q.OrderId == id).FirstOrDefault();
details.Status = "Accept";
Entity.Entry(details).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
if (details.StartDate.Day <= DateTime.Now.Day && details.EndDate.Day >= DateTime.Now.Day)
{
DailyOrder dor = new DailyOrder();
dor.CustId = details.CustomerId;
dor.OrderId = id;
dor.Date = DateTime.Now;
dor.Status = "Pending";
dor.Code = 0;
Entity.DailyOrders.Add(dor);
Entity.SaveChanges();
}
return(Json("Accept", JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateProfile(CustomerMaster ProfileInfo, FormCollection frm)
{
try
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
var id = Convert.ToInt32(Session["UserID"]);
ProfileInfo.CustId = Convert.ToInt32(frm["CustId"]);
Chatpata_dabbaEntities1 cd = new Chatpata_dabbaEntities1();
var user = cd.CustomerMasters.Where(q => q.CustId == ProfileInfo.CustId).FirstOrDefault();
ProfileInfo.Birthdate = user.Birthdate;
ProfileInfo.FirstName = user.FirstName;
user.LastName = Convert.ToString(frm["LastName"]);
user.Address1 = Convert.ToString(frm["Address1"]);
user.Address2 = Convert.ToString(frm["Address2"]);
user.Address3 = Convert.ToString(frm["Address3"]);
user.Pincode = Convert.ToString(frm["Pincode"]);
user.PhoneNo = Convert.ToString(frm["PhoneNo"]);
cd.Entry(user).State = System.Data.Entity.EntityState.Modified;
cd.SaveChanges();
return(RedirectToAction("Customer"));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult EditMenu(MenuMaster menuinfo, HttpPostedFileBase file)
{
try
{
Chatpata_dabbaEntities1 EntityFile = new Chatpata_dabbaEntities1();
var newFileName = "";
if (file != null)
{
string pic = System.IO.Path.GetFileName(file.FileName);
FileInfo fi = new FileInfo(pic);
string fileextension = fi.Extension.Substring(1).ToUpper();
newFileName = Convert.ToString(Guid.NewGuid()) + "." + fileextension;
var FolderPath = "~/Images/";
var Imgpath = Path.Combine(Server.MapPath(FolderPath), newFileName);
file.SaveAs(Imgpath);
newFileName = FolderPath + newFileName;
}
menuinfo.Image = newFileName;
EntityFile.Entry(menuinfo).State = System.Data.Entity.EntityState.Modified;
EntityFile.SaveChanges();
return(RedirectToAction("ViewMenu"));
}
catch (Exception e)
{
return(RedirectToAction("Login", "Home"));
}
}
public ActionResult Verifychpass(FormCollection frm)
{
try
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
Chatpata_dabbaEntities1 en = new Chatpata_dabbaEntities1();
CustomerMaster cm = new CustomerMaster();
var pass = Convert.ToString(frm["new_pass"]);
var id = Convert.ToInt32(Session["UserID"]);
var user = en.CustomerMasters.Where(q => q.CustId == id).FirstOrDefault();
user.Password = MD5Crypt.Encrypt(pass, "Dabba");
en.Entry(user).State = System.Data.Entity.EntityState.Modified;
en.SaveChanges();
return(RedirectToAction("Admin", "Admin"));
}
catch (Exception ex)
{
return(RedirectToAction("Admin"));
}
}
public ActionResult UpdateProfile(CustomerMaster ProfileInfo, FormCollection frm, HttpPostedFileBase file)
{
try
{
ProfileInfo.CustId = Convert.ToInt32(frm["CustId"]);
Chatpata_dabbaEntities1 cd = new Chatpata_dabbaEntities1();
var user = cd.CustomerMasters.Where(q => q.CustId == ProfileInfo.CustId).FirstOrDefault();
var newFileName = "";
if (file != null)
{
string pic = System.IO.Path.GetFileName(file.FileName);
FileInfo fi = new FileInfo(pic);
string fileextension = fi.Extension.Substring(1).ToUpper();
newFileName = Convert.ToString(Guid.NewGuid()) + "." + fileextension;
var FolderPath = "~/Images/";
var Imgpath = Path.Combine(Server.MapPath(FolderPath), newFileName);
file.SaveAs(Imgpath);
newFileName = FolderPath + newFileName;
}
ProfileInfo.Image = newFileName;
ProfileInfo.Birthdate = user.Birthdate;
cd.Entry(user).State = System.Data.Entity.EntityState.Modified;
cd.SaveChanges();
return(RedirectToAction("Customer"));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult CodeRetrival(FormCollection frm)
{
var code = Convert.ToString(frm["code"]);
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
DailyOrder DO = new DailyOrder();
var cid = Convert.ToInt32(Session["UserID"]);
// var dbcode = Entity.DailyOrders.Where(q => q.CustId == cid && q.Code == code).Count();
var dbcode = Entity.DailyStatusChange().LastOrDefault();
if (dbcode != null)
{
// var dbcode1 = Entity.DailyOrders.Where(q => q.CustId == cid && q.Code == code).ToList();
// var orderstatus=Entity.
// dbcode1[0].Status = "Delivered";
var orderdetails = Entity.DailyOrders.Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).ToList();
var data = orderdetails.Where(q => Convert.ToDecimal(q.Code) == Convert.ToDecimal(dbcode.rcode) && q.OrderId == dbcode.OrderId).ToList();
// var orderdetails = Entity.DailyOrderData().Where(q => q.CustId == dbcode.CustId).FirstOrDefault();
//var orderchange = Entity.DailyOrders.Where(q => q.CustId == orderdetails.CustId).ToList();
data[0].Status = "Delivered";
Entity.Entry(data[0]).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
return(RedirectToAction("ThankYouPage"));
}
else
{
return(RedirectToAction("CodeRetrival"));
}
}
public ActionResult Payment(FormCollection frm, OrderMaster OM)
{
try
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
var Id = Convert.ToInt32(Session["UserId"]);
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
OM.OrderId = Convert.ToInt32(frm["OrderID"]);
var orderdetails = Entity.OrderMasters.Where(q => q.OrderId == OM.OrderId).FirstOrDefault();
if (Convert.ToString(frm["Method"]) == "online")
{
orderdetails.PaymentMode = "Online";
}
if (Convert.ToString(frm["Method"]) == "cash")
{
orderdetails.PaymentMode = "COD";
}
Entity.Entry(orderdetails).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
return(RedirectToAction("OrderReview"));
}
catch (Exception e)
{
throw e;
}
}
public JsonResult CancelOrder(int oid)
{
try
{
Chatpata_dabbaEntities1 en = new Chatpata_dabbaEntities1();
var currentTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
var time = Convert.ToDateTime("10:00:00 AM");
var id = Convert.ToInt32(Session["UserID"]);
if (currentTime < time)
{
OrderMaster om = new OrderMaster();
var ss = en.OrderMasters.Where(q => q.OrderId == oid && q.CustomerId == id).FirstOrDefault();
DailyOrder Do = new DailyOrder();
var details = en.DailyOrders.Where(q => q.OrderId == oid && q.CustId == id && q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).ToList();
details[0].Status = "Cancel";
if (ss.PaymentMode == "Online")
{
decimal[] rid = (en.OrderList().Where(q => q.OrderId == oid).Select(q => q.Price)).ToArray();
decimal r = Convert.ToDecimal((((rid[0]) * 10) / 100) + rid[0]);
ss.Ecoupon = r;
en.Entry(details).State = System.Data.Entity.EntityState.Modified;
en.SaveChanges();
}
en.Entry(details[0]).State = System.Data.Entity.EntityState.Modified;
en.SaveChanges();
return(Json("Cancel", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GenerateDispatch()
{
try
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
Chatpata_dabbaEntities1 Entity1 = new Chatpata_dabbaEntities1();
var entry = Entity1.DailyOrders.Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).ToList();
foreach (var order in entry.ToList())
{
var co = Convert.ToDecimal(0);
if (order.Code == co)
{
var myrand = new Random();
var c = Convert.ToDecimal(myrand.Next(100000, 1000000));
order.Code = c;
Entity1.Entry(order).State = System.Data.Entity.EntityState.Modified;
Entity1.SaveChanges();
var mailid = order.CustomerMaster.EmailID;
int ck = Mail.SendMail("Today's Code for you", "Code:" + c + "\n have a nice food..", mailid);
}
}
return(RedirectToAction("ViewDailyOrder"));
}
catch (Exception e)
{
throw e;
}
}
