//Cách 1:
public ActionResult Addnew1(OrderModel objoOrder)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var dataorderid =
context.Database.SqlQuery <int>("exec sp_Order_Save 0,'OD+" + DateTime.Now.ToString("hh-mm-ss") + " ','Banhang',0," + objoOrder.TotalProduct + "," +
objoOrder.MoneyDiscount + "," + objoOrder.DiscountMoneyDirectly +
"," + objoOrder.TotalMoney + "," + objoOrder.CustomerId)
.FirstOrDefault();
// luu detail
foreach (var item in objoOrder.OrderDetail)
{
// update bang detail
var sqlquery = "exec sp_OrderDetail_Save " + dataorderid + "," + item.ProductID + "," +
item.Quanlity + ",0," + item.Discount + "," + item.MoneyDiscount + "," +
item.TotalMoney;
context.Database.SqlQuery <string>(sqlquery).FirstOrDefault();
// cap nhat so luong ban vao san pham
context.Database.SqlQuery <string>("exec sp_Product_UpdateOrder " + item.ProductID + " ," +
item.Quanlity + " ").FirstOrDefault();
}
}
return(RedirectToAction("Index", "tbl_Order"));
}
public ActionResult Del(int id)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var del = context.Database.SqlQuery <string>("Exec sp_Product_Delete " + id).First();
}
return(RedirectToAction("Index", "tbl_Product"));
}
// GET: ReportCustomer
public ActionResult Index_RPCustomer()
{
using (var context = new BANHANG_THUCTAPEntities())
{
var dataCustomer = context.sp_Customer_List(0).ToList();
ViewBag.ListCustomer = dataCustomer;
}
return(View());
}
//Cách 2: dùng xml
public ActionResult Addnew(string xml)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var add =
context.Database.SqlQuery <string>("exec sp_OrderOrderDetail_xml_Save N'" + xml + "'")
.FirstOrDefault();
return(Json(add, JsonRequestBehavior.AllowGet));
}
}
// GET: tbl_Order
public ActionResult Index()
{
using (var context = new BANHANG_THUCTAPEntities())
{
var DataProduct = context.sp_Product_List(0).ToList();
ViewBag.ListDataProduct = DataProduct;
var datacustomer = context.sp_Customer_List(0).ToList();
ViewBag.ListDataCustomer = datacustomer;
return(View(context.sp_Product_List(0).FirstOrDefault()));
}
}
public ActionResult Addnewxml(string sp_xml_Product_Save)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var add =
context.Database.SqlQuery <string>("exec sp_xml_Product_Save N'" + sp_xml_Product_Save + "'")
.FirstOrDefault();
return(Json(add, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SearchCustomer(ReportCustomerModel objCustomer)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var datasearch =
context.Database.SqlQuery <ReportCustomerModel>("exec sp_ReportCustomer_RP " + objCustomer.CustomerId)
.ToList();
return(Json(datasearch, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SearchCustomer(ReprotModel obj)
{
using (var context = new BANHANG_THUCTAPEntities())
{
// cach 1
var datasearch =
context.Database.SqlQuery <ReprotModel>("exec sp_OrderCustomer_RP '" + obj.TuNgay + "','" + obj.Denngay
+ "'").ToList();
// cach 2
//var data = context.sp_OrderCustomer_RP(obj.TuNgay, obj.Denngay);
return(Json(datasearch, JsonRequestBehavior.AllowGet));
}
}
public ActionResult login(tbl_Employee objEmployee)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var data =
context.tbl_Employee.Where(
a =>
a.AccountEmployee.Equals(objEmployee.AccountEmployee) &&
a.C_Password.Equals(objEmployee.C_Password)).FirstOrDefault();
if (data != null)
{
Session["Userid"] = data.EmployeeID;
Session["UserName"] = data.EmployeeName;
return(Json("OK", JsonRequestBehavior.AllowGet));
}
return(Json("Not OK", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Addnew(tbl_Product obj)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var add =
context.Database.SqlQuery <string>("EXEC dbo.sp_Product_Save @ProductID = " + obj.ProductID +
", @ProductName = N'" + obj.ProductName + "', @PriceProduct = " +
obj.PriceProduct + ", @CreateBy = " + obj.CreateBy +
", @GroupProductId = " + obj.GroupProductID).FirstOrDefault();
if (add == "Khong ton tai nhom san pham nay")
{
Session["tb"] = "ll";
}
else
{
Session["tb"] = "ok";
}
return(RedirectToAction("Index", "tbl_Product"));
}
}
public ActionResult Index_Product(int id = 0)
{
using (var context = new BANHANG_THUCTAPEntities())
{
var datapdd = context.sp_Product_List(0).ToList();
ViewBag.List = datapdd;
var GroupProduct = context.sp_GoupProduct_List(0).ToList();
ViewBag.ListGroupProduct = GroupProduct;
var Employee = context.sp_Employee_List(0).ToList();
ViewBag.ListEmployee = Employee;
if (id != 0)
{
return(View(context.sp_Product_List(id).FirstOrDefault()));
}
else
{
var nulldata = new sp_Product_List_Result();
nulldata.ProductID = 0;
nulldata.ProductName = "";
nulldata.PriceProduct = 0;
return(View(nulldata));
}
}
}
public BaseRepository(BANHANG_THUCTAPEntities context)
{
this.Context = context;
this.Table = context.Set <T>();
}
