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