private void KtraSuaCTPN()
{
try
{
ChiTietPN_DTO ctpn = new ChiTietPN_DTO();
ctpn.MaPN = cboMaPN.Text.Trim();
ctpn.MaHang = cboMaHangNhap.Text.Trim();
ctpn.TenHang = txtTenHangNhap.Text.Trim();
ctpn.SoLuong = int.Parse(txtSLNhap.Text.ToString());
ctpn.DonGiaNhap = int.Parse(txtDonGiaNhap.Text.ToString());
ctpn.TongTienNhap = int.Parse(lbTienNhap.Text.ToString());
kiemtra_rong();
if (ctpnBLL.SuaChiTietPN(ctpn))
{
MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Sửa không thành công!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load_ChiTietPN();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool SuaChiTietPN(ChiTietPN_DTO ctpn)
{
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update CHITIET_PN set TEN_HANG_NHAP=@TenHangNhap, SL_NHAP=@SoLuong, ID=@ID, DON_GIA_NHAP=@DonGiaNhap, TONG_TIEN_NHAP=@TongTienNhap where MA_PN=@MaPN and MA_HANG=@MaHang";
cmd.Connection = conn;
cmd.Parameters.Add("@MaPN", SqlDbType.VarChar).Value = ctpn.MaPN;
cmd.Parameters.Add("@MaHang", SqlDbType.VarChar).Value = ctpn.MaHang;
cmd.Parameters.Add("@TenHangNhap", SqlDbType.NVarChar).Value = ctpn.TenHang;
cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = ctpn.SoLuong;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = ctpn.ID;
cmd.Parameters.Add("@DonGiaNhap", SqlDbType.Int).Value = ctpn.DonGiaNhap;
cmd.Parameters.Add("@TongTienNhap", SqlDbType.Int).Value = ctpn.TongTienNhap;
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool ThemChiTietPN(ChiTietPN_DTO ctpn)
{
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into CHITIET_PN values(@MaPN, @MaHang, @TenHangNhap, @SLNhap, @ID, @DonGiaNhap, @TongTienNhap)";
cmd.Connection = conn;
cmd.Parameters.Add("@MaPN", SqlDbType.VarChar).Value = ctpn.MaPN;
cmd.Parameters.Add("@MaHang", SqlDbType.VarChar).Value = ctpn.MaHang;
cmd.Parameters.Add("@TenHangNhap", SqlDbType.NVarChar).Value = ctpn.TenHang;
cmd.Parameters.Add("@SLNhap", SqlDbType.Int).Value = ctpn.SoLuong;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = ctpn.ID;
cmd.Parameters.Add("@DonGiaNhap", SqlDbType.Int).Value = ctpn.DonGiaNhap;
cmd.Parameters.Add("@TongTienNhap", SqlDbType.Int).Value = ctpn.TongTienNhap;
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <ChiTietPN_DTO> ChiTietPN(string mapn)
{
List <ChiTietPN_DTO> ttctpn = new List <ChiTietPN_DTO>();
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from CHITIET_PN where MA_PN=@MaPN;";
cmd.Connection = conn;
cmd.Parameters.Add("@MaPN", SqlDbType.VarChar).Value = mapn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ChiTietPN_DTO ctpn = new ChiTietPN_DTO();
ctpn.MaPN = reader.GetString(0);
ctpn.MaHang = reader.GetString(1);
ctpn.TenHang = reader.GetString(2);
ctpn.SoLuong = reader.GetInt32(3);
ctpn.ID = reader.GetInt32(4);
ctpn.DonGiaNhap = reader.GetInt32(5);
ctpn.TongTienNhap = reader.GetInt32(6);
ttctpn.Add(ctpn);
}
if (reader != null)
{
reader.Close();
}
return(ttctpn);
}
public bool SuaChiTietPN(ChiTietPN_DTO ctpn)
{
return(ctpnDAL.SuaChiTietPN(ctpn));
}
public bool ThemChiTietPN(ChiTietPN_DTO ctpn)
{
return(ctpnDAL.ThemChiTietPN(ctpn));
}