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, "Контакт не существует"); } }