/// <summary>
/// Retrieve unread messages
/// </summary>
public void UpdateMessages()
{
if (SelectedUser == null)
{
return;
}
BL.DataContext msgdatacontext = new BL.DataContext();
////THIS IS WRONG BUT CANT GET GRID TO PULL DATA
messageList.Clear();
Parallel.ForEach(msgdatacontext.EntitySystemContext.SYS_MSG_Message.Where(n => (n.FromId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && n.ToId == SelectedUser.Id) || (n.ToId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && n.FromId == SelectedUser.Id)), message =>
{
if (message.ToId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && message.ReceivedOn == null)
{
message.Received = true;
message.ReceivedOn = BL.ApplicationDataContext.Instance.ServerDateTime;
}
messageList.Add(message);
});
//messageList = msgdatacontext.EntitySystemContext.SYS_MSG_Message.Where(n => (n.FromId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && n.ToId == SelectedUser.Id) || (n.ToId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && n.FromId == SelectedUser.Id)).ToList();
//messageList.Where(n => n.ToId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && n.ReceivedOn == null).ToList().ForEach(n => n.Received = true);
//messageList.Where(n => n.ToId == BL.ApplicationDataContext.Instance.LoggedInUser.PersonId && n.ReceivedOn == null).ToList().ForEach(n => n.ReceivedOn = BL.ApplicationDataContext.Instance.ServerDateTime);
try
{
using (TransactionScope transaction = DataContext.GetTransactionScope())
{
msgdatacontext.SaveChangesEntitySystemContext();
DataContext.CompleteTransaction(transaction);
}
msgdatacontext.EntitySystemContext.AcceptAllChanges();
}
catch (Exception ex)
{
msgdatacontext.EntitySystemContext.RejectChanges();
if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex))
{
throw ex;
}
}
this.Invoke(new Action(() => UpdateMessagesGrid()));
//grdMessage.Invoke(new Action(() => grdMessage.DataSource = messageList));
}
public CDSService()
{
BL.ApplicationDataContext.Instance.SetConnections(ConfigurationManager.ConnectionStrings["BaseConnection"].ConnectionString, true);
BL.ApplicationDataContext.Instance.SqlCommandTimeOut = Convert.ToInt32(ConfigurationManager.AppSettings["Timeout"]);
DataContext = new BL.DataContext();
}
public static void EmailtoPDF(Essential.BaseForm.ReportTemplateType reportTemplate, long id, string filename, BL.DataContext dataContext)
{
string reportName = null;
//rptReport = BL.RPT.RPT_Report.LoadByName("Sales Document Template", DataContext);
//
//rptReport = BL.RPT.RPT_Report.LoadByName("Picking Slip Document Template", DataContext);
//
//rptReport = BL.RPT.RPT_Report.LoadByName("Purchase Document Template", DataContext);
//
//rptReport = BL.RPT.RPT_Report.LoadByName("Transfer Document Template", DataContext);
//
//rptReport = BL.RPT.RPT_Report.LoadByName("Stock Document Template", DataContext);
//
//rptReport = BL.RPT.RPT_Report.LoadByName("Work Document Template", DataContext);
//
//rptReport = BL.RPT.RPT_Report.LoadByName("Work Document Template", DataContext);
switch (reportTemplate)
{
case Essential.BaseForm.ReportTemplateType.None:
reportName = "";
break;
case Essential.BaseForm.ReportTemplateType.SalesDocument:
reportName = "Sales Document Template";
break;
case Essential.BaseForm.ReportTemplateType.PurchaseDocument:
reportName = "Purchase Document Template";
break;
case Essential.BaseForm.ReportTemplateType.PickerDocument:
reportName = "Picking Slip Document Template";
break;
case Essential.BaseForm.ReportTemplateType.StockDocument:
reportName = "Stock Document Template";
break;
case Essential.BaseForm.ReportTemplateType.WorkDocument:
reportName = "Work Document Template";
break;
case Essential.BaseForm.ReportTemplateType.TransferDocument:
reportName = "Transfer Document Template";
break;
}
DB.RPT_Report rptReport = BL.RPT.RPT_Report.LoadByName(reportName, dataContext);
if (rptReport == null)
{
return;
}
System.IO.Stream xmlstream = new System.IO.MemoryStream(System.Text.Encoding.UTF8.GetBytes(rptReport.Data));
DevExpress.XtraReports.UI.XtraReport report = new DevExpress.XtraReports.UI.XtraReport();
report.LoadLayoutFromXml(xmlstream);
if (report.DataSource is DevExpress.DataAccess.Sql.SqlDataSource)
{
((DevExpress.DataAccess.Sql.SqlDataSource)(report.DataSource)).Connection.ConnectionString = BL.ApplicationDataContext.Instance.SqlConnectionString.ConnectionString;
}
else if (report.DataSource is DevExpress.DataAccess.EntityFramework.EFDataSource)
{
((DevExpress.DataAccess.EntityFramework.EFDataSource)(report.DataSource)).Connection.ConnectionString = BL.ApplicationDataContext.Instance.EntityViewConnectionString.ConnectionString;
}
else
{
throw new Exception("Data Source type not implemented in reports");
}
//adp.SelectCommand.Connection.ConnectionString = BL.ApplicationDataContext.Instance.SqlConnectionString.ConnectionString;
DevExpress.XtraReports.Parameters.ParameterCollection Parameters = new DevExpress.XtraReports.Parameters.ParameterCollection();
Parameters.Add(new DevExpress.XtraReports.Parameters.Parameter()
{
Name = "DocumentId", Value = id
});
if (Parameters.Count != 0)
{
foreach (var extparam in Parameters)
{
foreach (var param in report.Parameters)
{
if (extparam.Name == param.Name)
{
param.Value = extparam.Value;
break;
}
}
}
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
report.ExportToPdf(ms);
CDS.Client.Desktop.Essential.UTL.SendMailForm mail = new CDS.Client.Desktop.Essential.UTL.SendMailForm();
mail.AttachFile(ms, filename);
mail.ShowDialog();
}
public ReportExtension()
{
DataContext = new BL.DataContext();
}