private void btnThem_Click(object sender, EventArgs e)
{
List <DtoWarehouseBillDetail> list = new List <DtoWarehouseBillDetail>();
DtoWarehouseBill warehouseBill = new DtoWarehouseBill();
warehouseBill.MaPhieuNhapKho = txtMaPhieuNhapKho.Text;
warehouseBill.NgayLapPhieu = DateTime.Now;
warehouseBill.MaNguoiLapPhieu = nguoiLapPhieuComboBox.SelectedValue.ToString();
warehouseBill.GhiChu = txtGhiChu.Text;
for (int i = 0; i < dgvDetailWarehouseBill.Rows.Count - 1; i++)
{
DtoWarehouseBillDetail detail = new DtoWarehouseBillDetail();
detail.MaChiTietPhieuNhapKho = dgvDetailWarehouseBill.Rows[i].Cells[0].Value.ToString();
detail.MaPhieuNhapKho = warehouseBill.MaPhieuNhapKho;
detail.MaSanPham = dgvDetailWarehouseBill.Rows[i].Cells[1].Value.ToString();
detail.SoLuong = int.Parse(dgvDetailWarehouseBill.Rows[i].Cells[3].Value.ToString());
detail.GhiChu = dgvDetailWarehouseBill.Rows[i].Cells[4].Value.ToString();
list.Add(detail);
}
if (_bllWarehouseBill.AddWarehouseBillTran(warehouseBill, list))
{
MessageBox.Show(Constants.MsgNotificationSuccessfuly);
btnThoat.PerformClick();
}
else
{
MessageBox.Show(Constants.MsgExceptionError);
}
}
public int AddWarehouseBillTran(DtoWarehouseBill warehouseBill, List <DtoWarehouseBillDetail> list)
{
SqlConnection con = new SqlConnection(Constants.ConnectionString);
con.Open();
SqlTransaction tran = con.BeginTransaction();
try
{
SqlParameter[] para =
{
new SqlParameter("@MaPhieuNhapKho", warehouseBill.MaPhieuNhapKho),
new SqlParameter("@NgayLapPhieu", warehouseBill.NgayLapPhieu),
new SqlParameter("@MaNguoiLapPhieu", warehouseBill.MaNguoiLapPhieu),
new SqlParameter("@GhiChu", warehouseBill.GhiChu),
};
SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "AddWarehouseBill", para);
foreach (DtoWarehouseBillDetail detail in list)
{
SqlParameter[] para1 =
{
new SqlParameter("@MaChiTietPhieuNhapKho", detail.MaChiTietPhieuNhapKho),
new SqlParameter("@MaPhieuNhapKho", detail.MaPhieuNhapKho),
new SqlParameter("@MaSanPham", detail.MaSanPham),
new SqlParameter("@SoLuong", detail.SoLuong),
new SqlParameter("@GhiChu", detail.GhiChu),
};
SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure,
"AddWarehouseBillDetail",
para1);
SqlParameter[] para2 =
{
new SqlParameter("@MaSanPham", detail.MaSanPham),
new SqlParameter("@SoLuong", detail.SoLuong),
};
SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "UpdateCountProduct", para2);
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return(0);
}
return(1);
}
public int AddWarehouseBill(DtoWarehouseBill data)
{
SqlParameter[] para =
{
new SqlParameter("@MaPhieuNhapKho", data.MaPhieuNhapKho),
new SqlParameter("@NgayLapPhieu", data.NgayLapPhieu),
new SqlParameter("@MaNguoLapPhieu", data.MaNguoiLapPhieu),
new SqlParameter("@GhiChu", data.GhiChu),
};
try
{
return(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure,
"AddWarehouseBill",
para));
}
catch (SqlException)
{
throw new ArgumentException(Constants.MsgExceptionSql);
}
catch (Exception)
{
throw new AggregateException(Constants.MsgExceptionError);
}
}
public bool AddWarehouseBillTran(DtoWarehouseBill warehouseBill, List <DtoWarehouseBillDetail> list)
{
return(_dalWarehouseBill.AddWarehouseBillTran(warehouseBill, list) == 0 ? false : true);
}
