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