private string checkDate(String dat)
{
if (dat.Length == 1)
dat = "0" + dat;
return dat;
}
/**
* Put all data from given day into given table
*/
public static void collectDataforDay(DateTime dateTime, SQLiteConnection m_dbConnection)
{
string zeroMonth = dateTime.Month < 10 ? "0" : "";
string zeroDay = dateTime.Day < 10 ? "0" : "";
string date = zeroMonth + dateTime.Month + "/" + zeroDay + dateTime.Day + "/" + dateTime.Year;
PdfReader reader;
try
{
reader = new PdfReader("http://www.equibase.com/premium/eqbPDFChartPlus.cfm?RACE=A&BorP=P&TID=SAR&CTRY=USA&DT=" + date + "&DAY=D&STYLE=EQB");
}
catch (Exception e)
{
Console.WriteLine("CAPTCHA TIME");
Console.ReadKey();
Console.ReadKey();
reader = new PdfReader("http://www.equibase.com/premium/eqbPDFChartPlus.cfm?RACE=A&BorP=P&TID=SAR&CTRY=USA&DT=" + date + "&DAY=D&STYLE=EQB");
}
StringBuilder builder = new StringBuilder();
for (int x = 1; x <= reader.NumberOfPages; x++)
{
PdfDictionary page = reader.GetPageN(x);
IRenderListener listener = new SBTextRenderer(builder);
PdfContentStreamProcessor processor = new PdfContentStreamProcessor(listener);
PdfDictionary pageDic = reader.GetPageN(x);
PdfDictionary resourcesDic = pageDic.GetAsDict(PdfName.RESOURCES);
processor.ProcessContent(ContentByteUtils.GetContentBytesForPage(reader, x), resourcesDic);
}
if (pages.Count != 0)
{
DataHandler handler = new DataHandler(dateTime, pages, m_dbConnection);
Thread thread = new Thread(new ThreadStart(handler.extractPdfData));
thread.Start();
thread.Join();
reader.Dispose();
pages.Clear();
}
else
{
// If there were no races on this particular day, simply skip it! :D
Console.WriteLine("Invalid Date: " + date);
}
}
void Start()
{
if (GameObject.FindWithTag("Player"))
{
if (Screen.showCursor) Screen.showCursor = false; // Hide cursor in freeroam.
if (!Screen.lockCursor) Screen.lockCursor = true; // Lock cursor in freeroam.
}
// Data proto
myData = new DataHandler();
myData.ValidateProfiles(); // Check that profile folder exists, if not create one. Also validate profiles so that they are not corrupt.
// Proto
lastResSelection = selGridInt;
qualSlider = (int)QualitySettings.currentLevel;
// Works, however for prototyping i need to do stuff
selStrings = new string[Screen.resolutions.Length];
int i = 0;
foreach(Resolution res in Screen.resolutions)
{
selStrings[i] = res.width + "x" + res.height + "@"+res.refreshRate;
i++;
}
}
public Full_TT()
{
InitializeComponent();
TimeTable tt = new TimeTable();
TimeTableAdapter t;
DataHandler dat = new DataHandler();
try
{
for (int i = 1; i < 6; i++)
{
foreach (Slot s in tt.getForDay((DayOfWeek)i))
{
//Load the subject
t = new TimeTableAdapter();
Subject sub = dat.getSubject(s.clsnbr);
t.TT_Title = sub.title;
t.TT_Slot = s.slt.ToUpper();
t.TT_Time = s.frm_time.ToString("t") + " - " + s.to_time.ToString("t");
t.TT_Venue = "";
t.TT_Att = sub.percentage;
double per = Math.Round(((double)sub.attended / (double)sub.conducted) * 100, 1);
t.Att_Color = new SolidColorBrush(getClr(per));
switch (i)
{
//Monday
case 1:
tt_monday.Items.Add(t);
break;
case 2:
tt_tuesday.Items.Add(t);
break;
case 3:
tt_wednesday.Items.Add(t);
break;
case 4:
tt_thursday.Items.Add(t);
break;
case 5:
tt_friday.Items.Add(t);
break;
}
}
}
}
catch (Exception) { }
}
public static List<TopicalApplicationModel> GetTopicalApplicationModel()
{
List<TopicalApplicationModel> topicalApplicationCollection = new List<TopicalApplicationModel>();
try
{
IConnection connection = new Connection();
string sqlConnection = connection.GetDataSourceValue("BH.Application.RouteConfirmation.config", "DataSource", "InitialCatalog", "UserID", "Password", "BH.Application.RouteConfirmation");
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> storedProcedureParameters = new List<StoredProcedureParameter>();
storedProcedureParameters.Add(new StoredProcedureParameter("@DataItemCode", SqlDbType.VarChar, "GEN_BodySite_SUG"));
storedProcedureParameters.Add(new StoredProcedureParameter("@FormName", SqlDbType.VarChar, "PRX_Topicals"));
DataTable dataTable = dataHandler.GetStoredProcedureResults(sqlConnection, "BH_MLM_ObsValueListing_Sp", storedProcedureParameters);
foreach (DataRow dataRow in dataTable.Rows)
topicalApplicationCollection.Add(new TopicalApplicationModel(dataRow["Value"].ToString(), dataRow["Value"].ToString()));
dataTable.Dispose();
}
catch
{
throw;
}
return topicalApplicationCollection;
}
public Trivia_Lobby(string username)
{
InitializeComponent();
dh = new DataHandler();
//we pass the username from form1 to this form
user = username;
}
public static RxWriterModel GetRxWriterModel(int prescriptionID)
{
RxWriterModel rxWriterModel = new RxWriterModel();
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@PrescriptionID", SqlDbType.Int, prescriptionID));
DataTable dataTable = dataHandler.GetStoredProcedureResults(DataConnection.GetConnectionString(), "BH_OPlus_HomeMedSummaryRxWriterItems_Sp", parameters);
foreach (DataRow dataRow in dataTable.Rows)
{
rxWriterModel.GenericName = dataRow["GenericName"].ToString();
rxWriterModel.RxNormCode = dataRow["RxNormCode"].ToString();
rxWriterModel.NDCCode = dataRow["NDCCode"].ToString();
}
dataTable.Dispose();
}
catch
{
throw;
}
return rxWriterModel;
}
public PWM()
{
InitializeComponent();
dh = new igfxDHLib.DataHandler();
RefreshV();
}
public ActionResult <TableResult> Post([FromBody] Purview purview)
{
DataHandler dataHandler = new DataHandler();
return(dataHandler.GetList <TableResult>(purview));
}
/// <summary>
/// Sets the specified hander function to handle data for the handler's symbol
/// </summary>
/// <param name="symbol">The symbol whose data is to be handled</param>
/// <param name="handler">The handler to use when this symbol's data is encountered</param>
/// <returns>An identifier that can be used to remove this handler</returns>
public void SetDataHandler(Symbol symbol, Action<BaseData> handler)
{
var dataHandler = new DataHandler(symbol);
dataHandler.DataEmitted += (sender, args) => handler(args);
SetDataHandler(dataHandler);
}
/// <summary>
/// Argument Constructor
/// </summary>
/// <param name="dataHandler">Provides requested data</param>
/// <param name="asyncClassLogger">TraceSource Async Class Logger</param>
public MarketRequestListener(DataHandler dataHandler, AsyncClassLogger asyncClassLogger)
{
// Save Instances
_dataHandler = dataHandler;
_asyncClassLogger = asyncClassLogger;
}
public Form1()
{
InitializeComponent();
dh = new DataHandler();
}
public CASResult Write()
{
byte[][] entries = new byte[EncodingMap.Length][];
CASFile[] files = new CASFile[EncodingMap.Length];
// header
using (var ms = new MemoryStream())
using (var bw = new BinaryWriter(ms))
{
bw.Write(Header.Header);
bw.Write(Header.Version);
bw.Write(Header.ChecksumSize);
bw.Write(Header.HasChecksum);
bw.WriteUInt32BE((uint)Entries.Count);
bw.WriteUInt16BE((ushort)Tags.Count);
if (Header.Version >= 2)
{
bw.Write(Header.NumFlags);
}
if (Header.Version >= 3)
{
// TODO
//bw.Write(Header.BasePriority);
//bw.Write(Header.Unknown_0D);
}
entries[0] = ms.ToArray();
files[0] = new CASFile(entries[0], EncodingMap[0].Type, EncodingMap[0].CompressionLevel);
}
// files
using (var ms = new MemoryStream())
using (var bw = new BinaryWriter(ms))
{
foreach (var entry in Entries)
{
bw.Write(entry.EKey.Value);
bw.WriteUInt40BE(entry.FileSize);
bw.Write(entry.Priority);
if (Header.HasChecksum != 0)
{
bw.WriteUInt32BE(entry.Checksum);
}
if (Header.Version >= 2)
{
bw.Write((byte[])(object)entry.Flags);
}
}
entries[1] = ms.ToArray();
files[1] = new CASFile(entries[1], EncodingMap[1].Type, EncodingMap[1].CompressionLevel);
}
// tags
using (var ms = new MemoryStream())
using (var bw = new BinaryWriter(ms))
{
foreach (var tag in Tags)
{
bw.Write(Encoding.UTF8.GetBytes(tag.Name));
bw.Write((byte)0);
bw.WriteUInt16BE(tag.Type);
bw.Write(tag.BitMask.ToByteArray());
tag.BitMask.Clear();
}
entries[2] = ms.ToArray();
files[2] = new CASFile(entries[2], EncodingMap[2].Type, EncodingMap[2].CompressionLevel);
}
// write
CASResult res = DataHandler.Write(WriteMode.CDN, files);
using (var md5 = MD5.Create())
res.CEKey = new MD5Hash(md5.ComputeHash(entries.SelectMany(x => x).ToArray()));
File.Delete(Path.Combine(CASContainer.Settings.OutputPath, CASContainer.BuildConfig["download"][0]));
CASContainer.Logger.LogInformation($"Download: EKey: {res.EKey} CEKey: {res.CEKey}");
CASContainer.BuildConfig.Set("download-size", res.DecompressedSize.ToString());
CASContainer.BuildConfig.Set("download-size", (res.CompressedSize - 30).ToString(), 1);
CASContainer.BuildConfig.Set("download", res.CEKey.ToString());
CASContainer.BuildConfig.Set("download", res.EKey.ToString(), 1);
Array.Resize(ref entries, 0);
Array.Resize(ref files, 0);
entries = null;
files = null;
return(res);
}
public static Int64 GetOrderGUID(int prescriptionID, Int64 orderReconcileGUID)
{
Int64 orderGUID = 0;
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@PrescriptionID", SqlDbType.Int, prescriptionID));
parameters.Add(new StoredProcedureParameter("@OrderReconcileGUID", SqlDbType.BigInt, orderReconcileGUID));
DataTable dataTable = dataHandler.GetStoredProcedureResults(DataConnection.GetConnectionString(), "BH_OPlus_HomeMedSummaryOrderGUID_Sp", parameters);
foreach (DataRow dataRow in dataTable.Rows)
orderGUID = Convert.ToInt64(dataRow["OrderGUID"]);
dataTable.Dispose();
}
catch
{
throw;
}
return orderGUID;
}
/// <summary>
/// Stores the modifications in the database.
/// </summary>
protected override void Store(SecurityContext context)
{
DataHandler.DeleteUser(context, UserId);
}
public MainWindow()
{
InitializeComponent();
handler = new DataHandler();
}
public static void FromStream <TItemType>(Stream stream, DataHandler <TItemType> dataHandler,
ExceptionHandler exceptionHandler)
{
if (dataHandler == null)
{
throw new ArgumentNullException(nameof(dataHandler));
}
if (exceptionHandler == null)
{
throw new ArgumentNullException(nameof(exceptionHandler));
}
//BufferedStream bufferedStream = new BufferedStream(stream);
var reader = new BinaryReader(stream);
var items = reader.ReadInt32();
for (var i = 0; i < items; i++)
{
var useProtocolBuffers = reader.ReadBoolean();
var useCompression = reader.ReadBoolean();
var dataSize = reader.ReadInt32();
var data = reader.ReadBytes(dataSize);
using (var memStream = new MemoryStream(data))
{
try
{
var mode = SerializationMode.Json;
if (useProtocolBuffers)
{
mode = SerializationMode.ProtocolBuffers;
}
var deserializationFailure = false;
object result;
try
{
result = SerializationHelper.ObjectFromStream <TItemType>(memStream, mode, useCompression);
dataHandler((TItemType)result, i + 1, items);
}
catch (Exception)
{
deserializationFailure = true;
}
if (deserializationFailure)
{
memStream.Seek(0, SeekOrigin.Begin);
result = SerializationHelper.ObjectFromStream <ExceptionResponse>(memStream, mode,
useCompression);
if (result != null)
{
exceptionHandler((ExceptionResponse)result);
}
else
{
var message = $"Received an unknown item type while expecting {typeof(TItemType)}";
throw new StreamingException(message);
}
}
}
catch (IOException ex)
{
var exResponse = new ExceptionResponse(ex);
exceptionHandler(exResponse);
}
catch (SerializationException ex)
{
var exResponse = new ExceptionResponse(ex);
exceptionHandler(exResponse);
}
}
}
}
public virtual DataTable GetAll()
{
string sql = "SELECT * FROM " + TableName;
return(DataHandler.GetDataTable(sql));
}
/// <summary>
/// Sets the specified hander function to handle data for the handler's symbol
/// </summary>
/// <param name="handler">The handler to use when this symbol's data is encountered</param>
/// <returns>An identifier that can be used to remove this handler</returns>
public void SetDataHandler(DataHandler handler)
{
_dataHandlers[handler.Symbol] = handler;
}
// [DirectMethod]
// public void FillData()
protected void wdWindow_BeforeShow(object sender, DirectEventArgs e)
{
try
{
string strMau = "Mẫu: 001/" + DateTime.Now.Year + "/";
DataTable table = DataHandler.GetInstance().ExecuteDataTable("SystemConfig_GetConfigByMaDonVi", "@MaDonVi", Session["MaDonVi"].ToString());
foreach (DataRow item in table.Rows)
{
switch (item["VAR_NAME"].ToString())
{
case SystemConfigParameter.EMAIL:
txtSystemMail.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.PASSWORD_EMAIL:
txtPassword.Text = item["VAR_VALUE"].ToString();
txtConfirmPassword.Text = txtPassword.Text;
break;
case SystemConfigParameter.MENU_TYPE:
cbMenuType.SetValue(item["VAR_VALUE"].ToString());
break;
case SystemConfigParameter.COMPANY_NAME:
//if (string.IsNullOrEmpty(item["VAR_VALUE"].ToString()))
//{
// txtCompanyName.Text = new DM_DONVIController().GetById(Session["MaDonVi"].ToString()).TEN_DONVI;
//}
//else
//{
txtCompanyName.Text = item["VAR_VALUE"].ToString();
// }
break;
case SystemConfigParameter.COMPANY_ADDRESS:
txt_DiaChi.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.COMPANY_MASOTHUE:
txt_MaSoThue.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.COMPANY_DIENTHOAI:
txt_DienThoai.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.COMPANY_FAX:
txt_Fax.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.COMPANY_EMAIL:
txt_Email.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.CITY:
txtCity.Text = item["VAR_VALUE"].ToString();
break;
//case SystemConfigParameter.LUONG_CB:
// txtLuongCB.SetValue(item["VAR_VALUE"].ToString());
// break;
case SystemConfigParameter.PREFIX:
txtTienTo.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.NUMBER_OF_CHARACTER:
txtSoLuong.Text = item["VAR_VALUE"].ToString();
break;
//case SystemConfigParameter.CONG_CHUAN:
// txtSoNgayCongChuan.Text = item["VAR_VALUE"].ToString();
// break;
// tab sinh mã, số quyết định
case SystemConfigParameter.SUFFIX_SOHOPDONG:
txtSoHopDong.Text = item["VAR_VALUE"].ToString();
txtSoHopDong.Note = strMau + item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.SUFFIX_SOQDLUONG:
txtSoQuyetDinhLuong.Text = item["VAR_VALUE"].ToString();
txtSoQuyetDinhLuong.Note = strMau + item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.SUFFIX_SOQDKHENTHUONG:
txtSoQDKhenThuong.Text = item["VAR_VALUE"].ToString();
txtSoQDKhenThuong.Note = strMau + item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.SUFFIX_SOQDKYLUAT:
txtSoQDKyLuat.Text = item["VAR_VALUE"].ToString();
txtSoQDKyLuat.Note = strMau + item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.SUFFIX_SOQDCONGTAC:
txtSoQDCongTac.Text = item["VAR_VALUE"].ToString();
txtSoQDCongTac.Note = strMau + item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.SUFFIX_SOQDDIEUCHUYEN:
txtSoQĐieuChuyen.Text = item["VAR_VALUE"].ToString();
txtSoQĐieuChuyen.Note = strMau + item["VAR_VALUE"].ToString();
break;
// tab sinh người ký báo cáo
case SystemConfigParameter.SuDungTenDangNhap:
// chknguoidangnhap.SetValue(Boolean.Parse(item["VAR_VALUE"].ToString()));
chknguoidangnhap.Checked = Boolean.Parse(item["VAR_VALUE"].ToString());
break;
case SystemConfigParameter.chuky1:
txtnguoiky1.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.chuky2:
txtnguoiky2.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.chuky3:
txtnguoiky3.Text = item["VAR_VALUE"].ToString();
break;
case SystemConfigParameter.chuky4:
txtnguoiky4.Text = item["VAR_VALUE"].ToString();
break;
}
}
if (string.IsNullOrEmpty(txtCompanyName.Text.Trim()))
{
DM_DONVI dv = new DM_DONVIController().GetById(Session["MaDonVi"].ToString());
txtCompanyName.Text = dv.TEN_DONVI;
}
}
catch (Exception ex)
{
X.MessageBox.Alert("Thông báo", ex.Message).Show();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DataHandler.UpdateDB("Client");
}
public static extern CURLcode SetOpt(SafeEasyHandle handle, CURLoption option, DataHandler value);
public CustomRedirect(string oldUrl, string newUrl)
{
_oldUrl = oldUrl;
_newUrl = newUrl;
SiteId = DataHandler.GetSiteIdFromUrl(oldUrl);
}
public DAOConnector()
{
dataHandler = new DataHandler();
}
public async Task <IActionResult> Auth([FromBody] LoginViewModel viewModel)
{
var query = new UserByEmail {
Email = viewModel.Email
};
await DataHandler.Execute(query);
if (query.Result != null && query.Result.IsActive &&
(query.ResultTenant == null || query.ResultTenant.IsActive))
{
if (query.Result.EncryptedPwd.Equals(EncryptHelper.Encrypt(viewModel.Pwd)))
{
if (query.ResultConfig.IsTwoFactor)
{
query.ResultConfig.TwoFactorAuth = Convert.ToString(EncryptHelper.Randomizer(100000, 999999));
query.ResultConfig.IsTwoFactorActive = true;
var persist = new Persist <UserConfig>()
{
Model = query.ResultConfig
};
await DataHandler.Execute(persist);
if (persist.Confirm.Success)
{
await DataHandler.Commit();
}
var notify = new SimpleNotify
{
CloudHandler = CloudHandler,
DataHandler = DataHandler,
CurrentUser = query.Result,
LogicHandler = LogicHandler,
Model = persist.Model,
TemplateName = "twofactor"
};
await LogicHandler.Execute(notify);
return(Ok(new AuthViewModel()
{
Id = query.Result.Id, IsTwoFactor = true
}));
}
else
{
var logic = new SigninAuth
{
Login = query.Result,
Config = query.ResultConfig,
Tenant = query.ResultTenant,
Settings = CloudHandler.Settings
};
await LogicHandler.Execute(logic);
return(Ok(logic.Result));
}
}
}
return(Ok(new FailViewModel {
Message = "Login failed"
}));
}
public EmployeeController(DataHandler dataHandler)
{
_dataHandler = dataHandler;
}
public DOUbigeo()
{
_dbProviderFactory = new DataFactory();
_dataHandler = new DataHandler();
}
public EntityDefine AddEntityType <T>(DataHandler dataHandler)
{
return(AddEntityType(typeof(T), dataHandler));
}
public void BindData(ReportFilter filter)
{
DataTable table = new DataTable();
xrl_ngayBC.Text = "Tháng " + filter.StartMonth + " năm " + filter.Year;
table = DataHandler.GetInstance().ExecuteDataTable("sp_DanhSachNhanVienDieuChuyenTrongThang", "@MaBoPhan", "@Gender", "@TinhTrang", "@MinSeniority", "@MaxSeniority", "@Month", "@Year", "@WhereClause", filter.SelectedDepartment, filter.Gender, filter.WorkingStatus, filter.MinSeniority, filter.MaxSeniority, filter.StartMonth, filter.Year, filter.WhereClause);
xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment);
//xrl_ThanhPho.Text = ReportController.GetInstance().GetCityName(filter.SessionDepartment);
xrtngayketxuat.Text = ReportController.GetInstance().GetFooterReport(filter.SessionDepartment, filter.ReportedDate);
xr_chinhanh.Text = ReportController.GetInstance().GetCompanyAddress(filter.SessionDepartment);
xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment);
DataSource = table;
xrtmanhanvien.DataBindings.Add("Text", DataSource, "MA_CB");
xrthoten.DataBindings.Add("Text", DataSource, "HO_TEN");
xrtngaysinh.DataBindings.Add("Text", DataSource, "NGAY_SINH", "{0:dd/MM/yyyy}");
xrtgioitinh.DataBindings.Add("Text", DataSource, "TEN_GIOITINH");
xrt_tenbophanmoi.DataBindings.Add("Text", DataSource, "TenBoPhanMoi");
xrt_bophancu.DataBindings.Add("Text", DataSource, "TenBoPhanCu");
xrt_soquyetdinh.DataBindings.Add("Text", DataSource, "SoQuyetDinh");
xrt_ngayhieuluc.DataBindings.Add("Text", DataSource, "NgayCoHieuLuc", "{0:dd/MM/yyyy}");
xrt_ngayhethieuluc.DataBindings.Add("Text", DataSource, "NgayHetHieuLuc", "{0:dd/MM/yyyy}");
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("MA_DONVI", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
xrl_tenphong.DataBindings.Add("Text", DataSource, "TEN_PHONG");
ReportController rpCtr = new ReportController();
if (!string.IsNullOrEmpty(filter.Title1))
{
xrl_footer1.Text = filter.Title1;
}
else
{
xrl_footer1.Text = rpCtr.GetTitleOfSignature(xrl_footer1.Text, filter.Title1);
}
if (!string.IsNullOrEmpty(filter.Title2))
{
xrl_footer2.Text = filter.Title2;
}
else
{
xrl_footer2.Text = rpCtr.GetTitleOfSignature(xrl_footer2.Text, filter.Title2);
}
if (!string.IsNullOrEmpty(filter.Title3))
{
xrl_footer3.Text = filter.Title3;
}
else
{
xrl_footer3.Text = rpCtr.GetTitleOfSignature(xrl_footer3.Text, filter.Title3);
}
if (!string.IsNullOrEmpty(filter.Name1))
{
xrl_ten1.Text = filter.Name1;
}
else
{
xrl_ten1.Text = rpCtr.GetCreatedReporterName(filter.SessionDepartment, filter.Reporter);
}
if (!string.IsNullOrEmpty(filter.Name2))
{
xrl_ten2.Text = filter.Name2;
}
else
{
xrl_ten2.Text = rpCtr.GetHeadOfHRroom(filter.SessionDepartment, filter.Name2);
}
if (!string.IsNullOrEmpty(filter.Name3))
{
xrl_ten3.Text = filter.Name3;
}
else
{
xrl_ten3.Text = rpCtr.GetDirectorName(filter.SessionDepartment, filter.Name3);
}
//tieu de
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrl_TitleBC.Text = filter.ReportTitle;
}
}
public ColumnHeaderCellText(DataHandler data_handler)
: base(null, true)
{
UseMarkup = true;
this.data_handler = data_handler;
}
public SystemAdmin()
{
data = DataHandler.Instance;
}
public Register()
{
InitializeComponent();
dh = new DataHandler();
proxy = new LoginClient();
}
public DataService(DataHandler handler)
{
this.itsDataHandler = handler;
}
public void EF6_LoadActivities_AtStart_DataHandlerLevel()
{
var sctx = CurrentContext.Security;
var user1Id = TestUser.User1.Id;
var rootEntityId = Id("E01");
// create 30 activities
sctx.CreateSecurityEntity(rootEntityId, default(int), user1Id);
for (int entityId = rootEntityId + 1; entityId < rootEntityId + 31; entityId++)
{
sctx.CreateSecurityEntity(entityId, rootEntityId, user1Id);
}
var lastId = Db().ExecuteTestScript <int>("select top 1 Id from [EFMessages] order by Id desc").First();
// test0: initial
var expectedCs0 = new CompletionState {
LastActivityId = lastId
};
var cs0 = DataHandler.LoadCompletionState(sctx.DataProvider, out var dbId0);
Assert.AreEqual(lastId, dbId0);
Assert.AreEqual(expectedCs0.ToString(), cs0.ToString());
// test1: create unprocessed activities: set "wait" on 4 continuous activity (except last) + 2 gaps before
Db().ExecuteTestScript(@"declare @last int
select top 1 @last = Id from [EFMessages] order by Id desc
UPDATE EFMessages set ExecutionState = 'Executing'
where Id in (@last-1, @last-2, @last-3, @last-4, @last-6, @last-9)
");
var expectedCs1 = new CompletionState
{
LastActivityId = lastId,
Gaps = new[] { lastId - 9, lastId - 6, lastId - 4, lastId - 3, lastId - 2, lastId - 1 }
};
var cs1 = DataHandler.LoadCompletionState(sctx.DataProvider, out var dbId1);
Assert.AreEqual(dbId1, lastId);
Assert.AreEqual(expectedCs1.ToString(), cs1.ToString());
// test2: create unprocessed activities: set "wait" on last 5 continuous activity (except last) + 2 gaps before
Db().ExecuteTestScript(@"declare @last int
select top 1 @last = Id from [EFMessages] order by Id desc
UPDATE EFMessages set ExecutionState = 'Executing'
where Id in (@last)
");
var expectedCs2 = new CompletionState
{
LastActivityId = lastId - 5,
Gaps = new[] { lastId - 9, lastId - 6 }
};
var cs2 = DataHandler.LoadCompletionState(sctx.DataProvider, out var dbId2);
Assert.AreEqual(dbId2, lastId);
Assert.AreEqual(expectedCs2.ToString(), cs2.ToString());
}
public void EF6_LoadActivities_AtStart_ActivityQueueLevel()
{
var sctx = CurrentContext.Security;
var user1Id = TestUser.User1.Id;
var rootEntityId = Id("E01");
// create 30 activities
sctx.CreateSecurityEntity(rootEntityId, default(int), user1Id);
for (int entityId = rootEntityId + 1; entityId < rootEntityId + 31; entityId++)
{
sctx.CreateSecurityEntity(entityId, rootEntityId, user1Id);
}
var lastId = Db().ExecuteTestScript <int>("select top 1 Id from [EFMessages] order by Id desc").First();
// test0: initial state
var expectedCs = new CompletionState {
LastActivityId = lastId
};
var uncompleted = DataHandler.LoadCompletionState(SecurityContext.General.DataProvider, out var lastActivityIdFromDb);
SecurityActivityQueue.Startup(uncompleted, lastActivityIdFromDb);
var cs0 = SecurityActivityQueue.GetCurrentState().Termination;
Assert.AreEqual(expectedCs.ToString(), cs0.ToString());
// test1: create some unprocessed activities: 4 continuous activity (except last) + 2 gaps before
// last-2 and last-6 "Wait", the others "Executing" by another appdomain.
Db().ExecuteTestScript(@"declare @last int
select top 1 @last = Id from [EFMessages] order by Id desc
UPDATE EFMessages set ExecutionState = 'Executing', LockedBy = 'AnotherComputer'
where Id in (@last-1, @last-3, @last-4, @last-9)
UPDATE EFMessages set ExecutionState = 'Wait', LockedBy = null, LockedAt = null
where Id in (@last-2, @last-6)
");
var expectedIsFromDb1 = String.Join(", ", new[] { lastId - 9, lastId - 4, lastId - 3, lastId - 1, lastId });
uncompleted = DataHandler.LoadCompletionState(SecurityContext.General.DataProvider, out lastActivityIdFromDb);
SecurityActivityQueue.Startup(uncompleted, lastActivityIdFromDb);
var cs1 = SecurityActivityQueue.GetCurrentState().Termination;
var idsFromDb1 = String.Join(", ", Db().GetUnprocessedActivityIds());
Assert.AreEqual(expectedCs.ToString(), cs1.ToString());
Assert.AreEqual(expectedIsFromDb1, idsFromDb1);
// test2: create unprocessed activities: last 5 continuous activity + 2 gaps before
// last-2 and last-6 "Wait", the others "Executing" by another appdomain.
Db().ExecuteTestScript(@"declare @last int
select top 1 @last = Id from [EFMessages] order by Id desc
UPDATE EFMessages set ExecutionState = 'Executing', LockedBy = 'AnotherComputer'
where Id in (@last, @last-1, @last-3, @last-4, @last-9)
UPDATE EFMessages set ExecutionState = 'Wait', LockedBy = null, LockedAt = null
where Id in (@last-2, @last-6)
");
var expectedIsFromDb2 = String.Join(", ", new[] { lastId - 9, lastId - 4, lastId - 3, lastId - 1, lastId, lastId });
uncompleted = DataHandler.LoadCompletionState(SecurityContext.General.DataProvider, out lastActivityIdFromDb);
SecurityActivityQueue.Startup(uncompleted, lastActivityIdFromDb);
var cs2 = SecurityActivityQueue.GetCurrentState().Termination;
var idsFromDb2 = String.Join(", ", Db().GetUnprocessedActivityIds());
Assert.AreEqual(expectedCs.ToString(), cs2.ToString());
Assert.AreEqual(expectedIsFromDb2, idsFromDb2);
}
public Login()
{
InitializeComponent();
this.dataHandler = new DataHandler();
nEmpregado.Focus();
}
public void EF6_LoadActivities_SmartGapResolution()
{
var sb = new StringBuilder();
CommunicationMonitor.Stop();
var sctx = CurrentContext.Security;
var user1Id = TestUser.User1.Id;
var rootEntityId = Id("E01");
// create some activities with gap
sctx.CreateSecurityEntity(rootEntityId, default(int), user1Id);
for (int entityId = rootEntityId + 1; entityId < rootEntityId + 11; entityId++)
{
sctx.CreateSecurityEntity(entityId, rootEntityId, user1Id);
Db().ExecuteTestScript(@"
-- 2 gap
INSERT INTO EFMessages ([SavedBy], [SavedAt], [ExecutionState]) VALUES ('asdf1', GETDATE(),'Wait')
INSERT INTO EFMessages ([SavedBy], [SavedAt], [ExecutionState]) VALUES ('qwer1', GETDATE(),'Wait')
DELETE EFMessages WHERE Id in (select top 2 Id from [EFMessages] order by Id desc)");
}
// these are be unprocessed
Db().ExecuteTestScript("UPDATE EFMessages set ExecutionState = 'Wait', LockedBy = null, LockedAt = null");
sb.Clear();
var uncompleted = DataHandler.LoadCompletionState(SecurityContext.General.DataProvider, out var lastActivityIdFromDb);
SecurityActivityQueue.Startup(uncompleted, lastActivityIdFromDb);
var cs1 = SecurityActivityQueue.GetCurrentCompletionState();
// expectation: there is no any gap.
Assert.AreEqual(0, cs1.Gaps.Length);
// create a gap
Db().ExecuteTestScript(@"
-- 2 gap
INSERT INTO EFMessages ([SavedBy], [SavedAt], [ExecutionState]) VALUES ('asdf1', GETDATE(),'Wait')
INSERT INTO EFMessages ([SavedBy], [SavedAt], [ExecutionState]) VALUES ('qwer1', GETDATE(),'Wait')
DELETE EFMessages WHERE Id in (select top 2 Id from [EFMessages] order by Id desc)
-- copy last
INSERT INTO EFMessages([SavedBy],[SavedAt],[ExecutionState],[LockedBy],[LockedAt],[Body])
SELECT TOP 1 [SavedBy],GETDATE(),[ExecutionState],[LockedBy],[LockedAt],[Body] FROM EFMessages ORDER BY Id DESC
-- 2 gap
INSERT INTO EFMessages ([SavedBy], [SavedAt], [ExecutionState]) VALUES ('asdf2', GETDATE(),'Wait')
INSERT INTO EFMessages ([SavedBy], [SavedAt], [ExecutionState]) VALUES ('qwer2', GETDATE(),'Wait')
DELETE EFMessages WHERE Id in (select top 2 Id from [EFMessages] order by Id desc)");
// last activity
sctx.CreateSecurityEntity(101, rootEntityId, user1Id);
var cs2 = SecurityActivityQueue.GetCurrentCompletionState();
Assert.AreEqual(4, cs2.Gaps.Length);
Assert.AreEqual(cs1.LastActivityId + 6, cs2.LastActivityId);
SecurityActivityQueue.HealthCheck();
var cs3 = SecurityActivityQueue.GetCurrentCompletionState();
Assert.AreEqual(0, cs3.Gaps.Length);
Assert.AreEqual(cs2.LastActivityId, cs3.LastActivityId);
CommunicationMonitor.Start();
}
public override async Task Execute()
{
var regionKey = "GLA";
var tenant = new Tenant()
{
Name = Input.TenantName, TenantName = Input.TenantName, EntryKey = StringHelper.GenerateCode(16),
AuthorName = Input.Name, RegionKey = regionKey
};
var isNew = true;
if (string.IsNullOrEmpty(Input.TenantId))
{
var persistClient = new Persist <Tenant>()
{
Model = tenant
};
await DataHandler.Execute(persistClient);
tenant = persistClient.Model;
}
else
{
var loaderClient = new Loader <Tenant>()
{
Id = Input.TenantId
};
await DataHandler.Execute(loaderClient);
tenant = loaderClient.Result;
isNew = false;
}
if (tenant != null && !string.IsNullOrEmpty(tenant.Id))
{
var user = new User()
{
TenantId = tenant.Id, TenantName = Input.TenantName, Name = Input.Name, Email = Input.Email,
EncryptedPwd = EncryptHelper.Encrypt(Input.Pwd), AuthorName = Input.Name,
Right = new UserRight()
{
CanAuth = isNew, CanAdmin = isNew, CanSuperuser = false
},
RegionKey = regionKey
};
var persistUser = new UserSave {
Model = user
};
await DataHandler.Execute(persistUser);
if (persistUser.Confirm.Success)
{
if (isNew)
{
tenant.AuthorId = persistUser.Model.Id;
tenant.TenantId = tenant.Id;
var persistClient = new Persist <Tenant>()
{
Model = tenant
};
await DataHandler.Execute(persistClient);
tenant = persistClient.Model;
var meetingType = new MeetingType()
{
TenantId = tenant.Id, TenantName = tenant.Name, Name = "Standard", IsRecur = false,
Pretext = "Standard Meeting Type", RegionKey = regionKey, Prename = "Meeting",
AuthorId = persistUser.Model.Id, AuthorName = persistUser.Model.Name
};
var persistType = new Persist <MeetingType>()
{
Model = meetingType
};
await DataHandler.Execute(persistType);
}
persistUser.Model.AuthorId = persistUser.Model.Id;
await DataHandler.Execute(persistUser);
await DataHandler.Commit();
var signin = new SigninAuth()
{
Tenant = tenant, Login = persistUser.Model, LogicHandler = LogicHandler,
DataHandler = DataHandler, Config = persistUser.ResultConfig, Settings = CloudHandler.Settings
};
await LogicHandler.Execute(signin);
ResultAuth = signin.Result;
Result = ActionConfirm.CreateSuccess(persistUser.Model);
var notify = new SimpleNotify
{
CloudHandler = CloudHandler, DataHandler = DataHandler, CurrentUser = persistUser.Model,
LogicHandler = LogicHandler, Model = persistUser.Model,
TemplateName = isNew ? "welcomeclient" : "welcomeuser"
};
await LogicHandler.Execute(notify);
}
else
{
Result = ActionConfirm.CreateFailure(persistUser.Confirm.Message);
}
}
else
{
Result = ActionConfirm.CreateFailure("Error connecting organisation");
}
}
public static bool ExtractSystemFiles(string savepath)
{
if (Directory.Exists(savepath))
{
Directory.Delete(savepath, true);
}
Directory.CreateDirectory(savepath);
Logger.LogInformation("Extracting System Files");
OpenLocalIndices();
// .build.info
if (File.Exists(Path.Combine(BasePath, ".build.info")))
{
File.Copy(Path.Combine(BasePath, ".build.info"), Path.Combine(savepath, ".build.info"), true);
}
// Build Config
string buildKey = BuildInfo["Build Key"];
string buildCfgLocalPath = Path.Combine(BasePath, "Data", "config", buildKey.Substring(0, 2), buildKey.Substring(2, 2), buildKey);
if (File.Exists(buildCfgLocalPath))
{
File.Copy(buildCfgLocalPath, Path.Combine(savepath, buildKey), true);
}
else
{
Logger.LogCritical("Build Config missing.");
return(false);
}
// CDN Config
string cdnKey = BuildInfo["CDN Key"];
string cdnCfgLocalPath = Path.Combine(BasePath, "Data", "config", cdnKey.Substring(0, 2), cdnKey.Substring(2, 2), cdnKey);
if (File.Exists(cdnCfgLocalPath))
{
File.Copy(cdnCfgLocalPath, Path.Combine(savepath, cdnKey), true);
}
else
{
Logger.LogCritical("CDN Config missing.");
return(false);
}
string path;
// Encoding File
LocalIndexEntry idxInfo = LocalIndexHandler?.GetIndexInfo(BuildConfig.GetKey("encoding"));
if (idxInfo != null)
{
path = Path.Combine(BasePath, "Data", "data", string.Format("data.{0:D3}", idxInfo.Archive));
DataHandler.Extract(path, Path.Combine(savepath, BuildConfig.GetKey("encoding").ToString()), idxInfo);
OpenEncoding();
}
else
{
Logger.LogCritical("Encoding file missing.");
return(false);
}
// Root File
var rootkey = BuildConfig.GetKey("root");
if (EncodingHandler.CEKeys.TryGetValue(rootkey, out EncodingCEKeyPageTable enc))
{
idxInfo = LocalIndexHandler?.GetIndexInfo(enc.EKeys[0]);
if (idxInfo != null)
{
path = Path.Combine(BasePath, "Data", "data", string.Format("data.{0:D3}", idxInfo.Archive));
DataHandler.Extract(path, Path.Combine(savepath, enc.EKeys[0].ToString()), idxInfo);
}
else
{
Logger.LogCritical("Root file missing.");
return(false);
}
}
// Install File
var installkey = BuildConfig.GetKey("install");
if (EncodingHandler.CEKeys.TryGetValue(installkey, out enc))
{
idxInfo = LocalIndexHandler?.GetIndexInfo(enc.EKeys[0]);
if (idxInfo != null)
{
path = Path.Combine(BasePath, "Data", "data", string.Format("data.{0:D3}", idxInfo.Archive));
DataHandler.Extract(path, Path.Combine(savepath, enc.EKeys[0].ToString()), idxInfo);
}
else
{
Logger.LogCritical("Install file missing.");
return(false);
}
}
// Download File
var downloadkey = BuildConfig.GetKey("download");
if (EncodingHandler.CEKeys.TryGetValue(downloadkey, out enc))
{
idxInfo = LocalIndexHandler?.GetIndexInfo(enc.EKeys[0]);
if (idxInfo != null)
{
path = Path.Combine(BasePath, "Data", "data", string.Format("data.{0:D3}", idxInfo.Archive));
DataHandler.Extract(path, Path.Combine(savepath, enc.EKeys[0].ToString()), idxInfo);
}
else
{
Logger.LogCritical("Download file missing.");
return(false);
}
}
return(true);
}
public async Task Save()
{
await DataHandler.Save(this);
}
/// <summary>
/// Stores the modifications in the database.
/// </summary>
protected override void Store(SecurityContext context)
{
DataHandler.CreateSecurityEntity(context, this.EntityId, this.ParentEntityId, this.OwnerId);
}
public RandomWalk(DataHandler handler)
{
this.handler = handler;
}
/// <summary>
/// Stores the modifications in the database.
/// </summary>
protected override void Store(SecurityContext context)
{
DataHandler.RemoveMembers(context, GroupId, UserMembers, GroupMembers, ParentGroups);
}
public EntityDefine AddEntityType(Type type, DataHandler dataHandler)
{
return(AddEntityType(type, dataHandler, null));
}
public void SetData(DataHandler handler)
{
this.itsDataHandler = handler;
}
public ColumnHeaderCellText(DataHandler data_handler) : base(null, true)
{
UseMarkup = true;
this.data_handler = data_handler;
}
public static PatientHeaderModel GetPatientHeaderModel(Int64 clientVisitGUID, Int64 clientGUID, Int64 chartGUID)
{
PatientHeaderModel patientHeaderModel = new PatientHeaderModel();
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@ClientVisitGUID", SqlDbType.BigInt, clientVisitGUID));
parameters.Add(new StoredProcedureParameter("@ClientGUID", SqlDbType.BigInt, clientGUID));
parameters.Add(new StoredProcedureParameter("@ChartGUID", SqlDbType.BigInt, chartGUID));
DataTable dataTable = dataHandler.GetStoredProcedureResults(DataConnection.GetConnectionString(), "BH_OPlus_PatientHeaderInformation_Sp", parameters);
foreach (DataRow dataRow in dataTable.Rows)
{
patientHeaderModel.PatientName = dataRow["ClientDisplayName"].ToString();
patientHeaderModel.CurrentLocation = dataRow["CurrentLocation"].ToString();
patientHeaderModel.HeightWeight = dataRow["Height"].ToString();
patientHeaderModel.AdmissionDateTime = dataRow["AdmitDtm"].ToString();
patientHeaderModel.ProviderName = dataRow["ProviderDisplayName"].ToString();
patientHeaderModel.MedicalRecordNumber = dataRow["MRN"].ToString();
patientHeaderModel.PatientAge = dataRow["Age"].ToString();
patientHeaderModel.Gender = dataRow["GenderCode"].ToString();
}
dataTable.Dispose();
}
catch
{
throw;
}
return patientHeaderModel;
}
protected void submit_Click(object sender, EventArgs e)
{
DataHandler dh = new DataHandler();
dh.InsertEventContact(contactname.Text, email.Text, telephone.Text, timetocall.SelectedItem.ToString(), eventname.Text,
eventdate.Text, region.SelectedItem.ToString(), details.Text, publicize.Checked.ToString());
ResetForm();
}
void Awake()
{
// Load last profile if played before.
//Initialize
myData = new DataHandler();
DontDestroyOnLoad(gameObject); // This gameobject.
}
public static BindingList<PatientMedicationModel> GetPatientMedicationCollection(string type, Int64 clientVisitGUID, Int64 clientGUID, Int64 chartGUID)
{
BindingList<PatientMedicationModel> patientMedicationCollection = new BindingList<PatientMedicationModel>();
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@PopulateType", SqlDbType.BigInt, type));
parameters.Add(new StoredProcedureParameter("@ClientVisitGUID", SqlDbType.BigInt, clientVisitGUID));
parameters.Add(new StoredProcedureParameter("@ClientGUID", SqlDbType.BigInt, clientGUID));
parameters.Add(new StoredProcedureParameter("@ChartGUID", SqlDbType.BigInt, chartGUID));
DataTable dataTable = dataHandler.GetStoredProcedureResults(DataConnection.GetConnectionString(), "BH_OPlus_HomeMedSummaryPopulate_Sp", parameters);
foreach (DataRow dataRow in dataTable.Rows)
{
PatientMedicationModel model = new PatientMedicationModel() {
IsNewRecord = Convert.ToBoolean(dataRow["IsNewRecord"]),
HomeMedicationSummaryID = (dataRow["HomeMedSummaryID"] != DBNull.Value ? Convert.ToInt32(dataRow["HomeMedSummaryID"]) : 0),
OrderReconcileGUID = Convert.ToInt64(dataRow["OrderReconcileGUID"]),
OrderReconcileDetailGUID = Convert.ToInt64(dataRow["OrderReconcileDtlGUID"]),
PrescriptionStatus = dataRow["PrescriptionStatus"].ToString(),
PrescriptionID = Convert.ToInt32(dataRow["PrescriptionID"]),
DrugName = dataRow["DrugName"].ToString(),
Instructions = dataRow["Instructions"].ToString(),
AlsoKnownAs = dataRow["AlsoKnownAs"].ToString(),
Medication = dataRow["Medication"].ToString(),
ReasonForTaking = dataRow["ReasonForTaking"].ToString(),
DosesTakenToday = dataRow["DosesTakenToday"].ToString(),
NextDose = dataRow["NextDose"].ToString(),
Comments = dataRow["Comments"].ToString()
};
patientMedicationCollection.Add(model);
}
dataTable.Dispose();
}
catch
{
throw;
}
return patientMedicationCollection;
}
public static void SetPatientMedicationCollection(BindingList<PatientMedicationModel> patientMedicationCollection, Int64 clientVisitGUID, Int64 clientGUID, Int64 chartGUID, Int64 userGUID)
{
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
foreach (PatientMedicationModel patientMedicationModel in patientMedicationCollection)
{
parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@SaveDtm", SqlDbType.DateTime, DateTime.Now));
parameters.Add(new StoredProcedureParameter("@HomeMedSummaryID", SqlDbType.Int, patientMedicationModel.HomeMedicationSummaryID));
parameters.Add(new StoredProcedureParameter("@UserGUID", SqlDbType.Decimal, userGUID));
parameters.Add(new StoredProcedureParameter("@ClientVisitGUID", SqlDbType.Decimal, clientVisitGUID));
parameters.Add(new StoredProcedureParameter("@ClientGUID", SqlDbType.Decimal, clientGUID));
parameters.Add(new StoredProcedureParameter("@ChartGUID", SqlDbType.Decimal, chartGUID));
parameters.Add(new StoredProcedureParameter("@OrderReconcileGUID", SqlDbType.Decimal, patientMedicationModel.OrderReconcileGUID));
parameters.Add(new StoredProcedureParameter("@OrderReconcileDtlGUID", SqlDbType.Decimal, patientMedicationModel.OrderReconcileDetailGUID));
parameters.Add(new StoredProcedureParameter("@PrescriptionStatus", SqlDbType.VarChar, patientMedicationModel.PrescriptionStatus));
parameters.Add(new StoredProcedureParameter("@PrescriptionID", SqlDbType.Int, patientMedicationModel.PrescriptionID));
parameters.Add(new StoredProcedureParameter("@DrugName", SqlDbType.VarChar, patientMedicationModel.DrugName));
parameters.Add(new StoredProcedureParameter("@Instructions", SqlDbType.VarChar, patientMedicationModel.Instructions));
parameters.Add(new StoredProcedureParameter("@AlsoKnownAs", SqlDbType.VarChar, patientMedicationModel.AlsoKnownAs));
parameters.Add(new StoredProcedureParameter("@Medication", SqlDbType.VarChar, patientMedicationModel.Medication));
parameters.Add(new StoredProcedureParameter("@ReasonForTaking", SqlDbType.VarChar, patientMedicationModel.ReasonForTaking));
parameters.Add(new StoredProcedureParameter("@DosesTakenToday", SqlDbType.VarChar, patientMedicationModel.DosesTakenToday));
parameters.Add(new StoredProcedureParameter("@NextDose", SqlDbType.VarChar, patientMedicationModel.NextDose));
parameters.Add(new StoredProcedureParameter("@Comments", SqlDbType.VarChar, patientMedicationModel.Comments));
DataTable dataTable = dataHandler.GetStoredProcedureResults(DataConnection.GetConnectionString(), "BH_OPlus_HomeMedSummarySave_Sp", parameters);
dataTable.Dispose();
}
parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@SaveDtm", SqlDbType.DateTime, DateTime.Now));
parameters.Add(new StoredProcedureParameter("@UserGUID", SqlDbType.Decimal, userGUID));
parameters.Add(new StoredProcedureParameter("@ClientVisitGUID", SqlDbType.Decimal, clientVisitGUID));
parameters.Add(new StoredProcedureParameter("@ClientGUID", SqlDbType.Decimal, clientGUID));
parameters.Add(new StoredProcedureParameter("@ChartGUID", SqlDbType.Decimal, chartGUID));
DataTable dummyTable = dataHandler.GetStoredProcedureResults(DataConnection.GetConnectionString(), "BH_OPlus_HomeMedSummaryInactivate_Sp", parameters);
dummyTable.Dispose();
}
catch
{
throw;
}
}
private void ValidateHomeMedication()
{
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@ClientVisitGUID", SqlDbType.BigInt, this._ClientVisitGUID));
parameters.Add(new StoredProcedureParameter("@ClientGUID", SqlDbType.BigInt, this._ClientGUID));
string omrStatus = string.Empty;
DataTable dataTable = dataHandler.GetStoredProcedureResults(this._ConnectionString, "BH_OPlus_HomeMedicationStatus_Sp", parameters);
foreach (DataRow dataRow in dataTable.Rows)
omrStatus = dataRow["OMRStatus"].ToString();
if (omrStatus != "Complete")
this.Show();
else
{
OrderReconciliationManager orderReconciliationManager = new OrderReconciliationManager() { ClientVisitPrimaryKey = Convert.ToInt64(this._ClientVisitGUID) };
orderReconciliationManager.ShowDialog();
this.Close();
}
}
catch (Exception ex)
{
HandleExceptions(ex);
}
}
void Start()
{
dH = this.gameObject.GetComponent<DataHandler>();
clip = new List<AudioClip>();
//Add sounds to list
if (Application.loadedLevelName.Equals("Repetition3"))
{
activeSounds = 1;
if (this.gameObject.name.Contains("Metal"))
{
}
else if (this.gameObject.name.Contains("Wood"))
{
clip.Add(Resources.Load("Sounds/random/rand1") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand2") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand3") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand4") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand5") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand6") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand7") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand8") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand9") as AudioClip);
clip.Add(Resources.Load("Sounds/random/rand10") as AudioClip);
}
}
else if (Application.loadedLevelName.Equals("Speed1"))
{
activeSounds = 3;
if (this.gameObject.name.Contains("Metal"))
{
}
else if (this.gameObject.name.Contains("Wood"))
{
clip.Add(Resources.Load("Sounds/speed/lowSpeed") as AudioClip);
clip.Add(Resources.Load("Sounds/speed/mediumSpeed") as AudioClip);
clip.Add(Resources.Load("Sounds/speed/highSpeed") as AudioClip);
}
}
else
{
activeSounds = 3;
if (this.gameObject.name.Contains("Metal"))
{
}
else if (this.gameObject.name.Contains("Wood"))
{
clip.Add(Resources.Load("Sounds/size/smallCube") as AudioClip);
clip.Add(Resources.Load("Sounds/size/mediumCube") as AudioClip);
clip.Add(Resources.Load("Sounds/size/largeCube") as AudioClip);
}
}
}
