public ResponseModel GetStoreFileUploadLogs()
        {
            ResponseModel         objResponseModel = new ResponseModel();
            List <FileUploadLogs> objresponseModel = new List <FileUploadLogs>();
            int    statusCode    = 0;
            string statusMessage = "";
            int    fileuploadFor = 0;

            try
            {
                //Get token (Double encrypted) and get the tenant id
                string       token        = Convert.ToString(Request.Headers["X-Authorized-Token"]);
                Authenticate authenticate = new Authenticate();
                authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
                StoreFileUploadCaller storeFileUploadCaller = new StoreFileUploadCaller();
                objresponseModel              = storeFileUploadCaller.GetFileUploadLogs(new StoreFileUploadService(_connectioSting, rootPath), authenticate.TenantId, fileuploadFor);
                statusCode                    = objresponseModel.Count == 0 ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
                statusMessage                 = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
                objResponseModel.Status       = true;
                objResponseModel.StatusCode   = statusCode;
                objResponseModel.Message      = statusMessage;
                objResponseModel.ResponseData = objresponseModel;
            }
            catch (Exception)
            {
                throw;
            }

            return(objResponseModel);
        }
Beispiel #2
0
        public ResponseModel BulkUploadStoreSLA(int SLAFor = 3)
        {
            string                DownloadFilePath    = string.Empty;
            string                BulkUploadFilesPath = string.Empty;
            bool                  errorfilesaved      = false;
            bool                  successfilesaved    = false;
            int                   count            = 0;
            List <string>         CSVlist          = new List <string>();
            StoreSLACaller        newSLA           = new StoreSLACaller();
            StoreFileUploadCaller fileU            = new StoreFileUploadCaller();
            ResponseModel         objResponseModel = new ResponseModel();
            int                   StatusCode       = 0;
            string                statusMessage    = "";
            string                fileName         = "";
            string                finalAttchment   = "";
            string                timeStamp        = DateTime.Now.ToString("ddmmyyyyhhssfff");
            DataSet               DataSetCSV       = new DataSet();

            string[] filesName = null;


            try
            {
                var files = Request.Form.Files;

                string       _token       = Convert.ToString(Request.Headers["X-Authorized-Token"]);
                Authenticate authenticate = new Authenticate();
                authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(_token));



                if (files.Count > 0)
                {
                    for (int i = 0; i < files.Count; i++)
                    {
                        fileName += files[i].FileName.Replace(".", "_" + authenticate.UserMasterID + "_" + timeStamp + ".") + ",";
                    }
                    finalAttchment = fileName.TrimEnd(',');
                }

                #region FilePath
                string Folderpath = Directory.GetCurrentDirectory();
                filesName = finalAttchment.Split(",");


                BulkUploadFilesPath = Path.Combine(Folderpath, BulkUpload, UploadFiles, CommonFunction.GetEnumDescription((EnumMaster.FileUpload)SLAFor));
                DownloadFilePath    = Path.Combine(Folderpath, BulkUpload, DownloadFile, CommonFunction.GetEnumDescription((EnumMaster.FileUpload)SLAFor));


                if (!Directory.Exists(BulkUploadFilesPath))
                {
                    Directory.CreateDirectory(BulkUploadFilesPath);
                }



                if (files.Count > 0)
                {
                    for (int i = 0; i < files.Count; i++)
                    {
                        using (var ms = new MemoryStream())
                        {
                            files[i].CopyTo(ms);
                            var          fileBytes = ms.ToArray();
                            MemoryStream msfile    = new MemoryStream(fileBytes);
                            FileStream   docFile   = new FileStream(Path.Combine(BulkUploadFilesPath, filesName[i]), FileMode.Create, FileAccess.Write);
                            msfile.WriteTo(docFile);
                            docFile.Close();
                            ms.Close();
                            msfile.Close();
                            string s = Convert.ToBase64String(fileBytes);
                            byte[] a = Convert.FromBase64String(s);
                            // act on the Base64 data
                        }
                    }
                }

                #endregion



                DataSetCSV = CommonService.csvToDataSet(Path.Combine(BulkUploadFilesPath, filesName[0]));
                CSVlist    = newSLA.StoreSLABulkUpload(new StoreSLAService(_connectioSting), authenticate.TenantId, authenticate.UserMasterID, DataSetCSV);


                #region Create Error and Success files and  Insert in FileUploadLog

                string SuccessFileName = "Store_SLASuccessFile_" + timeStamp + ".csv";
                string ErrorFileName   = "Store_SLAErrorFile_" + timeStamp + ".csv";

                string SuccessFileUrl = !string.IsNullOrEmpty(CSVlist[0]) ?
                                        rootPath + BulkUpload + "/" + DownloadFile + "/" + CommonFunction.GetEnumDescription((EnumMaster.FileUpload)SLAFor) + "/Success/" + SuccessFileName : string.Empty;
                string ErrorFileUrl = !string.IsNullOrEmpty(CSVlist[1]) ?
                                      rootPath + BulkUpload + "/" + DownloadFile + "/" + CommonFunction.GetEnumDescription((EnumMaster.FileUpload)SLAFor) + "/Error/" + ErrorFileName : string.Empty;

                if (!string.IsNullOrEmpty(CSVlist[0]))
                {
                    successfilesaved = CommonService.SaveFile(Path.Combine(DownloadFilePath, "Success", SuccessFileName), CSVlist[0]);
                }

                if (!string.IsNullOrEmpty(CSVlist[1]))
                {
                    errorfilesaved = CommonService.SaveFile(Path.Combine(DownloadFilePath, "Error", ErrorFileName), CSVlist[1]);
                }

                count = fileU.CreateFileUploadLog(new StoreFileUploadService(_connectioSting), authenticate.TenantId, filesName[0], true,
                                                  ErrorFileName, SuccessFileName, authenticate.UserMasterID, "Store_SLA", SuccessFileUrl, ErrorFileUrl, SLAFor);
                #endregion

                StatusCode                    = count > 0 ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;
                statusMessage                 = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)StatusCode);
                objResponseModel.Status       = true;
                objResponseModel.StatusCode   = StatusCode;
                objResponseModel.Message      = statusMessage;
                objResponseModel.ResponseData = count;
            }
            catch (Exception)
            {
                throw;
            }
            return(objResponseModel);
        }
