/// <summary>
/// Gets data from database
/// </summary>
/// <returns></returns>
public Collection<CallDispositions> GetCallDespositionsInfo()
{
var db = new SqlConnection(Utility.GetConnectionString());
db.Open();
var rec = new Collection<CallDispositions>();
const string query = "Select * from DialConnect.CallDispositions";
var sqlcmd = new SqlCommand(query, db);
using (SqlDataReader dataReader = sqlcmd.ExecuteReader())
{
while (dataReader.Read())
{
var info = new CallDispositions
{
//this is where we are mapping the column that came back from database to your model from CallDispositions.cs class
ActionCode = dataReader.GetString(dataReader.GetOrdinal("ActionCode")),
AgentInitials = dataReader.GetString(dataReader.GetOrdinal("AgentInitials")),
CallDate = Convert.ToDateTime(dataReader.GetString(dataReader.GetOrdinal("CallDate"))),
CallStartStr = dataReader.GetString(dataReader.GetOrdinal("CallStartStr")),
CampaignId = Convert.ToInt64(dataReader.GetString(dataReader.GetOrdinal("CampaignId"))),
CubsAccountNumber = Convert.ToInt64(dataReader.GetString(dataReader.GetOrdinal("CubsAccountNumber"))),
DurationSeconds = dataReader.GetString(dataReader.GetOrdinal("DurationSeconds")),
};
}
db.Close();
return rec;
}
}
static void Main(string[] args)
{
//get data from db first
var datafromdb = new DataMapper();
// Collection<CallDispositions> result=datafromdb.GetCallDespositionsInfo();
var result = new Collection<CallDispositions>();
var testdata1 = new CallDispositions();
testdata1.ActionCode = "test";
testdata1.AgentInitials = "PM";
testdata1.CallDate = Convert.ToDateTime("2016/01/13");
testdata1.CallStartStr = "test";
testdata1.CampaignId = 4;
testdata1.CubsAccountNumber = 12345;
testdata1.DurationSeconds = "55";
result.Add(testdata1);
//send result to messaging queue
try
{
var req = new SendMsgToQueue();
req.SendMessageToQueue(queueName, result);
}
catch (Exception ex)
{
Console.WriteLine("unable to queue message", ex.StackTrace);
}
}
