public int DeleteContactById(int contactId) { var parameter = new DynamicParameters(); parameter.Add("Id", contactId); Contact contact = DBAccessService.GetSingleResult <Contact>("spContact_GetById", parameter); return(DBAccessService.Execute("spContact_DeleteById", parameter)); }
public Contact GetContactById(int contactId) { var parameter = new DynamicParameters(); parameter.Add("Id", contactId); Contact contact = DBAccessService.GetSingleResult <Contact>("spContact_GetById", parameter); return(contact); }
public int SaveContact(Contact contact) { var parameter = new DynamicParameters(); parameter.Add("Id", Convert.ToInt32(contact.Id)); parameter.Add("FirstName", contact.FirstName); parameter.Add("LastName", contact.LastName); parameter.Add("Email", contact.Email); parameter.Add("PhoneNumber", contact.PhoneNumber); parameter.Add("IsActive", contact.Status); return(DBAccessService.Execute("spContact_Upsert", parameter)); }
public List <Contact> GetContacts() { List <Contact> contacts = DBAccessService.GetMultipleResults <Contact>("spContact_Get", null); return(contacts); }