public List <AsteriskCallModel> GetAsteriskCallsInfo() { //throw new NotImplementedException(); using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(MssqlDataAccess.GetConnectionString())) { List <AsteriskCallModel> output = connection.Query <AsteriskCallModel>("select * from [ViewAsteriskCaller]").ToList(); return(output); } }
public List <CustomerInfoModel> GetCustomerInfoByPhone(string phone) { //throw new NotImplementedException(); using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(MssqlDataAccess.GetConnectionString())) { List <CustomerInfoModel> output = connection.Query <CustomerInfoModel>("dbo.rp_GetCustomerByPhone @Phone", new { Phone = phone }).ToList(); return(output); } }