// GET: Order
public ActionResult PostOrder() //update the order status of the order once customer quick confirms / confirms order
{
RestaurantDBEntities db = new RestaurantDBEntities();
Order order = new Order();
var UserId = 0; // find from session later
var OrderId = db.Orders.Where(o => o.CustomerId == UserId && o.OrderStatus == 0)
.Select(o => o.OrderId)
.DefaultIfEmpty(0)
.Max();
order = db.Orders.FirstOrDefault(o => o.OrderId == OrderId); // find the unconfirmoed order of the customer and confirm it
order.OrderStatus = 1; // change status to confirmed
db.SaveChanges();
return(Json(Url.Action("Index", "OrderStatus")));
}
public ActionResult Register(LoginModel login)
{
if (ModelState.IsValid)
{
using (RestaurantDBEntities db = new RestaurantDBEntities())
{
var repo = new HomeRepository();
var checkUser = repo.GetUserRoleAndId(login.Username, login.Password);
if (checkUser == null)
{
//you should check duplicate registration here
// dc.Roles.Add(U);
// db.Entry()
UserLogin ul = new UserLogin();
User u = new User();
ul.Username = login.Username;
ul.Password = login.Password;
ul.RoleId = 2;
u.RoleId = 2;
u.FirstName = login.FirstName;
u.LastName = login.LastName;
u.Email = login.Username;
u.UserId = login.UserID;
db.Entry(ul).State = EntityState.Added;
db.Entry(u).State = EntityState.Added;
db.SaveChanges();
ModelState.Clear();
// login = null;
ViewBag.Message = "Successfully Registration Done";
}
else
{
ViewBag.Message = "This email already exists in the system.";
}
}
}
return(RedirectToAction("Login", new { id = login.UserID }));
}
public JsonResult DeleteOrderDetail(OrderDetailViewModel OrderDetailDeleteJSON) // delete item from OrderDEtail
{
RestaurantDBEntities db = new RestaurantDBEntities();
Order order = new Order();
var UserId = 0; // find from session later
var ItemId = OrderDetailDeleteJSON.ItemId;
var OrderId = db.Orders.Where(o => o.CustomerId == UserId && o.OrderStatus == 0)
.Select(o => o.OrderId)
.DefaultIfEmpty(0)
.Max();
OrderDetail orderDetail = new OrderDetail();
orderDetail = db.OrderDetails.FirstOrDefault(o => o.ItemId == ItemId && o.OrderId == OrderId);
db.OrderDetails.Remove(orderDetail);
db.SaveChanges();
return(Json("success"));
}
public ActionResult UserProfile(LoginModel login)
{
if (ModelState.IsValid)
{
using (RestaurantDBEntities db = new RestaurantDBEntities())
{
//you should check duplicate registration here
// dc.Roles.Add(U);
// db.Entry()
UserLogin ul = new UserLogin();
User u = new User();
ul.Username = login.Username;
// ul.Password = login.Password;
ul.RoleId = 2;
u.FirstName = login.FirstName;
u.LastName = login.LastName;
u.Email = login.Email;
u.Address1 = login.Address1;
u.Address2 = login.Address2;
u.City = login.City;
u.State = login.State;
u.Zip = login.Zip;
u.UserId = ul.UserId;
db.Entry(ul).State = EntityState.Modified;
db.Entry(u).State = EntityState.Modified;
db.SaveChanges();
ModelState.Clear();
// login = null;
ViewBag.Message = "Successfully Registration Done";
}
}
return(View(login));
}
public UnitOfWork(RestaurantDBEntities restaurantDbContext)
{
this.OrderRepository = new OrderRepository(restaurantDbContext);
this.CustomerRepository = new CustomerRepository(restaurantDbContext);
}
public JsonResult PostOrder(OrderDetailViewModel OrderDetailJSON)
{
RestaurantDBEntities db = new RestaurantDBEntities();
Order order = new Order();
OrderDetail odetail = new OrderDetail();
// before creating OrderDetail , Order has to be created . if an Order is already created but not placed, add items in that order no for same custommer
// if the order has not created , create order for that customer
var UserId = 0; // for now 0 , but get from session later
var OrderId = db.Orders.Where(o => o.CustomerId == UserId && o.OrderStatus == 0)
.Select(o => o.OrderId)
.DefaultIfEmpty(0)
.Max();
if (OrderId == 0) // create order if customer is adding first item in order
{
var MaxOrderId = db.Orders.Select(o => o.OrderId).DefaultIfEmpty(0).Max();
order.OrderId = MaxOrderId + 1;
order.CustomerId = UserId;
order.OrderDate = DateTime.Today;
order.OrderStatus = 0; //orderstaus = 0 , incomplete order , 1 : full order 2 payment received order
odetail.OrderDetailId = db.OrderDetails.Select(o => o.OrderDetailId).DefaultIfEmpty(0).Max() + 1;
odetail.OrderId = MaxOrderId + 1;
odetail.ItemId = OrderDetailJSON.ItemId;
odetail.Quantity = OrderDetailJSON.Quantity;
db.Orders.Add(order);
db.OrderDetails.Add(odetail);
db.SaveChanges();
}
else // create orderdetails if order is created and customer is adding item on it
{
//if customer adds the same item more than one time overwrite the quantity with new quantity
odetail.OrderId = OrderId;
var orderDetailId = db.OrderDetails.Where(o => o.OrderId == OrderId && o.ItemId == OrderDetailJSON.ItemId) //checking if orderdetail exist already for that item
.Select(o => o.OrderDetailId)
.DefaultIfEmpty(0)
.Max();
if (orderDetailId == 0) // if orderdetail doesnot exist already for that item , create orderdetail
{
odetail.OrderDetailId = db.OrderDetails.Select(o => o.OrderDetailId).DefaultIfEmpty(0).Max() + 1;
odetail.ItemId = OrderDetailJSON.ItemId;
odetail.Quantity = OrderDetailJSON.Quantity;
db.OrderDetails.Add(odetail);
}
else //
{
odetail = db.OrderDetails.FirstOrDefault(o => o.OrderDetailId == orderDetailId);
odetail.Quantity = OrderDetailJSON.Quantity;
}
db.SaveChanges();
}
return(Json("success"));
}
public PaymentTypeRepository()
{
_paymentTypeViewModel = new PaymentTypeViewModel();
_restaurantDBEntities = new RestaurantDBEntities();
}
public GenericRepository(RestaurantDBEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public HomeController()
{
objEntities = new RestaurantDBEntities();
}
public OrderRepository()
{
objRestaurantDBEntities = new RestaurantDBEntities();
}
public CustomerRepo()
{
restaurantDBEntities = new RestaurantDBEntities();
}
public OrderService()
{
var restaurantDbContext = new RestaurantDBEntities();
unitOfWork = new UnitOfWork.UnitOfWork(restaurantDbContext);
}
public CustomerRepository(RestaurantDBEntities restaurantDbContext) : base(restaurantDbContext)
{
this.restaurantDbContext = restaurantDbContext;
}
public RestaurantController()
{
objRestaurantDBEntities = new RestaurantDBEntities();
}
public Repository(RestaurantDBEntities restaurantDbContext)
{
this.restaurantDbContext = restaurantDbContext;
}
public UMFamilyRepository(RestaurantDBEntities context)
: base(context)
{
}
public TagRepository(RestaurantDBEntities context)
: base(context)
{
}
public ItemRepository()
{
objRestaurantDBEntities = new RestaurantDBEntities();
}
public PaymentTypeRepo()
{
_restaurantDBEntities = new RestaurantDBEntities();
}
public PRRepository()
{
_restaurantDBEntities = new RestaurantDBEntities();
}
public ProductRepository(RestaurantDBEntities context)
: base(context)
{
this.context = context;
}
public LineItemRepository(RestaurantDBEntities context)
: base(context)
{
}
public EmployeeRepository(RestaurantDBEntities context)
: base(context)
{
}
public DepartmentRepository()
{
_restaurantDBEntities = new RestaurantDBEntities();
}
public PaymentTypeRepository()
{
objRestaurantDBEntities = new RestaurantDBEntities();
}
public OrderRepo()
{
_restaurantDBEntities = new RestaurantDBEntities();
}
public CategoryRepository(RestaurantDBEntities context)
: base(context)
{
}
//CRUD-C
public void Create(PRLine pRLine)
{
_restaurantDBEntities = new RestaurantDBEntities();
_restaurantDBEntities.PRLines.Add(pRLine);
_restaurantDBEntities.SaveChanges();
}
public CustomerRespository()
{
objRestaurantDBEntities = new RestaurantDBEntities();
}
public PaymentRepositroy()
{
objRestaurantDbEntities = new RestaurantDBEntities();
}
