public object Generatecsm_complaint_mst_mstObject(ref IDataReader returnData) { csm_complaint_mst obj = new csm_complaint_mst(); while (returnData.Read()) { obj.ComplaintId = (string)returnData["ComplaintId"]; obj.ComplaintDesc = (string)returnData["ComplaintDesc"]; obj.CustomerName = (string)returnData["CustomerName"]; if (returnData["ComplaintDate "] != DBNull.Value) { DateTime Mydatetime = new DateTime(); Mydatetime = (DateTime)returnData["ComplaintDate "]; obj.ComplaintDate = Mydatetime.ToString(); } } returnData.Close(); returnData.Dispose(); return obj; }
public CollectionBase Generatecsm_complaint_mst_mstCollection(ref IDataReader returnData) { BLLCollection<csm_complaint_mst> col = new BLLCollection<csm_complaint_mst>(); while (returnData.Read()) { csm_complaint_mst obj = new csm_complaint_mst(); obj.ComplaintId = (string)returnData["ComplaintId"]; obj.ComplaintDesc = (string)returnData["ComplaintDesc"]; obj.CustomerName = (string)returnData["CustomerName"]; if (returnData["ComplaintDate"] != DBNull.Value) { DateTime Mydatetime = new DateTime(); Mydatetime = (DateTime)returnData["ComplaintDate"]; obj.ComplaintDate = Mydatetime.ToString(); } col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }