public ConversationMessageDetails(ConversationMessageModel message) { this.Dispatcher.Invoke(() => { InitializeComponent(); DetailsTable.AddItem("Data: ", message.InitialDate.Value.ToString("dd.MM.yyyy HH:mm")); if (message.Attachments.Count == 0) { AttachmentListContainer.Visibility = Visibility.Collapsed; } else { foreach (FileModel attachment in message.Attachments) { FileListItem listItem = new FileListItem(attachment); listItem.AllowDelete = false; listItem.AllowDownload = false; listItem.AllowRename = false; listItem.AllowSelect = false; AttachmentList.Children.Add(listItem); } } if (message is ConversationEmailMessageModel) { ConversationEmailMessageModel emailMessage = (ConversationEmailMessageModel)message; EmailAddressModel email = message.Author.EmailAddresses.Find(obj => obj.Id == message.AuthorFrom); DetailsTable.AddItem("Od: ", message.Author.FullName + " <" + email.Address + ">"); SubjectLabel.Text = emailMessage.MessageSubject; MessageContainer.Text = emailMessage.MessageContent; } else if (message is ConversationPhoneMessageModel) { ConversationPhoneMessageModel phoneMessage = (ConversationPhoneMessageModel)message; DetailsTable.AddItem("Od: ", message.Author.FullName + " (" + phoneMessage.AuthorPhoneNumber.Number + ")"); DetailsTable.AddItem("Do: ", phoneMessage.Recipient.FullName + " (" + phoneMessage.RecipientPhoneNumber.Number + ")"); SubjectLabelContainer.Visibility = Visibility.Collapsed; if (!phoneMessage.CallAnswered) { CallUnansweredContainer.Visibility = Visibility.Visible; } MessageContainer.Margin = new Thickness(MessageContainer.Margin.Left, 10, MessageContainer.Margin.Right, MessageContainer.Margin.Bottom); MessageContainer.Text = phoneMessage.CallDescription; } CloseButton.PreviewMouseLeftButtonDown += CloseButton_PreviewMouseLeftButtonDown; CloseButton.MouseEnter += CloseButton_MouseEnter; CloseButton.MouseLeave += CloseButton_MouseLeave; }); }
// Function : ExportData // Arguments : table, FormatType, FileName // Purpose : To get all the column headers in the datatable and // exorts in CSV / Excel format with all columns public void ExportData(DataTableCollection tables, ExportFormat FormatType, string FileName) { try { string NewFileName; if (tables == null) { throw new Exception("There are no details to export."); } foreach (DataTable DetailsTable in tables) { if (DetailsTable.Rows.Count == 0) { throw new Exception("There are no details to export."); } NewFileName = FileName.Substring(0, FileName.LastIndexOf(".")); NewFileName += " - " + DetailsTable.TableName; NewFileName += FileName.Substring(FileName.LastIndexOf(".")); // Create Dataset DataSet dsExport = new DataSet("Export"); DataTable dtExport = DetailsTable.Copy(); dtExport.TableName = "Values"; dsExport.Tables.Add(dtExport); // Getting Field Names string[] sHeaders = new string[dtExport.Columns.Count]; string[] sFileds = new string[dtExport.Columns.Count]; for (int i = 0; i < dtExport.Columns.Count; i++) { sHeaders[i] = dtExport.Columns[i].ColumnName; sFileds[i] = dtExport.Columns[i].ColumnName; } if (appType == "Web") { Export_with_XSLT_Web(dsExport, sHeaders, sFileds, FormatType, NewFileName); } else if (appType == "Win") { Export_with_XSLT_Windows(dsExport, sHeaders, sFileds, FormatType, NewFileName); } } } catch (Exception Ex) { throw Ex; } }
public int Upd(DetailsTable aDetailsTable) { try { aDatabaseDA.DetailsTable.AddOrUpdate(aDetailsTable); return aDatabaseDA.SaveChanges(); } catch (Exception ex) { throw new Exception(String.Format("DetailsTableBO.Upd: {0}", ex.Message)); } }