protected void btnSua_Click(object sender, EventArgs e)
{
try
{
if (txtMaNhaSX.Text.Length > 0)
{
tbl_Producer nsx = db.tbl_Producer.Find(int.Parse(txtMaNhaSX.Text));
nsx.Producer_Name = txtTenNhaSX.Text;
db.SaveChanges();
load();
reset();
lbThongBao.Text = "sửa thành công";
lbThongBao.ForeColor = System.Drawing.Color.Green;
}
else
{
lbThongBao.Text = "Chưa nhập dữ liệu";
lbThongBao.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
lbThongBao.Text = "Đã có lỗi xảy ra. Vui lòng thử lại sau.";
lbThongBao.ForeColor = System.Drawing.Color.Red;
}
}
public ActionResult SuaSP(int id)
{
var sua_sp = ddd.tbl_Products.First(sp => sp.Id == id);
tbl_TypeOfProduct nsp = ddd.tbl_TypeOfProducts.FirstOrDefault(mnsp => mnsp.Id == sua_sp.TypeId);
tbl_Producer nsx = ddd.tbl_Producers.FirstOrDefault(mnsx => mnsx.Id == sua_sp.ProducerId);
Session["TenNSP"] = nsp.TypeName;
Session["TenNSX"] = nsx.ProducerName;
return(View(sua_sp));
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
Label lblMa = (Label)GridView1.Rows[e.NewEditIndex].FindControl("lbMa");
tbl_Producer p = db.tbl_Producers.SingleOrDefault(c => c.Producer_ID == int.Parse(lblMa.Text));
txtMa.Text = p.Producer_ID.ToString();
txtTen.Text = p.Producer_Name.ToString();
GridView1.EditIndex = e.NewEditIndex;
load();
}
protected void btnXoa_Click(object sender, EventArgs e)
{
tbl_Producer p = db.tbl_Producers.SingleOrDefault(c => c.Producer_ID == int.Parse(txtMa.Text));
db.tbl_Producers.DeleteOnSubmit(p);
db.SubmitChanges();
load();
Label2.Text = "Xoá thành công.";
rong();
txtTen.Focus();
}
protected void btnNhap_Click(object sender, EventArgs e)
{
tbl_Producer p = new tbl_Producer();
p.Producer_Name = txtTen.Text;
db.tbl_Producers.InsertOnSubmit(p);
db.SubmitChanges();
load();
Label2.Text = "Thêm thành công";
rong();
}
protected void btnSua_Click(object sender, EventArgs e)
{
tbl_Producer p = db.tbl_Producers.SingleOrDefault(c => c.Producer_ID == int.Parse(txtMa.Text));
p.Producer_ID = int.Parse(txtMa.Text);
p.Producer_Name = txtTen.Text;
db.SubmitChanges();
load();
Label2.Text = "Sửa thành công.";
rong();
txtTen.Focus();
}
