public void DeleteContact(int id) { var connectString = ConfigurationManager.AppSettings["connectString"]; IMylogger log = new Log4netUsing(); var test = new ContactDBWorker(connectString, log); test.DeleteContact(id); }
public void UpdateContact(Contact person) { var connectString = ConfigurationManager.AppSettings["connectString"]; IMylogger log = new Log4netUsing(); var test = new ContactDBWorker(connectString, log); test.UpdateContact(person); }
public void CreateContact(Contact person) { var connectString = ConfigurationManager.AppSettings["connectString"]; IMylogger log = new Log4netUsing(); var test = new ContactDBWorker(connectString, log); /*var test_return = */ test.Create(person); //return 1; }
public List <Contact> GetContactsByLastName(string lastname) { var connectString = ConfigurationManager.AppSettings["connectString"]; var amountRestrict = Convert.ToInt32(ConfigurationManager.AppSettings["amountrestrict"]); IMylogger log = new Log4netUsing(); var test = new ContactDBWorker(connectString, log); var toReturn = test.GetContactsByLastName(lastname); toReturn = BubbleSorter.BubbleSorterFN(toReturn); toReturn = ListContactSlicer.Slice(toReturn, amountRestrict); return(toReturn); }
public List <Contact> GetContactsByFirstName(string firstname)// чтобы вернуть еще и значение amountRestrict, нужно создать класс GetContactsResponse и добавить туда два поля: List<Contact> и int amountRestrict { var connectString = ConfigurationManager.AppSettings["connectString"]; var amountRestrict = Convert.ToInt32(ConfigurationManager.AppSettings["amountrestrict"]); IMylogger log = new Log4netUsing(); var test = new ContactDBWorker(connectString, log); // ДЛЯ КАЖДОГО МЕТОДА СЕРВИСА TRY CATCH var toReturn = test.GetContactsByFirstName(firstname); toReturn = BubbleSorter.BubbleSorterLN(toReturn); toReturn = ListContactSlicer.Slice(toReturn, amountRestrict); return(toReturn); }
public List <Contact> GetContacts() { var connectString = ConfigurationManager.AppSettings["connectString"]; IMylogger log = new Log4netUsing(); var test = new ContactDBWorker(connectString, log); List <Contact> toReturn = new List <Contact>(); try { toReturn = test.GetContacts(); } catch (SqlException e) { log.Info("При считывании всех записей из бд таблицы Person произошла ошибка Детали: " + e.ToString()); } return(toReturn); }