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 { } }