public static Answer get(int id)
{
Dictionary <string, string> dic = new siteSql(@"SELECT * FROM adresTable WHERE id = @id", 'o', new[] { "@id", id.ToString() }, true).getFStringDic();
if (dic == null)
{
return(new Answer(0, "Адрес не найден"));
}
return(new Answer(1, "ОК", new Address(dic)));
}
public static Answer AllClientAddresses(Client.Client client)
{
DataSet ds = new siteSql(@"SELECT * FROM adresTable WHERE clientId = @clientId", 'o', new[] { "@clientId", client.id.ToString() }, true).getDS();
if (ds == null)
{
return(new Answer(0, "Адреса не найдены"));
}
List <Address> addresses = new List <Address>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
addresses.Add(new Address(ds.Tables[0].Rows[i]));
}
return(new Answer(1, "ОК", addresses));
}
