public string InsertContact(string Name, string Surname, string MiddleName,
string Gender, string BirthDate, string Phone, string TaxNumber,
string Position, string JobID)
{
Logger.Log.Info($"InsertContact got params: name = {Name}, surname = {Surname}, " +
$"middlename = {MiddleName},gender = { Gender}, birthday = {BirthDate}, phone = {Phone}," +
$" taxnumber = {TaxNumber}, position = {Position}, jobid = {JobID}");
ContactsDataConverter converter = new ContactsDataConverter();
Contact newContact = converter.CreateInstance(Name, Surname, MiddleName,
Gender, BirthDate, Phone, TaxNumber, Position, JobID);
string db = ConfigurationManager.AppSettings["DBConnectionString"];
ContactsDBOperator dBOperator = new ContactsDBOperator(db);
try
{
int id = dBOperator.InsertContact(newContact);
string result = JsonConvert.SerializeObject(id);
return(result);
}
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, "Контакт не существует");
}
}