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