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));
}
