private void metroButton1_Click(object sender, EventArgs e)
{
ExpenseDetailSchedule ed = new ExpenseDetailSchedule();
ed.ScheduleOfExp = new Schedule(int.Parse(scheduleId.Text.ToString()));
ed.ProjectOfSchedule = new Project(int.Parse(projectIdBox.SelectedValue.ToString()));
if (Validation.isNumber(amountTxtBox.Text))
{
ed.Amount = float.Parse(amountTxtBox.Text);
ed.Comment = details.Text.ToString();
Database.CashIssue(ed);
}
else
{
MessageBox.Show("Invalid Number");
}
}
public static void CashIssue(ExpenseDetailSchedule cashIssue)
{
/* try
* {
*/string date = DateTime.Now.ToString("yyyy-MM-dd");
int e = cashIssue.ScheduleOfExp.ScheduleId;
int p = cashIssue.ProjectOfSchedule.ProjectID;
double a = cashIssue.Amount;
string c = cashIssue.Comment;
DBConnection.updateDB("insert into iou ( proj_id, sch_no , date,amount , detail) values" + "(" + e + " , " + p + " ,'" + date + "', " + a + " , '" + c + "');");
MessageBox.Show("Expenses successfully added!");
/* }
* catch (Exception)
* {
* MessageBox.Show("Something went wrong!", "Add Expenses", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }*/
}
