private Khohang Laythongtinncc()
{
Khohang ncc = new Khohang();
ncc.Tenkhohang = txtkhohang.Text;
ncc.Diachikho = txtdiachi.Text;
return(ncc);
}
public themsuakhohang(Khohang khohang)
{
InitializeComponent();
Id = khohang.Id;
txtdiachi.Text = khohang.Diachikho;
txtkhohang.Text = khohang.Tenkhohang;
btnluu.Text = "Cập nhật";
this.Text = "Cập nhật kho hàng";
}
public int themsuankh(int Id, Khohang khohang)
{
string sql = "";
if (Id != 0)
{
sql = string.Format("Update Khohang Set Tenkhohang=N'{0}',Diachikho= N'{1}' Where Id='{2}'", khohang.Tenkhohang, khohang.Diachikho, Id);
}
else
{
sql = string.Format("Insert into Khohang(Tenkhohang,Diachikho) Values(N'{0}',N'{1}')", khohang.Tenkhohang, khohang.Diachikho);
}
var rs = db.thesuadulieu(sql);
return(rs);
}
private void Btnsua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Object id = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Id");
Object tenNCC = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Tenkhohang");
Object diaChi = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Diachikho");
Khohang khohang = new Khohang()
{
Id = int.Parse(id.ToString()),
Tenkhohang = tenNCC.ToString(),
Diachikho = diaChi.ToString(),
};
themsuakhohang themsuansx = new themsuakhohang(khohang);
themsuansx.Show();
themsuansx.khicapnhat += Themsuansx_khicapnhat;
}
private void Btnluu_Click(object sender, EventArgs e)
{
Khohang ncc = Laythongtinncc();
var row = khohangBUS.themsuankh(Id, ncc);
if (row > 0)
{
khicapnhat();
if (Id != 0)
{
MessageBox.Show("Cập nhật thành công!");
}
else
{
MessageBox.Show("Thêm kho hàng thành công!");
}
this.Close();
}
else
{
MessageBox.Show("Cập nhật thất bại!");
}
}
public int themsuankh(int Id, Khohang khohang)
{
return(khohangDAO.themsuankh(Id, khohang));
}
