public int Insert(PaymentStatu entity) { entity.CreateDate = DateTime.Now; db.PaymentStatus.Add(entity); db.SaveChanges(); return(entity.PaymentStatusID); }
// PUT api/PaymentStatus/5 public IHttpActionResult PutPaymentStatu(int id, PaymentStatu paymentstatu) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != paymentstatu.PaymentStatusId) { return(BadRequest()); } db.Entry(paymentstatu).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!PaymentStatuExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetPaymentStatu(int id) { PaymentStatu paymentstatu = db.PaymentStatus.Find(id); if (paymentstatu == null) { return(NotFound()); } return(Ok(paymentstatu)); }
public IHttpActionResult PostPaymentStatu(PaymentStatu paymentstatu) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.PaymentStatus.Add(paymentstatu); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = paymentstatu.PaymentStatusId }, paymentstatu)); }
public IHttpActionResult DeletePaymentStatu(int id) { PaymentStatu paymentstatu = db.PaymentStatus.Find(id); if (paymentstatu == null) { return(NotFound()); } db.PaymentStatus.Remove(paymentstatu); db.SaveChanges(); return(Ok(paymentstatu)); }
public bool Update(PaymentStatu entity) { try { var _paystatus = db.PaymentStatus.Find(entity.PaymentStatusID); _paystatus.Name = entity.Name; _paystatus.Note = entity.Note; _paystatus.ModifiedDate = DateTime.Now; _paystatus.ModifiedUser = entity.ModifiedUser; _paystatus.CreateDate = entity.CreateDate; _paystatus.CreateUser = entity.CreateUser; _paystatus.IsActive = entity.IsActive; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public IQueryable <GroceryOrder> GetGroceryOrdersByLoginId(int LoginId) { var items = db.GroceryOrders.Where(i => i.LoginId == LoginId); foreach (var item in items) { OrderStatusGrocer orderStatusGrocer = db.OrderStatusGrocers.Find(item.OrderStatusId); item.OrderStatusGrocer = orderStatusGrocer; PaymentStatu paymentStatus = db.PaymentStatus.Find(item.PaymentStatusId); item.PaymentStatu = paymentStatus; Login login = db.Logins.Find(item.LoginId); item.Login = login; Grocer grocer = db.Grocers.Find(item.GrocerId); item.Grocer = grocer; } return(db.GroceryOrders.OrderBy(a => a.GroceryOrderId)); }
// GET api/GroceryOrder public IQueryable <GroceryOrder> GetGroceryOrders() { var items = db.GroceryOrders; foreach (var item in items) { OrderStatusGrocer orderStatusGrocer = db.OrderStatusGrocers.Find(item.OrderStatusId); item.OrderStatusGrocer = orderStatusGrocer; PaymentStatu paymentStatus = db.PaymentStatus.Find(item.PaymentStatusId); item.PaymentStatu = paymentStatus; //Login login = db.Logins.Find(item.LoginId); //item.Login = login; //Grocer grocer = db.Grocers.Find(item.GrocerId); //item.Grocer = grocer; } return(db.GroceryOrders.OrderBy(a => (a.GroceryOrderId))); }
public IQueryable <RestaurantOrder> GetRestaurantOrdersByLoginId(int LoginId) { var items = db.RestaurantOrders.Where(i => i.LoginId == LoginId); foreach (var item in items) { Login login = db.Logins.Find(item.LoginId); item.Login = login; OrderStatusRestaurateur orderStatusRestaurateur = db.OrderStatusRestaurateurs.Find(item.OrderStatusId); item.OrderStatusRestaurateur = orderStatusRestaurateur; PaymentStatu paymentStatus = db.PaymentStatus.Find(item.PaymentStatusId); item.PaymentStatu = paymentStatus; Restaurateur restaurateur = db.Restaurateurs.Find(item.RestaurateurId); item.Restaurateur = restaurateur; } return(db.RestaurantOrders.OrderBy(a => a.RestaurantOrderId)); }
// GET api/RestaurantOrder public IQueryable <RestaurantOrder> GetRestaurantOrders() { var items = db.RestaurantOrders; foreach (var item in items) { //Login login = db.Logins.Find(item.LoginId); //item.Login = login; OrderStatusRestaurateur orderStatusRestaurateur = db.OrderStatusRestaurateurs.Find(item.OrderStatusId); item.OrderStatusRestaurateur = orderStatusRestaurateur; PaymentStatu paymentStatus = db.PaymentStatus.Find(item.PaymentStatusId); item.PaymentStatu = paymentStatus; //Restaurateur restaurateur = db.Restaurateurs.Find(item.RestaurateurId); //item.Restaurateur = restaurateur; } return(db.RestaurantOrders.OrderBy(a => (a.RestaurantOrderId))); }
public ActionResult Edit([Bind(Include = "PaymentStatusID,Name,Note,CreateDate,CreateUser,ModifiedDate,ModifiedUser,IsActive")] PaymentStatu paymentStatu) { var UserSession = (UserLogin)Session[TechDeviShopVs002.Common.CommonConstants.USER_SESSION]; if (ModelState.IsValid) { var _dal = new PaymentStatusDAL(); paymentStatu.ModifiedUser = UserSession.UserID; var _result = _dal.Update(paymentStatu); if (_result) { return(RedirectToAction("Index", "PaymentStatus")); } else { ModelState.AddModelError("", "Cập nhật trạng thái thanh toán ko thành công"); } } return(View(paymentStatu)); }