public int Insert_ProblemNotes_mst(ProblemNotes ObjProblemNotes)
{
return (int)ExecuteNonQuery(Sp_ProblemNotes_Insert, new object[] { ObjProblemNotes.Problemid, ObjProblemNotes.Comments, ObjProblemNotes.UserName });
}
public CollectionBase GenerateProblemNotes_mstCollection(ref IDataReader returnData)
{
BLLCollection<ProblemNotes> col = new BLLCollection<ProblemNotes>();
while (returnData.Read())
{
ProblemNotes obj = new ProblemNotes();
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Date"];
obj.Date = Mydatetime.ToString();
obj.Problemid = (int)returnData["Problemid"];
obj.UserName = (int)returnData["UserName"];
if (returnData["Comments"] != DBNull.Value)
{
obj.Comments = (string)returnData["Comments"];
}
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
