private void FrmHistory_Load(object sender, EventArgs e)
{
DataSet invoices = new DAO.InvoiceDAO().getAllInvoices();
dgvReport.DataSource = invoices.Tables[0];
Utility.setGridHeaderText("លេខកូដវិក្ក័យប័ត្រ|កាលបរិច្ឆេទចេញវិក្ក័យប័ត្រ|ឈ្មោះអ្នកលក់|តម្លៃសរុប", dgvReport);
Utility.setGridHeaderWidth("100|200|300|200", dgvReport);
dgvReport.Columns["id"].Visible= false;
}
private void txtInvoiceCode_Leave(object sender, EventArgs e)
{
cboOldProduct.Items.Clear();
//List Product from Invoice to Old Combo
int invoiceid = int.Parse(txtInvoiceCode.Text.Substring(9));
DTO.Invoice invoice = new DAO.InvoiceDAO().getInvoice(invoiceid);
for (int i = 0; i < invoice.InvoiceDetail.Count; i++)
{
DTO.Product product = ((DTO.InvoiceDetail)invoice.InvoiceDetail[i]).Product;
Item item = new Item(product.Productname, product.Productid);
cboOldProduct.Items.Add(item);
}
}
public FrmReport()
{
InitializeComponent();
productDAO = new DAO.ProductDAO();
invoiceDAO = new DAO.InvoiceDAO();
transactionDAO = new DAO.TransactionDAO();
memberDAO = new DAO.MemberDAO();
staffDAO = new DAO.StaffDAO();
DataSet ds = new DAO.StaffDAO().GetAllStaffs();
//DataRow dr = new DataRow("SELECT");
//ds.Tables[0].Rows.InsertAt(,0);
cboStaffs.DataSource = ds.Tables[0];
cboStaffs.DisplayMember = "staffname";
cboStaffs.ValueMember = "staffid";
//cboMember.Items.Insert(0, "-Select-");
}
private void txtInvoiceCode_Leave(object sender, EventArgs e)
{
try
{
cboOldProduct.Items.Clear();
//List Product from Invoice to Old Combo
int invoiceid = int.Parse(txtInvoiceCode.Text.Substring(2));
DTO.Invoice invoice = new DAO.InvoiceDAO().getInvoice(invoiceid);
for (int i = 0; i < invoice.InvoiceDetail.Count; i++)
{
DTO.Product product = ((DTO.InvoiceDetail)invoice.InvoiceDetail[i]).Product;
Item item = new Item(product.Productname, product.Productid);
cboOldProduct.Items.Add(item);
}
}
catch (Exception e1)
{
MessageBox.Show("សូមបំពេញពត័មានឲ្យបានត្រឺមត្រូវ");
}
}
