public static void AddExpenses(ExpenseDetailEvent addExpense)
{
/* try
* {*/
string date = DateTime.Now.ToString("yyyy-MM-dd");
int eti = addExpense.ExpType.ExpTypeId;
int ei = addExpense.EventOfExp.EventId;
int p = addExpense.ProjectOfEvent.ProjectID;
double a = addExpense.Amount;
string c = addExpense.Comment;
string pt = addExpense.PaymentType;
DBConnection.updateDB("insert into exp_detail_event (exp_type_id, event_id, proj_id, amount, comment, dateOfExp, paymentType) values" +
" (" + eti + ", " + ei + " , " + p + " , " + a + " ,'" + c + "','" + date + "', '" + pt + "');");
MessageBox.Show("Expenses successfully added!");
/* }
* catch (Exception)
* {
*
* MessageBox.Show("Something went wrong!", "Add Expenses", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }*/
}
private void submitExpBtn_Click(object sender, EventArgs e)
{
ExpenseDetailEvent exp = null;
foreach (DataGridViewRow row in eventExpensesGrid.Rows)
{
int expTypeId = 0;
string expType = row.Cells[0].Value.ToString();
double amount = Double.Parse(row.Cells[2].Value.ToString());
DateTime date = Convert.ToDateTime(row.Cells[3].Value.ToString());
String iouDir = row.Cells[1].Value.ToString();
string comment = row.Cells[4].Value.ToString();
DataTable tmp = (DataTable)expTypeCmbBox.DataSource;
foreach (DataRow r in tmp.Rows)
{
if (r[1].ToString() == expType)
{
expTypeId = Int32.Parse(r[0].ToString());
}
}
exp = new ExpenseDetailEvent(new ExpenseType(expTypeId), new Event(eventId), new Project(projId), amount, date, comment, iouDir);
Database.addEventExpense(exp);
}
notifyIcon.Icon = SystemIcons.Application;
notifyIcon.BalloonTipText = "Event Expenses Successfully added!";
notifyIcon.ShowBalloonTip(200);
expTypeCmbBox.SelectedIndex = 0;
amountTxtBox.Text = "";
datePicker.Value = DateTime.Today;
commentTxtBox.Text = "";
iouRadioBtn.Checked = true;
dt.Rows.Clear();
eventExpensesGrid.DataSource = dt;
double tot = 0.0;
foreach (DataGridViewRow row in eventExpensesGrid.Rows)
{
tot += Double.Parse(row.Cells[2].Value.ToString());
}
totalExpLbl.Text = "Rs. " + tot;
}
private void btnOk_Click(object sender, EventArgs e)
{
if (Validation.isNumber(totalAmount.Text))
{
ExpenseDetailEvent ede = new ExpenseDetailEvent();
ede.PaymentType = paymentType.Text.ToString();
ede.ProjectOfEvent = new Project(pid);
ede.EventOfExp = new Event(eid);
ede.ExpType = new ExpenseType(int.Parse(expenseType.SelectedValue.ToString()));
ede.Comment = details.Text.ToString();
ede.Amount = double.Parse(totalAmount.Text.ToString());
Database.AddExpenses(ede);
}
else
{
MessageBox.Show("Invalid Number");
}
}
