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); * }*/ }