/// <summary>
/// Lấy danh sách Hóa đơn bán hàng theo Khóa phụ
/// </summary>
/// <param name="FK_iNhanvienID">Mã nhân viên</param>
/// <returns>List<tblHoadonbanhang></returns>
public List <tblHoadonbanhang> tblHoadonbanhang_SelectByFK(int FK_iNhanvienID)
{
List <tblHoadonbanhang> listHoadonbanhang = new List <tblHoadonbanhang>();
using (SqlConnection cnn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("sp_tblHoadonbanhang_SelectByFK", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iHoadonbanhangID", FK_iNhanvienID);
cnn.Open();
using (SqlDataReader rd = cmd.ExecuteReader())
{
if (rd.HasRows)
{
while (rd.Read())
{
tblHoadonbanhang hoadon = new tblHoadonbanhang();
hoadon.PK_iHoadonbanhangID = Convert.ToInt32(rd["PK_iHoadonbanhangID"].ToString());
hoadon.FK_iNhanvienID = Convert.ToInt32(rd["FK_iNhanvienID"].ToString());
hoadon.sTenKhachhang = rd["sTenKhachhang"].ToString();
hoadon.sDiachi = rd["sDiachi"].ToString();
hoadon.sSdt = rd["sSdt"].ToString();
hoadon.dThoigianban = Convert.ToDateTime(rd["dThoigianban"].ToString());
hoadon.iTongtien = Convert.ToInt32(rd["iTongtien"].ToString());
listHoadonbanhang.Add(hoadon);
}
rd.Close();
}
cnn.Close();
return(listHoadonbanhang);
}
}
}
}
private void buttonTao_Click(object sender, EventArgs e)
{
tblHoadonbanhang hoadonban = new tblHoadonbanhang();
hoadonban.FK_iNhanvienID = Convert.ToInt32(txtNhanvienID.Text.Trim());
hoadonban.sTenKhachhang = txtTenKhachhang.Text.Trim();
hoadonban.sDiachi = txtDiachi.Text.Trim();
hoadonban.sSdt = txtSdt.Text.Trim();
hoadonban.dThoigianban = DateTime.Today;
hoadonban.iTongtien = Convert.ToInt32(txtTongtien.Text.Trim());
if (Mahoadon == 0)
{
hoadonban.PK_iHoadonbanhangID = new XuLy_tblHoadonbanhang().tblHoadonbanhang_Insert(hoadonban);
foreach (DataRow r in table.Rows)
{
tblHangban h = new tblHangban();
h.iHoadonbanhangID = hoadonban.PK_iHoadonbanhangID;
h.iHanghoaID = Convert.ToInt32(r["iHanghoaID"]);
h.iSoluongban = Convert.ToInt32(r["iSoluongban"]);
h.iGiaban = Convert.ToInt32(r["iDongia"]);
h.iThanhtien = Convert.ToInt32(r["iThanhtien"]);
new XuLy_tblHangban().tblHangban_Insert(h);
}
MessageBox.Show("Tạo thành công!");
}
else
{
hoadonban.PK_iHoadonbanhangID = Mahoadon;
new XuLy_tblHoadonbanhang().tblHoadonbanhang_Update(hoadonban);
List <tblHangban> listHangban = new XuLy_tblHangban().tblHangban_Select(Mahoadon, 0);
foreach (tblHangban hb in listHangban)
{
new XuLy_tblHangban().tblHangban_Delete(Mahoadon, hb.iHanghoaID);
}
//new XuLy_tblHangban().tblHangban_Delete(hoadonban.PK_iHoadonbanhangID, 0);
foreach (DataRow r in table.Rows)
{
tblHangban h = new tblHangban();
h.iHoadonbanhangID = hoadonban.PK_iHoadonbanhangID;
h.iHanghoaID = Convert.ToInt32(r["iHanghoaID"]);
h.iSoluongban = Convert.ToInt32(r["iSoluongban"]);
h.iGiaban = Convert.ToInt32(r["iDongia"]);
h.iThanhtien = Convert.ToInt32(r["iThanhtien"]);
new XuLy_tblHangban().tblHangban_Insert(h);
}
MessageBox.Show("Sửa thành công.");
this.Close();
}
buttonBoqua_Click(sender, e);
}
/// <summary>
/// Cập nhật Hóa đơn bán hàng theo PK_iHoadonbanhangID
/// </summary>
/// <param name="hoadon">tblHoadonbanhang</param>
/// <returns>bool</returns>
public bool tblHoadonbanhang_Update(tblHoadonbanhang hoadon)
{
using (SqlConnection cnn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("sp_tblHoadonbanhang_Update", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iHoadonbanhangID", hoadon.PK_iHoadonbanhangID);
cmd.Parameters.AddWithValue("@FK_iNhanvienID", hoadon.FK_iNhanvienID);
cmd.Parameters.AddWithValue("@sTenKhachhang", hoadon.sTenKhachhang);
cmd.Parameters.AddWithValue("@sDiachi", hoadon.sDiachi);
cmd.Parameters.AddWithValue("@sSdt", hoadon.sSdt);
cmd.Parameters.AddWithValue("@dThoigianban", hoadon.dThoigianban);
cmd.Parameters.AddWithValue("@iTongtien", hoadon.iTongtien);
cnn.Open();
int i = cmd.ExecuteNonQuery();
cnn.Close();
return(i > 0);
}
}
}
/// <summary>
/// Thêm Hóa đơn bán hàng
/// </summary>
/// <param name="hoadon">tblHoadonbanhang</param>
/// <returns>int</returns>
public int tblHoadonbanhang_Insert(tblHoadonbanhang hoadon)
{
using (SqlConnection cnn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("sp_tblHoadonbanhang_Insert", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PK_iHoadonbanhangID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@FK_iNhanvienID", hoadon.FK_iNhanvienID);
cmd.Parameters.AddWithValue("@sTenKhachhang", hoadon.sTenKhachhang);
cmd.Parameters.AddWithValue("@sDiachi", hoadon.sDiachi);
cmd.Parameters.AddWithValue("@sSdt", hoadon.sSdt);
cmd.Parameters.AddWithValue("@dThoigianban", hoadon.dThoigianban);
cmd.Parameters.AddWithValue("@iTongtien", hoadon.iTongtien);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
return(Convert.ToInt32(cmd.Parameters["@PK_iHoadonbanhangID"].Value));
}
}
}