Beispiel #3
0
        public ResponseModel BulkUploadCampaign()
        {
            string downloadFilePath    = string.Empty;
            string bulkUploadFilesPath = string.Empty;
            bool   errorFileSaved      = false;
            bool   successFileSaved    = false;
            int    count = 0;

            ModulesSettingColler  modulesSettingColler = new ModulesSettingColler();
            StoreFileUploadCaller fileU            = new StoreFileUploadCaller();
            ResponseModel         objResponseModel = new ResponseModel();
            int           statusCode     = 0;
            string        statusMessage  = "";
            DataSet       dataSetCSV     = new DataSet();
            string        fileName       = "";
            string        finalAttchment = "";
            string        timeStamp      = DateTime.Now.ToString("ddmmyyyyhhssfff");
            List <string> CSVlist        = new List <string>();

            int ItemFor = 3;

            try
            {
                var    exePath        = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().CodeBase);
                Regex  appPathMatcher = new Regex(@"(?<!fil)[A-Za-z]:\\+[\S\s]*?(?=\\+bin)");
                string appRoot        = appPathMatcher.Match(exePath).Value;
                string folderpath     = appRoot;

                var files = Request.Form.Files;

                #region FilePath
                bulkUploadFilesPath = folderpath + "\\" + "BulkUpload\\UploadFiles" + "\\" + CommonFunction.GetEnumDescription((EnumMaster.FileUpload)ItemFor);
                downloadFilePath    = folderpath + "\\" + "BulkUpload\\DownloadFiles" + "\\" + CommonFunction.GetEnumDescription((EnumMaster.FileUpload)ItemFor);

                #endregion


                if (files.Count > 0)
                {
                    bulkUploadFilesPath = bulkUploadFilesPath + "\\Campaign\\";

                    if (!Directory.Exists(bulkUploadFilesPath))
                    {
                        Directory.CreateDirectory(bulkUploadFilesPath);
                    }

                    for (int i = 0; i < files.Count; i++)
                    {
                        fileName = files[i].FileName.Replace(".", timeStamp + ".") + ",";
                        fileName = fileName.TrimEnd(',');

                        finalAttchment = fileName;

                        using (var ms = new MemoryStream())
                        {
                            files[i].CopyTo(ms);
                            var          fileBytes = ms.ToArray();
                            MemoryStream msfile    = new MemoryStream(fileBytes);
                            FileStream   docFile   = new FileStream(bulkUploadFilesPath + "\\" + fileName, FileMode.Create, FileAccess.Write);
                            msfile.WriteTo(docFile);
                            docFile.Close();
                            ms.Close();
                            msfile.Close();
                            string s = Convert.ToBase64String(fileBytes);
                            byte[] a = Convert.FromBase64String(s);
                            // act on the Base64 data
                        }
                    }
                }
                else
                {
                    statusCode                    = (int)EnumMaster.StatusCode.ButNoBody;
                    statusMessage                 = CommonFunction.GetEnumDescription((EnumMaster.StatusCode.ButNoBody));
                    objResponseModel.Status       = false;
                    objResponseModel.StatusCode   = statusCode;
                    objResponseModel.Message      = statusMessage;
                    objResponseModel.ResponseData = 0;

                    return(objResponseModel);
                }

                string       token        = Convert.ToString(Request.Headers["X-Authorized-Token"]);
                Authenticate authenticate = new Authenticate();
                authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));



                dataSetCSV = CommonService.csvToDataSet(bulkUploadFilesPath + "\\" + finalAttchment);
                CSVlist    = modulesSettingColler.CampaignBulkUpload(new ModulesSettingService(_connectioSting), authenticate.TenantId, authenticate.UserMasterID, ItemFor, dataSetCSV);

                #region Create Error and Succes files and  Insert in FileUploadLog

                if (!string.IsNullOrEmpty(CSVlist[0]))
                {
                    successFileSaved = CommonService.SaveFile(downloadFilePath + "\\Campaign\\Success" + "\\" + "CampaignSuccessFile.csv", CSVlist[1]);
                }

                if (!string.IsNullOrEmpty(CSVlist[1]))
                {
                    errorFileSaved = CommonService.SaveFile(downloadFilePath + "\\Campaign\\Error" + "\\" + "CampaignErrorFile.csv", CSVlist[0]);
                }



                count = fileU.CreateFileUploadLog(new StoreFileUploadService(_connectioSting), authenticate.TenantId, finalAttchment, errorFileSaved,
                                                  "CategoryErrorFile.csv", "CategorySuccessFile.csv", authenticate.UserMasterID, "Item",
                                                  downloadFilePath + "\\Campaign\\Error" + "\\" + "CampaignErrorFile.csv",
                                                  downloadFilePath + "\\Campaign\\Success" + "\\" + "CampaignSuccessFile.csv", ItemFor
                                                  );
                #endregion

                statusCode                    = successFileSaved ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;
                statusMessage                 = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
                objResponseModel.Status       = true;
                objResponseModel.StatusCode   = statusCode;
                objResponseModel.Message      = statusMessage;
                objResponseModel.ResponseData = CSVlist.Count;
            }
            catch (Exception)
            {
                throw;
            }
            return(objResponseModel);
        }