Exemple #1
0
        public bool SaveOrUpdateOMRecords(OMNITURE_DATA omData, string fweek)
        {
            bool isFileSaved = false;

            try
            {
                using (var ctx = new TODEntities())
                {
                    DateTime currDate    = TodDateUtils.GetCurrentTimeInIST();
                    string   fiscalweek  = TodDateUtils.GetWeekOfYearFor(TodDateUtils.GetCurrentTimeInIST());
                    DateTime ceStartDate = currDate.AddDays(-7).Date;
                    DateTime ceEndDate   = currDate.AddDays(-1).Date;


                    omData.FW_ID         = fweek;
                    omData.FW_START_DATE = ceStartDate;
                    omData.FW_END_DATE   = ceEndDate;
                    omData.REP_GEN_DATE  = currDate;

                    omData.OMNITURE_STATUS = "Success";
                    ctx.OMNITURE_DATA.Attach(omData);
                    ctx.Entry <OMNITURE_DATA>(omData).State = omData.SEQUENCE_ID == 0 ? EntityState.Added : EntityState.Unchanged;
                    ctx.SaveChanges();
                }
                isFileSaved = true;
            }
            catch (Exception e)
            {
                log.Info(e.Message);
                isFileSaved = false;
            }
            return(isFileSaved);
        }
Exemple #2
0
        public JsonResult UploadMultiple(HttpPostedFileBase[] uploadedFiles, string fweek)
        {
            bool          success = true;
            OMNITURE_DATA omData  = new OMNITURE_DATA();

            tODDataService = new TODDataService();
            for (var i = 0; i < uploadedFiles.Length; i++)
            {
                var uploadedFile = uploadedFiles[i];
                if (uploadedFile != null && uploadedFile.ContentLength > 0)
                {
                    byte[] FileByteArray = new byte[uploadedFile.ContentLength];
                    uploadedFile.InputStream.Read(FileByteArray, 0, uploadedFile.ContentLength);

                    //save the file to database

                    omData = tODDataService.AppendFileData(omData, uploadedFile, fweek);
                }
            }

            success = tODDataService.SaveOrUpdateOMRecords(omData, fweek);

            if (success)
            {
                log.Info("Files successfully uploaded to database.");
                ViewData["UploadStatus"] = Json(new
                {
                    statusCode = 200,
                    status     = "Files Uploaded Successfully"
                }, JsonRequestBehavior.AllowGet);
            }
            else
            {
                log.Info("Files uploading to database failed.");
                ViewData["UploadStatus"] = Json(new
                {
                    statusCode = 400,
                    status     = "Bad Request! Upload Failed",
                    file       = string.Empty
                }, JsonRequestBehavior.AllowGet);
            }
            return(Json(ViewData));
        }
Exemple #3
0
        public OMNITURE_DATA AppendFileData(OMNITURE_DATA omData, HttpPostedFileBase uploadedFile, string fweek)
        {
            bool isFileSaved = false;

            try
            {
                /*var qresult = (from om in ctx.OMNITURE_DATA
                 *             join fd in ctx.FW_CALENDAR
                 *             on om.FW_ID equals fd.Fiscal_Week
                 *             where om.FW_ID == fweek
                 *             select om).ToList();
                 * List<OMNITURE_DATA> omDataList = qresult.Distinct().ToList();
                 *
                 * if(omDataList.Count == 0)
                 * {
                 *  log.Info("Omniture Reports Records not found for the Week : (" + fweek + ")");
                 * }
                 */

                byte[] FileByteArray = new byte[uploadedFile.ContentLength];
                uploadedFile.InputStream.Read(FileByteArray, 0, uploadedFile.ContentLength);
                string FileName = uploadedFile.FileName;



                if (FileName.Contains("c58") || FileName.Contains("TOD")) // TOD Report file
                {
                    omData.TOD_REPORT = FileByteArray;
                }
                else if (FileName.Contains("ProductCD")) // Product Code File
                {
                    omData.PRODUCT_CODE = FileByteArray;
                }
                else if (FileName.Contains("Language")) // Language Report
                {
                    omData.LANGUAGE_REPORT = FileByteArray;
                }
                else if (FileName.Contains("Product Name")) // product Name Report file
                {
                    omData.PRODUCT_NAME = FileByteArray;
                }
                else if (FileName.Contains("Publication ID")) // publication id Report File
                {
                    omData.PUBLICATION_ID = FileByteArray;
                }
                else if (FileName.Contains("GUID")) // topic guid report file
                {
                    omData.TOPIC_GUID = FileByteArray;
                }
                else if (FileName.Contains("Topic Title")) // topic title report file
                {
                    omData.TOPIC_TITLE = FileByteArray;
                }
                else if (FileName.Contains("Manual Title"))
                {
                    omData.MANUAL_TITLE = FileByteArray;
                }

                isFileSaved = true;
            }
            catch (Exception e)
            {
                log.Info(e.Message);
                isFileSaved = false;
            }
            return(omData);
        }