public ActionResult DeleteConfirmed(int id)
{
TB_PRODUCT tb_product = db.TB_PRODUCT.Find(id);
db.TB_PRODUCT.Remove(tb_product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Product/Details/5
public ActionResult Details(int id = 0)
{
TB_PRODUCT tb_product = db.TB_PRODUCT.Find(id);
if (tb_product == null)
{
return(HttpNotFound());
}
return(View(tb_product));
}
public TB_PRODUCT getProductById(int id)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", id)
};
TB_PRODUCT result = context.Database.SqlQuery <TB_PRODUCT>("Usp_GetProductById @N_ID", sqlParams).SingleOrDefault();
return(result);
}
// GET: StoreShow
public ActionResult Index(int?store_id)
{
string Sql = "SELECT ID,NAME,TYPE,FILE_NAME FROM TB_STORE NATURAL JOIN TB_STORE_TYPE NATURAL JOIN TB_DECORATION WHERE ID= " + store_id.ToString();
List <StoreMes> storemess = db.Database.SqlQuery <StoreMes>(Sql).ToList();
IndexModel.name = storemess.First().NAME;
IndexModel.filename = storemess.First().FILE_NAME;
IndexModel.types = new List <string>();
foreach (StoreMes item in storemess)
{
IndexModel.types.Add(item.TYPE);
}
IndexModel.store_id = store_id;
string SqlString = "SELECT * FROM TB_PRODUCT P WHERE P.S_ID = " + store_id.ToString() + "ORDER BY (SELECT SUM(NUM) FROM TB_CONTAINS GROUP BY S_ID,P_ID HAVING S_ID = P.S_ID AND P_ID = P.ID) DESC";
List <TB_PRODUCT> hot_products = db.Database.SqlQuery <TB_PRODUCT>(SqlString).ToList();
int min_num = Math.Min(4, hot_products.Count);
int num = 0;
int i = 0;
while (num < min_num && i < hot_products.Count)
{
TB_PRODUCT temp_product = hot_products[i];
string Sql2 = "SELECT COUNT(*) FROM TB_CONTAINS WHERE S_ID = " + temp_product.S_ID.ToString() + "AND P_ID = " + temp_product.ID.ToString();
var list = db2.TB_CONTAINS.Where(a => a.P_ID == temp_product.ID && a.S_ID == temp_product.S_ID).ToList();
if (list.Count > 0)
{
HotProductView product = new HotProductView();
product.name = temp_product.NAME;
product.price = temp_product.PRICE;
product.s_id = (int?)temp_product.S_ID;
product.id = (int?)temp_product.ID;
Pro_pics pics = new Pro_pics();
TB_PRO_PIC pic = pics.TB_PRO_PIC.Where(a => a.P_ID == temp_product.ID && a.S_ID == temp_product.S_ID).FirstOrDefault();
if (pic != null)
{
product.picture = pic.PICTURE;
}
hot_product_models.Add(product);
num--;
}
else
{
min_num--;
min_num = Math.Min(min_num, 4);
}
i++;
}
IndexModel.hot_products = hot_product_models;
IndexModel.low_products = db.Database.SqlQuery <TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString() + "AND DISCOUNT_RATE < 0.5").ToList();
IndexModel.high_products = db.Database.SqlQuery <TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString() + "AND DISCOUNT_RATE < 1 AND DISCOUNT_RATE > 0.5").ToList();
return(View(IndexModel));
}
public ActionResult Edit(TB_PRODUCT tb_product)
{
if (ModelState.IsValid)
{
db.Entry(tb_product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_PRODUCT = new SelectList(db.TB_GROUP_USER, "ID_GROUP_USER", "OBS", tb_product.ID_PRODUCT);
ViewBag.ID_SUBCATEGORY = new SelectList(db.TB_SUBCATEGORY, "ID_SUBCATEGORY", "DESCRIPTION", tb_product.ID_SUBCATEGORY);
return(View(tb_product));
}
//
// GET: /Product/Edit/5
public ActionResult Edit(int id = 0)
{
TB_PRODUCT tb_product = db.TB_PRODUCT.Find(id);
if (tb_product == null)
{
return(HttpNotFound());
}
ViewBag.ID_PRODUCT = new SelectList(db.TB_GROUP_USER, "ID_GROUP_USER", "OBS", tb_product.ID_PRODUCT);
ViewBag.ID_SUBCATEGORY = new SelectList(db.TB_SUBCATEGORY, "ID_SUBCATEGORY", "DESCRIPTION", tb_product.ID_SUBCATEGORY);
return(View(tb_product));
}
public object createProduct(TB_PRODUCT model)
{
object[] sqlParams =
{
new SqlParameter("@S_NAME", model.S_NAME),
new SqlParameter("@N_PRICE", model.N_PRICE),
new SqlParameter("@S_TYPE", model.S_TYPE),
new SqlParameter("@S_DETAIL", model.S_DETAIL),
new SqlParameter("@S_DESCRIPTION", model.S_DESCRIPTION)
};
var result = context.Database.SqlQuery <object>("Usp_InsertProduct @S_NAME,@N_PRICE,@S_TYPE,@S_DETAIL,@S_DESCRIPTION", sqlParams).SingleOrDefault();
return(result);
}
public object updateProductById(TB_PRODUCT model)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", model.N_ID),
new SqlParameter("@S_NAME", model.S_NAME),
new SqlParameter("@N_PRICE", model.N_PRICE),
new SqlParameter("@S_TYPE", model.S_TYPE),
new SqlParameter("@S_DESCRIPTION", model.S_DESCRIPTION)
};
var result = context.Database.SqlQuery <object>("Usp_updateProductById @N_ID,@S_NAME,@N_PRICE,@S_TYPE,@S_DESCRIPTION", sqlParams).SingleOrDefault();
return(result);
}
public ActionResult Create(TB_PRODUCT tb_product)
{
if (ModelState.IsValid)
{
var user = db.TB_USER.FirstOrDefault(u => u.LOGIN == User.Identity.Name);
tb_product.ID_USER = user.ID_USER;
var subcategory = db.TB_SUBCATEGORY.FirstOrDefault(u => u.ID_SUBCATEGORY == tb_product.ID_SUBCATEGORY);
tb_product.TB_SUBCATEGORY = subcategory;
db.TB_PRODUCT.Add(tb_product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_PRODUCT = new SelectList(db.TB_GROUP_USER, "ID_GROUP_USER", "OBS", tb_product.ID_PRODUCT);
ViewBag.ID_SUBCATEGORY = new SelectList(db.TB_SUBCATEGORY, "ID_SUBCATEGORY", "DESCRIPTION", tb_product.ID_SUBCATEGORY);
return(View(tb_product));
}
public ActionResult Edit(ProductModel model)
{
try
{
var modelDB = new ProductDBModel();
TB_PRODUCT product = new TB_PRODUCT();
product.N_ID = model.id;
product.S_NAME = model.productName;
product.N_PRICE = model.price;
product.S_TYPE = model.type;
product.S_DESCRIPTION = model.description;
modelDB.updateProductById(product);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Create(ProductModel model)
{
try
{
var modelDB = new ProductDBModel();
TB_PRODUCT product = new TB_PRODUCT();
product.S_NAME = model.productName;
product.N_PRICE = model.price;
product.S_TYPE = model.type;
product.S_DETAIL = model.detail;
product.S_DESCRIPTION = model.description;
modelDB.createProduct(product);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Index()
{
string Sql = "SELECT * FROM TB_PRODUCT P ORDER BY (SELECT SUM(NUM) FROM TB_CONTAINS GROUP BY S_ID,P_ID HAVING S_ID = P.S_ID AND P_ID = P.ID) DESC";
List <TB_PRODUCT> hot_products = db.Database.SqlQuery <TB_PRODUCT>(Sql).ToList();
int min_num = Math.Min(8, hot_products.Count);
int num = 0;
int i = 0;
while (num < min_num && i < hot_products.Count)
{
TB_PRODUCT temp_product = hot_products[i];
string Sql2 = "SELECT COUNT(*) FROM TB_CONTAINS WHERE S_ID = " + temp_product.S_ID.ToString() + "AND P_ID = " + temp_product.ID.ToString();
var list = db.TB_CONTAINS.Where(a => a.P_ID == temp_product.ID && a.S_ID == temp_product.S_ID).ToList();
if (list.Count > 0)
{
HotProductView product = new HotProductView();
product.name = temp_product.NAME;
product.price = temp_product.PRICE;
product.id = (int?)temp_product.ID;
product.s_id = (int?)temp_product.S_ID;
Pro_pics pics = new Pro_pics();
TB_PRO_PIC pic = pics.TB_PRO_PIC.Where(a => a.P_ID == temp_product.ID && a.S_ID == temp_product.S_ID).FirstOrDefault();
if (pic != null)
{
product.picture = pic.PICTURE;
}
hot_product_models.Add(product);
num--;
}
else
{
min_num--;
min_num = Math.Min(min_num, 8);
}
i++;
}
return(View(hot_product_models));
}
