public string GetSLXConnectionString()
{
string result = string.Empty;
Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get <Sage.Platform.Data.IDataService>();
return(service.GetConnectionString());
}
public static void btnPrint_OnClickStep(IRNReportDetails form, EventArgs args)
{
// TODO: Complete business rule implementation
IAttachment attachment = null;
string pluginid = string.Empty;
Sage.Entity.Interfaces.IRNReport parentEntity = form.CurrentEntity as Sage.Entity.Interfaces.IRNReport;
if (ReportsHelper.GetPluginId("RNReport:Irnreport", out pluginid))
{
WebReportingClass reporting = new WebReportingClass();
Sage.Platform.Data.IDataService datasvc = MySlx.Data.CurrentConnection;
Sage.Entity.Interfaces.IUser user = MySlx.Security.CurrentSalesLogixUser;
string tempPath = Rules.GetTempAttachmentPath();
string ConnectionString = datasvc.GetConnectionString();
string report = reporting.GenerateReport(ConnectionString, datasvc.Server, DatabaseServer.dsMSSQL, tempPath, false, false, "RNREPORT.RNREPORTID", "", pluginid, "", "", "", "SELECT RNREPORT.RNREPORTID FROM RNREPORT", string.Format("(RNREPORT.RNREPORTID = '{0}')", parentEntity.Id), user.Id.ToString(), user.UserName.ToString());
ReportDocument doc = new ReportDocument();
report = string.Format("{0}run\\{1}", tempPath, report);
doc.Load(report);
string filename = string.Format("{0}\\{1}_v{2}.pdf", Rules.GetAttachmentPath(), parentEntity.ReferenceNumber.Replace(" ", "_"), 1);
doc.ExportToDisk(ExportFormatType.PortableDocFormat, filename);
doc.Close();
attachment = Sage.Platform.EntityFactory.Create <IAttachment>();
attachment.Description = string.Format("{0} v{1}", parentEntity.ReferenceNumber, 1);
attachment.InsertFileAttachment(filename);
attachment.RNREPORTID = Convert.ToString(parentEntity.Id);
attachment.Save();
System.IO.File.Delete(report);
}
}
private static WebUserConfiguration GetConfiguration()
{
if (_Config == null)
{
Sage.Platform.Data.IDataService data = ApplicationContext.Current.Services.Get <Sage.Platform.Data.IDataService>();
if (data != null)
{
Sage.Platform.VirtualFileSystem.VFSQuery.ConnectToVFS(data.GetConnectionString());
}
Sage.Platform.Configuration.ConfigurationManager manager = ApplicationContext.Current.Services.Get <Sage.Platform.Configuration.ConfigurationManager>(true);
if (!manager.IsConfigurationTypeRegistered(typeof(WebUserConfiguration)))
{
manager.RegisterConfigurationType(typeof(WebUserConfiguration));
}
_Config = (WebUserConfiguration)manager.GetConfiguration(typeof(WebUserConfiguration));
}
return(_Config);
}
public static T GetField <T>(string Field, string Table, string Where)
{
string sql = string.Format("select {0} from {1} where {2}", Field, Table, (Where.Equals(string.Empty) ? "1=1" : Where));
//get the DataService to get a connection string to the database
Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get <Sage.Platform.Data.IDataService>();
using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(datasvc.GetConnectionString()))
{
conn.Open();
using (OleDbCommand cmd = new OleDbCommand(sql, conn))
{
object fieldval = cmd.ExecuteScalar();
return(fieldval == DBNull.Value ? default(T) : (T)fieldval);
}
}
}
private static Boolean IsMember(string TeamName, string Type)
{
Boolean blnReturn = false; // Intialize False
//Get Current user
Sage.SalesLogix.Security.SLXUserService usersvc = (Sage.SalesLogix.Security.SLXUserService)Sage.Platform.Application.ApplicationContext.Current.Services.Get <Sage.Platform.Security.IUserService>();
Sage.Entity.Interfaces.IUser currentuser = usersvc.GetUser();
// get the DataService to get a connection string to the database
string SQL = "";
SQL = "select accessid from secrights where seccodeid = ";
SQL += " (select seccodeid from seccode where (seccodedesc = '" + TeamName + "') ";
SQL += " and (seccodetype = '" + Type + "')) and (accessid = '" + currentuser.Id.ToString() + "')";
Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get <Sage.Platform.Data.IDataService>();
using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(datasvc.GetConnectionString()))
{
conn.Open();
using (System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn))
{
OleDbDataReader reader = cmd.ExecuteReader();
//loop through the reader
while (reader.Read())
{
if (reader["accessid"].ToString() != string.Empty)
{
blnReturn = true;
}
}
reader.Close();
}
}
return(blnReturn);
}