public List <ProfileDom> Get(string id) { cmd.CommandText = "Company_Selectbyuserid"; List <ProfileDom> result = new List <ProfileDom>(); cmd.Parameters.AddWithValue("@UserId", id); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ProfileDom model = Mapper(reader); result.Add(model); } conn.Close(); return(result); }
private ProfileDom Mapper(SqlDataReader reader) { ProfileDom model = new ProfileDom(); int index = 0; model.Id = reader.GetInt32(index++); model.UserId = reader.GetString(index++); model.CompName = reader.GetString(index++); model.FName = reader.GetString(index++); model.LName = reader.GetString(index++); model.Street = reader.GetString(index++); model.City = reader.GetString(index++); model.State = reader.GetString(index++); model.Zip = reader.GetInt32(index++); model.Email = reader.GetString(index++); model.Phone = reader.GetString(index++); model.CreatedDate = reader.GetDateTime(index++); model.ModifiedDate = reader.GetDateTime(index++); model.ModifiedBy = reader.GetString(index++); return(model); }