void fncRefreshReport() { try { string selQuery = "select uName,Campaign_Id,Status,Group_Name,Phone_No,callDuration from Active_call"; OpenConnection(); SqlCeDataAdapter adp = new SqlCeDataAdapter(selQuery, LocalSQLConn); DataSet ds = new DataSet(); adp.Fill(ds); List <ActiveCall> objActiveCall = new List <ActiveCall>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataSet dsCampName = new DataSet(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConnectionString); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("Select Name from Campaign where ID='" + ds.Tables[0].Rows[i]["Campaign_Id"].ToString() + "'", conn); System.Data.SqlClient.SqlDataAdapter daCampName = new System.Data.SqlClient.SqlDataAdapter(cmd); daCampName.Fill(dsCampName); objActiveCall.Add(ActiveCall.Create(ds.Tables[0].Rows[i]["uName"].ToString(), dsCampName.Tables[0].Rows[0][0].ToString(), ds.Tables[0].Rows[i]["Status"].ToString(), ds.Tables[0].Rows[i]["Group_Name"].ToString(), ds.Tables[0].Rows[i]["Phone_No"].ToString(), ds.Tables[0].Rows[i]["callDuration"].ToString())); } AgentItems.ItemsSource = objActiveCall; closeConnection(); } catch (Exception ex) { VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "fncRefreshReport()", "ctlrptActiveCall.xaml.cs"); } }
public static ActiveCall Create(string uName, string Camapign_Id, string Status,string Group_Name,string Phone_No,string callDuration) { ActiveCall ai = new ActiveCall(); ai.uName = uName; ai.Campaign_Id = Camapign_Id; ai.Status = Status; ai.Group_Name = Group_Name; ai.Phone_No = Phone_No; ai.callDuration = callDuration; return ai; }
public static ActiveCall Create(string uName, string Camapign_Id, string Status, string Group_Name, string Phone_No, string callDuration) { ActiveCall ai = new ActiveCall(); ai.uName = uName; ai.Campaign_Id = Camapign_Id; ai.Status = Status; ai.Group_Name = Group_Name; ai.Phone_No = Phone_No; ai.callDuration = callDuration; return(ai); }