示例#1
0
        public static void SendMailReport(string reportName, string reportTitle,
                                          List <ParameterValue> parameters, string company,
                                          string emailTo, string Subject, string body)
        {
            string deviceInfo = null;
            string extension  = string.Empty;
            string mimeType   = string.Empty;
            string encoding   = string.Empty;

            Warning[] warnings  = null;
            string[]  streamIDs = null;
            string    historyId = null;

            Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-us");

            // Create a Report Execution object
            var rsExec = new ReportExecutionService()
            {
                ExecutionHeaderValue = new ExecutionHeader(),
                Timeout = Timeout.Infinite
            };

            rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rsExec.Url         = ReportServer + "/ReportExecution2005.asmx";

            // Load the report
            ExecutionInfo execInfo = rsExec.LoadReport("/Report/" + reportName, historyId);
            TblCompany    companyRow;

            using (var context = new WorkFlowManagerDBEntities())
            {
                companyRow = context.TblCompanies.FirstOrDefault(x => x.DbName == company);
            }
            string Ip = companyRow.Ip + companyRow.Port;

            foreach (var item in execInfo.Parameters)
            {
                try
                {
                    if (item.Name == "Ip" && !string.IsNullOrWhiteSpace(Ip))
                    {
                        parameters.Add(new ParameterValue()
                        {
                            Name = item.Name, Value = Ip
                        });
                        continue;
                    }
                    if (item.Name == "Database" && !string.IsNullOrWhiteSpace(company))
                    {
                        parameters.Add(new ParameterValue()
                        {
                            Name = item.Name, Value = company
                        });
                        continue;
                    }
                    //parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter(item.Name, para[count]));
                }
                catch (Exception) { }
            }

            rsExec.SetExecutionParameters(parameters.ToArray(), "en-us");

            // get pdf of report
            byte[] results = rsExec.Render("PDF", deviceInfo,
                                           out extension, out encoding,
                                           out mimeType, out warnings, out streamIDs);

            //Walla...almost no code, it's easy to manage and your done.

            //Take the bytes and add as an attachment to a MailMessage(SMTP):

            var attach = new Attachment(new MemoryStream(results), string.Format("{0}.pdf", reportTitle));

            string emailFrom;
            var    service = new GlOperations.GlService();

            try
            {
                emailFrom = service.GetRetailChainSetupByCode("CashDepositeFromMail", company).sSetupValue;
            }
            catch (Exception ex)
            {
                new AssistanceService().SaveLog(JsonConvert.SerializeObject(ex), 0);
                emailFrom = "*****@*****.**";
            }

            SendEmail(attach, emailFrom, emailTo.Split(';').ToList(), Subject, body);
        }
示例#2
0
        public int UpdateNewUsersRequest(NewUserRequests UserRequest)
        {
            int    Result = 0;
            string dbName = "";

            TblAuthUser LikeUser = new TblAuthUser();

            using (var context = new WorkFlowManagerDBEntities())
            {
                var currentUserRequest = context.TblAddUserRequests.FirstOrDefault
                                             (x => x.UserCreateRequestID == UserRequest.UserCreateRequestID &&
                                             x.NewUserID == UserRequest.NewUserID & x.NewUserCompanyID == UserRequest.NewUserCompanyID);

                currentUserRequest.Approved    = UserRequest.Approved;
                currentUserRequest.Rejected    = UserRequest.Rejected;
                currentUserRequest.ApproveDate = DateTime.Now;

                /*************************************Approved User*********************************/
                if (currentUserRequest.Approved == "1")
                {
                    LikeUser = context.TblAuthUsers.FirstOrDefault(x => x.PayrollCode == UserRequest.LikeUserID);

                    int _NewUserCompanyID = int.Parse(UserRequest.NewUserCompanyID);
                    dbName = context.TblCompanies.FirstOrDefault(x => x.Iserial == _NewUserCompanyID).DbName;

                    //Create New User Login

                    TblAuthUser CreateNewUser = new TblAuthUser();
                    CreateNewUser.UserName     = currentUserRequest.UserName;
                    CreateNewUser.UserPassword = currentUserRequest.UserPassword;
                    CreateNewUser.Code         = string.Format(@"{0}{1}", currentUserRequest.NewUserID, currentUserRequest.NewUserCompanyID);
                    CreateNewUser.TblCompany   = int.Parse(currentUserRequest.NewUserCompanyID);
                    CreateNewUser.PayrollCode  = currentUserRequest.NewUserID;
                    CreateNewUser.Ename        = currentUserRequest.UserName;
                    CreateNewUser.Aname        = currentUserRequest.UserName;
                    CreateNewUser.TblJob       = LikeUser.TblJob;
                    CreateNewUser.CurrLang     = LikeUser.CurrLang;
                    context.TblAuthUsers.AddObject(CreateNewUser);
                }

                context.SaveChanges();
            }

            if (UserRequest.Approved == "1" && UserRequest.IsSalesPerson == "1")
            {
                Operations.GlOperations.GlService service = new Operations.GlOperations.GlService();
                using (var newContext = new ccnewEntities(service.GetSqlConnectionString(dbName)))
                {
                    TBLSalesPerson newRow = new TBLSalesPerson();

                    int NextSerial = newContext.TBLSalesPersons.Select(x => x.ISerial).Max();
                    newRow.ISerial = NextSerial + 1;
                    newRow.Ename   = UserRequest.UserName;
                    newRow.Aname   = UserRequest.UserName;
                    newRow.Code    = UserRequest.NewUserID;
                    newContext.TBLSalesPersons.AddObject(newRow);
                    if (UserRequest.IsRetailPerson == "1")
                    {
                        TblUser newUser = new TblUser();
                        TblUser oldUser = newContext.TblUsers.FirstOrDefault(x => x.Code == UserRequest.LikeUserID);

                        try
                        {
                            int NextUserSerial = newContext.TblUsers.Select(x => x.iserial).Max();
                            newUser.iserial         = NextUserSerial + 1;
                            newUser.Ename           = UserRequest.UserName;
                            newUser.Aname           = UserRequest.UserName;
                            newUser.Code            = UserRequest.NewUserID;
                            newUser.UserPassword    = UserRequest.UserPassword;
                            newUser.TblJob          = oldUser.TblJob;
                            newUser.Active          = oldUser.Active;
                            newUser.CurrLang        = oldUser.CurrLang;
                            newUser.ReportFont      = oldUser.ReportFont;
                            newUser.ActiveCashMach  = oldUser.ActiveCashMach;
                            newUser.ActiveStore     = oldUser.ActiveStore;
                            newUser.RegNo           = oldUser.RegNo;
                            newUser.AllowedStores   = oldUser.AllowedStores;
                            newUser.AllowedStoresTo = oldUser.AllowedStoresTo;
                            newContext.TblUsers.AddObject(newUser);
                        }
                        catch { }
                    }
                    newContext.SaveChanges();
                }

                AddUserToActiveDirectory(UserRequest);
            }

            return(Result);
        }