public bool UpdateReceipt(ReceiveTable receive)
{
int data = 0;
string query = string.Format("USP_UpdateReceipt @id = {0}, @inputDate = N'{1}', @idReceiver = {2}, @idPayer = {3}, @idProduct = {4}, @exportProduct = {5}, @priceInDay = {6}, @describe = N'{7}', @money = {8}", receive.Id, receive.InputDate, receive.IdReceiver, receive.IdPayer, receive.IdProduct, receive.ExportProduct, receive.PriceInDay, receive.Describe, receive.Money);
data = DataProvider.Instance.ExecuteNonQuery(query);
return(data > 0);
}
public ReceiveTable GetReceiptById(int id)
{
ReceiveTable receive = new ReceiveTable();
DataTable data = DataProvider.Instance.ExecuteQuery(string.Format("USP_GetReceiptById {0}", id));
receive.Id = Int32.Parse(data.Rows[0][0].ToString());
receive.InputDate = DateTime.Parse(data.Rows[0][1].ToString());
receive.IdReceiver = Int32.Parse(data.Rows[0][2].ToString());
receive.IdPayer = Int32.Parse(data.Rows[0][3].ToString());
receive.IdProduct = Int32.Parse(data.Rows[0][4].ToString());
receive.ExportProduct = Int32.Parse(data.Rows[0][5].ToString());
receive.PriceInDay = Int32.Parse(data.Rows[0][6].ToString());
receive.Describe = data.Rows[0][7].ToString();
receive.Money = Int32.Parse(data.Rows[0][8].ToString());
return(receive);
}
private void btnUpdateReceipt_Click(object sender, EventArgs e)
{
if (isDigit(txtPriceInDayReceive.Text) == true)
{
if (isDigit(txtExportReceive.Text) == true)
{
if (txtDescribeReceive.Text.Trim() != "")
{
ReceiveTable receive = new ReceiveTable();
receive.Id = Int32.Parse(txtIdReceive.Text);
receive.InputDate = DateTime.Parse(txtInputDateReceive.Text);
receive.Describe = txtDescribeReceive.Text;
receive.IdReceiver = ReceiveDAO.Instance.GetIdReceiverByName(cbbReceiverReceive.Text);
receive.IdPayer = ReceiveDAO.Instance.GetIdPayerByName(cbbPayerReceive.Text);
receive.IdProduct = ReceiveDAO.Instance.GetIdProductByName(cbbProduct.Text);
receive.ExportProduct = float.Parse(txtExportReceive.Text);
receive.PriceInDay = Int32.Parse(txtPriceInDayReceive.Text);
receive.Money = float.Parse(txtMoneyReceive.Text);
if (ReceiveDAO.Instance.UpdateReceipt(receive) == true)
{
MessageBox.Show("Update success!"); LoadReceive();
}
else
{
MessageBox.Show("Update fail!");
}
}
else
{
MessageBox.Show("Lí Do Thu Tiền Không Được Để Trống!");
}
}
else
{
MessageBox.Show("Số Lượng Xuất (Lít) Phải Là Số!");
}
}
else
{
MessageBox.Show("Giá Trong Ngày Phải Là Số!");
}
}
