public int Update_ChangeHistoryDiff_mst_By_id(ChangeHistoryDiff objChageHistoryDiff)
{
return (int)ExecuteNonQuery(Sp_ChangeHistoryDiff_Update, new object[] { objChageHistoryDiff.Prev_value, objChageHistoryDiff.Historyid, objChageHistoryDiff.Historydiffid, objChageHistoryDiff.Current_value, objChageHistoryDiff.Columnname });
}
public object GenerateChangeHistoryDiff_mstObject(ref IDataReader returnData)
{
ChangeHistoryDiff obj = new ChangeHistoryDiff();
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_ChangeHistoryDiff_mst(ChangeHistoryDiff objChangeHistoryDiff)
{
return (int)ExecuteNonQuery(Sp_ChangeHistoryDiff_Insert, new object[] { objChangeHistoryDiff.Prev_value, objChangeHistoryDiff.Historyid, objChangeHistoryDiff.Current_value, objChangeHistoryDiff.Columnname });
}
public CollectionBase GenerateChangeHistoryDiff_mstCollection(ref IDataReader returnData)
{
BLLCollection<ChangeHistoryDiff> col = new BLLCollection<ChangeHistoryDiff>();
while (returnData.Read())
{
ChangeHistoryDiff obj = new ChangeHistoryDiff();
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;
}
