public VEE_Subform(DataGridViewRow Info, string encoder) { InitializeComponent(); this.encoder = encoder; VEE_L_User.Text = encoder; erowid = Convert.ToInt32(Info.Cells[1].Value.ToString()); VEE_TB_Row.Text = erowid.ToString(); this.VEE_But_Date.Value = DateTime.ParseExact(Info.Cells[0].Value.ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture); BalanseConn VEEConn = new BalanseConn(); DataTable branch = VEEConn.SelectQuery("SELECT BRANCH_NAME FROM BRANCH"); Dictionary <String, String> test = new Dictionary <string, string>(); int i = 0; foreach (DataRow row in branch.Rows) { test.Add(i.ToString(), row[0].ToString()); i++; } VEE_DD_Branch.DataSource = new BindingSource(test, null); VEE_DD_Branch.DisplayMember = "Value"; VEE_DD_Branch.ValueMember = "Key"; //PopulatePODGV(); PopulateExpensesTab(); }
public void PopulateDepositsTab() { BalanseConn VEDConn = new BalanseConn(); DataTable VEDSubform = VEDConn.SelectQuery(@"SELECT CASH1, CASH2, CASH3, CASH4, ENC_CHECK1, ENC_CHECK2, ENC_CHECK3, ENC_CHECK4, CHECK1,CHECK2, CHECK3, CHECK4, COMMENTS, BRANCH FROM DEPOSITS WHERE ROWID='" + drowid + "'"); foreach (DataRow row in VEDSubform.Rows) { VED_TB_Cash1.Text = row[0].ToString(); VED_TB_Cash2.Text = row[1].ToString(); VED_TB_Cash3.Text = row[2].ToString(); VED_TB_Cash4.Text = row[3].ToString(); VED_TB_Enc1.Text = row[4].ToString(); VED_TB_Enc2.Text = row[5].ToString(); VED_TB_Enc3.Text = row[6].ToString(); VED_TB_Enc4.Text = row[7].ToString(); VED_TB_Ch1.Text = row[8].ToString(); VED_TB_Ch2.Text = row[9].ToString(); VED_TB_Ch3.Text = row[10].ToString(); VED_TB_Ch4.Text = row[11].ToString(); VED_RTB_Comm.Text = row[12].ToString(); VED_DD_Branch.Text = row[13].ToString(); UpdateDepositsTotals(); } }
public void PopulateSalesTab() { BalanseConn VESConn = new BalanseConn(); DataTable VESSubform = VESConn.SelectQuery(@"SELECT TOTAL_SALES, CASH, CREDIT_CARD1, CREDIT_CARD2, CREDIT_CARD3, CREDIT_CARD4, CREDIT_CARD5, CREDIT_CARD6, CREDIT_CARD7, CREDIT_CARD8, CREDIT_CARD9, CREDIT_CARD10, GOV_CHECK, PER_CHECK, GIFT_CHECK, COUPON, TAX_CERT, PO, COMMENTS, BRANCH FROM SALES WHERE ROWID='" + srowid + "'"); foreach (DataRow row in VESSubform.Rows) { VES_TB_Total.Text = row[0].ToString(); VES_TB_Cash.Text = row[1].ToString(); VES_TB_CC1.Text = row[2].ToString(); VES_TB_CC2.Text = row[3].ToString(); VES_TB_CC3.Text = row[4].ToString(); VES_TB_CC4.Text = row[5].ToString(); VES_TB_CC5.Text = row[6].ToString(); VES_TB_CC6.Text = row[7].ToString(); VES_TB_CC7.Text = row[8].ToString(); VES_TB_CC8.Text = row[9].ToString(); VES_TB_CC9.Text = row[10].ToString(); VES_TB_CC10.Text = row[11].ToString(); VES_TB_GovCh.Text = row[12].ToString(); VES_TB_PerCh.Text = row[13].ToString(); VES_TB_GC.Text = row[14].ToString(); VES_TB_Cou.Text = row[15].ToString(); VES_TB_TaxCert.Text = row[16].ToString(); VES_TB_POTotal.Text = row[17].ToString(); VES_RTB_Comm.Text = row[18].ToString(); VES_DD_Branch.Text = row[19].ToString(); UpdateSalesTotals(); } }
public Boolean CheckPayment(int inv_no) { Boolean withPayment = true; BalanseConn VESConn = new BalanseConn(); DataTable POPayments = VESConn.SelectQuery("SELECT COUNT(*) FROM PO_PAYMENTS WHERE INVOICE_NO= '" + inv_no + "'"); if (POPayments.Rows.Count < 1) { withPayment = false; } return(withPayment); }
public void RetrievePayments(int inv_no) { BalanseConn conn = new BalanseConn(); string QueryString = "SELECT PAYMENT_TYPE, PAID_AMOUNT, PAYMENT_DATE, (CASE DEPOSIT_TAG WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END) AS DEPOSIT_TAG FROM PO_PAYMENTS WHERE INVOICE_NO =" + inv_no + ";"; DataTable dt = conn.SelectQuery(QueryString); foreach (DataRow row in dt.Rows) { dgv_PoPayments.Rows.Add( row[0].ToString(), Decimal.Parse(row[1].ToString()).ToString("#,##0.00"), DateTime.Parse(row[2].ToString()).ToString("MM/dd/yyyy"), row[3].ToString() ); } RecalculatePaymentTotals(); }
private void label1_Click(object sender, EventArgs e) { string name = L_TB_Name.Text; string pw = L_TB_Password.Text; BalanseConn L_Conn = new BalanseConn(); DataTable cred = L_Conn.SelectQuery("SELECT USER_NAME, PASSWORD FROM USERS WHERE USER_NAME=LOWER('" + name + "') AND PASSWORD=('" + pw + "')"); if (cred.Rows.Count > 0) { this.Hide(); Form_Balanse balanse = new Form_Balanse(name); balanse.Show(); } else { MessageBox.Show("Incorrect User Name and/or Password"); } }
public void PopulatePODGV() { BalanseConn VESConn = new BalanseConn(); DataTable VESSubformPO = VESConn.SelectQuery(@"SELECT ROWID, CUSTOMER_NAME, INVOICE_NO, PO_AMOUNT FROM PURCHASE_ORDERS WHERE SALES_ID= '" + srowid + "'"); this.VES_DGV_PO.DataSource = null; this.VES_DGV_PO.Rows.Clear(); foreach (DataRow arow in VESSubformPO.Rows) { string recid = arow[0].ToString(); string customername = arow[1].ToString(); int invoice = Convert.ToInt32(arow[2].ToString()); decimal po_amount = Decimal.Parse(arow[3].ToString()); VES_DGV_PO.Rows.Add( recid, customername, invoice.ToString(), po_amount.ToString("#,##0.00")); } }
public void PopulateExpensesTab() { BalanseConn VEEConn = new BalanseConn(); DataTable VEESubform = VEEConn.SelectQuery(@"SELECT PCF_1, PCF_2, PCF_3, PCF_4, WTX, REFUND, OTH_1, OTH_2, OTH_3, OTH_4, COMMENTS, BRANCH FROM EXPENSES WHERE ROWID='" + erowid + "'"); foreach (DataRow row in VEESubform.Rows) { VEE_TB_PCF1.Text = row[0].ToString(); VEE_TB_PCF2.Text = row[1].ToString(); VEE_TB_PCF3.Text = row[2].ToString(); VEE_TB_PCF4.Text = row[3].ToString(); VEE_TB_WTX.Text = row[4].ToString(); VEE_TB_Ref.Text = row[5].ToString(); VEE_TB_Oth1.Text = row[6].ToString(); VEE_TB_Oth2.Text = row[7].ToString(); VEE_TB_Oth3.Text = row[8].ToString(); VEE_TB_Oth4.Text = row[9].ToString(); VEE_RTB_Comm.Text = row[10].ToString(); VEE_DD_Branch.Text = row[11].ToString(); UpdateExpensesTotals(); } }