public static void Update(Mathang mh)
{
using (SqlConnection cnn = ConnectDataBase())
{
SqlCommand cmd = new SqlCommand("sp_Mathang_Update", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mamh", mh.Mamh);
cmd.Parameters.AddWithValue("@tenmh", mh.Tenmh);
cmd.Parameters.AddWithValue("@giaban", mh.Giaban);
cmd.Parameters.AddWithValue("@giagiam", mh.Giagiam);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
}
}
}
protected void grv_mathang_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txttenmh = (TextBox)grv_mathang.Rows[e.RowIndex].Cells[2].Controls[0];
TextBox txtgiaban = (TextBox)grv_mathang.Rows[e.RowIndex].Cells[4].Controls[0];
TextBox txtgiagiam = (TextBox)grv_mathang.Rows[e.RowIndex].Cells[5].Controls[0];
string mamh = grv_mathang.DataKeys[e.RowIndex].Value.ToString();
Mathang mh = new Mathang();
mh.Mamh = mamh;
mh.Tenmh = txttenmh.Text;
mh.Giaban = decimal.Parse(txtgiaban.Text);
mh.Giagiam = decimal.Parse(txtgiagiam.Text);
try
{
MathangBUS.Mathang_Update(mh);
Response.Write("<script>alert('Cập nhật mặt hàng thành công')</script>");
Response.Redirect(Request.Url.AbsoluteUri);
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
public static void Mathang_Update(Mathang mh)
{
MathangDAO.Update(mh);
}
protected void btn_themmathang_Click(object sender, EventArgs e)
{
Mathang mh = new Mathang();
mh.Mamh = txt_mamh.Text;
mh.Tenmh = txt_tenmh.Text;
mh.Hinhdd = mh.Mamh + ".jpg";
mh.Madm = ddl_danhmuc.SelectedValue.ToString();
mh.Mota = cke_mota.Text;
mh.Giaban = decimal.Parse(txt_giaban.Text + "000");
mh.Giagiam = decimal.Parse(txt_giagiam.Text + "000");
if(ful_anhdaidien.HasFile && txt_tenmh.Text != "" && txt_giaban.Text != "" && txt_giagiam.Text != "" && cke_mota.Text != "")
{
FileInfo info = new FileInfo(ful_anhdaidien.FileName);
if (info.Extension == ".jpg")
{
ful_anhdaidien.SaveAs(Server.MapPath("~/images/mat-hang/") + ful_anhdaidien.FileName);
try
{
File.Move(Server.MapPath("~/images/mat-hang/") + info.Name, Server.MapPath("~/images/mat-hang/") + mh.Hinhdd);
}
catch (Exception)
{
}
try
{
MathangBUS.Mathang_Insert(mh);
List<string> ds_size = new List<string>();
if(ddl_danhmuc.SelectedValue=="AO")
{
if(size_S.Checked==true)
{
ds_size.Add("S");
}
if (size_M.Checked == true)
{
ds_size.Add("M");
}
if (size_L.Checked == true)
{
ds_size.Add("L");
}
if (size_XL.Checked == true)
{
ds_size.Add("XL");
}
}
else if(ddl_danhmuc.SelectedValue=="QU")
{
if (size_30.Checked == true)
{
ds_size.Add("30");
}
if (size_31.Checked == true)
{
ds_size.Add("31");
}
if (size_32.Checked == true)
{
ds_size.Add("32");
}
if (size_33.Checked == true)
{
ds_size.Add("33");
}
if (size_34.Checked == true)
{
ds_size.Add("34");
}
}
else if(ddl_danhmuc.SelectedValue=="GD")
{
if (size_40.Checked == true)
{
ds_size.Add("40");
}
if (size_41.Checked == true)
{
ds_size.Add("41");
}
if (size_42.Checked == true)
{
ds_size.Add("42");
}
if (size_43.Checked == true)
{
ds_size.Add("43");
}
if (size_44.Checked == true)
{
ds_size.Add("44");
}
}
else
{
}
foreach (string i in ds_size)
{
SizeBUS.Size_Insert(mh.Mamh, i);
}
Response.Redirect(Request.Url.AbsoluteUri);
Response.Write("<script>alert('Thêm mặt hàng thành công')</script>");
Mathang_Show();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}
else
{
Response.Write("<script>alert('Định dạng ảnh phải là JPEG(*.jpg)')</script>");
}
}
else
{
Response.Write("<script>alert('Bạn chưa nhập đầy đủ thông tin')</script>");
}
}
public static void Mathang_Insert(Mathang mh)
{
MathangDAO.Insert(mh);
}