Пример #1
0
        public async Task <Object> ExportAllBusinessUsers(Guid businessID, string fileType)
        {
            try
            {
                string downloadUrl = null;
                string folder      = FoldersNames.ExportedData;

                var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);

                var listOfBusinessUsersToExport = await Task.Run(() => _projectContextDB.ExportBusinessUsersModel.
                                                                 FromSqlRaw("select * from exportallbusinessusers(@thebusinessid)", businessId)
                                                                 .Select(e => new ExportBusinessUsersModel()
                {
                    BusinessName = e.BusinessName,
                    UserName = e.UserName
                }).ToList());

                if (fileType.ToLower() == "excel")
                {
                    downloadUrl = _commonLogic.ExportToExcel(listOfBusinessUsersToExport, folder);
                }

                //create a datatable of this data
                var listOfBusinessUsersInDataTable = _commonLogic.ToDataTable(listOfBusinessUsersToExport);


                if (fileType.ToLower() == "csv")
                {
                    downloadUrl = _commonLogic.ExportToCsv(listOfBusinessUsersInDataTable, folder);
                }

                if (fileType.ToLower() == "pdf")
                {
                    downloadUrl = _commonLogic.ExportToPdf(listOfBusinessUsersInDataTable, folder);
                }

                var exportedData = new { Success = "OK", Data = downloadUrl };

                return(exportedData);
            }

            catch (Exception e)
            {
                return(null);
            }
        }
Пример #2
0
        public async Task <Object> ExportAllUsers(string fileType)
        {
            try
            {
                string downloadUrl = null;
                string folder      = FoldersNames.ExportedData;

                var listOfUsersToBeExported = await Task.Run(() => _projectContextDB.ExportUserModel
                                                             .FromSqlRaw("select * from Exportallusers()")
                                                             .Select(e => new ExportUserModel()
                {
                    UserName = e.UserName,
                    UserFirstName = e.UserFirstName,
                    UserLastName = e.UserLastName,
                    UserEmail = e.UserEmail,
                    UserContact = e.UserContact
                }).ToList());


                if (fileType.ToLower() == "excel")
                {
                    downloadUrl = _commonLogic.ExportToExcel(listOfUsersToBeExported, folder);
                }

                var listOfUserInDataTable = _commonLogic.ToDataTable(listOfUsersToBeExported);

                if (fileType.ToLower() == "csv")
                {
                    downloadUrl = _commonLogic.ExportToCsv(listOfUserInDataTable, folder);
                }

                if (fileType.ToLower() == "pdf")
                {
                    downloadUrl = _commonLogic.ExportToPdf(listOfUserInDataTable, folder);
                }

                var exportedData = new { Success = "OK", Data = downloadUrl };

                return(exportedData);
            }
            catch (Exception e)
            {
                return(null);
            }
        }
Пример #3
0
        public async Task <object> ExportAllEmployees(Guid businessID, string fileType)
        {
            try
            {
                string downlaodUrl = null;
                string folder      = FoldersNames.ExportedData;

                var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);

                var listOfEmployeesDataToBeExport = await Task.Run(() => _projectContextDB.ExportEmployeeModels.
                                                                   FromSqlRaw("select * from exportallemployees(@thebusinessid)", businessId)
                                                                   .Select(e => new ExportEmployeeModel()
                {
                    EmployeeName = e.EmployeeName,
                    EmployeeGender = e.EmployeeGender,
                    EmployeeSSN = e.EmployeeSSN,
                    DepartmentName = e.DepartmentName,

                    CreationDate = Convert.ToString(e.CreationDate),
                    Status = e.Status,
                    BPS = e.BPS,
                    EmpDesignation = e.EmpDesignation,
                    PACountry = e.PACountry,
                    PACity = e.PACity,
                    PAProvince = e.PAProvince,
                    PAZip = e.PAZip,
                    MACountry = e.MACountry,
                    MACity = e.MACity,
                    MAProvince = e.MAProvince,
                    MAZip = e.MAZip,
                    EmpEmail = e.EmpEmail,
                    EmpJoiningDate = Convert.ToString(e.EmpJoiningDate),
                    EmpAppointmentDate = Convert.ToString(e.EmpAppointmentDate),
                    Description = e.Description,
                    Photo = e.Photo,
                    SkypeUserName = e.SkypeUserName,
                    EmpOfficeNo = e.EmpOfficeNo,
                    EmpCellNo = e.EmpCellNo
                }).ToList());


                if (fileType.ToLower() == "excel")
                {
                    downlaodUrl = _commonLogic.ExportToExcel(listOfEmployeesDataToBeExport, folder);
                }

                //create a datatable of this data
                var listOfemployeesInDataTable = _commonLogic.ToDataTable(listOfEmployeesDataToBeExport);

                if (fileType.ToLower() == "csv")
                {
                    downlaodUrl = _commonLogic.ExportToCsv(listOfemployeesInDataTable, folder);
                }

                if (fileType.ToLower() == "pdf")
                {
                    downlaodUrl = _commonLogic.ExportToPdf(listOfemployeesInDataTable, folder);
                }

                var exportedData = new { Success = "OK", Data = downlaodUrl };

                return(exportedData);
            }
            catch (Exception e)
            {
                return(null);
            }
        }