public ActionResult List()
{
var modelDB = new OrderDBModel();
var list = modelDB.getListOrder();
return(View(list));
}
public ActionResult Delete(int id)
{
var modelDB = new OrderDBModel();
modelDB.deleteOrderById(id);
return(RedirectToAction("Index"));
}
// GET: Card
public ActionResult Index()
{
InfoSession modelSession = new InfoSession();
modelSession = SessionHelper.GetInfoSession();
if (modelSession == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
Session["infoSession"] = modelSession;
var orderDBModel = new OrderDBModel();
/*OrderModel orderModel = new OrderModel();*/
var models = orderDBModel.getOrdersByCustomerId(modelSession.id);
CardModel model = new CardModel();
model.orders = models;
model.total = 0;
foreach (TB_ORDER order in models)
{
if (order.S_STATUS.Equals("InActive") && order.PRICE != null)
{
model.total = (double)(model.total + (order.PRICE * order.N_TOTAL));
}
}
return(View(model));
}
}
public ActionResult DetailOrder(string name, DateTime date)
{
var modelDB = new OrderDBModel();
var list = modelDB.getDetailOrder(name, date);
return(View(list));
}
public ActionResult UpdateStatusOrder(int id, string name, DateTime date, string s_status)
{
var modelDB = new OrderDBModel();
s_status = s_status.Equals("Active") ? "InActive" : "Active";
modelDB.updateStatusOrder(id, s_status);
return(RedirectToAction("DetailOrder", "Order", new { name, date }));
}
public ActionResult Active()
{
var modelDB = new OrderDBModel();
InfoSession modelSession = new InfoSession();
modelSession = SessionHelper.GetInfoSession();
Session["infoSession"] = modelSession;
modelDB.activeOrderByCustomerId(modelSession.id);
return(RedirectToAction("Index"));
}
// GET: Admin/Store/Edit/5
public ActionResult Edit(int n_id)
{
var modelDB = new OrderDBModel();
var model = new OrderModel();
var result = modelDB.getOrderById(n_id);
model.id = result.N_ID;
model.customerName = result.S_CUSTOMER_NAME;
model.phone = result.S_PHONE;
model.address = result.S_ADDRESS;
model.productName = result.PRODUCT_NAME;
model.planName = result.PLAN_NAME;
model.amount = result.N_AMOUNT;
model.total = result.N_TOTAL;
model.description = result.S_DESCRIPTION;
model.status = result.S_STATUS;
model.createdDate = result.D_CREATED;
return(View(model));
}
public ActionResult Edit(OrderModel model)
{
try
{
var modelDB = new OrderDBModel();
TB_ORDER order = new TB_ORDER();
order.N_ID = model.id;
order.S_CUSTOMER_NAME = model.customerName;
order.S_PHONE = model.phone;
order.S_ADDRESS = model.address;
order.S_DESCRIPTION = model.description;
modelDB.updateOrderById(order);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Create(int id, string type, double price, int total)
{
InfoSession modelSession = new InfoSession();
modelSession = SessionHelper.GetInfoSession();
if (modelSession == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
var orderDBModel = new OrderDBModel();
TB_ORDER order = new TB_ORDER();
order.N_AMOUNT = price * total;
order.N_TOTAL = total;
order.S_TYPE = type;
order.S_CUSTOMER_NAME = modelSession.fullName;
order.S_PHONE = modelSession.phone;
order.S_ADDRESS = modelSession.address;
order.N_CUSTOMER_ID = modelSession.id;
orderDBModel.createOrder(order, id);
return(RedirectToAction("Index", "Card"));
}
}
