コード例 #1
0
        private void ProcessUnschdeuledAdjustment()
        {
            this.Logger.Log(TraceEventType.Information, LoggingMessageId.PortalOfcomEvaluation, "processing unscheduled adjustments started at " + DateTime.Now);

            string directoryPath = this.GetDirectoryPath("Stage4");
            string tableName     = "RGN5Stage4UnscheduledAdjustments";
            string fileName      = "Stage 4 - Unscheduled Adjustments.csv";

            string filePath = directoryPath + fileName;

            try
            {
                // Get All PmseAssigments
                IEnumerable <DTTDataAvailability> dttData = this.regionDataAccess.GetDTTDataAvailability(tableName);

                if (dttData.Count() > 0)
                {
                    // delete all assignments
                    this.regionDataAccess.DeleteDTTDataAvailability(dttData, tableName);
                }

                List <DTTDataAvailability> listPD = new List <DTTDataAvailability>();
                foreach (var line in File.ReadAllLines(filePath))
                {
                    string[] values = line.Split(',');
                    if (values[0] == "Easting" || string.IsNullOrEmpty(values[0]))
                    {
                        continue;
                    }

                    DTTDataAvailability pd = new DTTDataAvailability();
                    var dttvalues          = values.Skip(2).Select(obj => obj.ToInt32()).ToArray();
                    pd.DataRecord = Conversion.IntToByte(dttvalues);
                    var test = Conversion.ByteToInt(pd.DataRecord);
                    pd.Easting      = values[0].ToInt32();
                    pd.Northing     = values[1].ToInt32();
                    pd.PartitionKey = "Stage4Unscheduled";
                    pd.RowKey       = string.Format("{0}-{1}", pd.Easting, pd.Northing);

                    listPD.Add(pd);
                }

                this.regionDataAccess.InsertDTTDataAvailability(listPD, tableName);
            }
            catch (Exception)
            {
            }

            this.Logger.Log(TraceEventType.Information, LoggingMessageId.PortalOfcomEvaluation, "processing unscheduled adjustments ended at " + DateTime.Now);
        }
コード例 #2
0
        /// <summary>
        /// Processes the unscheduled adjustments.
        /// </summary>
        /// <param name="dataStream">The data stream.</param>
        /// <param name="fileName">Name of the file.</param>
        /// <param name="replyMessage">The reply message.</param>
        /// <returns>returns List{DTTDataAvailability}.</returns>
        private bool ProcessUnscheduledAdjustments(string[] dataStream, string fileName, out string replyMessage)
        {
            AuditId auditId         = AuditId.PmseSync;
            string  auditMethodName = "ProcessUnscheduledAdjustments";

            try
            {
                List <DTTDataAvailability> listPD = new List <DTTDataAvailability>();
                foreach (var line in dataStream)
                {
                    var values = line.Split(',');
                    if (values[0].ToLower().Contains("easting"))
                    {
                        continue;
                    }

                    try
                    {
                        if (!this.CheckRequiredInteger(values[0]) || !this.CheckRequiredInteger(values[1]) || !this.CheckUnscheduledData(values))
                        {
                            listPD       = null;
                            replyMessage = Utils.Configuration["mailBodyFileNotValid"];
                            break;
                        }
                        else
                        {
                            DTTDataAvailability pd = new DTTDataAvailability();
                            var dttvalues          = values.Skip(2).Select(obj => obj.ToInt32()).ToArray();
                            pd.DataRecord = Conversion.IntToByte(dttvalues);
                            var test = Conversion.ByteToInt(pd.DataRecord);
                            pd.Easting      = values[0].ToInt32();
                            pd.Northing     = values[1].ToInt32();
                            pd.PartitionKey = fileName;
                            pd.RowKey       = string.Format("{0}-{1}", pd.Easting, pd.Northing);
                            listPD.Add(pd);
                        }
                    }
                    catch
                    {
                        this.PmseAssignmentLogger.Log(TraceEventType.Error, LoggingMessageId.PmseSyncGenericMessage, string.Format("Error in File:{0}, Line :{1}", fileName, line));
                        listPD = null;
                    }
                }

                if (listPD != null && listPD.Count > 0 && listPD.Select(obj => obj.RowKey).Distinct().Count() == listPD.Count)
                {
                    try
                    {
                        bool result = this.PmseSync.InsertPMSEUnscheduledAdjustment(listPD, Utils.GetRegionalTableName(Constants.UnscheduledAdjustmentsTableName));
                        if (result)
                        {
                            List <DTTDataAvailability> existingPMSEUnscheduledData = this.CommonDalc.FetchEntity <DTTDataAvailability>(Utils.GetRegionalTableName(Constants.UnscheduledAdjustmentsTableName), null);
                            if (existingPMSEUnscheduledData.Count > 0)
                            {
                                existingPMSEUnscheduledData = existingPMSEUnscheduledData.Where(obj => obj.PartitionKey != fileName).ToList();
                                this.CommonDalc.DeleteRecords(Constants.UnscheduledAdjustmentsTableName, existingPMSEUnscheduledData);
                            }

                            replyMessage = Utils.Configuration["mailBodySyncSuccessfully"];
                        }
                        else
                        {
                            replyMessage = Utils.Configuration["mailBodyServerError"];
                        }
                    }
                    catch
                    {
                        replyMessage = Utils.Configuration["mailBodyServerError"];
                    }
                }
                else
                {
                    replyMessage = Utils.Configuration["mailBodyFileNotValid"];
                    return(false);
                }

                return(true);
            }
            catch (Exception e)
            {
                replyMessage = Utils.Configuration["mailBodyFailToProcessFile"];
                this.PmseAssignmentLogger.Log(TraceEventType.Information, LoggingMessageId.PmseSyncGenericMessage, "Exception Occured while processing file  " + fileName + " Exception :- " + e.ToString());
                this.PmseAssignmentAuditor.Audit(auditId, AuditStatus.Failure, this.stopWatch.ElapsedMilliseconds, auditMethodName + "Exception Occured while processing file  " + fileName + " Exception :- " + e.ToString());
                return(false);
            }
        }