public int Insert_ChangeNotes_mst(ChangeNotes ObjChangeNotes)
{
return (int)ExecuteNonQuery(Sp_ChangeNotes_Insert, new object[] { ObjChangeNotes.Changeid, ObjChangeNotes.Comments, ObjChangeNotes.Username });
}
public CollectionBase GenerateChangeNotes_mstCollection(ref IDataReader returnData)
{
BLLCollection<ChangeNotes> col = new BLLCollection<ChangeNotes>();
while (returnData.Read())
{
ChangeNotes obj = new ChangeNotes();
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Date"];
obj.Date = Mydatetime.ToString();
obj.Changeid = (int)returnData["Changeid"];
obj.Username = (int)returnData["Username"];
if (returnData["Comments"] != DBNull.Value)
{
obj.Comments = (string)returnData["Comments"];
}
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}