private void SetGridView()
        {
            GridViewDef view = new GridViewDef(GridViewDef.DefaultViewName);
            ObservableList <GridColView> viewCols = new ObservableList <GridColView>();

            view.GridColsView = viewCols;

            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.AttachmentType, WidthWeight = 100, BindingMode = BindingMode.OneTime
            });
            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.Name, WidthWeight = 200
            });
            viewCols.Add(new GridColView()
            {
                Field = "...", Header = "...", WidthWeight = 20, StyleType = GridColView.eGridColStyleType.Template, CellTemplate = (DataTemplate)this.GridAttachment.Resources["ParamValueExpressionButton"]
            });
            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.ExtraInformation, WidthWeight = 250
            });
            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.ZipIt, WidthWeight = 50, Header = "Zip It", HorizontalAlignment = System.Windows.HorizontalAlignment.Center, StyleType = GridColView.eGridColStyleType.Template, CellTemplate = (DataTemplate)this.GridAttachment.Resources["ReportAttachment"]
            });

            AttachmentsGrid.SetAllColumnsDefaultView(view);
            AttachmentsGrid.InitViewItems();
        }
        private void materialFlatButton1_Click_1(object sender, EventArgs e)
        {
            try
            {
                EmailAttachments emailAttachments = new EmailAttachments();
                var attach       = emailAttachments.BrowseForFile();
                var notAddedList = new List <string>();
                if (attach != (null, null))
                {
                    foreach (var files in attach.Item1.Zip(attach.Item2, (paths, names) => (paths, names)))
                    {
                        var bytes = File.ReadAllBytes(files.paths);
                        var file  = Convert.ToBase64String(bytes);
                        var type  = emailAttachments.GetMIMEType(files.paths);
                        if (type == null)
                        {
                            notAddedList.Add(files.names);
                            continue;
                        }
                        SendGrid.Helpers.Mail.Attachment attachment = new SendGrid.Helpers.Mail.Attachment()
                        {
                            Content  = file,
                            Filename = files.names,
                            Type     = type
                        };
                        attachmentList.Add(attachment);
                    }
                    if (attachmentList.Count >= 1)
                    {
                        AttachmentsGrid.DataSource = null;
                        AttachmentsGrid.DataSource = attachmentList;
                        AttachmentsGrid.Columns["Content"].Visible     = false;
                        AttachmentsGrid.Columns["Type"].Visible        = false;
                        AttachmentsGrid.Columns["ContentId"].Visible   = false;
                        AttachmentsGrid.Columns["Disposition"].Visible = false;
                    }
                    if (notAddedList.Count >= 1)
                    {
                        string list = null;

                        foreach (var x in notAddedList)
                        {
                            list += x + " ";
                        }
                        var msg = $"Súbor/y {list} nebol pridaný, lebo tento typ súboru nie je možné odoslať emailom. Pre informácie o tom, ktoré " +
                                  "súbory nie je možné odoslať otvorte BlockedExtensions.txt";
                        MessageBox.Show(msg);
                    }
                    AttachmentsGrid.ClearSelection();
                }
                else
                {
                    return;
                }
            }
Esempio n. 3
0
 private void InitAttachmentsGrid()
 {
     SetGridView();
     AttachmentsGrid.AddButton("Add Report", AddReport);
     AttachmentsGrid.AddButton("Add File", AddFile);
     if (runSetActionEmailReport.EmailAttachments == null)
     {
         runSetActionEmailReport.EmailAttachments = new ObservableList <EmailAttachment>();
     }
     AttachmentsGrid.DataSourceList = runSetActionEmailReport.EmailAttachments;
 }
        private void InitAttachmentsGrid()
        {
            SetGridView();
            AttachmentsGrid.AddToolbarTool("@AddHTMLReport_16x16.png", "Add Report", HTMLReportsConfigurationConfigWindow);
            AttachmentsGrid.AddToolbarTool("@AddScript_16x16.png", "Add File", new RoutedEventHandler(AddFile));

            if (runSetActionHTMLReportSendEmail.EmailAttachments == null)
            {
                runSetActionHTMLReportSendEmail.EmailAttachments = new ObservableList <EmailAttachment>();
            }
            AttachmentsGrid.RowDoubleClick += HTMLReportsConfigurationConfigWindow;
            AttachmentsGrid.DataSourceList  = runSetActionHTMLReportSendEmail.EmailAttachments;
            DefaultTemplatePickerCbx_Binding();
        }
        private void CreateEmailTempBtn_Click(object sender, EventArgs e)
        {
            try
            {
                using (StudentDBDataContext con = new StudentDBDataContext(conn_str))
                {
                    var exists = con.GetTable <EmailTemplate>().Where(x => x.EmailTemplateName == NameOfTempTextBox.Text && x.IdUser == currentUser.Id);

                    if (exists.Count().Equals(0))
                    {
                        if (!string.IsNullOrEmpty(SubjectTextbox.Text) && !string.IsNullOrEmpty(ContentTextBox.Text) && !string.IsNullOrEmpty(NameOfTempTextBox.Text))
                        {
                            var newTemp = new EmailTemplate()
                            {
                                EmailTemplateName = NameOfTempTextBox.Text,
                                EmailSubject      = SubjectTextbox.Text,
                                EmailContent      = ContentTextBox.Text,
                                IdUser            = currentUser.Id
                            };

                            con.EmailTemplates.InsertOnSubmit(newTemp);
                            con.SubmitChanges();
                            SaveAttachmentsToDB(newTemp);
                        }
                        else
                        {
                            MessageBox.Show("Subjekt alebo správa nie sú vyplnené, pred uložením je potrebné vyplniť tieto polia", "Prázdne polia");
                            return;
                        }
                    }
                    else
                    {
                        var exisEmail = con.EmailTemplates.Where(x => x.IdUser == currentUser.Id && x.Id == (int)TempGridView.CurrentRow.Cells[2].Value);
                        exisEmail.FirstOrDefault().EmailSubject = SubjectTextbox.Text;
                        exisEmail.FirstOrDefault().EmailContent = ContentTextBox.Text;
                        SaveAttachmentsToDB(exisEmail.FirstOrDefault());

                        con.SubmitChanges();
                    }
                    GetEmailTemps(currentUser);
                    AttachmentsGrid.ClearSelection();
                }
            }
            catch (Exception ex)
            {
                Logger logger = new Logger();
                logger.LogError(ex);
            }
        }
        /// <summary>
        /// Load email template
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void materialFlatButton2_Click(object sender, EventArgs e)
        {
            try
            {
                using (StudentDBDataContext con = new StudentDBDataContext(conn_str))
                {
                    if (TempGridView.Rows.Count <= 0)
                    {
                        MessageBox.Show("Nie je vytvorená žiadna emailová šablóna");
                        return;
                    }
                    var loadTemplate = con.GetTable <EmailTemplate>().Where(x => x.IdUser == currentUser.Id && x.Id == (int)TempGridView.CurrentRow.Cells[2].Value);

                    foreach (var mail in loadTemplate)
                    {
                        AttachmentsGrid.DataSource = null;

                        ContentTextBox.Text        = string.Empty;
                        SubjectTextbox.Text        = string.Empty;
                        NameOfTempTextBox.Text     = string.Empty;
                        NameOfTempTextBox.Text     = mail.EmailTemplateName;
                        ContentTextBox.Text        = mail.EmailContent;
                        SubjectTextbox.Text        = mail.EmailSubject;
                        AttachmentsGrid.DataSource = mail.Attachments;
                    }

                    AttachmentsGrid.Columns["FilePath"].Visible        = false;
                    AttachmentsGrid.Columns["IdUSer"].Visible          = false;
                    AttachmentsGrid.Columns["IdEmailTemplate"].Visible = false;
                    AttachmentsGrid.Columns["Id"].Visible            = false;
                    AttachmentsGrid.Columns["EmailTemplate"].Visible = false;
                    AttachmentsGrid.Columns["User"].Visible          = false;

                    AttachmentsGrid.ClearSelection();
                    editMode = true;
                }
            }
            catch (Exception ex)
            {
                Logger logger = new Logger();
                logger.LogError(ex);
            }
        }
Esempio n. 7
0
        private void SetGridView()
        {
            GridViewDef view = new GridViewDef(GridViewDef.DefaultViewName);
            ObservableList <GridColView> viewCols = new ObservableList <GridColView>();

            view.GridColsView = viewCols;

            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.AttachmentType, WidthWeight = 50, BindingMode = BindingMode.OneTime
            });
            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.Name, WidthWeight = 300
            });
            viewCols.Add(new GridColView()
            {
                Field = EmailAttachment.Fields.ZipIt, WidthWeight = 50, StyleType = GridColView.eGridColStyleType.CheckBox
            });

            AttachmentsGrid.SetAllColumnsDefaultView(view);
            AttachmentsGrid.InitViewItems();
        }
        //private void materialFlatButton1_Click(object sender, EventArgs e)
        //{
        //    this.Close();
        //}

        private void AddEmailTemplateAttachmentsBtn_Click(object sender, EventArgs e)
        {
            try
            {
                EmailAttachments emailAttachments = new EmailAttachments();
                var attach       = emailAttachments.BrowseForFile();
                var notAddedList = new List <string>();
                if (attach != (null, null))
                {
                    foreach (var files in attach.Item1.Zip(attach.Item2, (paths, names) => (paths, names)))
                    {
                        var type = emailAttachments.GetMIMEType(files.paths);
                        if (type == null)
                        {
                            notAddedList.Add(files.names);
                            continue;
                        }

                        Attachment attachment = new Attachment()
                        {
                            FilePath = files.paths,
                            FileName = files.names,
                            IdUser   = currentUser.Id,
                        };

                        if (editMode)
                        {
                            using (StudentDBDataContext con = new StudentDBDataContext(conn_str))
                            {
                                var att = attachment;
                                att.IdEmailTemplate = (int)TempGridView.CurrentRow.Cells[2].Value;
                                var emailTemp = con.GetTable <EmailTemplate>().First(x => x.Id == (int)TempGridView.CurrentRow.Cells[2].Value);
                                if (!AttachmentExists(att, emailTemp))
                                {
                                    con.Attachments.InsertOnSubmit(att);
                                    con.SubmitChanges();

                                    AttachmentsGrid.DataSource = null;
                                    AttachmentsGrid.DataSource = con.GetTable <Attachment>().Where(x => x.IdEmailTemplate == (int)TempGridView.CurrentRow.Cells[2].Value);
                                    AttachmentsGrid.Columns["FilePath"].Visible        = false;
                                    AttachmentsGrid.Columns["IdUSer"].Visible          = false;
                                    AttachmentsGrid.Columns["IdEmailTemplate"].Visible = false;
                                    AttachmentsGrid.Columns["Id"].Visible            = false;
                                    AttachmentsGrid.Columns["EmailTemplate"].Visible = false;
                                    AttachmentsGrid.Columns["User"].Visible          = false;

                                    if (notAddedList.Count >= 1)
                                    {
                                        string list = null;

                                        foreach (var x in notAddedList)
                                        {
                                            list += x + " ";
                                        }
                                        var msg = $"Súbor/y {list} nebol pridaný, lebo tento typ súboru nie je možné odoslať emailom. Pre informácie o tom, ktoré " +
                                                  "súbory nie je možné odoslať otvorte BlockedExtensions.txt";
                                        MessageBox.Show(msg);
                                    }
                                }
                                return;
                            }
                        }
                        else if (!attachmentList.Contains(attachment))
                        {
                            attachmentList.Add(attachment);
                        }
                    }
                    if (attachmentList.Count >= 1)
                    {
                        AttachmentsGrid.DataSource = null;
                        AttachmentsGrid.DataSource = attachmentList;
                        AttachmentsGrid.Columns["FilePath"].Visible        = false;
                        AttachmentsGrid.Columns["IdUSer"].Visible          = false;
                        AttachmentsGrid.Columns["IdEmailTemplate"].Visible = false;
                        AttachmentsGrid.Columns["Id"].Visible            = false;
                        AttachmentsGrid.Columns["EmailTemplate"].Visible = false;
                        AttachmentsGrid.Columns["User"].Visible          = false;
                    }
                    if (notAddedList.Count >= 1)
                    {
                        string list = null;

                        foreach (var x in notAddedList)
                        {
                            list += x + " ";
                        }
                        var msg = $"Súbor/y {list} nebol pridaný, lebo tento typ súboru nie je možné odoslať emailom. Pre informácie o tom, ktoré " +
                                  "súbory nie je možné odoslať otvorte BlockedExtensions.txt";
                        MessageBox.Show(msg);
                    }
                }
                else
                {
                    return;
                }
                AttachmentsGrid.ClearSelection();
            }