public void UpdateAddress(int clientId, int clientAddressId, string cityName, string countyName, string streetName, string streetNo)
{
DAAddress dAAddress = new DAAddress();
dAAddress.Update(clientId, clientAddressId, cityName, countyName, streetName, streetNo);
}
public void UpdateSelectedAddress(AddressModel adresaNoua, out string errorMessage)
{
errorMessage = "OK";
DAAddress daAdr = new DAAddress();
daAdr.UpdateSelectedAddress(adresaNoua);
errorMessage = "Adresa modificata!";
}
public void DeleteSelectedAddress(int id, out string errorMessage)
{
errorMessage = "OK";
DAAddress daADR = new DAAddress();
daADR.DeleteSelectedAddress(id);
errorMessage = "Adresa stearsa!";
}
public void DeleteClient(int id, out string errorMessage)
{
errorMessage = "OK";
DAAddress daADR = new DAAddress();
daADR.DeleteAddress(id);
DAClients daClients = new DAClients();
daClients.DeleteClient(id);
errorMessage = "Client sters!";
}
public DataTable GetClientAddressesById(int clientId, int adrId)
{
DAAddress daAdrese = new DAAddress();
DataTable dataTable = new DataTable();
try
{
dataTable = daAdrese.GetClientAddressesById(clientId, adrId);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(dataTable);
}
public DataTable GetCountyNameById(int id)
{
DAAddress daAdrese = new DAAddress();
DataTable dataTable = new DataTable();
try
{
dataTable = daAdrese.GetCountyNameById(id);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(dataTable);
}
public void InsertAdress(AddressModel adresa, out bool status, out string message)
{
message = "OK";
status = false;
try
{
DAAddress daAdresa = new DAAddress();
daAdresa.InsertAddress(adresa);
DataTable dataTable2 = daAdresa.GetAddresses(adresa.PartnerId);
message = "Adresa adaugata!";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public List <CountyModel> GetCounty()
{
List <CountyModel> address = new List <CountyModel>();
DAAddress aAddress = new DAAddress();
DataTable data = aAddress.GetCounty();
for (int i = 0; i < data.Rows.Count; i++)
{
address.Add(new CountyModel
{
CountyId = Convert.ToInt32(data.Rows[i]["CountyId"]),
CountyName = data.Rows[i]["CountyName"].ToString(),
});
}
return(address);
}
public List <FullAddressModule> GetFullAddress(int clientId)
{
List <FullAddressModule> fullAddresses = new List <FullAddressModule>();
DAAddress dAAddress = new DAAddress();
DataTable data = dAAddress.GetFullAddress(clientId);
for (int i = 0; i < data.Rows.Count; i++)
{
fullAddresses.Add(new FullAddressModule
{
ClientAddressId = Convert.ToInt32(data.Rows[i]["ClientAddressId"]),
FullAddress = data.Rows[i]["FullAddress"].ToString(),
});
}
return(fullAddresses);
}
public List <AddressModel> Address(int id)
{
List <AddressModel> address = new List <AddressModel>();
DAAddress aAddress = new DAAddress();
DataTable data = aAddress.Address(id);
for (int i = 0; i < data.Rows.Count; i++)
{
address.Add(new AddressModel
{
ClientId = Convert.ToInt32(data.Rows[i]["ClientId"]),
ClientAddressId = Convert.ToInt32(data.Rows[i]["ClientAddressId"]),
ClientName = data.Rows[i]["ClientName"].ToString(),
ClientSurname = data.Rows[i]["ClientSurName"].ToString(),
CityName = data.Rows[i]["CityName"].ToString(),
CountyName = data.Rows[i]["CountyName"].ToString(),
StreetName = data.Rows[i]["StreetName"].ToString(),
StreetNo = data.Rows[i]["StreetNo"].ToString(),
});
}
return(address);
}
public List <CountyModel> GetCounties()
{
List <CountyModel> lista = new List <CountyModel>();
DAAddress daAdrese = new DAAddress();
DataTable dataTable = new DataTable();
try
{
dataTable = daAdrese.GetCounties();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
for (int i = 0; i < dataTable.Rows.Count; i++)
{
CountyModel jud = new CountyModel();
jud.CountyId = Convert.ToInt32(dataTable.Rows[i]["CountyId"]);
jud.CountyName = dataTable.Rows[i]["CountyName"].ToString();
lista.Add(jud);
}
return(lista);
}
public void AddAddress(int clientId, string cityName, string countyName, string streetName, string streetNo)
{
DAAddress da = new DAAddress();
da.Add(clientId, cityName, countyName, streetName, streetNo);
}
public void DeleteAddress(int clientId, int clientAddressId)
{
DAAddress dAAddress = new DAAddress();
dAAddress.Delete(clientId, clientAddressId);
}
