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