static void Main(string[] pArgs)
{
try
{
_ParseApplicationSettings(pArgs);
#if DEBUG
TechnicalSettings.EnsureKeyExists();
#endif
Thread.CurrentThread.CurrentUICulture = CultureInfo.CreateSpecificCulture(UserSettings.Language);
Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture;
Application.EnableVisualStyles();
Application.DoEvents();
ConfigureAutoMapper();
var bootstrapper = new Bootstrapper(new Container());
Application.Run(bootstrapper.GetAppContext());
}
catch (Exception ex)
{
//new frmShowError(CustomExceptionHandler.ShowExceptionText(ex)).ShowDialog();
//System.Diagnostics.Debugger.Break();
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
static void Main(string[] pArgs)
{
try
{
_ParseApplicationSettings(pArgs);
#if DEBUG
TechnicalSettings.EnsureKeyExists();
#endif
Thread.CurrentThread.CurrentUICulture = CultureInfo.CreateSpecificCulture(UserSettings.Language);
Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture;
Application.EnableVisualStyles();
Application.DoEvents();
ConfigureAutoMapper();
var bootstrapper = new Bootstrapper(new Container());
Application.Run(bootstrapper.GetAppContext());
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
MessageBox.Show(ex.InnerException.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public DataSet EIDTestedSummary(int facility, int user_id, string role, string ReceiveFrom, string ReceiveTo, string CollectFrom, string CollectTo, string TestedFrom, string TestedTo, string ProvinceId, string FacilityType1, string LabCode)
{
string connstring = TechnicalSettings.Decrypt(TechnicalConfig.GetConfiguration()["ConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRptEIDTestedSummary";
cmd.Parameters.AddWithValue("@facility", facility);
cmd.Parameters.AddWithValue("@type", role);
cmd.Parameters.AddWithValue("@user_id", user_id);
cmd.Parameters.AddWithValue("@provinceIDs", ProvinceId);
cmd.Parameters.AddWithValue("@facilityTypes", FacilityType1);
cmd.Parameters.AddWithValue("@ReceiveFrom", ReceiveFrom);
cmd.Parameters.AddWithValue("@ReceiveTo", ReceiveTo);
cmd.Parameters.AddWithValue("@CollectFrom", CollectFrom);
cmd.Parameters.AddWithValue("@CollectTo", CollectTo);
cmd.Parameters.AddWithValue("@TestedFrom", TestedFrom);
cmd.Parameters.AddWithValue("@TestedTo", TestedTo);
cmd.Parameters.AddWithValue("@LabCode", LabCode);
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
return(ds);
}
}
public IList GetLaboratories()
{
string connstring = TechnicalSettings.Decrypt(ConfigurationManager.ConnectionStrings["LISReportConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetLaboratories";
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
var testResult = ds.Tables[0].AsEnumerable().Select(
dataRow => new ArrayList {
dataRow.Field <int>("Id"),
dataRow.Field <string>("LabCode"),
dataRow.Field <string>("LaboratoryName"),
dataRow.Field <string>("Description")
}).ToList();
return(testResult);
}
}
public DataSet GetRptARTMonthlyByIndicators(int user_id, string role, int year, int month, string ProvinceId, string FacilityType1, string LabCode)
{
string connstring = TechnicalSettings.Decrypt(TechnicalConfig.GetConfiguration()["ConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRptARTMonthlyByIndicators";
cmd.Parameters.AddWithValue("@type", role);
cmd.Parameters.AddWithValue("@user_id", user_id);
cmd.Parameters.AddWithValue("@provinceIDs", ProvinceId);
cmd.Parameters.AddWithValue("@facilityTypes", FacilityType1);
cmd.Parameters.AddWithValue("@Year", year);
cmd.Parameters.AddWithValue("@Month", month);
cmd.Parameters.AddWithValue("@LabCode", LabCode);
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
return(ds);
}
}
public void TestFixtureSetUp()
{
TechnicalSettings.CheckSettings();
TechnicalSettings.UseOnlineMode = false;
_serverName = TechnicalSettings.DatabaseServerName;
_databaseName = TechnicalSettings.DatabaseName;
_databaseLogin = TechnicalSettings.DatabaseLoginName;
_databasePassword = TechnicalSettings.DatabasePassword;
}
private static void _ParseApplicationSettings(IEnumerable <string> pArgs)
{
foreach (String arg in pArgs)
{
if (arg == PARAM_ONLINE_MODE)
{
TechnicalSettings.UseOnlineMode = true;
}
if (arg == PARAM_HELP)
{
MessageBox.Show(HELP, @"OMFS " + TechnicalSettings.SoftwareVersion, MessageBoxButtons.OK, MessageBoxIcon.Information);
Environment.Exit(1);
}
else if (arg.StartsWith(PARAM_DATE))
{
TimeProvider.SetToday(DateTime.Parse(arg.Substring(PARAM_DATE.Length)));
}
else if (arg.StartsWith(PARAM_USER))
{
_user = arg.Substring(PARAM_USER.Length);
}
else if (arg.StartsWith(PARAM_PASSWORD))
{
_password = arg.Substring(PARAM_PASSWORD.Length);
}
else if (arg.StartsWith(PARAM_DATABASE))
{
TechnicalSettings.CheckSettings();
ServicesProvider.GetInstance().GetDatabaseServices().SaveDatabaseDiagramsInXml(false, TechnicalSettings.DatabaseName);
Environment.Exit(1);
}
else if (arg == PARAM_USER_SETTINGS)
{
TechnicalSettings.CheckSettings();
Form frm = new FrmUserSettings();
frm.ShowDialog();
Environment.Exit(1);
}
else if (arg == PARAM_SETUP)
{
TechnicalSettings.CheckSettings();
Form frm = new FrmDatabaseSettings(FrmDatabaseSettingsEnum.SqlServerConnection, true, true);
frm.ShowDialog();
Environment.Exit(1);
}
else if (arg == PARAM_DUMP_OBJECTS)
{
TechnicalSettings.CheckSettings();
ServicesProvider.GetInstance().GetDatabaseServices().DumpObjects(TechnicalSettings.DatabaseName);
Environment.Exit(1);
}
else if (arg == "--skip-schema-check")
{
_skipSchemaCheck = true;
}
}
}
private static void Ping()
{
var worker = new BackgroundWorker();
worker.DoWork += (sender, args) =>
{
var mfiService = ServicesProvider.GetInstance().GetMFIServices();
var pingInfo = mfiService.GetPingInfo();
var appSettingsService = ServicesProvider.GetInstance().GetApplicationSettingsServices();
var guid = appSettingsService.GetGuid();
if (guid == null)
{
guid = Guid.NewGuid();
appSettingsService.SetGuid(guid.Value);
}
var collection = new Dictionary <string, string>
{
{ "Guid", guid.ToString() },
{ "Username", User.CurrentUser.UserName },
{ "Version", TechnicalSettings.GetDisplayVersion() },
{ "Olb", pingInfo.Olb.ToString("0") },
{ "NumberOfIndividualClients", pingInfo.NumberOfIndividualClients.ToString("0") },
{ "NumberOfSolidarityGroups", pingInfo.NumberOfSolidarityGroups.ToString("0") },
{ "NumberOfNonSolidarityGroups", pingInfo.NumberOfNonSolidarityGroups.ToString("0") },
{ "NumberOfCompanies", pingInfo.NumberOfCompanies.ToString("0") }
};
var parameters = string.Join("&", collection.Select(x => string.Format("{0}={1}", x.Key, x.Value)).ToArray());
var data = Encoding.UTF8.GetBytes(parameters);
var request = (HttpWebRequest)WebRequest.Create("http://opencbsping.apphb.com/Ping");
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = data.Length;
request.UserAgent = "OpenCBS";
request.Timeout = 5000;
try
{
using (var stream = request.GetRequestStream())
{
stream.Write(data, 0, data.Length);
}
}
catch
{
}
};
worker.RunWorkerCompleted += (sender, args) =>
{
if (args.Error != null)
{
Debug.WriteLine(args.Error.Message);
}
};
worker.RunWorkerAsync();
}
private void _CheckTechnicalSettings()
{
Thread.CurrentThread.CurrentUICulture = CultureInfo.CreateSpecificCulture(UserSettings.Language);
bWOneToSeven.ReportProgress(1, MultiLanguageStrings.GetString(Ressource.FrmSplash, "CheckTechnicalSettings.Text"));
if (!TechnicalSettings.CheckSettings())
{
_LoadDatabaseSettingsForm(FrmDatabaseSettingsEnum.SqlServerConnection);
}
_settingsAreOk = true;
}
public void InitManager()
{
TechnicalSettings.CheckSettings();
LoanProductManager loanProductManager = new LoanProductManager(DataUtil.TESTDB);
AccountingTransactionManager accountingTransactionManager = new AccountingTransactionManager(DataUtil.TESTDB);
EventManager eventManager = new EventManager(DataUtil.TESTDB);
ExchangeRateManager exchangeRateManager = new ExchangeRateManager(DataUtil.TESTDB);
ProvisioningRuleManager provisioningRuleManager = new ProvisioningRuleManager(DataUtil.TESTDB);
AccountManager accountManager = new AccountManager(DataUtil.TESTDB);
InstallmentTypeManager installmentTypeManager = new InstallmentTypeManager(DataUtil.TESTDB);
UserManager userManager = new UserManager(DataUtil.TESTDB);
EconomicActivityManager economicActivityManager = new EconomicActivityManager(DataUtil.TESTDB);
InstallmentManager installmentManager = new InstallmentManager(DataUtil.TESTDB);
FundingLineManager fundingLineManager = new FundingLineManager(DataUtil.TESTDB);
ClientManager clientManager = new ClientManager(DataUtil.TESTDB);
LocationsManager locationsManager = new LocationsManager(DataUtil.TESTDB);
LoanManager loanManager = new LoanManager(DataUtil.TESTDB);
ProjectManager projectManager = new ProjectManager(DataUtil.TESTDB);
MFIManager mfiManager = new MFIManager(DataUtil.TESTDB);
SavingManager savingManager = new SavingManager(DataUtil.TESTDB);
SavingProductManager savingProductManager = new SavingProductManager(DataUtil.TESTDB);
SavingEventManager savingEventManager = new SavingEventManager(DataUtil.TESTDB);
CurrencyManager currencyManager = new CurrencyManager(DataUtil.TESTDB);
AccountingRuleManager accountingRuleManager = new AccountingRuleManager(DataUtil.TESTDB);
FundingLineServices fundingLineServices = new FundingLineServices(DataUtil.TESTDB);
container = new Hashtable
{
{ "LoanProductManager", loanProductManager },
{ "AccountingTransactionManager", accountingTransactionManager },
{ "EventManager", eventManager },
{ "ExchangeRateManager", exchangeRateManager },
{ "ProvisioningRuleManager", provisioningRuleManager },
{ "AccountManager", accountManager },
{ "InstallmentTypeManager", installmentTypeManager },
{ "UserManager", userManager },
{ "FundingLineManager", fundingLineManager },
{ "LoanManager", loanManager },
{ "ClientManager", clientManager },
{ "LocationsManager", locationsManager },
{ "ProjectManager", projectManager },
{ "EconomicActivityManager", economicActivityManager },
{ "InstallmentManager", installmentManager },
{ "MFIManager", mfiManager },
{ "SavingManager", savingManager },
{ "SavingProductManager", savingProductManager },
{ "SavingEventManager", savingEventManager },
{ "CurrencyManager", currencyManager },
{ "FundingLineServices", fundingLineServices },
{ "AccountingRuleManager", accountingRuleManager }
};
}
public DataSet GetLabDataEntryPerformanceList()
{
string connstring = TechnicalSettings.Decrypt(ConfigurationManager.ConnectionStrings["LISReportConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetLabDataEntryPerformanceList";
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
return(ds);
}
}
private void bWDatabaseCreation_DoWork(object sender, DoWorkEventArgs e)
{
string name = e.Argument.ToString();
e.Result = DatabaseServices.CreateDatabase(
name
, TechnicalSettings.SoftwareVersion
, UserSettings.GetUpdatePath
);
if (!(bool)e.Result)
{
return;
}
TechnicalSettings.DatabaseName = name;
_sqlDatabases.Add(new SqlDatabaseSettings {
Name = TechnicalSettings.DatabaseName, Version = TechnicalSettings.SoftwareVersion, Size = "-"
});
TechnicalSettings.AddAvailableDatabase(name);
}
//Added by ZaySoe on 19_Dec_2018
public DataSet VLReport(int ProvinceId, int FacilityId, string Test,
string CollectedDateFrom, string CollectedDateTo, string ReceivedDateFrom, string ReceivedDateTo,
string specimenStatus, int NumberOfTests, string LabNumber, string LabNumberTo, string PatientCode, int Year,
string ARTNumber, string patientType, string labCode)
{
string connstring = TechnicalSettings.Decrypt(ConfigurationManager.ConnectionStrings["LISReportConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "VLGetAllListforDetailByCriteria";
cmd.Parameters.AddWithValue("@ProvinceId", ProvinceId);
cmd.Parameters.AddWithValue("@FacilityId", FacilityId);
cmd.Parameters.AddWithValue("@Test", Test);
cmd.Parameters.AddWithValue("@CollectedDateFrom", CollectedDateFrom);
cmd.Parameters.AddWithValue("@CollectedDateTo", CollectedDateTo);
cmd.Parameters.AddWithValue("@RecievedDateFrom", ReceivedDateFrom);
cmd.Parameters.AddWithValue("@RecievedDateTo", ReceivedDateTo);
cmd.Parameters.AddWithValue("@SpecimenStatus", specimenStatus);
cmd.Parameters.AddWithValue("@NumberOfTests", NumberOfTests);
cmd.Parameters.AddWithValue("@LabNumber", LabNumber);
cmd.Parameters.AddWithValue("@LabNumberTo", LabNumberTo);
cmd.Parameters.AddWithValue("@PatientCode", PatientCode);
cmd.Parameters.AddWithValue("@Year", Year);
cmd.Parameters.AddWithValue("@ARTNumber", ARTNumber);
cmd.Parameters.AddWithValue("@PatientType", patientType);
cmd.Parameters.AddWithValue("@LabCode", labCode);
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
int rows = ds.Tables[0].Rows.Count;
cn.Close();
return(ds);
}
}
public DataSet GetUserLocationsInfo(int userId)
{
string connstring = TechnicalSettings.Decrypt(ConfigurationManager.ConnectionStrings["LISReportConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetUserLocationInfo";
cmd.Parameters.AddWithValue("@user_id", userId);
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
//var eidIntialPCR = ds.Tables[0].AsEnumerable().Select(
// dataRow => new ArrayList {
// dataRow.Field<int>("UserId"),
// dataRow.Field<string>("UserName"),
// //dataRow.Field<int>("ProvinceId"),
// //dataRow.Field<string>("ProvinceName"),
// //dataRow.Field<int>("DistrictId"),
// //dataRow.Field<string>("DistrictName"),
// //dataRow.Field<int>("LLGId"),
// //dataRow.Field<string>("LLGName"),
// //dataRow.Field<int>("FacilityId"),
// //dataRow.Field<string>("FacilityName"),
// //dataRow.Field<int>("LabId"),
// //dataRow.Field<string>("LaboratoryName"),
// //dataRow.Field<bool>("IsFacility")
// }).ToList();
//return eidIntialPCR;
return(ds);
}
}
private void OnLoad(object sender, System.EventArgs e)
{
versionLabel.Text = "version " + TechnicalSettings.GetDisplayVersion();
}
private void OnLoad(object sender, System.EventArgs e)
{
versionLabel.Text = "OpenCBS LLC Kyrgyz Republic. v" + TechnicalSettings.GetDisplayVersion();
}
