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());
}
}