public void loadSubCategories(String categ) { MySqlDataReader rd; String serverPassqord = new implementActions().serverPassword; String serverName = new implementActions().serverName; String serveruser = new implementActions().serveruser; MySqlConnection conn; string connetionString = null; connetionString = "server='" + serverName + "';database=ledger_horanadb;uid='" + serveruser + "';pwd='" + serverPassqord + "';"; conn = new MySqlConnection(connetionString); String query; query = "SELECT * FROM ledger_horanadb.subcategories where cname = '" + categ + "'"; try { conn.Open(); MySqlCommand command = new MySqlCommand(query, conn); rd = command.ExecuteReader(); comboBox2.Items.Clear(); while (rd.Read()) { comboBox2.Items.Add(rd.GetString("sname").ToUpper()); //Console.WriteLine(rd.GetString("sname")); } comboBox2.SelectedIndex = 0; } catch (Exception e) { Console.WriteLine(e); } }
public void loadCategories() { MySqlDataReader rd; String serverPassqord = new implementActions().serverPassword; MySqlConnection conn; string connetionString = null; connetionString = "server=localhost;database=ledger_horanadb;uid=root;pwd='" + serverPassqord + "';"; conn = new MySqlConnection(connetionString); String query; query = "SELECT * FROM ledger_horanadb.categories"; try { conn.Open(); MySqlCommand command = new MySqlCommand(query, conn); rd = command.ExecuteReader(); while (rd.Read()) { comboBox1.Items.Add(rd.GetString("cname").ToUpper()); Console.WriteLine(rd.GetString("cname")); } comboBox1.SelectedIndex = 0; } catch (Exception e) { Console.WriteLine(e); } }
private void bunifuThinButton21_Click(object sender, EventArgs e) { bool status = new implementActions().addCategory(txtCategoryName.Text.ToString()); if (status == true) { MessageBox.Show("Added Succcesfully"); } else { MessageBox.Show("fail"); } }
private void bunifuThinButton21_Click(object sender, EventArgs e) { bool status = new implementActions().addSubCategory(comboBox1.SelectedItem.ToString(), txtCategoryName.Text.ToString()); if (status == true) { MessageBox.Show("successfully added"); } else { MessageBox.Show("failed"); } }
private void txtSubmit_Click(object sender, EventArgs e) { if (txtBmn.Text == "" && txtInvoiceNo.Text == "" && txtInvoiceValue.Text == "" && txtPaidAmount.Text == "") { MessageBox.Show("Please fill all fields"); } else { String category, subCategory, invoiceNo, cOrCheque, user; double invoiceValue, paidValue, igesheOld, igesheNew; int bnn; String invoiceDate; category = comboBox1.SelectedItem.ToString(); subCategory = comboBox2.SelectedItem.ToString(); invoiceNo = txtInvoiceNo.Text.ToString(); cOrCheque = bunifuDropdown3.selectedValue.ToString(); user = "******"; invoiceValue = double.Parse(txtInvoiceValue.Text); paidValue = double.Parse(txtPaidAmount.Text); invoiceDate = dateTimePicker1.Value.ToString(); var d = dateTimePicker1.Value.Date; CultureInfo cul = CultureInfo.CurrentCulture; int weekNum = cul.Calendar.GetWeekOfYear( d, CalendarWeekRule.FirstDay, DayOfWeek.Monday); int dateNum = cul.Calendar.GetDayOfYear(d); bnn = int.Parse(txtBmn.Text); String ret = new implementActions().getCreditFinal(); igesheOld = double.Parse(ret); //Console.WriteLine(ret); igesheNew = igesheOld + invoiceValue; bool status = new implementActions().addCredit(category, subCategory, invoiceNo, invoiceDate, invoiceValue, paidValue, cOrCheque, bnn, user, igesheNew, weekNum.ToString(), dateNum.ToString()); if (status == true) { MessageBox.Show("success"); } else { MessageBox.Show("failes"); } } }
private void btnLogin_Click(object sender, EventArgs e) { //new implementActions().updateDebitTotal(100); bool status = new implementActions().Login(txtUserName.Text.ToString(), txtPassword.Text.ToString()); txtUserName.Text = ""; txtPassword.Text = ""; if (status == true) { this.Hide(); } //new implementActions().checkDuePayements(); }
public void viewDailyTotal() { var d = DateTime.Now; CultureInfo cul = CultureInfo.CurrentCulture; String serverName = new implementActions().serverName; String serveruser = new implementActions().serveruser; String serverPassword = new implementActions().serverPassword; int dateNum = cul.Calendar.GetDayOfYear(d); MySqlDataReader rd; string sMonth = DateTime.Now.ToString("MM"); MySqlConnection conn; string connetionString = null; connetionString = "server='" + serverName + "';database=ledger_horanadb;uid='" + serveruser + "';pwd='" + serverPassword + "';"; conn = new MySqlConnection(connetionString); String query; query = "select * from dailyTotal where dateNo='" + dateNum + "'"; try { conn.Open(); MySqlCommand command = new MySqlCommand(query, conn); rd = command.ExecuteReader(); while (rd.Read()) { this.dt = rd["debitTotal"].ToString(); this.ct = rd["creditTotal"].ToString(); frmMain.ActiveForm.Controls["lblDebit"].Text = dt; Console.WriteLine(dt); Console.WriteLine(ct); } conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
public void deleteInvoice(String invoiceNo) { MySqlDataReader rd; String serverName = new implementActions().serverName; String serveruser = new implementActions().serveruser; String serverPassword = new implementActions().serverPassword; MySqlConnection conn; string connetionString = null; connetionString = "server='" + serverName + "';database=ledger_horanadb;uid='" + serveruser + "';pwd='" + serverPassword + "';"; conn = new MySqlConnection(connetionString); conn.Open(); try { MySqlCommand deletecmd = new MySqlCommand("delete from ledgerdebit where invoice_no = '" + invoiceNo + "'", conn); deletecmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void getInvoice(String invoiceNo) { MySqlDataReader rd; MySqlConnection conn; string connetionString = null; String serverName = new implementActions().serverName; String serveruser = new implementActions().serveruser; String serverPassword = new implementActions().serverPassword; connetionString = "server='" + serverName + "';database=ledger_horanadb;uid='" + serveruser + "';pwd='" + serverPassword + "';"; conn = new MySqlConnection(connetionString); String query; query = "select * from ledgerdebit where invoice_no='" + invoiceNo + "'"; try { conn.Open(); MySqlCommand command = new MySqlCommand(query, conn); rd = command.ExecuteReader(); while (rd.Read()) { txtBmn.Text = rd["bnn"].ToString(); bunifuMetroTextbox1.Text = rd["invoice_no"].ToString(); txtInvoiceValue.Text = rd["invoice_value"].ToString(); txtPaidAmount.Text = rd["paid_value"].ToString(); } conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
public void checkDueChequesDaily() { dataGridView1.Columns.Clear(); dataGridView1.Rows.Clear(); String serverPassword = new implementActions().serverPassword; String serverName = new implementActions().serverName; String serveruser = new implementActions().serveruser; var d = dateTimePicker1.Value; CultureInfo cul = CultureInfo.CurrentCulture; int weekNum = cul.Calendar.GetWeekOfYear( d, CalendarWeekRule.FirstDay, DayOfWeek.Monday); int dateNum = cul.Calendar.GetDayOfYear(d); MySqlDataReader rd; MySqlConnection conn; MySqlDataAdapter adapter; string connetionString = null; connetionString = "server='" + serverName + "';database=ledger_horanadb;uid='" + serveruser + "';pwd=" + serverPassword + ";;"; conn = new MySqlConnection(connetionString); String query; int count = 0; String checkNo, checkVal, bankName, invoiceNo, cod, credited, debited; Console.WriteLine("queryta kalin"); query = "select * from duecheques where dueDayNo = '" + dateNum + "' "; Console.WriteLine("queryta passe"); try { Console.WriteLine("querya thule"); conn.Open(); MySqlCommand command = new MySqlCommand(query, conn); rd = command.ExecuteReader(); dataGridView1.Columns.Add("asd", "Cheque No"); dataGridView1.Columns.Add("asd", "Cheque Amount"); dataGridView1.Columns.Add("asd", "Bank"); dataGridView1.Columns.Add("asd", "Invoice No"); dataGridView1.Columns.Add("asd", "Credit or Debit"); dataGridView1.Columns[0].Width = 160; dataGridView1.Columns[1].Width = 160; dataGridView1.Columns[2].Width = 160; dataGridView1.Columns[3].Width = 160; dataGridView1.Columns[4].Width = 160; while (rd.Read()) { Console.WriteLine("read eka athuke"); checkNo = rd["chequeNo"].ToString(); checkVal = rd["chequeValue"].ToString(); bankName = rd["bankName"].ToString(); invoiceNo = rd["invoiceId"].ToString(); credited = rd["credited"].ToString(); debited = rd["debited"].ToString(); if (debited == "") { cod = "D"; } else { cod = "C"; } count = count + 1; DataTable dt = new DataTable(); dt = (DataTable)dataGridView1.DataSource; string[] row = { checkNo, checkVal, bankName, invoiceNo, cod }; dataGridView1.Rows.Add(row); } conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }