protected void btnLogin_Click(object sender, EventArgs e)
{
string username = txtUsernameLogin.Text;
string enc_pwd = StringUtils.MD5(txtPassLogin.Text);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
User us = ctx.Users
.Where(u => u.f_Username == username && u.f_Password == enc_pwd)
.FirstOrDefault();
if (us != null)
{
Session["IsLogin"] = 1;
Session["CurUser"] = us;
if (chkRemember.Checked)
{
Response.Cookies["Username"].Value = username;
Response.Cookies["Username"].Expires = DateTime.Now.AddDays(7);
}
string retUrl = Request.QueryString["retUrl"];
if (string.IsNullOrEmpty(retUrl))
{
retUrl = "~/admin/admproducts.aspx";
}
Response.Redirect(retUrl);
}
else
{
lbThongBao.Text = "Username hoặc mật khẩu không đúng!";
}
}
}
protected void lvwProducts_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "EditProduct")
{
int proID = Convert.ToInt32(e.CommandArgument);
tempProID = proID;
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Product pro = ctx.Products.Where
(p => p.ProID == proID).FirstOrDefault();
txtPricee.Text = pro.Price.ToString();
txtProNamee.Text = pro.ProName;
txtFullDese.Text = HttpUtility.HtmlDecode(pro.FullDes);
txtQuantitye.Text = pro.Quantity.ToString();
txtTinyDese.Text = HttpUtility.HtmlDecode(pro.TinyDes);
ddlCategorye.SelectedValue = pro.CatID.ToString();
}
//string script = "$('#modalEdit').modal('show')";
//if (ClientScript.IsStartupScriptRegistered("editProduct") == false)
//{
// ClientScript.RegisterStartupScript
// (
// this.GetType(), "editProduct", script, true
// );
//}
}
}
public bool Add(CartItems item)
{
CartItems existedItem = Items.Where(i => i.ProID == item.ProID).FirstOrDefault();
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Product pro = ctx.Products.Where(p => p.ProID == item.ProID).FirstOrDefault();
if (existedItem != null)
{
if (pro.Quantity < (existedItem.Quantity + item.Quantity))
{
return(false);
}
existedItem.Quantity += item.Quantity;
}
else//existedItem == null
{
if (pro.Quantity == 0 || pro.Quantity < item.Quantity)
{
return(false);
}
Items.Add(item);
}
return(true);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int proid = tempProID;
if (proid != -1)
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Product p = ctx.Products.Where(pro => pro.ProID == proid).FirstOrDefault();
if (p != null)
{
p.ProName = txtProNamee.Text;;
p.CatID = Convert.ToInt32(ddlCategorye.SelectedItem.Value);
p.Quantity = Convert.ToInt32(txtQuantitye.Text);
p.Price = Convert.ToInt32(txtPricee.Text);
p.TinyDes = txtTinyDese.Text;
p.FullDes = txtFullDese.Text;
ctx.Entry(p).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
if (FileUpload1.HasFile && FileUpload11.HasFile && FileUpload2.HasFile && FileUpload22.HasFile)
{
string spDirPath = Server.MapPath("~/images/products");
string targetDirPath = Path.Combine(spDirPath, p.ProID.ToString());
if (Directory.Exists(targetDirPath) == false)
{
Directory.CreateDirectory(targetDirPath);
}
//copy hình lên
//hinh 1
string mainFileName = Path.Combine(targetDirPath, "1.jpg");
FileUpload1.SaveAs(mainFileName);
string thumbsFileName = Path.Combine(targetDirPath, "1_thumbs.jpg");
FileUpload11.SaveAs(thumbsFileName);
//hình 2
mainFileName = Path.Combine(targetDirPath, "2.jpg");
FileUpload2.SaveAs(mainFileName);
thumbsFileName = Path.Combine(targetDirPath, "2_thumbs.jpg");
FileUpload22.SaveAs(thumbsFileName);
}
}
}
ClientScript.RegisterStartupScript(this.GetType(),
"swal",
"alert('Đã Chỉnh sửa');",
true
);
ClearProductInfo();
tempProID = -1;
LoadProducts();
}
}
protected void btnSavePro_Click(object sender, EventArgs e)
{
string proName = txtProName.Text;
int catID = Convert.ToInt32(ddlCategory.SelectedItem.Value);
int quantity = Convert.ToInt32(txtQuantity.Text);
int price = Convert.ToInt32(txtPrice.Text);
string tinyDes = txtTinyDes.Text;
string fullDes = txtFullDes.Text;
Product p = new Product
{
DOR = DateTime.Now,
ProName = proName,
CatID = catID,
Quantity = quantity,
Price = price,
TinyDes = tinyDes,
FullDes = fullDes
};
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
ctx.Products.Add(p);
ctx.SaveChanges();
}
if (fuPhotoL1.HasFile && fuPhotoN1.HasFile)
{
//tạo thư mục chứa hình
string spDirPath = Server.MapPath("~/images/products");
string targetDirPath = Path.Combine(spDirPath, p.ProID.ToString());
Directory.CreateDirectory(targetDirPath);
//copy hình lên
//hinh 1
string mainFileName = Path.Combine(targetDirPath, "1.jpg");
fuPhotoL1.SaveAs(mainFileName);
string thumbsFileName = Path.Combine(targetDirPath, "1_thumbs.jpg");
fuPhotoN1.SaveAs(thumbsFileName);
//hình 2
mainFileName = Path.Combine(targetDirPath, "2.jpg");
fuPhotoL2.SaveAs(mainFileName);
thumbsFileName = Path.Combine(targetDirPath, "2_thumbs.jpg");
fuPhotoN2.SaveAs(thumbsFileName);
}
ClientScript.RegisterStartupScript(this.GetType(),
"swal",
"alert('Đã thêm');",
true
);
ClearProductInfo();
LoadProducts();
}
private void LoadCats()
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Category> list = ctx.Categories.ToList();
lvwCats.DataSource = list;
lvwCats.DataBind();
}
}
private void LoadOrders()
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Order> list = ctx.Orders.ToList();
lvwOrders.DataSource = list;
lvwOrders.DataBind();
}
}
private void LoadProducts()
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Product> list = ctx.Products.Include("Category").ToList();
lvwProducts.DataSource = list;
lvwProducts.DataBind();
}
}
private void LoadBrands()
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Type> list = ctx.Types.ToList();
lvwBrands.DataSource = list;
lvwBrands.DataBind();
}
}
protected void lvwProducts_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
{
DataPagerViewProducts.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Product> list = ctx.Products.Include("Category").ToList();
lvwProducts.DataSource = list;
lvwProducts.DataBind();
}
}
private void LoadCategoryForEdit()
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Category> list = ctx.Categories.ToList();
ddlCategorye.DataSource = list;
ddlCategorye.DataTextField = "CatName";
ddlCategorye.DataValueField = "CatID";
ddlCategorye.DataBind();
}
}
//phan trang
protected void lvwBrands_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
{
DataPagerView.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
List <Category> list = ctx.Categories.ToList();
lvwBrands.DataSource = list;
lvwBrands.DataBind();
}
}
protected void lvwBrands_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
var typeID = Convert.ToInt32(e.Keys["TypeID"]);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Type type = ctx.Types.Where(c => c.TypeID == typeID).FirstOrDefault();
if (type != null)
{
ctx.Types.Remove(type);
ctx.SaveChanges();
LoadBrands();
}
}
}
protected void lvwProducts_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
var proID = Convert.ToInt32(e.Keys["ProID"]);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Product pro = ctx.Products.Where(c => c.ProID == proID).FirstOrDefault();
if (pro != null)
{
ctx.Products.Remove(pro);
ctx.SaveChanges();
LoadProducts();
}
}
}
protected void lvwOrders_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
var orderID = Convert.ToInt32(e.Keys["OrderID"]);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Order order = ctx.Orders.Where(c => c.OrderID == orderID).FirstOrDefault();
if (order != null)
{
ctx.Orders.Remove(order);
ctx.SaveChanges();
LoadOrders();
}
}
}
protected void lvwCats_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
var catID = Convert.ToInt32(e.Keys["CatID"]);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Category cat = ctx.Categories.Where(c => c.CatID == catID).FirstOrDefault();
if (cat != null)
{
ctx.Categories.Remove(cat);
ctx.SaveChanges();
LoadCats();
}
}
}
protected void lvwBrands_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
var typeID = Convert.ToInt32(e.Keys["TypeID"]);
string typeName = e.NewValues["TypeName"].ToString();
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Type type = ctx.Types.Where(c => c.TypeID == typeID).FirstOrDefault();
if (type != null)
{
type.TypeName = typeName;
ctx.SaveChanges();
}
}
lvwBrands.EditIndex = -1;
LoadBrands();
}
protected void lvwCats_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
var catID = Convert.ToInt32(e.Keys["CatID"]);
string catName = e.NewValues["CatName"].ToString();
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Category cat = ctx.Categories.Where(c => c.CatID == catID).FirstOrDefault();
if (cat != null)
{
cat.CatName = catName;
//ctx.Entry(cat).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
lvwCats.EditIndex = -1;
LoadCats();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Category cat = new Category
{
CatName = txtProName.Text
};
txtProName.Text = string.Empty;
ctx.Categories.Add(cat);
ctx.SaveChanges();
ClientScript.RegisterStartupScript(this.GetType(),
"swal",
"alert('Đã thêm');",
true
);
LoadCats();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Type cat = new Type
{
TypeName = txtNameBrands.Text
};
txtNameBrands.Text = string.Empty;
ctx.Types.Add(cat);
ctx.SaveChanges();
ClientScript.RegisterStartupScript(this.GetType(),
"swal",
"alert('Đã thêm');",
true
);
LoadBrands();
}
}
protected void lvwOrders_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
var orderID = Convert.ToInt32(e.Keys["OrderID"]);
string typeName = e.NewValues["Shipment"].ToString();
ClientScript.RegisterStartupScript(this.GetType(),
"swal",
"alert(" + typeName + ");",
true
);
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Order order = ctx.Orders.Where(c => c.OrderID == orderID).FirstOrDefault();
if (order != null)
{
int shipment = Convert.ToInt32(e.NewValues["Shipment"]);
order.Shipment = shipment;
ctx.SaveChanges();
}
}
lvwOrders.EditIndex = -1;
LoadOrders();
}
public static bool IsLogged()
{
if ((int)HttpContext.Current.Session["IsLogin"] == 1)
{
return(true);
}
if (HttpContext.Current.Request.Cookies["Username"] != null)
{
string username = HttpContext.Current.Request.Cookies["Username"].Value;
HttpContext.Current.Session["IsLogin"] = 1;
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
User us = ctx.Users
.Where(u => u.f_Username == username)
.FirstOrDefault();
HttpContext.Current.Session["CurUser"] = us;
}
return(true);
}
return(false);
}
