private void btSubmit_Click(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
string DateMonth = cbDate.Text.Split(' ')[1].ToString();
int DateDay = Convert.ToInt32(cbDate.Text.Split(' ')[0]);
DataSet dsReport = dba.GetDailyReport(UserID, DateMonth, DateDay);
DialogResult dResult = MessageBox.Show("Daily report is complete and I want to submit it!", "Are you sure", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
if (dResult == DialogResult.Yes)
{
if (dsReport.Tables.Count == 0 || dsReport.Tables[0].Rows.Count == 0)
{
dba.InsertDailyReport(UserID, tbReportText.Text.Replace("'", "''"), tbReportStat.Text.Replace("'", "''"), DateMonth, DateDay, 1);
}
else
{
dba.UpdateDailyReport(UserID, tbReportText.Text.Replace("'", "''"), tbReportStat.Text.Replace("'", "''"), DateMonth, DateDay, 1);
}
this.Close();
}
}
catch
{
}
}
private void cbDate_SelectedIndexChanged(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
string DateMonth = cbDate.Text.Split(' ')[1].ToString();
int DateDay = Convert.ToInt32(cbDate.Text.Split(' ')[0]);
DataSet dsReport = dba.GetDailyReport(UserID, DateMonth, DateDay);
tbReportText.Text = dsReport.Tables[0].Rows[0]["ReportText"].ToString();
tbReportStat.Text = dsReport.Tables[0].Rows[0]["ReportStats"].ToString();
if (dsReport.Tables[0].Rows[0]["Finished"].ToString() == "Yes")
{
tbReportStat.ReadOnly = true;
tbReportText.ReadOnly = true;
}
else
{
tbReportStat.ReadOnly = false;
tbReportText.ReadOnly = false;
}
}
catch
{
tbReportText.Text = "";
tbReportStat.Text = "";
tbReportStat.ReadOnly = false;
tbReportText.ReadOnly = false;
}
}
private void cbDate_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string DateMonth = cbDate.Text.Split(' ')[1].ToString();
int DateDay = Convert.ToInt32(cbDate.Text.Split(' ')[0]);
DBlayer dba = new GIM.DBlayer();
DataSet dsReport = dba.GetDailyReport(0, DateMonth, DateDay);
DataView dvReport = dsReport.Tables[0].DefaultView;
gvReports.DataSource = dvReport;
}
catch
{
}
}
private void btSave_Click(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
string DateMonth = cbDate.Text.Split(' ')[1].ToString();
int DateDay = Convert.ToInt32(cbDate.Text.Split(' ')[0]);
DataSet dsReport = dba.GetDailyReport(UserID, DateMonth, DateDay);
if (dsReport.Tables.Count == 0 || dsReport.Tables[0].Rows.Count == 0)
{
dba.InsertDailyReport(UserID, tbReportText.Text.Replace("'", "''"), tbReportStat.Text.Replace("'", "''"), DateMonth, DateDay, 0);
}
else
{
dba.UpdateDailyReport(UserID, tbReportText.Text.Replace("'", "''"), tbReportStat.Text.Replace("'", "''"), DateMonth, DateDay, 0);
}
}
catch
{
}
}
