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 btSave_Click(object sender, EventArgs e)
{
if (tbCloseText.Text == "")
{
MessageBox.Show("Please insert closing comment!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
string DateActualEnd = dtActualEnd.Value.ToString("yyyy-MM-dd");
if (cbH.Text != "" && cbM.Text != "")
{
DateActualEnd = DateActualEnd + " " + cbH.Text + ":" + cbM.Text;
}
DBlayer dba = new GIM.DBlayer();
dba.UpdateStatus(IssueID, DateActualEnd);
dba.InsertUpdate(IssueID, UserID, Environment.UserName, "The issue is now CLOSED -- " + tbCloseText.Text, "", "");
MessageBox.Show("You have successfully closed the issue!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
catch
{
}
}
}
private void SignIn_Load(object sender, EventArgs e)
{
try
{
DBlayer dba = new GIM.DBlayer();
if (dba.IsServerConnected() == false)
{
MessageBox.Show("Please check your connection!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet dsUser = dba.GetUsers(0);
DataRow rCT = dsUser.Tables[0].NewRow();
rCT["ID"] = 0;
rCT["Ucode"] = "Select";
dsUser.Tables[0].Rows.Add(rCT);
DataView dvFunc = new DataView(dsUser.Tables[0], "", "ID", DataViewRowState.CurrentRows);
cbUsers.DataSource = dvFunc;
cbUsers.DisplayMember = "Ucode";
cbUsers.ValueMember = "ID";
}
catch
{
}
}
private void btClose_Click(object sender, EventArgs e)
{
try
{
DBlayer dba = new GIM.DBlayer();
dba.UpdateStatus(IssueID, "");
this.Close();
}
catch { }
}
private void btDelete_Click(object sender, EventArgs e)
{
try
{
DBlayer dba = new GIM.DBlayer();
dba.DeleteComment(UpdateID);
this.Close();
}
catch { }
}
private void btSave_Click(object sender, EventArgs e)
{
try
{
DBlayer dba = new GIM.DBlayer();
dba.UpdateComment(UpdateID, tbUpdate.Text, tbAttachment.Text);
this.Close();
}
catch { }
}
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 gvUpdates_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
IssueUpdate frm = new IssueUpdate(UserID, Convert.ToInt32(gvUpdates.SelectedRows[0].Cells[0].Value));
frm.ShowDialog();
try
{
DBlayer dba = new GIM.DBlayer();
DataSet dsUpdates = dba.GetUpdates(IssueID);
DataView dvUpdates = dsUpdates.Tables[0].DefaultView;
gvUpdates.DataSource = dvUpdates;
}
catch { }
}
private void btSubmitUpdate_Click(object sender, EventArgs e)
{
try
{
DBlayer dba = new GIM.DBlayer();
dba.InsertUpdate(IssueID, UserID, Environment.UserName, tbUpdate.Text.Replace("'", "''"), "", tbAttachment.Text);
tbUpdate.Text = "";
tbAttachment.Text = "";
DataSet dsUpdates = dba.GetUpdates(IssueID);
DataView dvUpdates = dsUpdates.Tables[0].DefaultView;
gvUpdates.DataSource = dvUpdates;
}
catch { }
}
private void btSave_Click(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
if (tbPass.Text == tbPass2.Text)
{
dba.UpdateUserPassword(UserID, tbPass.Text);
MessageBox.Show("You have successfully updated the password!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
else
{
MessageBox.Show("The passwords are not matching. Please check!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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
{
}
}
private void IssueUpdate_Load(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
DataSet dUpdate = dba.GetTable("GIMupdateLog", UpdateID);
lbUpdateDate.Text += " " + dUpdate.Tables[0].Rows[0]["DateUpdate"].ToString();
lbUpdatedBy.Text += " " + dUpdate.Tables[0].Rows[0]["Creator"].ToString();
tbUpdate.Text = dUpdate.Tables[0].Rows[0]["UpdateContext"].ToString();
tbAttachment.Text = dUpdate.Tables[0].Rows[0]["FileUploaded"].ToString();
if (UserID == 1 || UserID == Convert.ToInt32(dUpdate.Tables[0].Rows[0]["UpdatedBy"]))
{
btDelete.Enabled = true;
}
else
{
btDelete.Enabled = false;
}
}
catch { }
}
private void btSave_Click(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
string ImpactedFuncs = "";
string ImpactedVenues = "";
string DateOccurence = "";
if (IssueID == 0)
{
foreach (object itemChecked in clbImpactedFuncs.CheckedItems)
{
DataRowView castedItem = itemChecked as DataRowView;
ImpactedFuncs += castedItem["ID"].ToString() + ",";
}
foreach (object itemChecked in clbImpactedVenues.CheckedItems)
{
DataRowView castedItem = itemChecked as DataRowView;
ImpactedVenues += castedItem["ID"].ToString() + ",";
}
DateOccurence = dtOccurence.Value.ToString("yyyy-MM-dd");
if (cbHour.Text != "" && cbMins.Text != "")
{
DateOccurence = DateOccurence + " " + cbHour.Text + ":" + cbMins.Text;
}
try
{
dba.InsertIssue(2, tbTitle.Text, -1, -1, UserID, tbDesc.Text.Replace("'", "''"), Convert.ToInt32(cbLeadFunc.SelectedValue),
ImpactedFuncs, Convert.ToInt32(cbLocation.SelectedValue), ImpactedVenues, DateOccurence, "", "", 0, 0, Environment.UserName.Replace("'", "''"), " ", tbLocationDesc.Text.Replace("'", "''"));
MessageBox.Show("You have successfully created a log!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
catch
{
MessageBox.Show("Something went wrong. Please check the data that you have inserted, if everything seems ok please check your network connection!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (IssueID > 0)
{
foreach (object itemChecked in clbImpactedFuncs.CheckedItems)
{
DataRowView castedItem = itemChecked as DataRowView;
ImpactedFuncs += castedItem["ID"].ToString() + ",";
}
foreach (object itemChecked in clbImpactedVenues.CheckedItems)
{
DataRowView castedItem = itemChecked as DataRowView;
ImpactedVenues += castedItem["ID"].ToString() + ",";
}
DateOccurence = dtOccurence.Value.ToString("yyyy-MM-dd");
if (cbHour.Text != "" && cbMins.Text != "")
{
DateOccurence = DateOccurence + " " + cbHour.Text + ":" + cbMins.Text;
}
int Reportable = 0;
if (chReportable.Checked)
{
Reportable = 1;
}
try
{
dba.UpdateIssueDetails(IssueID, 2, tbTitle.Text.Replace("'", "''"), -1, -1, UserID, tbDesc.Text.Replace("'", "''"), Convert.ToInt32(cbLeadFunc.SelectedValue),
ImpactedFuncs, Convert.ToInt32(cbLocation.SelectedValue), ImpactedVenues, DateOccurence, "", tbLocationDesc.Text.Replace("'", "''"), 0, Reportable);
MessageBox.Show("You have successfully updated the log!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
catch
{
MessageBox.Show("Something went wrong. Please check the data that you have inserted, if everything seems ok please check your network connection!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void AddLog_Load(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
DataSet dsFuncs = dba.GetTable("GIMfunc", 0);
DataView dvFuncs = new DataView(dsFuncs.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
clbImpactedFuncs.DataSource = dvFuncs;
clbImpactedFuncs.DisplayMember = "FuncCode";
clbImpactedFuncs.ValueMember = "ID";
DataSet dsLead = dba.GetTable("GIMfunc", 0);
DataView dvLead = new DataView(dsLead.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
cbLeadFunc.DataSource = dvLead;
cbLeadFunc.DisplayMember = "FuncCode";
cbLeadFunc.ValueMember = "ID";
DataSet dsVenues = dba.GetTable("GIMvenue", 0);
DataView dvVenues = new DataView(dsVenues.Tables[0], "", "VenueCode", DataViewRowState.CurrentRows);
clbImpactedVenues.DataSource = dvVenues;
clbImpactedVenues.DisplayMember = "VenueCode";
clbImpactedVenues.ValueMember = "ID";
DataSet dsLocation = dba.GetTable("GIMvenue", 0);
DataRow rCT = dsLocation.Tables[0].NewRow();
rCT["ID"] = 0;
rCT["VenueCode"] = "";
dsLocation.Tables[0].Rows.Add(rCT);
DataView dvLocation = new DataView(dsLocation.Tables[0], "", "VenueCode", DataViewRowState.CurrentRows);
cbLocation.DataSource = dvLocation;
cbLocation.DisplayMember = "VenueCode";
cbLocation.ValueMember = "ID";
DataSet dsUsers = dba.GetTable("GIMusers", UserID);
lblRaisedBy.Text = "Creator: " + dsUsers.Tables[0].Rows[0]["Ucode"].ToString() + " (" + Environment.UserName + ")";
btSave.Visible = true;
if (UserID != 1)
{
chReportable.Visible = false;
}
if (IssueID > 0)
{
this.Text = "Edit Log";
groupBox1.Text = "Edit";
DataSet dsIssue = dba.GetTable("GIMissue", IssueID);
tbTitle.Text = dsIssue.Tables[0].Rows[0]["Title"].ToString();
tbDesc.Text = dsIssue.Tables[0].Rows[0]["Description"].ToString();
cbLocation.SelectedValue = dsIssue.Tables[0].Rows[0]["Location"];
tbLocationDesc.Text = dsIssue.Tables[0].Rows[0]["LocationDesc"].ToString();
cbLeadFunc.SelectedValue = dsIssue.Tables[0].Rows[0]["LeadFunction"];
if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Reportable"]) == 1)
{
chReportable.Checked = true;
}
dsUsers = dba.GetTable("GIMusers", Convert.ToInt32(dsIssue.Tables[0].Rows[0]["RaisedBy"]));
lblRaisedBy.Text = "Created by: " + dsUsers.Tables[0].Rows[0]["Ucode"].ToString() + " (" + dsIssue.Tables[0].Rows[0]["Creator"].ToString() + ")";
DateTime dtOcc = Convert.ToDateTime(dsIssue.Tables[0].Rows[0]["DateOccurence"].ToString());
dtOccurence.Value = dtOcc.Date;
cbHour.Text = dtOcc.Hour.ToString();
cbMins.Text = dtOcc.Minute.ToString();
DataSet impFuncs = dba.GetIssueImpcFuncs(IssueID);
if (UserID == 1 || Convert.ToInt32(dsIssue.Tables[0].Rows[0]["RaisedBy"]) == UserID)
{
btSave.Visible = true;
btClose.Visible = true;
}
else
{
btSave.Visible = false;
btClose.Visible = false;
}
int i = 0, j = 0;
for (; i < clbImpactedFuncs.Items.Count; i++)
{
for (j = 0; j < impFuncs.Tables[0].Rows.Count; j++)
{
if (((System.Data.DataRowView)(clbImpactedFuncs.Items[i])).Row.ItemArray[0].ToString() == impFuncs.Tables[0].Rows[j]["ID"].ToString())
{
clbImpactedFuncs.SetItemCheckState(i, CheckState.Checked);
}
}
}
DataSet impVenues = dba.GetIssueImpcVenues(IssueID);
for (i = 0; i < clbImpactedVenues.Items.Count; i++)
{
for (j = 0; j < impVenues.Tables[0].Rows.Count; j++)
{
if (((System.Data.DataRowView)(clbImpactedVenues.Items[i])).Row.ItemArray[0].ToString() == impVenues.Tables[0].Rows[j]["VenueID"].ToString())
{
clbImpactedVenues.SetItemCheckState(i, CheckState.Checked);
}
}
}
}
}
catch
{
}
}
private void AddIssue_Load(object sender, EventArgs e)
{
DBlayer dba = new GIM.DBlayer();
try
{
DataSet dsSeverity = dba.GetTable("GIMSeverity", 0);
DataView dvSeverity = new DataView(dsSeverity.Tables[0], "", "ID", DataViewRowState.CurrentRows);
cbSeverity.DataSource = dvSeverity;
cbSeverity.DisplayMember = "SeverityName";
cbSeverity.ValueMember = "ID";
DataSet dsFuncs = dba.GetTable("GIMfunc", 0);
DataView dvFuncs = new DataView(dsFuncs.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
clbImpactedFuncs.DataSource = dvFuncs;
clbImpactedFuncs.DisplayMember = "FuncCode";
clbImpactedFuncs.ValueMember = "ID";
DataSet dsLead = dba.GetTable("GIMfunc", 0);
DataRow rLead = dsLead.Tables[0].NewRow();
rLead["ID"] = 0;
rLead["FuncCode"] = "";
dsLead.Tables[0].Rows.Add(rLead);
DataView dvLead = new DataView(dsLead.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
cbLeadFunc.DataSource = dvLead;
cbLeadFunc.DisplayMember = "FuncCode";
cbLeadFunc.ValueMember = "ID";
DataSet dsVenues = dba.GetTable("GIMvenue", 0);
DataView dvVenues = new DataView(dsVenues.Tables[0], "", "VenueCode", DataViewRowState.CurrentRows);
clbImpactedVenues.DataSource = dvVenues;
clbImpactedVenues.DisplayMember = "VenueCode";
clbImpactedVenues.ValueMember = "ID";
DataSet dsLocation = dba.GetTable("GIMvenue", 0);
DataRow rCT = dsLocation.Tables[0].NewRow();
rCT["ID"] = 0;
rCT["VenueCode"] = "";
dsLocation.Tables[0].Rows.Add(rCT);
DataView dvLocation = new DataView(dsLocation.Tables[0], "", "VenueCode", DataViewRowState.CurrentRows);
cbLocation.DataSource = dvLocation;
cbLocation.DisplayMember = "VenueCode";
cbLocation.ValueMember = "ID";
if (UserID != 1)
{
chReportable.Visible = false;
chDashboard.Visible = false;
}
tbStatus.Visible = true;
if (IssueID > 0)
{
this.Text = "Edit Issue";
groupBox1.Text = "Edit";
cbStatus.Visible = true;
tbStatus.Visible = false;
DataSet dsStatus = dba.GetStatus(0);
DataView dvStatus = new DataView(dsStatus.Tables[0], "", "ID", DataViewRowState.CurrentRows);
cbStatus.DataSource = dvStatus;
cbStatus.DisplayMember = "StatusName";
cbStatus.ValueMember = "ID";
DataSet dsIssue = dba.GetTable("GIMissue", IssueID);
tbTitle.Text = dsIssue.Tables[0].Rows[0]["Title"].ToString();
tbDesc.Text = dsIssue.Tables[0].Rows[0]["Description"].ToString();
cbLocation.SelectedValue = dsIssue.Tables[0].Rows[0]["Location"];
cbSeverity.SelectedValue = dsIssue.Tables[0].Rows[0]["IssueSeverity"];
if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["IssueStatus"]) < 4)
{
cbStatus.SelectedValue = dsIssue.Tables[0].Rows[0]["IssueStatus"];
}
else if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["IssueStatus"]) == 4)
{
cbStatus.Text = "Closed";
}
tbLocationDesc.Text = dsIssue.Tables[0].Rows[0]["LocationDesc"].ToString();
cbLeadFunc.SelectedValue = dsIssue.Tables[0].Rows[0]["LeadFunction"];
tbAttachment.Text = dsIssue.Tables[0].Rows[0]["Attachment"].ToString();
if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Dashboard"]) == 1)
{
chDashboard.Checked = true;
}
if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Reportable"]) == 1)
{
chReportable.Checked = true;
}
DateTime dtOcc = Convert.ToDateTime(dsIssue.Tables[0].Rows[0]["DateOccurence"].ToString());
dtOccurence.Value = dtOcc.Date;
cbHour.Text = dtOcc.Hour.ToString();
cbMins.Text = dtOcc.Minute.ToString();
DataSet impFuncs = dba.GetIssueImpcFuncs(IssueID);
int i = 0, j = 0;
for (; i < clbImpactedFuncs.Items.Count; i++)
{
for (j = 0; j < impFuncs.Tables[0].Rows.Count; j++)
{
if (((System.Data.DataRowView)(clbImpactedFuncs.Items[i])).Row.ItemArray[0].ToString() == impFuncs.Tables[0].Rows[j]["ID"].ToString())
{
clbImpactedFuncs.SetItemCheckState(i, CheckState.Checked);
}
}
}
DataSet impVenues = dba.GetIssueImpcVenues(IssueID);
for (i = 0; i < clbImpactedVenues.Items.Count; i++)
{
for (j = 0; j < impVenues.Tables[0].Rows.Count; j++)
{
if (((System.Data.DataRowView)(clbImpactedVenues.Items[i])).Row.ItemArray[0].ToString() == impVenues.Tables[0].Rows[j]["VenueID"].ToString())
{
clbImpactedVenues.SetItemCheckState(i, CheckState.Checked);
}
}
}
}
}
catch
{
}
}
