public bool InsertContribution(ContributionVO p) { try { DataTable dt = new DataTable(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Rows.Add(new Object[] { p.ContributionID1, p.University1, p.Year1, p.Month1, p.SubDate1, p.Amount1, p.ReceiptNo1, p.OwnerID1 }); return(cd.InsertContribution(dt)); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public void UpdateContribution() { try { ContributionVO cv = new ContributionVO(Convert.ToInt32(lContributionID.Text), Convert.ToInt32(tUniversity.SelectedValue.ToString()), Convert.ToInt32(tYear.Text.ToString()), Convert.ToInt32(tMonth.Text.ToString()), Convert.ToDateTime(tSubDate.Text.ToString()), Convert.ToDouble(tAmount.Text.ToString()), tReceiptNo.Text.ToString(), tOwnerID.SelectedValue.ToString()); if (cb.EditContribution(cv)) { MessageBox.Show("Update Successful"); } else { MessageBox.Show("Update Faailed"); } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } }
private void Insert_Click(object sender, EventArgs e) { if (tPeriod.Value.Year > DateTime.Now.Year || (tPeriod.Value.Month > DateTime.Now.Month && tPeriod.Value.Year == DateTime.Now.Year)) { MessageBox.Show("Do not Enter Future Periods"); return; } ContributionVO cv = new ContributionVO(Convert.ToInt32(tContributionID.Text), Convert.ToInt32(tUniversity.SelectedValue.ToString()), Convert.ToInt32(tPeriod.Value.Year.ToString()), Convert.ToInt32(tPeriod.Value.Month.ToString()), tSubDate.Value, Convert.ToDouble(tAmount.Text), tReceiptNo.Text, tOwnerID.SelectedValue.ToString()); if (cb.InsertContribution(cv)) { MessageBox.Show("Insert Successful"); tContributionID.Clear(); tAmount.Clear(); tReceiptNo.Clear(); } else { MessageBox.Show("Record Failed"); } }
public void InsertContribution(DataTable dt, int length) { string conn = @DBStr.connectionString; MySqlConnection DBConnect = new MySqlConnection(conn); int progress = 0; try { for (int n = 0; n < length; n++) { ContributionVO cv = new ContributionVO(Convert.ToInt32(dt.Rows[n][0].ToString()), Convert.ToInt32(dt.Rows[n][1].ToString()), Convert.ToInt32(dt.Rows[n][2].ToString()), Convert.ToInt32(dt.Rows[n][3].ToString()), (Convert.ToDateTime(dt.Rows[n][4].ToString())), Convert.ToDouble(dt.Rows[n][5].ToString()), dt.Rows[n][6].ToString(), dt.Rows[n][7].ToString()); if (cb.InsertContribution(cv)) { if (cb.UpdateEntryCon(dt.Rows[n][0].ToString())) { progress = Convert.ToInt32((n + 1) * 100 / length); progressBar1.Increment(progress); } } } if (progress == 100) { MessageBox.Show("Sucessfull"); } cb.DisplayRemain(Remain); Available(); progressBar1.Value = 0; MessageBox.Show("Data inserted"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }