public void DeleteContact(string id)
{
Logger.Log.Info($"DeleteContact got params: id = {id}");
string db = ConfigurationManager.AppSettings["DBConnectionString"];
ContactsDBOperator dBOperator = new ContactsDBOperator(db);
if (dBOperator.RowExists(id))
{
try
{
dBOperator.DeleteContact(id);
}
catch (DBConnectionException)
{
throw new FaultException("Ошибка подключения к базе данных");
}
catch (SQLCommandException)
{
throw new FaultException("Ошибка выполнения запроса к базе данных");
}
}
else
{
Logger.Log.Info($"Contact doesn't exist: id = {id}");
throw new FaultException <string>(id, "Контакт не существует");
}
}
public string GetContact(string id)
{
Logger.Log.Info($"GetContact got params: id = {id}");
string db = ConfigurationManager.AppSettings["DBConnectionString"];
ContactsDBOperator dBOperator = new ContactsDBOperator(db);
try
{
if (dBOperator.RowExists(id))
{
Contact contact = dBOperator.GetById(id);
JsonSerializerSettings settings = new JsonSerializerSettings();
settings.DateFormatString = "yyyy-MM-dd";
string responce = JsonConvert.SerializeObject(contact, settings);
return(responce);
}
else
{
Logger.Log.Info($"Contact doesn't exist: id = {id}");
throw new FaultException <string>(id, "Контакт не существует");
}
}
catch (DBConnectionException)
{
throw new FaultException("Ошибка подключения к базе данных");
}
catch (SQLCommandException)
{
throw new FaultException("Ошибка выполнения запроса к базе данных");
}
}
public void UpdateContact(string ID, string Name, string Surname, string MiddleName,
string Gender, string BirthDate, string Phone, string TaxNumber,
string Position, string JobID)
{
Logger.Log.Info($"UpdateContact got params: id = {ID}, name = {Name}, surname = {Surname}, " +
$"middlename = {MiddleName},gender = { Gender}, birthday = {BirthDate}, phone = {Phone}," +
$" taxnumber = {TaxNumber}, position = {Position}, jobid = {JobID}");
string db = ConfigurationManager.AppSettings["DBConnectionString"];
ContactsDBOperator dBOperator = new ContactsDBOperator(db);
if (dBOperator.RowExists(ID))
{
ContactsDataConverter converter = new ContactsDataConverter();
Contact newContact = converter.CreateInstance(Name, Surname, MiddleName,
Gender, BirthDate, Phone, TaxNumber, Position, JobID, ID);
try
{
dBOperator.UpdateContact(newContact);
}
catch (DBConnectionException)
{
throw new FaultException("Ошибка подключения к базе данных");
}
catch (SQLCommandException)
{
throw new FaultException("Ошибка выполнения запроса к базе данных");
}
}
else
{
Logger.Log.Info($"Contact doesn't exist: id = {ID}");
throw new FaultException <string>(ID, "Контакт не существует");
}
}