public int Insert_ProblemAnalysis_mst(ProblemAnalysis ObjProblemAnalysis)
{
return (int)ExecuteNonQuery(Sp_ProblemAnalysis_Insert, new object[] { ObjProblemAnalysis.Problemid, ObjProblemAnalysis.Impact, ObjProblemAnalysis.RootCause, ObjProblemAnalysis.Symtom });
}
public int Update_ProblemAnalysis_By_id(ProblemAnalysis ObjProblemAnalysis)
{
return (int)ExecuteNonQuery(Sp_ProblemAnalysis_Update, new object[] { ObjProblemAnalysis.Problemid, ObjProblemAnalysis.Impact, ObjProblemAnalysis.RootCause, ObjProblemAnalysis.Symtom });
}
public object GenerateProblemAnalysis_mstObject(ref IDataReader returnData)
{
ProblemAnalysis obj = new ProblemAnalysis();
while (returnData.Read())
{
obj.Problemid = (int)returnData["Problemid"];
obj.Impact = (string)returnData["Impact"];
obj.RootCause = (string)returnData["RootCause"];
obj.Symtom = (string)returnData["Symptoms"];
if (returnData["Symptoms"] != DBNull.Value)
{
obj.Symtom = (string)returnData["Symptoms"];
}
if (returnData["RootCause"] != DBNull.Value)
{
obj.RootCause = (string)returnData["RootCause"];
}
if (returnData["Symtom"] != DBNull.Value)
{
obj.Symtom = (string)returnData["Symtom"];
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
