public CustomerRewardPointsHistoryUserControl() { InitializeComponent(); custTableAdapter = new JSManagementDataSetTableAdapters.CustomerTableAdapter(); custTableAdapter.Connection = CommonHelper.GetSQLConnection(); rewardPointsByCustIdTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryByCustomerIdTableAdapter(); rewardPointsByCustIdTableAdapter.Connection = CommonHelper.GetSQLConnection(); rewardPointHistoryTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryTableAdapter(); rewardPointHistoryTableAdapter.Connection = CommonHelper.GetSQLConnection(); }
private void ViewDetailReceivableFromCustomer(DataGridViewCellEventArgs e) { if (e.RowIndex == -1 || e.RowIndex == grvReceivableFromCustomer.Rows.Count - 1) { return; } DataGridViewRow row = grvReceivableFromCustomer.Rows[e.RowIndex]; int purchaseOrderId = int.Parse(row.Cells["PurchaseReceiptOrderId"].Value.ToString()); int orderId = row.Cells[0].Value == DBNull.Value?0: int.Parse(row.Cells[0].Value.ToString()); string billNumber = row.Cells[1].Value.ToString(); string orderDate = DateTime.Parse(row.Cells[2].Value.ToString()).ToShortDateString(); int storeId = LoginInfor.StoreId; lbOrderDate.Text = orderDate; lbBillNumber.Text = billNumber; lbOrder.Text = purchaseOrderId.ToString(); JSManagementDataSetTableAdapters.PurchaseReceiptOrderTableAdapter purchaseReceiptOrderTableAdapter = new JSManagementDataSetTableAdapters.PurchaseReceiptOrderTableAdapter(); purchaseReceiptOrderTableAdapter.Connection = CommonHelper.GetSQLConnection(); JSManagementDataSetTableAdapters.CustomerTableAdapter custTableAdapter = new JSManagementDataSetTableAdapters.CustomerTableAdapter(); custTableAdapter.Connection = CommonHelper.GetSQLConnection(); JSManagementDataSetTableAdapters.Orders_ProductTableAdapter order_ProductTableAdapter = new JSManagementDataSetTableAdapters.Orders_ProductTableAdapter(); order_ProductTableAdapter.Connection = CommonHelper.GetSQLConnection(); JSManagementDataSet.PurchaseReceiptOrderDataTable purchaseOrderDataTable = purchaseReceiptOrderTableAdapter.GetById(purchaseOrderId); if (purchaseOrderDataTable.Rows.Count > 0) { int custId = purchaseOrderDataTable[0].CustId; lbPurchaseReceiptOrderId.Text = purchaseOrderId.ToString(); //int custId = int.Parse(orderRow.ItemArray[2].ToString()); lbCustomerInfo.Text = string.Format("{0} / {1} / {2}", custTableAdapter.GetDataByCustomerId(custId)[0].CustomerName, custTableAdapter.GetDataByCustomerId(custId)[0].Address, custTableAdapter.GetDataByCustomerId(custId)[0].Telephone); txtNote.Text = purchaseOrderDataTable[0].OrderNote; if (purchaseOrderId > 0) { grvProductOutput.DataSource = order_ProductTableAdapter.GetOrdersByPurchaserReceivableOrderId(purchaseOrderId); } else { grvProductOutput.DataSource = order_ProductTableAdapter.GetOrderById(orderId); } } }
public CustomerForm() { InitializeComponent(); customerTableAdapter = new JSManagementDataSetTableAdapters.CustomerTableAdapter(); this.customerTableAdapter.Connection = CommonHelper.GetSQLConnection(); customerTypeTableAdapter = new JSManagementDataSetTableAdapters.CustomerTypeTableAdapter(); customerTypeTableAdapter.Connection = CommonHelper.GetSQLConnection(); rewardPointsHistoryTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryTableAdapter(); rewardPointsHistoryTableAdapter.Connection = CommonHelper.GetSQLConnection(); getProductInOutDetailTableAdapter = new JSManagementDataSetTableAdapters.GetProductInOutDetailTableAdapter(); getProductInOutDetailTableAdapter.Connection = CommonHelper.GetSQLConnection(); rewardPointsByCustIdTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryByCustomerIdTableAdapter(); rewardPointsByCustIdTableAdapter.Connection = CommonHelper.GetSQLConnection(); }
public CustomerSelectUserControl() { InitializeComponent(); custTableAdapter = new JSManagementDataSetTableAdapters.CustomerTableAdapter(); //custTableAdapter.Connection = CommonHelper.GetSQLConnection(); }