public IHttpActionResult PutItem(int id, Item item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != item.ItemId)
{
return(BadRequest());
}
db.Entry(item).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutOrder(long id, Order order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != order.OrderID)
{
return(BadRequest());
}
db.Entry(order).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "ID,Text,RestaurantID,Rating,Name")] Review review)
{
if (ModelState.IsValid)
{
db.Reviews.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public ActionResult Create([Bind(Include = "ItemId,ItemName,ItemPrice")] Item item)
{
if (ModelState.IsValid)
{
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(item));
}
public ActionResult Create([Bind(Include = "restid,restname")] Restaurant restaurant)
{
if (ModelState.IsValid)
{
db.Restaurants.Add(restaurant);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(restaurant));
}
public ActionResult Create([Bind(Include = "revid,revscore,revsubject")] Review review)
{
if (ModelState.IsValid)
{
db.Reviews.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.revsubject = new SelectList(db.Restaurants, "restid", "restname", review.revsubject);
return(View(review));
}
public JsonResult UploadFileImage(UploadFileViewModel uploadFileViewModel)
{
RestaurantDBEntities db = new RestaurantDBEntities();
int imgId = 0;
////var file = model.UploadFileImageWrapper;
//// Get all files from Request object
//HttpFileCollectionBase files = Request.Files;
//HttpPostedFileBase file = files[0];
HttpPostedFileBase file = uploadFileViewModel.httpPostedUploadFileImage;
byte[] imagebyte = null;
if (file != null)
{
// Get the complete folder path and store the file inside it.
string fname = Path.Combine(Server.MapPath("~/Upload/img/temp"), file.FileName);
file.SaveAs(fname);
BinaryReader reader = new BinaryReader(file.InputStream);
imagebyte = reader.ReadBytes(file.ContentLength);
//Not use mapper
//Using directly to Model
UploadFile img = new UploadFile();
img.UploadFileName = file.FileName;
img.UploadFileImage = imagebyte;
img.UploadFilePath = "/Upload/img/temp/" + file.FileName;
img.UploadFileId = uploadFileViewModel.UploadFileId;
img.SubCatagoryId = uploadFileViewModel.SubCatagoryId;
img.UploadFileVersion = uploadFileViewModel.UploadFileVersion;
//DBset
db.UploadFiles.Add(img);
db.SaveChanges();
imgId = img.UploadFileId;
}
return(Json(imgId, JsonRequestBehavior.AllowGet));
}
public void AddRestaurant(Restaurants item)
{
using (db = new RestaurantDBEntities())
{
db.Restaurant.Add(LibraryToData(item));
db.SaveChanges();
}
}
public void Delete(int _pRLineId)
{
_restaurantDBEntities = new RestaurantDBEntities();
var _pRLine = _restaurantDBEntities.PRLines.Find(_pRLineId);
_restaurantDBEntities.PRLines.Remove(_pRLine);
_restaurantDBEntities.SaveChanges();
}
public IHttpActionResult PostOrder(Order order)
{
try
{
//Order table
if (order.OrderID == 0)
{
db.Orders.Add(order);
}
else
{
db.Entry(order).State = EntityState.Modified;
}
//OrderItems table
foreach (var item in order.OrderItems)
{
if (item.OrderItemID == 0)
{
db.OrderItems.Add(item);
}
else
{
db.Entry(item).State = EntityState.Modified;
}
}
//Delete for OrderItems
if (order.DeletedOrderItemIDs != null)
{
foreach (var id in order.DeletedOrderItemIDs.Split(',').Where(x => x != ""))
{
OrderItem x = db.OrderItems.Find(Convert.ToInt64(id));
db.OrderItems.Remove(x);
}
}
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
throw ex;
}
}
//public IEnumerable<PR> GetAll()
//{
// var _listPR = _restaurantDBEntities.PRs.ToList();
// return _listPR;
//}
//public PR GetById(string pRNo)
//{
// var _pR = _restaurantDBEntities.PRs.Where(s => s.PRNo == "200001").FirstOrDefault<PR>();
// var _pRLineRepository = new PRLineRepository();
// //_pR.PRLines = _pRLineRepository.GetById(pRNo);
// return _pR;
//}
public void Create(PR pR)
{
try
{
_restaurantDBEntities.PRs.Add(pR);
_restaurantDBEntities.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
public bool AddOrder(OrderViewModel objOrderViewModel)
{
Order objOrder = new Order();
objOrder.CustomerId = objOrderViewModel.CustomerId;
objOrder.FinalTotal = objOrderViewModel.FinalTotal;
objOrder.OrderDate = DateTime.Now;
objOrder.OrderName = string.Format("{0:ddmmmyyyyhhmmss}", DateTime.Now);
objOrder.PaymentTypeId = objOrderViewModel.PaymentTypeId;
objRestaurantDBEntities.Orders.Add(objOrder);
objRestaurantDBEntities.SaveChanges();
int OrderId = objOrder.OrderId;
foreach (var item in objOrderViewModel.ListOfOrderDetailViewModel)
{
OrderDetail objOrderDetail = new OrderDetail();
objOrderDetail.OrderId = OrderId;
objOrderDetail.Discount = item.Discount;
objOrderDetail.ItemId = item.ItemId;
objOrderDetail.Total = item.Total;
objOrderDetail.UnitPrice = item.UnitPrice;
objOrderDetail.Quantity = item.Quantity;
objRestaurantDBEntities.OrderDetails.Add(objOrderDetail);
objRestaurantDBEntities.SaveChanges();
Transaction objTransaction = new Transaction();
objTransaction.ItemId = item.ItemId;
objTransaction.Quantity = (-1) * item.Quantity;
objTransaction.TransactionDate = DateTime.Now;
objTransaction.TypeId = 2;
objRestaurantDBEntities.Transactions.Add(objTransaction);
objRestaurantDBEntities.SaveChanges();
}
return(true);
}
public bool AddOrder(OrderViewModel objOrderViewModel)
{
Orders objOrder = new Orders();
objOrder.FinalTotal = objOrderViewModel.FinalTotal;
objOrder.CustomerId = objOrderViewModel.CustomerId;
objOrder.OrderDate = DateTime.Now;
objOrder.OrderNumber = String.Format("{0:ddmmmyyyyhhmmss}", DateTime.Now);
objOrder.PaymentTypeId = objOrderViewModel.PaymentTypeId;
int a = objRestaurantDbEntities.Orders.Count();
objOrder.OrderId = a;
int OrderId = objOrder.OrderId;
objRestaurantDbEntities.Orders.Add(objOrder);
objRestaurantDbEntities.SaveChanges();
foreach (var item in objOrderViewModel.ListOfOrderDetailViewModel)
{
OrderDetails objOrderDetails = new OrderDetails();
objOrderDetails.OrderId = OrderId;
objOrderDetails.Discount = item.Discount;
objOrderDetails.ItemId = item.ItemId;
objOrderDetails.Total = item.Total;
objOrderDetails.Price = item.Price;
objOrderDetails.Quantity = item.Quantity;
objRestaurantDbEntities.OrderDetails.Add(objOrderDetails);
objRestaurantDbEntities.SaveChanges();
Transactions objTransactions = new Transactions();
objTransactions.ItemId = item.ItemId;
objTransactions.Quantity = (-1) * item.Quantity;
objTransactions.TransactionDate = DateTime.Now;
objTransactions.TypeId = 2;
objRestaurantDbEntities.Transactions.Add(objTransactions);
objRestaurantDbEntities.SaveChanges();
}
return(true);
}
public bool AddOrder(OrderViewModel orderViewModel)
{
Order order = new Order();
order.CustomerId = orderViewModel.CustomerId;
order.FinalTotal = orderViewModel.FinalTotal;
order.OrderDate = DateTime.Now;
order.OrderNumber = String.Format("{0:ddmmmyyyyhhmmss}", DateTime.Now);
order.PaymentTypeId = orderViewModel.PaymentTypeId;
_restaurantDBEntities.Orders.Add(order);
_restaurantDBEntities.SaveChanges();
int orderId = order.OrderId;
foreach (OrderDetailViewModel itemDetails in orderViewModel.ListOfOrderDetailViewModels)
{
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderId = orderId;
orderDetail.Discount = itemDetails.Discount;
orderDetail.ItemId = itemDetails.ItemId;
orderDetail.Total = itemDetails.Total;
orderDetail.UnitPrice = itemDetails.UnitPrice;
orderDetail.Tax = itemDetails.Tax;
orderDetail.ItemName = itemDetails.ItemName;
orderDetail.Quantity = itemDetails.Quantity;
_restaurantDBEntities.OrderDetails.Add(orderDetail);
_restaurantDBEntities.SaveChanges();
Transaction transaction = new Transaction();
transaction.ItemId = itemDetails.ItemId;
transaction.Quantity = (-1) * itemDetails.Quantity;
transaction.TransactionDate = DateTime.Now;
transaction.TypeId = "Restaurant";
_restaurantDBEntities.Transactions.Add(transaction);
_restaurantDBEntities.SaveChanges();
}
return(true);
}
// 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));
}
//CRUD-C
public void Create(PRLine pRLine)
{
_restaurantDBEntities = new RestaurantDBEntities();
_restaurantDBEntities.PRLines.Add(pRLine);
_restaurantDBEntities.SaveChanges();
}
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 void SaveChanges()
{
context.SaveChanges();
}
