public static ItemIncident SWIncidentByIncidentIDGet(int IncidentID) { ItemIncident incident = new ItemIncident(); try { DbCommand dbcmd = mDatabase.GetStoredProcCommand("uspSWIncidentByIncidentIDGet"); mDatabase.AddInParameter(dbcmd, "@iIncidentID", DbType.Int32, IncidentID); IDataReader reader = mDatabase.ExecuteReader(dbcmd); if (reader.Read()) { incident.IIncidentID = reader["IIncidentID"] == DBNull.Value ? -1 : (int)reader["IIncidentID"]; incident.IItemID = reader["IItemID"] == DBNull.Value ? -1 : (int)reader["IItemID"]; incident.VcCRFNumber = reader["vcCRFNumber"] == DBNull.Value ? "" : (string)reader["vcCRFNumber"]; incident.VcCRPRTDR = reader["vcCRPRTDR"] == DBNull.Value ? "" : (string)reader["vcCRPRTDR"]; incident.VcDescription = reader["vcDescription"] == DBNull.Value ? "" : (string)reader["vcDescription"]; incident.VcBuildPackage = reader["vcBuildPackage"] == DBNull.Value ? "" : (String)reader["vcBuildPackage"]; incident.BHasIncident = reader["BHasIncident"] == DBNull.Value ? null : (bool?)reader["BHasIncident"]; incident.BRolledBack = reader["BRolledBack"] == DBNull.Value ? null : (bool?)reader["BRolledBack"]; incident.BHotfixed = reader["BHotfixed"] == DBNull.Value ? null : (bool?)reader["BHotfixed"]; incident.vcIncidentNumber = reader["vcIncidentNumber"] == DBNull.Value ? "" : (string)reader["vcIncidentNumber"]; incident.sdtIncidentDate = reader["sdtIncidentDate"] == DBNull.Value ? null : (DateTime?)reader["sdtIncidentDate"]; } } catch (Exception ex) { throw ex; } return(incident); }
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; } }
public static ItemIncident SWIncidentByIncidentIDGet(int IncidentID) { ItemIncident incident = new ItemIncident(); try { DbCommand dbcmd = mDatabase.GetStoredProcCommand("uspSWIncidentByIncidentIDGet"); mDatabase.AddInParameter(dbcmd, "@iIncidentID", DbType.Int32, IncidentID); IDataReader reader = mDatabase.ExecuteReader(dbcmd); if (reader.Read()) { incident.IIncidentID = reader["IIncidentID"] == DBNull.Value ? -1 : (int)reader["IIncidentID"]; incident.IItemID = reader["IItemID"] == DBNull.Value ? -1 : (int)reader["IItemID"]; incident.VcCRFNumber = reader["vcCRFNumber"] == DBNull.Value ? "" : (string)reader["vcCRFNumber"]; incident.VcCRPRTDR = reader["vcCRPRTDR"] == DBNull.Value ? "" : (string)reader["vcCRPRTDR"]; incident.VcDescription = reader["vcDescription"] == DBNull.Value ? "" : (string)reader["vcDescription"]; incident.VcBuildPackage = reader["vcBuildPackage"] == DBNull.Value ? "" : (String)reader["vcBuildPackage"]; incident.BHasIncident = reader["BHasIncident"] == DBNull.Value ? null : (bool?)reader["BHasIncident"]; incident.BRolledBack = reader["BRolledBack"] == DBNull.Value ? null : (bool?)reader["BRolledBack"]; incident.BHotfixed = reader["BHotfixed"] == DBNull.Value ? null : (bool?)reader["BHotfixed"]; incident.vcIncidentNumber = reader["vcIncidentNumber"] == DBNull.Value ? "" : (string)reader["vcIncidentNumber"]; incident.sdtIncidentDate = reader["sdtIncidentDate"] == DBNull.Value ? null : (DateTime?)reader["sdtIncidentDate"]; } } catch (Exception ex) { throw ex; } return incident; }