public void Start()
{
try
{
Logger.Info("load external setting");
ExternalSettings.Default.LoadSettings();
this.GatewayProxy = new GatewayProxy(ExternalSettings.Default.GatewayServiceUrl);
_server = new Server("TransactionServer", "CacheFiles");
this.InitializePriceAlertManager();
_server.Start();
Logger.Info("Start up");
}
catch (Exception ex)
{
Logger.Error(ex);
}
}
//==========================================================================
// 接続と切断
//==========================================================================
jsch::Session create_session(SshUserData user, jsch::Session gateway)
{
msg.Write(1, ". Connecting {0}@{1}", user.user, user.host);
// setting
jsch::Session session = m_jsch.getSession(user.user, user.host, user.port);
session.setConfig(SSH_CONFIG);
session.setUserInfo(new SshLoginInfo(this.msg, user));
session.setPassword(user.pass);
if (gateway != null)
{
GatewayProxy proxy = new GatewayProxy(gateway);
resources.Add(proxy);
session.setProxy(proxy);
}
// connect
session.connect();
resources.Add(session);
return(session);
}
public DataSet GetPreProjectList(ProlianceConnection conn, string prjAccount)
{
DataSet nData = new DataSet();
//List<Attachment> Attachments = GetAttachmentCache();
//List<PreProjectDocument> docs = new List<PreProjectDocument>();
using (var proliance = new GatewayProxy(conn, prjAccount))
{
try
{
var pageInfo = new PageInfo();
pageInfo.SelectFields = new List<OutputField>
{
new OutputField("SmallProjectDocument_DocumentGuid"),
new OutputField("SmallProjectDocument_DocVisualId"),
new OutputField("SmallProjectDocument_DocTitle"),
new OutputField("SmallProjectDocument_DocSubTypeName"),
new OutputField("SmallProjectDocument_WorkflowStateDisplayName"),
new OutputField("SmallProjectDocument_MarketSector_FullCode"),
new OutputField("SmallProjectDocument_ManagerCode_Description"),
new OutputField("SmallProjectDocument_MarketSector_Description"),
new OutputField("SmallProjectDocument_PlannedStartDate"),
new OutputField("SmallProjectDocument_AlternateNumber1"),
new OutputField("SmallProjectDocument_OfficeUnit_FullCode"),
new OutputField("SmallProjectDocument_OfficeUnit_Description"),
new OutputField("SmallProjectDocument_SecuredStatus_FullCode"),
new OutputField("SmallProjectDocument_SecuredStatus_Description"),
new OutputField("SmallProjectDocument_ServiceType_FullCode"),
new OutputField("SmallProjectDocument_ServiceType_Description"),
new OutputField("SmallProjectDocument_Status_FullCode"),
new OutputField("SmallProjectDocument_Status_Description"),
new OutputField("SmallProjectDocument_DocDescription"),
new OutputField("SmallProjectDocument_DocDescriptionFull"),
new OutputField("SmallProjectDocument_ApproximateValueText"),
new OutputField("SmallProjectDocument_WorkflowStateUID"),
new OutputField("SmallProjectDocument_AddressInfoNote"),
new OutputField("SmallProjectDocument_SiteFaxInfoNote"),
new OutputField("SmallProjectDocument_PhoneInfoNote")
};
pageInfo.Filters.Add(new FilterField("SmallProjectDocument_WorkflowStateDisplayName", QueryFilterOperation.NotEqual, "Cancelled", QueryFieldType.DataField, false));
pageInfo.Filters.Add(new FilterField("SmallProjectDocument_DocTitle", QueryFilterOperation.NotEqual, "Program Administration", QueryFieldType.DataField, false));
pageInfo.Filters.FilterRelations = (" 0 & 1 ");
pageInfo.PagedOrderFields.Add(new OrderField("SmallProjectDocument_DocVisualId", QueryFieldType.DataField, QueryOrderAttribute.Ascending));
var ds = proliance.ListDocumentDataSet(DocumentTypeNames.SmallProjectDocument, pageInfo);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
nData = ds;
foreach (DataRow r in nData.Tables[0].Rows)
{
r["SmallProjectDocument_DocVisualId"] = r["SmallProjectDocument_DocVisualId"].ToString().Replace("PI-", "");
r["SmallProjectDocument_ServiceType_Description"] = r["SmallProjectDocument_ServiceType_Description"].ToString().Replace("Band", "");
r["SmallProjectDocument_ManagerCode_Description"] = r["SmallProjectDocument_ManagerCode_Description"].ToString().Replace("Congressional District", "");
r["SmallProjectDocument_OfficeUnit_Description"] = r["SmallProjectDocument_OfficeUnit_Description"].ToString().Replace("County", "");
r["SmallProjectDocument_SecuredStatus_Description"] = r["SmallProjectDocument_SecuredStatus_Description"].ToString().Replace("Status", "");
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex.InnerException);
}
return nData;
}
}
public DataSet GetPreProjectList()
{
DataSet nData = new DataSet();
//var foo = "SmallProjectDocument_PlannedFinishDate"; //TODO: this is for getting the currently shelved planned finish date
using (var proliance = new GatewayProxy(connection, account))
{
try
{
var pageInfo = new PageInfo();
pageInfo.SelectFields = new List<OutputField>
{
new OutputField("SmallProjectDocument_DocumentGuid"),
new OutputField("SmallProjectDocument_DocVisualId"),
new OutputField("SmallProjectDocument_DocTitle"),
new OutputField("SmallProjectDocument_DocSubTypeName"),
new OutputField("SmallProjectDocument_WorkflowStateDisplayName"),
new OutputField("SmallProjectDocument_MarketSector_FullCode"),
new OutputField("SmallProjectDocument_ManagerCode_Description"),
new OutputField("SmallProjectDocument_MarketSector_Description"),
new OutputField("SmallProjectDocument_PlannedStartDate"),
new OutputField("SmallProjectDocument_AlternateNumber1"),
new OutputField("SmallProjectDocument_OfficeUnit_FullCode"),
new OutputField("SmallProjectDocument_OfficeUnit_Description"),
new OutputField("SmallProjectDocument_SecuredStatus_FullCode"),
new OutputField("SmallProjectDocument_SecuredStatus_Description"),
new OutputField("SmallProjectDocument_ServiceType_FullCode"),
new OutputField("SmallProjectDocument_ServiceType_Description"),
new OutputField("SmallProjectDocument_Status_FullCode"),
new OutputField("SmallProjectDocument_Status_Description"),
new OutputField("SmallProjectDocument_DocDescription"),
new OutputField("SmallProjectDocument_DocDescriptionFull"),
new OutputField("SmallProjectDocument_ApproximateValueText"),
new OutputField("SmallProjectDocument_WorkflowStateUID"),
new OutputField("SmallProjectDocument_AddressInfoNote"),
new OutputField("SmallProjectDocument_SiteFaxInfoNote"),
new OutputField("SmallProjectDocument_PhoneInfoNote")//,
//new OutputField(foo)
};
pageInfo.Filters.Add(new FilterField("SmallProjectDocument_WorkflowStateDisplayName", QueryFilterOperation.NotEqual, "Cancelled", QueryFieldType.DataField, false));
pageInfo.Filters.Add(new FilterField("SmallProjectDocument_DocTitle", QueryFilterOperation.NotEqual, "Program Administration", QueryFieldType.DataField, false));
pageInfo.Filters.FilterRelations = (" 0 & 1 ");
pageInfo.PagedOrderFields.Add(new OrderField("SmallProjectDocument_DocVisualId", QueryFieldType.DataField, QueryOrderAttribute.Ascending));
DataSet ds = null;
try
{
ds = proliance.ListDocumentDataSet(DocumentTypeNames.SmallProjectDocument, pageInfo);
} catch (Exception e) {
System.Diagnostics.Debug.Print(e.ToString());
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
nData = ds;
foreach (DataRow r in nData.Tables[0].Rows)
{
r["SmallProjectDocument_DocVisualId"] = r["SmallProjectDocument_DocVisualId"].ToString().Replace("PI-", "");
r["SmallProjectDocument_ServiceType_Description"] = r["SmallProjectDocument_ServiceType_Description"].ToString().Replace("Band", "");
r["SmallProjectDocument_ManagerCode_Description"] = r["SmallProjectDocument_ManagerCode_Description"].ToString().Replace("Congressional District", "");
r["SmallProjectDocument_OfficeUnit_Description"] = r["SmallProjectDocument_OfficeUnit_Description"].ToString().Replace("County", "");
r["SmallProjectDocument_SecuredStatus_Description"] = r["SmallProjectDocument_SecuredStatus_Description"].ToString().Replace("Status", "");
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex.InnerException);
}
return nData;
}
}
public DataSet GetProjectApproxValues()
{
DataSet nData = new DataSet();
using (var proliance = new GatewayProxy(connection, account))
{
try
{
var pageInfo = new PageInfo();
pageInfo.SelectFields = new List<OutputField>
{
new OutputField("ProjectDocument_DocumentGuid"),
};
var ds = proliance.ListDocumentDataSet(DocumentTypeNames.ProjectDocument, pageInfo);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
nData = ds;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex.InnerException);
}
return nData;
}
}
