public int Update_ProblemHistoryDiff_mst_By_id(ProblemHistoryDiff objProblemHistoryDiff)
{
return (int)ExecuteNonQuery(Sp_ProblemHistoryDiff_Update, new object[] { objProblemHistoryDiff.Prev_value, objProblemHistoryDiff.Historyid, objProblemHistoryDiff.Historydiffid, objProblemHistoryDiff.Current_value, objProblemHistoryDiff.Columnname });
}
public object GenerateProblemHistoryDiff_mstObject(ref IDataReader returnData)
{
ProblemHistoryDiff obj = new ProblemHistoryDiff();
while (returnData.Read())
{
obj.Historyid = (int)returnData["Historyid"];
obj.Historydiffid = (int)returnData["Historydiffid"];
obj.Prev_value = (string)returnData["Prev_value"];
obj.Current_value = (string)returnData["Current_value"];
obj.Columnname = (string)returnData["Columnname"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public int Insert_ProblemHistoryDiff_mst(ProblemHistoryDiff objProblemHistoryDiff)
{
return (int)ExecuteNonQuery(Sp_ProblemHistoryDiff_Insert, new object[] { objProblemHistoryDiff.Prev_value, objProblemHistoryDiff.Historyid, objProblemHistoryDiff.Current_value, objProblemHistoryDiff.Columnname });
}
public CollectionBase GenerateProblemHistoryDiff_mstCollection(ref IDataReader returnData)
{
BLLCollection<ProblemHistoryDiff> col = new BLLCollection<ProblemHistoryDiff>();
while (returnData.Read())
{
ProblemHistoryDiff obj = new ProblemHistoryDiff();
obj.Historyid = (int)returnData["Historyid"];
obj.Historydiffid = (int)returnData["Historydiffid"];
obj.Prev_value = (string)returnData["Pre_value"];
obj.Current_value = (string)returnData["Current_value"];
obj.Columnname = (string)returnData["Columnname"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}