private void buttonUpdateProduct_Click(object sender, EventArgs e)
{
ReceiveVoucherInfo voucherInfo = new ReceiveVoucherInfo();
string idVoucher = reVoucherSelected.ID;
string idProduct, nameProduct, note;
int quantityInput, inputPrice, outputPrice, quantityOutput;
if (rowSeletedObj != null)
{
FormUpdateReceiveVoucherInfo f = new FormUpdateReceiveVoucherInfo();
//send data to form f
f.reVoucherInfoSelected = rowSeletedObj;
f.productHaveNotChosenAndThisSelectedProduct = listProductOutOfReceiveVoucher;
f.ShowDialog();
//get data update from form f
var infoAfterUpdate = f.infoUpdate;
if (infoAfterUpdate != null)
{
reVoucherInfos.Remove(rowSeletedObj);
reVoucherInfos.Add(infoAfterUpdate);
rowSeletedObj = null;
LoadDtgvVoucherInfo();
}
}
else
{
MessageBox.Show("Hãy chọn thông tin bạn muốn sửa trong bảng");
}
}
private int InsertReceiveVoucherAndInfo()
{
string idVoucher, idSupplier, idProduct, note;
int inputQuantity, inputPrice;
const int outputQuantity = 0;
DateTime inputDate;
List <ReceiveVoucherInfo> voucherInfos = new List <ReceiveVoucherInfo>();
idVoucher = comboBoxIDInputVoucher.Text;
inputDate = dateTimePickerInputDate.Value;
idSupplier = comboBoxIDSupplier.Text;
int rowAffected = 0;
if (ReceiveVoucherDAO.Instance.CheckID(idVoucher))
{
int indexLastRow = dataGridViewProduct.Rows.Count - 1;
for (int i = 0; i < indexLastRow; i++)
{
ReceiveVoucherInfo info = new ReceiveVoucherInfo();
info.IDProduct = dataGridViewProduct.Rows[i].Cells["ProductID"].Value.ToString();
info.QuantityInput = (int)dataGridViewProduct.Rows[i].Cells["quantityInput"].Value;
info.PriceInput = (int)dataGridViewProduct.Rows[i].Cells["inputPrice"].Value;
info.Note = dataGridViewProduct.Rows[i].Cells["note"].Value.ToString();
info.QuantityOutput = outputQuantity;
info.IDReceiveVoucher = idVoucher;
voucherInfos.Add(info);
}
rowAffected = ReceiveVoucherDAO.Instance.InserReceivetVoucher(idVoucher, inputDate, idSupplier, voucherInfos);
}
return(rowAffected);
}
public int RemoveByID(string idProduct, string idReceiveVoucher)
{
ReceiveVoucherInfo info = db.ReceiveVoucherInfoes.Find(idProduct, idReceiveVoucher);
db.ReceiveVoucherInfoes.Remove(info);
int rowAffected = db.SaveChanges();
return(rowAffected);
}
public int Inser(ReceiveVoucherInfo infoes)
{
int rowAffected = 0;
db.ReceiveVoucherInfoes.Add(infoes);
rowAffected = db.SaveChanges();
return(rowAffected);
}
public void UpdateQuantityOutput(string productID, string receiveVoucherID, int quantity)
{
ReceiveVoucherInfo info = db.ReceiveVoucherInfoes.Find(productID, receiveVoucherID);
if (quantity < info.QuantityInput)
{
info.QuantityOutput = quantity;
db.SaveChanges();
}
}
public void UpdateQuantityOutput(ReceiveVoucherInfo info, int quantity)
{
ReceiveVoucherInfo receiveVoucherInfo = db.ReceiveVoucherInfoes.Find(info.IDProduct, info.IDReceiveVoucher);
if (receiveVoucherInfo != null)
{
if (quantity <= info.QuantityInput)
{
info.QuantityOutput = quantity;
db.SaveChanges();
}
}
}
public ReceiveVoucherInfo dtoToEntity(ReceiveVoucherInfoDTO dto)
{
ReceiveVoucherInfo info = new ReceiveVoucherInfo();
info.IDReceiveVoucher = dto.IDReceiveVoucher;
info.IDProduct = dto.IDProduct;
info.QuantityInput = dto.QuantityInput;
info.PriceInput = dto.PriceInput;
info.QuantityOutput = dto.QuantityOutput;
info.Note = dto.Note;
return(info);
}
private void buttonOK_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Xác nhận thay đổi?", "Xác nhận", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
int rowAffected = 0;
//step1: update receive voucher
ReceiveVoucher voucherUpdate = new ReceiveVoucher();
voucherUpdate.ID = reVoucherSelected.ID;
voucherUpdate.IDSupplier = (comboBoxIDSupplier.SelectedItem as Supplier).ID;
voucherUpdate.Date = dateTimePickerInputDate.Value;
//ReceiveVoucherDAO.Instance.UpdateReceiveVoucher(voucherUpdate);
//step2: update receive voucher infomation
//step2.1: remove all product have quantityOutput = 0( not been sold)
//step2.2: if product in dtgview has been sold, the only thing we can do is update it
//step2.3: add product in dtgrview never be sold, add it to receive voucher
//add new product info have quantity output = 0
//or update if it's quantity output > 0
for (int i = 0; i < dtgvProduct.RowCount; i++)
{
ReceiveVoucherInfoDTO infoDTO = dtgvProduct.Rows[i].DataBoundItem as ReceiveVoucherInfoDTO;
ReceiveVoucherInfo voucherInfo = new ReceiveVoucherInfo();
voucherInfo.IDProduct = infoDTO.IDProduct;
voucherInfo.IDReceiveVoucher = infoDTO.IDReceiveVoucher;
voucherInfo.QuantityInput = infoDTO.QuantityInput;
voucherInfo.PriceInput = infoDTO.PriceInput;
voucherInfo.QuantityOutput = infoDTO.QuantityOutput;
voucherInfo.Note = infoDTO.Note;
voucherUpdate.ReceiveVoucherInfoes.Add(voucherInfo);
}
rowAffected = ReceiveVoucherDAO.Instance.UpdateReceiveVoucher(voucherUpdate);
if (rowAffected > 0)
{
MessageBox.Show("Cập nhật thành công");
}
else
{
MessageBox.Show("Không thành công");
}
this.Close();
}
}
public int Inser(string idProduct, string idVoucher, int quantityInput, int priceInput, int quantityOutput, string note)
{
int rowAffected = 0;
ReceiveVoucherInfo voucherInfo = new ReceiveVoucherInfo();
voucherInfo.IDProduct = idProduct;
voucherInfo.IDReceiveVoucher = idVoucher;
voucherInfo.QuantityInput = quantityInput;
voucherInfo.PriceInput = priceInput;
voucherInfo.QuantityOutput = quantityOutput;
voucherInfo.Note = note;
db.ReceiveVoucherInfoes.Add(voucherInfo);
rowAffected = db.SaveChanges();
return(rowAffected);
}
public int UpdateReceiveVoucherInfo(ReceiveVoucherInfo voucherInfo)
{
int rowAffected = 0;
string idProduct, idVoucher;
idProduct = voucherInfo.IDProduct;
idVoucher = voucherInfo.IDReceiveVoucher;
ReceiveVoucherInfo voucherInfoUpdate = db.ReceiveVoucherInfoes.Find(idProduct, idVoucher);
voucherInfoUpdate.PriceInput = voucherInfo.PriceInput;
voucherInfoUpdate.QuantityInput = voucherInfo.QuantityInput;
voucherInfoUpdate.QuantityOutput = voucherInfo.QuantityOutput;
voucherInfoUpdate.Note = voucherInfo.Note;
rowAffected = db.SaveChanges();
return(rowAffected);
}
