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