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);
}
}