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(); }