示例#1
0
 /// <summary>
 /// Clears/invalidates all caches in all services.
 /// </summary>
 public static void InvalidateCache()
 {
     UserService?.ClearCache();
     StatusService?.ClearCache();
     AlertService?.ClearCache();
     DeviceService?.ClearCache();
     SensorService?.ClearCache();
     StationService?.ClearCache();
     CircuitService?.ClearCache();
     ProgramService?.ClearCache();
     PivotService?.ClearCache();
 }
示例#2
0
        // GET: SBOSvcCtr
        public ActionResult Index()
        {
            IEnumerable <SCRequestModel> scRequestModelList = null;
            var          modelObj      = new SCRequest();
            var          SCRequestData = new Collection <SCRequest>();
            PivotService _pivotService = new PivotService();

            try
            {
                SCRequestData = _pivotService.GetAllSCRequestData(modelObj);

                scRequestModelList = (from item in SCRequestData
                                      select new SCRequestModel
                {
                    Number = item.Number,
                    Resolved_Month = item.Resolved_Month,
                    TTRwithExcludesInMinutes = item.TTRwithExcludesInMinutes,
                    RawTTRInMInutes = item.RawTTRInMInutes,
                    Open_Month = item.Open_Month,
                    Opened_By = item.Opened_By,
                    Impact = item.Impact,
                    Escalation = item.Escalation,
                    Due_Date = item.Due_Date,
                    Priority = item.Priority,
                    Request_State = item.Request_State,
                    Requested_For = item.Requested_For,
                    Short_Description = item.Short_Description,
                    Stage = item.Stage,
                    State = item.State,
                    BPIT = item.BPIT,
                    Assignment_Group = item.Assignment_Group
                }).Take(500);

                DataTable dt = new DataTable();

                DataColumn col1 = new DataColumn();
                col1.DataType   = System.Type.GetType("System.String");
                col1.ColumnName = "Number";

                DataColumn col2 = new DataColumn();
                col2.DataType   = System.Type.GetType("System.String");
                col2.ColumnName = "Resolved_Month";

                DataColumn col3 = new DataColumn();
                col3.DataType   = System.Type.GetType("System.Int32");
                col3.ColumnName = "TTRwithExcludesInMinutes";

                DataColumn col4 = new DataColumn();
                col4.DataType   = System.Type.GetType("System.Int32");
                col4.ColumnName = "RawTTRInMInutes";

                DataColumn col5 = new DataColumn();
                col5.DataType   = System.Type.GetType("System.String");
                col5.ColumnName = "Open_Month";

                DataColumn col6 = new DataColumn();
                col6.DataType   = System.Type.GetType("System.String");
                col6.ColumnName = "Opened_By";

                DataColumn col7 = new DataColumn();
                col7.DataType   = System.Type.GetType("System.String");
                col7.ColumnName = "Impact";

                DataColumn col8 = new DataColumn();
                col8.DataType   = System.Type.GetType("System.String");
                col8.ColumnName = "Escalation";

                DataColumn col9 = new DataColumn();
                col9.DataType   = System.Type.GetType("System.DateTime");
                col9.ColumnName = "Due_Date";

                DataColumn col10 = new DataColumn();
                col10.DataType   = System.Type.GetType("System.String");
                col10.ColumnName = "Priority";

                DataColumn col11 = new DataColumn();
                col11.DataType   = System.Type.GetType("System.String");
                col11.ColumnName = "Request_State";

                DataColumn col12 = new DataColumn();
                col12.DataType   = System.Type.GetType("System.String");
                col12.ColumnName = "Requested_For";

                DataColumn col13 = new DataColumn();
                col13.DataType   = System.Type.GetType("System.String");
                col13.ColumnName = "Short_Description";

                DataColumn col14 = new DataColumn();
                col14.DataType   = System.Type.GetType("System.String");
                col14.ColumnName = "Stage";

                DataColumn col15 = new DataColumn();
                col15.DataType   = System.Type.GetType("System.String");
                col15.ColumnName = "State";

                DataColumn col16 = new DataColumn();
                col16.DataType   = System.Type.GetType("System.String");
                col16.ColumnName = "BPIT";

                DataColumn col17 = new DataColumn();
                col17.DataType   = System.Type.GetType("System.String");
                col17.ColumnName = "Assignment_Group";

                dt.Columns.Add(col1);
                dt.Columns.Add(col2);
                dt.Columns.Add(col3);
                dt.Columns.Add(col4);
                dt.Columns.Add(col5);
                dt.Columns.Add(col6);
                dt.Columns.Add(col7);
                dt.Columns.Add(col8);
                dt.Columns.Add(col9);
                dt.Columns.Add(col10);
                dt.Columns.Add(col11);
                dt.Columns.Add(col12);
                dt.Columns.Add(col13);
                dt.Columns.Add(col14);
                dt.Columns.Add(col15);
                dt.Columns.Add(col16);
                dt.Columns.Add(col17);

                foreach (var item in scRequestModelList)
                {
                    DataRow dr = dt.NewRow();
                    dr[0]  = item.Number;
                    dr[1]  = item.Resolved_Month;
                    dr[2]  = item.TTRwithExcludesInMinutes;
                    dr[3]  = item.RawTTRInMInutes;
                    dr[4]  = item.Open_Month;
                    dr[5]  = item.Opened_By;
                    dr[6]  = item.Impact;
                    dr[7]  = item.Escalation;
                    dr[8]  = item.Due_Date;
                    dr[9]  = item.Priority;
                    dr[10] = item.Request_State;
                    dr[11] = item.Requested_For;
                    dr[12] = item.Short_Description;
                    dr[13] = item.Stage;
                    dr[14] = item.State;
                    dr[15] = item.BPIT;
                    dr[16] = item.Assignment_Group;
                    dt.Rows.Add(dr);
                }

                var result = new StringBuilder();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    result.Append(dt.Columns[i].ColumnName);
                    result.Append(i == dt.Columns.Count - 1 ? "\n" : ",");
                }

                foreach (DataRow row in dt.Rows)
                {
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        result.Append(row[i].ToString());
                        result.Append(i == dt.Columns.Count - 1 ? "\n" : ",");
                    }
                }
                Session["firstTimeSC"] = result;
                string newFileName = AppDomain.CurrentDomain.BaseDirectory + "SBOSvcCtr_Jennifer.csv";
            }
            catch (Exception ex)
            {
                return(View("Error"));
            }
            return(View());
        }
