private void btnThem_Click(object sender, EventArgs e)
{
try
{
idKho = (int)cbKhoNhanVatTu.SelectedValue;
}
catch (Exception ex)
{
MessageBox.Show("Bạn chưa chọn kho ");
}
//progressAll.Maximum = gridDanhSachPhieuNhap.Rows.Count;
//backgroundWorker1.RunWorkerAsync();
try
{
Int32 selectedRowCount = gridDanhSachPhieuNhap.CurrentCell.RowIndex;
DataGridViewRow SelectedRow = gridDanhSachPhieuNhap.Rows[selectedRowCount];
string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString();
string maphieu = SelectedRow.Cells["Ma_phieu_nhap"].Value.ToString();
if (cbKhoNhanVatTu.Text == "")
{
MessageBox.Show("Bạn chưa chọn kho để phân vật tư");
return;
}
// string soluong = SelectedRow.Cells["So_luong"].Value.ToString();
string tenvt = SelectedRow.Cells["Ten_vat_tu"].Value.ToString();
string tenkho = cbKhoNhanVatTu.Text;
decimal soluong = decimal.Parse(SelectedRow.Cells["So_luong_thuc_lanh"].Value.ToString());
// string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString();
int idcl = int.Parse(SelectedRow.Cells["ID_chat_luong"].Value.ToString());
frmChiTietNhanVatTu ob = new frmChiTietNhanVatTu(this, maphieu, mavt, idKho, soluong, tenvt, tenkho, idcl);
ob.Show(); //show child
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void InProgress()
{
if (chbChonTatCa.Checked == false)
{
try
{
Int32 selectedRowCount = gridDanhSachPhieuNhap.CurrentCell.RowIndex;
DataGridViewRow SelectedRow = gridDanhSachPhieuNhap.Rows[selectedRowCount];
string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString();
string maphieu = SelectedRow.Cells["Ma_phieu_nhap"].Value.ToString();
if (cbKhoNhanVatTu.Text == "")
{
MessageBox.Show("Bạn chưa chọn kho để phân vật tư");
return;
}
// string soluong = SelectedRow.Cells["So_luong"].Value.ToString();
string tenvt = SelectedRow.Cells["Ten_vat_tu"].Value.ToString();
string tenkho = cbKhoNhanVatTu.Text;
decimal soluong = decimal.Parse(SelectedRow.Cells["So_luong_thuc_lanh"].Value.ToString());
// string mavt = SelectedRow.Cells["Ma_vat_tu"].Value.ToString();
int idcl = int.Parse(SelectedRow.Cells["ID_chat_luong"].Value.ToString());
frmChiTietNhanVatTu ob = new frmChiTietNhanVatTu(this, maphieu, mavt, idKho, soluong, tenvt, tenkho, idcl);
ob.Show(); //show child
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
//txtRunning.Visible = true;
//progressAll.Visible = true;
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
for (int i = 0; i < gridDanhSachPhieuNhap.Rows.Count; i++)
{
string mavt = gridDanhSachPhieuNhap.Rows[i].Cells["Ma_vat_tu"].Value.ToString();
string maphieu = gridDanhSachPhieuNhap.Rows[i].Cells["Ma_phieu_nhap"].Value.ToString();
string tenvt = gridDanhSachPhieuNhap.Rows[i].Cells["Ten_vat_tu"].Value.ToString();
// string tenkho = cbKhoNhanVatTu.Text;
decimal soluong = decimal.Parse(gridDanhSachPhieuNhap.Rows[i].Cells["So_luong_thuc_lanh"].Value.ToString());
int idcl = int.Parse(gridDanhSachPhieuNhap.Rows[i].Cells["ID_chat_luong"].Value.ToString());
clsXuLyDuLieuChung dc = new clsXuLyDuLieuChung();
DateTime ngayNhap = DateTime.Now;
try
{
if (dc.InsertTonKho(help, mavt, idKho, soluong, maphieu, ngayNhap, idcl,true) == 0)
{
dbcxtransaction.Rollback();
MessageBox.Show("Thêm thất bại tại dòng " + i);
return;
}
}
catch (Exception ex)
{
dbcxtransaction.Rollback();
MessageBox.Show("Thêm thất bại tại dòng " + i);
return;
}
//dbcxtransaction.Commit();
backgroundWorker1.ReportProgress(i);
}
dbcxtransaction.Commit();
}
}
}
