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