示例#3
0
        // GET: ConnectMe
        public ActionResult ConnectMe()
        {
            IEnumerable <ConnectMe> _connectMe = null;
            var          modelObj      = new ConnectMe();
            var          SCRequestData = new Collection <ConnectMe>();
            PivotService _pivotService = new PivotService();

            SCRequestData = _pivotService.GetAllConnectMe(modelObj);
            _connectMe    = (from item in SCRequestData
                             select new ConnectMe
            {
                SessionDate = item.SessionDate,

                alias = item.alias,

                sessionId = item.sessionId,

                chatId = item.chatId,

                SessionStartTime = item.SessionStartTime,

                ChatStartTime = item.ChatStartTime,

                ChatRequestedTime = item.ChatRequestedTime,

                ChatEndTime = item.ChatEndTime,

                BOTTime = item.BOTTime,

                AgentChatWaitTime = item.AgentChatWaitTime,

                PostCallWork = item.PostCallWork,

                AgentAbandoned = item.AgentAbandoned,

                CallAvoided = item.CallAvoided,

                AgentChatDuration = item.AgentChatDuration,

                SessionDuration = item.SessionDuration,

                Country = item.Country,

                Topic = item.Topic,

                SupervisorActivity = item.SupervisorActivity,

                AgentChatMonth = item.AgentChatMonth,

                SessionMonth = item.SessionMonth,
            });
            var result = new StringBuilder();

            foreach (var item in _connectMe)
            {
                result.Append(item.SessionDate + "," + item.alias + "," + item.sessionId + "," + item.chatId + "," + item.SessionStartTime + "," + item.ChatStartTime + "," + item.ChatRequestedTime + "," + item.ChatEndTime + "," + item.BOTTime + "," + item.AgentChatWaitTime + "," + item.PostCallWork + "," + item.AgentAbandoned + "," + item.CallAvoided + "," + item.AgentChatDuration + "," + item.SessionDuration + "," + item.Country + "," + item.Topic + "," + item.SupervisorActivity + "," + item.AgentChatMonth + "," + item.SessionMonth + "\n");
            }
            System.IO.File.WriteAllText(@"D:\Pivot\PivotExcel05-01-2017\PivotExcel\MSIT.Web.ExcelPivot\MSIT.Web.ExcelPivot\data.csv", Convert.ToString(result));
            string newFileName = AppDomain.CurrentDomain.BaseDirectory + "data.csv";

            return(View());
        }