public BindingList <ClientModel> GetClientBi(string ClientName, string ClientSurname, string ClientCode, int?ClientId, int?skip_page, int?take_page) { DAClient dac = new DAClient(); DataTable dt = new DataTable(); dt = dac.GetClients(ClientName, ClientSurname, ClientCode, ClientId, skip_page, take_page); BindingList <ClientModel> list = new BindingList <ClientModel>(); for (int i = 0; i < dt.Rows.Count; i++) { ClientModel client = new ClientModel(); client.ClientId = Convert.ToInt32(dt.Rows[i]["ClientId"].ToString()); client.ClientName = dt.Rows[i]["ClientName"].ToString(); client.ClientSurname = dt.Rows[i]["ClientSurname"].ToString(); client.ClientCode = dt.Rows[i]["ClientCode"].ToString(); client.PhoneNo = dt.Rows[i]["PhoneNo"].ToString(); client.Email = dt.Rows[i]["Email"].ToString(); list.Add(client); } return(list); }