private void btnUpdateContract_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("UPDATE CONTRACT STATUS TO COMPLETED?", "UPDATE CONTRACT STATUS", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialogResult == DialogResult.Yes) { if (tbEditContractNumber.Text == "" || tbEditContractName.Text == "" || tbEditContractTimePeriod.Text == "" || tbEditContractEndDate.Text == "" || tbEditContractStatus.Text == "") { MessageBox.Show("PLEASE SELECT CONTRACT TO COMPLETE FIRST", "ERROR UPDATING CONTRACT STATUS", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { string TodayDate = DateTime.Today.ToShortDateString(); string OneDayAfter = DateTime.Today.AddDays(-1).ToShortDateString(); string TwoDayAfter = DateTime.Today.AddDays(-2).ToShortDateString(); string ThreeDayAfter = DateTime.Today.AddDays(-3).ToShortDateString(); string FourDayAfter = DateTime.Today.AddDays(-4).ToShortDateString(); string FiveDayAfter = DateTime.Today.AddDays(-5).ToShortDateString(); string SixDayAfter = DateTime.Today.AddDays(-6).ToShortDateString(); string SevenDayAfter = DateTime.Today.AddDays(-7).ToShortDateString(); if(tbEditContractEndDate.Text == TodayDate || tbEditContractEndDate.Text == OneDayAfter || tbEditContractEndDate.Text == TwoDayAfter || tbEditContractEndDate.Text == ThreeDayAfter || tbEditContractEndDate.Text == FourDayAfter || tbEditContractEndDate.Text == FiveDayAfter || tbEditContractEndDate.Text == SixDayAfter || tbEditContractEndDate.Text == SevenDayAfter) { string ContractNumber = tbEditContractNumber.Text; Admin A = new Admin(); A.UpdateContractStatus(ContractNumber); MessageBox.Show("CONTRACT STATUS UPDATED", "CONTRACT DONE", MessageBoxButtons.OK, MessageBoxIcon.Information); tbEditContractNumber.Clear(); tbEditContractName.Clear(); tbEditContractTimePeriod.Clear(); tbEditContractEndDate.Clear(); tbEditContractStatus.Clear(); RefreshDG(); } else { MessageBox.Show("CONTRACT IS NOT DONE YET, CAN'T UPDATE CONTRACT STATUS", "CONTRACT STILL ONGOING", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } catch (SqlException) { MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (InvalidOperationException) { MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error); } }