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