protected void btnCreate_Click(object sender, EventArgs e) { try { Int32 ItemID = Convert.ToInt32(ddlCRPRTDR.SelectedItem.Value.ToString()); bool hadincident = false; //int incidenttype = 0; bool wasrolledback = false; bool washotfixed = false; if (rbHasIncidentYes.Checked) { hadincident = true; } if (rbHasIncidentNo.Checked) { hadincident = false; } if (rbRolledBackYes.Checked) { wasrolledback = true; } if (rbRolledBackNo.Checked) { wasrolledback = false; } if (rbHotFixedYes.Checked) { washotfixed = true; } if (rbHotFixedNo.Checked) { washotfixed = false; } string incidentdescription = txtIncidentDescription.Text; string IncidentNumber = txtincidentNumber.Text; DateTime IncidentDate = DateTime.Parse(txtincidentDate.Text); int rows = SWIncidentDAL.SWIncidentInsert(ItemID, incidentdescription, IncidentNumber, IncidentDate, hadincident, wasrolledback, washotfixed); ErrorMessage = rows.ToString() + " row(s) updated"; //GetIncidentInfo(IncidentID); ResetControls(); GridView1.SelectedIndex = -1; FillData(); } catch (Exception exc) { ErrorMessage = exc.Message; } }
private void GetIncidentByIncidentID(Int32 IncidentID) { try { int ItemID = Convert.ToInt32(ddlCRPRTDR.SelectedItem.Value); ItemIncident incident = SWIncidentDAL.SWIncidentByIncidentIDGet(IncidentID); if (incident.BHasIncident.HasValue) { if (incident.BHasIncident.Value == true) { rbHasIncidentYes.Checked = true; } else { rbHasIncidentNo.Checked = true; } } if (incident.BHotfixed.HasValue) { if (incident.BHotfixed.Value == true) { rbHotFixedYes.Checked = true; } else { rbHotFixedNo.Checked = true; } } if (incident.BRolledBack.HasValue) { if (incident.BRolledBack.Value == true) { rbRolledBackYes.Checked = true; } else { rbRolledBackNo.Checked = true; } } txtIncidentDescription.Text = incident.VcDescription; if (incident.sdtIncidentDate.HasValue) { txtincidentDate.Text = incident.sdtIncidentDate.Value.ToString(); } txtincidentNumber.Text = incident.vcIncidentNumber; } catch (Exception exc) { ErrorMessage = exc.Message; } }
private void DeleteRecord(Int32 iIncidentID) { try { SWIncidentDAL.SWIncidentDelete(iIncidentID); FillData(); } catch (Exception exc) { ErrorMessage = exc.Message; } }
private void FillData() { try { int ItemID = Convert.ToInt32(ddlCRPRTDR.SelectedItem.Value); GridView1.DataSource = SWIncidentDAL.SWIncidentByItemGet(ItemID); GridView1.DataBind(); } catch (Exception exc) { ErrorMessage = exc.Message; } }
private void FetchIncidents() { GridView1.DataSource = SWIncidentDAL.SWIncidentsAllGet(); GridView1.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (GridView1.SelectedIndex < 0) { ErrorMessage = "Nothing to update"; return; } Int32 IncidentID = Convert.ToInt32(GridView1.SelectedDataKey.Value.ToString()); bool hadincident = false; int incidenttype = 0; bool wasrolledback = false; bool washotfixed = false; if (rbHasIncidentYes.Checked) { hadincident = true; } if (rbHasIncidentNo.Checked) { hadincident = false; } if (rbRolledBackYes.Checked) { wasrolledback = true; } if (rbRolledBackNo.Checked) { wasrolledback = false; } if (rbHotFixedYes.Checked) { washotfixed = true; } if (rbHotFixedNo.Checked) { washotfixed = false; } string incidentdescription = txtIncidentDescription.Text; int rows = SWIncidentDAL.SWIncidentUpdate( IncidentID, hadincident, incidentdescription, incidenttype, wasrolledback, washotfixed, txtincidentNumber.Text, Convert.ToDateTime(txtincidentDate.Text) ); ErrorMessage = rows.ToString() + " row(s) updated"; //GetIncidentInfo(IncidentID); ResetControls(); GridView1.SelectedIndex = -1; FillData(); } catch (Exception exc) { ErrorMessage = exc.Message; } }