public bool IsTodaySequenceReset()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
DataTable dt = db.ExecuteDataSet(CommandType.Text, "select * from DaySequence").Tables[0];
db.Close();
db = null;
if (dt.Rows.Count == 0)
{
return(false);
}
else
{
if (((DateTime)dt.Rows[0]["DateTime"]).Date == DateTime.Today.Date && (bool)dt.Rows[0]["IsReset"])
{
return(true);
}
else
{
return(false);
}
}
}
public ProposalService(IProposalRepository repository, SystemConfigurations configurations, ICategoryRepository categoryRepository, ISupplierRepository supplierRepository)
{
this.Repository = repository;
this.Configurations = configurations;
this.CategoryRepository = categoryRepository;
this.SupplierRepository = supplierRepository;
}
public static SystemConfigurations GetInstance()
{
if (systemConfigurations == null)
{
systemConfigurations = new SystemConfigurations();
//ApplicationCommonFunctions applicationCommonFunctions = new ApplicationCommonFunctions();
//DataSet ds = applicationCommonFunctions.GetSystemConfigurations();
//if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
//{
//systemConfigurations.ReportFolder = ds.Tables[0].Rows[0]["ReportFolderName"].ToString();
//systemConfigurations.ReportServerDomain = ds.Tables[0].Rows[0]["ReportServerDomain"].ToString();
//systemConfigurations.ReportServerUserName = ds.Tables[0].Rows[0]["ReportServerUserName"].ToString();
//systemConfigurations.ReportServerPassword = ds.Tables[0].Rows[0]["ReportServerPassword"].ToString();
//systemConfigurations.ReportURL = ds.Tables[0].Rows[0]["ReportURL"].ToString();
//}
//else
//{
systemConfigurations.ReportFolder = System.Configuration.ConfigurationManager.AppSettings["ReportFolderName"];
systemConfigurations.ReportServerDomain = System.Configuration.ConfigurationManager.AppSettings["ReportServerDomain"];
systemConfigurations.ReportServerUserName = System.Configuration.ConfigurationManager.AppSettings["ReportServerUserName"];
systemConfigurations.ReportServerPassword = System.Configuration.ConfigurationManager.AppSettings["ReportServerPassword"];
systemConfigurations.ReportURL = System.Configuration.ConfigurationManager.AppSettings["ReportURL"];
//}
}
return(systemConfigurations);
}
public byte[] RenderPDFFromReportViewObject(string reportName, ReportParameter[] reportParameters)
{
CustomReportCredentials objCustomReportCredentials = null;
Uri reportServerURL = null;
try
{
SystemConfigurations systemConfigurations = SystemConfigurations.GetInstance();
reportServerURL = new Uri(systemConfigurations.ReportURL);
string reportServerDomain = systemConfigurations.ReportServerDomain;
string reportServerUserName = systemConfigurations.ReportServerUserName;
string reportServerPassword = systemConfigurations.ReportServerPassword;
string reportFolder = systemConfigurations.ReportFolder;
string[] streamids;
objCustomReportCredentials = new CustomReportCredentials(reportServerUserName, reportServerPassword, reportServerDomain);
ReportViewer1.ServerReport.ReportServerCredentials = objCustomReportCredentials;
ReportViewer1.ServerReport.ReportServerUrl = reportServerURL;
ReportViewer1.ServerReport.ReportPath = "/" + reportFolder + "/" + reportName;
ReportViewer1.ServerReport.SetParameters(reportParameters);
ReportViewer1.ServerReport.Refresh();
return(ReportViewer1.ServerReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings));
}
finally
{
if (reportServerURL != null)
{
reportServerURL = null;
}
if (objCustomReportCredentials != null)
{
objCustomReportCredentials = null;
}
}
}
static void Main(string[] args)
{
for (int i = 0; i < args.Length; i++)
{
Console.WriteLine("Arg[{0}] = [{1}]", i, args[i]);
string param = args[i];
if (param.ToLower() == "resetseq")
{
_resetSequenceNumber = true;
}
}
_resetSequenceNumber = true;
//Console.Title = "Fix Orders Service (Fix Client)";
SystemLogger.Initialize();
SystemConfigurations.Initialize();
NotificationSender.Initialize();
Program prog = new Program();
if (Environment.UserInteractive)
{
prog.OnStart(args);
while (true)
{
Console.ReadKey();
}
}
else
{
ServiceBase.Run(prog);
}
}
public Dictionary <int, Dictionary <int, decimal> > GetFX_Rate()
{
Dictionary <int, Dictionary <int, decimal> > rates = new Dictionary <int, Dictionary <int, decimal> >();
string query = "select * from CurrenciesConversions";
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString("BasicDataDBConnectionString"));
db.Open();
DataSet ds = db.ExecuteDataSet(System.Data.CommandType.Text, query);
db.Close();
db = null;
foreach (DataRow row in ds.Tables[0].Rows)
{
int from = (int)row["CurrencyID_From"];
int to = (int)row["CurrencyID_To"];
decimal rate = (decimal)row["ConversionRate"];
if (!rates.ContainsKey(from))
{
rates.Add(from, new Dictionary <int, decimal>());
}
if (!rates[from].ContainsKey(to))
{
rates[from].Add(to, rate);
}
}
return(rates);
}
public GroupSession[] GetAllGroupsSessions()
{
List <GroupSession> marketsGroups = new List <GroupSession>();
string query = "select * from Markets_Groups_Sessions";
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString("BasicDataDBConnectionString"));
db.Open();
DataSet ds = db.ExecuteDataSet(System.Data.CommandType.Text, query);
db.Close();
db = null;
string today = DateTime.Today.DayOfWeek.ToString();
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row["WorkingDays"].ToString().Contains(today))
{
marketsGroups.Add(new GroupSession()
{
MarketID = row["MarketID"].ToString(),
GroupID = row["GroupID"].ToString(),
ExchangeID = row["ExchangeID"].ToString(),
SessionStartTime = (DateTime)row["SessionStartTime"],
SessionEndTime = (DateTime)row["SessionEndTime"],
WorkingDays = row["WorkingDays"].ToString()
});
}
}
return(marketsGroups.ToArray());
}
private void btnSub_Click(object sender, EventArgs e)
{
//if (MessageBox.Show(this, "Subscribe to FIX orders service ?", "FIX Service", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
using (OrdersProxy proxy = new OrdersProxy())
{
//string path = string.Format(@"{0}\private$\client", Environment.MachineName);
//string path = @"10.30.60.11\private$\client";
//string ip = SystemConfigurations.GetMachineIP();
btnSub.Enabled = false;
if (!isSubscribed)
{
string path = string.Format(@"Formatname:DIRECT=TCP:{0}", SystemConfigurations.GetAppSetting("ResponseQueue"));
proxy.SubscribeSession(path);
}
else
{
proxy.UnsubscribeSession(clientKey);
}
//66A92E99-721E-47C2-B866-FA853E0AE17F
//proxy.ResubscribeMe(new Guid("57D42C89-2EF5-4AEA-9C67-8CE0F0A8088C"), @".\private$\client");
}
}
}
/// <summary>
/// 初始化属于指定服务角色的系统工作者
/// </summary>
/// <param name="role">服务角色</param>
/// <param name="setting">远程配置设置</param>
/// <param name="configurationProxy">远程配置站访问代理器</param>
/// <param name="notificationHandler">异常通知处理器</param>
/// <param name="proxy">KAE资源代理器</param>
/// <exception cref="ArgumentNullException">参数不能为空</exception>
public static void Initialize(string role, RemoteConfigurationSetting setting, IRemoteConfigurationProxy configurationProxy, ITracingNotificationHandler notificationHandler = null, IKAEResourceProxy proxy = null)
{
if (IsInitialized)
{
return;
}
if (setting == null)
{
setting = RemoteConfigurationSetting.Default;
}
if (proxy == null)
{
proxy = new KAEHostResourceProxy();
}
if (string.IsNullOrEmpty(role))
{
throw new ArgumentNullException(nameof(role));
}
if (configurationProxy == null)
{
throw new ArgumentNullException(nameof(configurationProxy));
}
SystemConfigurations.Initialize(role, setting, configurationProxy);
_tracing = TracingManager.GetTracing(typeof(SystemWorker));;
TransactionGlobal.Initialize();
_configurationProxy = configurationProxy;
_hostProxy = proxy;
TracingManager.NotificationHandler = notificationHandler ?? new RemoteLogProxy();
InitializeCore(role);
//initialize long...long memory buffer for tcp layer.
ChannelConst.Initialize();
_isInitialized = true;
IsInSpecifiedKPP = false;
}
public DayOff[] GetAllDaysOff()
{
List <DayOff> daysOff = new List <DayOff>();
string query = "select * from sysdaysoff where convert(nvarchar,getdate(),101) >= convert(nvarchar,datefrom,101) and convert(nvarchar,getdate(),101) <= convert(nvarchar,dateto,101) ";
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString("BasicDataDBConnectionString"));
db.Open();
DataSet ds = db.ExecuteDataSet(System.Data.CommandType.Text, query);
db.Close();
db = null;
string today = DateTime.Today.DayOfWeek.ToString();
foreach (DataRow row in ds.Tables[0].Rows)
{
daysOff.Add(new DayOff()
{
OccasionAr = row["Occasion_Ar"].ToString(),
OccasionEn = row["Occasion_En"].ToString(),
ExchangeID = row["ExchangeID"].ToString(),
DateFrom = (DateTime)row["DateFrom"],
DateTo = (DateTime)row["DateTo"]
});
}
return(daysOff.ToArray());
}
private static bool InternalSendMail(EmailFunctions EmailFunction, List <string> To, string EmailSubject, string EmailContent, List <Attachment> Attachments, out string ErrorMessage)
{
try
{
MailMessage _Message = new MailMessage();
_Message.Subject = EmailSubject;
_Message.SubjectEncoding = System.Text.Encoding.Unicode;
_Message.Body = EmailContent;
_Message.BodyEncoding = System.Text.Encoding.UTF8;
_Message.IsBodyHtml = true;
_Message.Priority = MailPriority.High;
_Message.From = new MailAddress(SystemConfigurations.GetSMTPProperty(EmailFunction, SMTPProperties.From));
To.ForEach(m => { _Message.Bcc.Add(m); });
Attachments.ForEach(attachment => { _Message.Attachments.Add(attachment); });
SmtpClient Client = GetSmtpClient(EmailFunction);
Client.Send(_Message);
ErrorMessage = string.Empty;
return(true);
}
catch (Exception exc)
{
ErrorMessage = exc.Message;
return(false);
}
}
//timer to check connectivity with MCSD should be added to establish connection with MCSD if it went down during the session.
#endregion
#region Constructor
#endregion
#region private members
private static void InitializeDeclerations()
{
try
{
m_MCSDresponseQueueIP = SystemConfigurations.GetAppSetting("MCSDresponseQueueIP");
m_MCSDresponseQueueName = SystemConfigurations.GetAppSetting("MCSDresponseQueueName");
m_MCSDUserName = SystemConfigurations.GetAppSetting("MCSD_UserName");
m_MCSD_Password = SystemConfigurations.GetAppSetting("MCSD_Password");
m_OverrideMCSDQueue = Boolean.Parse(SystemConfigurations.GetAppSetting("OverrideMCSDQueue"));
m_FlushMCSDUpdatesOffline = Boolean.Parse(SystemConfigurations.GetAppSetting("FlushMCSDUpdatesOffline"));
_McsdServicePingIntervals = int.Parse(SystemConfigurations.GetAppSetting("McsdServicePingIntervals"));
m_IncomingMessageDelegate = new IMCDSCallbackHandler.IncomingMessageDelegate(OnIncomingMsg);
m_callbackHandler = new IMCDSCallbackHandler(m_IncomingMessageDelegate);
m_InstanceContext = new InstanceContext(m_callbackHandler);
m_factory = new DuplexChannelFactory <IMcdrAdmin>(m_InstanceContext, "netTcpBinding_IMcdrAdmin");
subRequest = new MCDR.Contract.Entities.ToAdmin.subReq();
}
catch (Exception exp)
{
SystemLogger.LogErrorAsync("MCSDManager Constructor Error: " + exp.ToString());
}
}
public void InitSessions()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
db.ExecuteNonQuery(CommandType.Text, "truncate table [Beltone.FixService].[dbo].[Sessions]");
db.Close();
}
private string ValidateOrder(string username, NewSingleOrder order)
{
if (OrdersManager.CallbackHasReqOrdID(order.RequesterOrderID))
{
return("Requested Order ID already existed for this session.");
}
if (order.DateTime.Date != DateTime.Today.Date)
{
return("Invalid DateTime");
}
if (DateTime.Now.Subtract(order.DateTime).Milliseconds > m_allowableOrderDelayInMilliSeconds)
{
return("Delayed Order");
}
Dictionary <string, object> optionalParam = order.OptionalParam;
if (optionalParam != null)
{
bool aon = false;
if (optionalParam.ContainsKey("AON") && (optionalParam["AON"] == null || !bool.TryParse(optionalParam["AON"].ToString(), out aon)))
{
return("Invalid AON");
}
if (aon)
{
if (!optionalParam.ContainsKey("MinQty"))
{
return("Missing Min. Qty");
}
int minq = 0;
if (optionalParam["MinQty"] == null || !int.TryParse(optionalParam["MinQty"].ToString(), out minq))
{
return("Invalid Min. Qty");
}
if (minq <= 0)
{
return("Invalid Min. Qty");
}
if (minq > order.Quantity)
{
return("Min. quantity should be equal or less than order's quantity");
}
}
if (optionalParam.ContainsKey(ALLOC_REQ_FIELDS.ALLOC_TYPE) && order.OrderSide == "Buy")
{
bool isAllowBuyAllocation = Convert.ToBoolean(SystemConfigurations.GetAppSetting("AllowBuyAllocation"));
if (isAllowBuyAllocation == false)
{
return("Mcsd Allocation for buy orders is not allowed");
}
}
}
return("valid");
}
private void btnSub_Click(object sender, EventArgs e)
{
//if (MessageBox.Show(this, "Subscribe to FIX orders service ?", "FIX Service", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
using (OrdersProxy proxy = new OrdersProxy())
{
btnSub.Enabled = false;
ICallbackHandler m_callbackHandler;
InstanceContext m_InstanceContext;
DuplexChannelFactory <IFixAdmin> m_factory;
ICallbackHandler.IncomingMessageDelegate m_IncomingMessageDelegate = new ICallbackHandler.IncomingMessageDelegate(OnIncomingMsg);
m_callbackHandler = new ICallbackHandler(m_IncomingMessageDelegate);
m_InstanceContext = new InstanceContext(m_callbackHandler);
m_factory = new DuplexChannelFactory <IFixAdmin>(m_InstanceContext, "netTcpBinding_IFixAdmin");
_client = m_factory.CreateChannel();
((ICommunicationObject)_client).Closed += TcpClient_Closed;
((ICommunicationObject)_client).Faulted += tcpClient_Faulted;
//for (int i = 0; i < 3; i++)
//{
try
{
FixAdminMsg returnMsg = _client.Subscribe(
new subReq()
{
Username = "******",
Password = "******",
QueueName = SystemConfigurations.GetAppSetting("ResponseQueueName"),
QueueIP = SystemConfigurations.GetAppSetting("ResponseQueueIP"),
FlushUpdatesOffline = true,
});
//FixAdminMsg returnMsg = _client.Resubscribe(
// new ResupReq()
// {
// SessionKey = new Guid("6D0AC300-CC63-4F34-81B6-B4E6DB358DC6"),
// NewQueue = true,
// QueueName = SystemConfigurations.GetAppSetting("ResponseQueueName"),
// QueueIP = SystemConfigurations.GetAppSetting("ResponseQueueIP"),
// Username = "******",
// Password = "******",
// FlushUpdatesOffline = true,
// });
isConnectedToAdmin = true;
SetReport(returnMsg.Code + " " + returnMsg.Note ?? "");
// Task.Factory.StartNew(() => { while (isConnectedToAdmin) { _client.Ping(); Thread.Sleep(3000); } }, tokenSource.Token);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//}
}
}
}
public DataTable test_GetTodayExecOrders()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
DataTable dtOrders = db.ExecuteDataSet(CommandType.Text, "SELECT SecurityCode,OrderStatus, OrderSide, CurrentQuantity, RemainingQuantity, ExecutedQuantity, LastExecQuantity, CurrentPrice, AvgPrice, IsActive, IsCompleted, LastExecPrice, PlacementDateTime, IsExecuted from orders where Convert(varchar,orders.placementdatetime,101) = Convert(varchar,Getdate(),101) and isExecuted = 1").Tables[0];
db.Close();
return(dtOrders);
}
public DataTable GetTable(string tableName)
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
DataTable dtOrders = db.ExecuteDataSet(CommandType.Text, string.Format("SELECT * from {0}", tableName)).Tables[0];
db.Close();
db = null;
return(dtOrders);
}
private static SmtpClient GetSmtpClient(EmailFunctions EmailFunction)
{
return(new SmtpClient()
{
Host = SystemConfigurations.GetSMTPProperty(EmailFunction, SMTPProperties.Host),
Port = int.Parse(SystemConfigurations.GetSMTPProperty(EmailFunction, SMTPProperties.Port)),
EnableSsl = bool.Parse(SystemConfigurations.GetSMTPProperty(EmailFunction, SMTPProperties.EnableSSL)),
UseDefaultCredentials = false,
Credentials = new NetworkCredential(SystemConfigurations.GetSMTPProperty(EmailFunction, SMTPProperties.Username), SystemConfigurations.GetSMTPProperty(EmailFunction, SMTPProperties.Password)),
});
}
public DataTable FillOrdersRequestIDs()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
DataTable dtOrdersRequests = db.ExecuteDataSet(CommandType.Text, "SELECT RequesterOrderID FROM Orders").Tables[0];
db.Close();
db = null;
return(dtOrdersRequests);
}
public DataTable GetStocksDetails()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString("BasicDataDBConnectionString"));
db.Open();
DataTable dt = db.ExecuteDataSet(CommandType.Text, string.Format("Select * from stocks")).Tables[0];
//List<Guid> subscribersIDs = new List<Guid>();
db.Close();
return(dt);
}
static void Main(string[] args)
{
SystemLogger.Initialize();
SystemConfigurations.Initialize();
Task.Factory.StartNew(() => { OpenFixConn(); });
while (true)
{
Console.ReadLine();
PlaceNewSingleOrder();
}
}
public DataTable FillOrdersData()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
string qeury = "SELECT Orders.*, SessionOrders.* FROM Orders INNER JOIN SessionOrders ON Orders.OrderID = SessionOrders.OrdID where orders.IsActive = 1 or (orders.isactive = 0 and orders.ispending = 1)";
DataTable dtOrders = db.ExecuteDataSet(CommandType.Text, qeury).Tables[0];
db.Close();
db = null;
return(dtOrders);
}
public bool RemoveReplicationSessionSubscriber(Guid subscriberKey)
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
db.CreateParameters(1);
db.AddParameters(0, "@subscriberid", subscriberKey);
int affectedRows = db.ExecuteNonQuery(CommandType.Text, "update ReplicationSessionSubscribers set IsExpiredSession = 1 where subscriberid = @subscriberid");
db.Close();
db = null;
return(affectedRows > 0);
}
public void UpdateTodaySequenceReset()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
db.ExecuteNonQuery(CommandType.Text, "Delete from DaySequence");
db.CreateParameters(2);
db.AddParameters(0, "@DateTime", DateTime.Now);
db.AddParameters(1, "@IsReset", true);
db.ExecuteNonQuery(CommandType.Text, "Insert into DaySequence (DateTime, IsReset) values(@DateTime, @IsReset)");
db.Close();
db = null;
}
static void sh_Closed(object sender, EventArgs e)
{
try
{
Counters.IncrementCounter(CountersConstants.ExceptionMessages);
string[] cc = SystemConfigurations.GetAppSetting("SupportMailCC").Split(',');
NotificationSender.Send(true, true, false, SystemConfigurations.GetAppSetting("SupportMailFrom"), SystemConfigurations.GetAppSetting("SupportMailTo"), cc, "Fix Orders Service Closed", "Fix Orders Service Closed",
string.Format("Fix Orders Service has been closed on machine {0} at {1}", SystemConfigurations.GetMachineIP(), DateTime.Now.ToString()), null);
}
catch (Exception ex)
{
SystemLogger.WriteOnConsoleAsync(true, "Sending Mail Error: " + ex.Message, ConsoleColor.Red, ConsoleColor.Black, true);
}
}
public void AddReplicationSessionSubscriber(Guid sessionKey, string msgTypes, string subscriberQueuePath, DateTime dateTime)
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
db.CreateParameters(5);
db.AddParameters(0, "@SubscriberID", sessionKey);
db.AddParameters(1, "@SubscriberQueuePath", subscriberQueuePath);
db.AddParameters(2, "@SubscriptionDateTime", DateTime.Now);
db.AddParameters(3, "@SubscribedFixMsgsTypes", msgTypes);
db.AddParameters(4, "@IsExpiredSession", false);
db.ExecuteNonQuery(CommandType.Text, "Insert into ReplicationSessionSubscribers (SubscriberID, SubscriberQueuePath, SubscriptionDateTime, SubscribedFixMsgsTypes, IsExpiredSession) values(@SubscriberID, @SubscriberQueuePath, @SubscriptionDateTime, @SubscribedFixMsgsTypes, @IsExpiredSession)");
db.Close();
db = null;
}
public IEnumerable <string> GetExecutionIDs()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
DataTable dt = db.ExecuteDataSet(CommandType.Text, string.Format("Select executionid from orders_details where Convert(varchar,ExecutionDate,101) = Convert(varchar,Getdate(),101) AND executionid <> null")).Tables[0];
//List<Guid> subscribersIDs = new List<Guid>();
foreach (DataRow row in dt.Rows)
{
if (!row.IsNull("executionid"))
{
yield return(row["executionid"].ToString());
}
}
}
public Beltone.Services.Fix.Entities.Entities.RepSession[] GetReplicationSessionsSubscribers()
{
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString(ConStrongKeys.FixDbCon));
db.Open();
db.ExecuteNonQuery(CommandType.Text, string.Format("update ReplicationSessionSubscribers Set IsExpiredSession = 1 where Convert(varchar,subscriptiondatetime,101) < Convert(varchar,Getdate(),101)"));
DataTable dtSubscribers = db.ExecuteDataSet(CommandType.Text, string.Format("select * from ReplicationSessionSubscribers where IsExpiredSession = 0 and Convert(varchar,subscriptiondatetime,101) = Convert(varchar,Getdate(),101) AND IsExpiredSession = 0")).Tables[0];
List <RepSession> subscribers = new List <RepSession>();
foreach (DataRow row in dtSubscribers.Rows)
{
subscribers.Add(new RepSession()
{
SubscriberKey = (Guid)row["SubscriberID"], SubscribedFixMsgsTypes = row["SubscriberQueuePath"].ToString().Split(','), QueuePath = row["SubscriberQueuePath"].ToString(), SubscriptionDateTime = (DateTime)row["SubscriptionDateTime"]
});
}
return(subscribers.ToArray());
}
public Dictionary <int, CurrencyItem> GetCurrencies()
{
Dictionary <int, CurrencyItem> currencies = new Dictionary <int, CurrencyItem>();
string query = "select * from Currencies";
DBManager db = new DBManager(DataProvider.SqlServer, SystemConfigurations.GetConnectionString("BasicDataDBConnectionString"));
db.Open();
DataSet ds = db.ExecuteDataSet(System.Data.CommandType.Text, query);
db.Close();
db = null;
foreach (DataRow row in ds.Tables[0].Rows)
{
currencies.Add((int)row["CurrencyID"], new CurrencyItem()
{
ID = (int)row["CurrencyID"], Code = row["CurrencyCode"].ToString(), NameAr = row["NameAr"].ToString(), NameEn = row["NameEn"].ToString()
});
}
return(currencies);
}
public async Task CreateConfigurationAsync(ConfigurationItemViewModel configuration)
{
_sharedService.WriteLogs("CreateConfigurationAsync started by:" + _userSettings.UserName, true);
try
{
var _configuration = new SystemConfigurations();
_configuration.FieldName = configuration.FieldName;
_configuration.FieldValue = configuration.FieldValue;
_configuration.CreatedDate = DateTime.Now;
_configuration.CreatedBy = _userSettings.UserName;
_configuration.ModifiedDate = DateTime.Now;
_configuration.ModifiedBy = _userSettings.UserName;
await _configurationRepository.AddAsync(_configuration);
}
catch (Exception ex)
{
_sharedService.WriteLogs("CreateConfigurationAsync failed:" + ex.Message, false);
}
}
