public Form1()
{
InitializeComponent();
var lp = new Lichtpunkt();
var mast = new Mast();
var s = new SecondForm();
s.ShowDialog();
}
public bool CanDeffend(Card card, int index, Mast kozir, Table table)
{
if (card.CanKill(table.AtackCards[index], kozir) && table.AtackCards.Count > table.DefendCards.Count)
{
table.DefendCards.Add(card);
Ruka.Remove(card);
return(true);
}
return(false);
}
public bool CanKill(Card atackCard, Mast kozir)
{
if (atackCard.Mast == Mast && atackCard.Rank < Rank)
{
return(true);
}
if (Mast == kozir)
{
return(true);
}
return(false);
}
void TusuiColoda()
{
var colodaTusovana = new Card[36];
var rnd = new Random();
for (int i = 0; i < 36; i++)
{
var index = rnd.Next(0, 36);
while (colodaTusovana[index] != null)
{
index = (index + 1) % 36;
}
colodaTusovana[index] = ColodaCard[i];
}
ColodaCard = colodaTusovana.ToList();
Kozir = (Mast)rnd.Next(0, 4);
}
public void Connect_ShouldReturnUpdatedFields_WhenRun()
{
Mast mast = new Mast()
{
VOAAddressLine1 = "Address One",
VOAAddressLine2 = "Address Two",
VOAAddressLine3 = "Address Three",
VOAAddressLine4 = "Address Four",
VOAMastOperator = "asasd",
VOAOccupier = "Occupier",
VOARateableValue = "300",
VOAShared = "Shared",
VOASharedWith = "Many"
};
DataConnector <Mast> mastsConnector = new DataConnector <Mast>();
List <PDFField> fields = new List <PDFField>()
{
new PDFField()
{
Name = "VOAShared",
Value = "Shared"
},
new PDFField()
{
Name = "FOoo",
Value = ""
}
};
List <PDFField> result = mastsConnector.Connect(fields, mast);
//Preserve count
Assert.AreEqual(fields.Count, result.Count);
//Preserve order
Assert.AreEqual(fields[0].Name, result[0].Name);
string updatedResult = result.Where(x => x.Name == "VOAShared").FirstOrDefault().Value;
Assert.AreEqual(mast.VOAShared, updatedResult);
}
public Mast GetMastData(string sharing, string uid, string mastData = "0")
{
Mast mastDataObject = new Mast();
string sql;
using (EventLog eventLog = new EventLog("Application"))
{
eventLog.Source = "Application";
eventLog.WriteEntry($@"Sharing: {sharing}, UID: {uid}, MastData: {mastData}", EventLogEntryType.Information, 101, 1);
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("sp_setapprole", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@rolename", appRoleUsername);
command.Parameters.AddWithValue("@password", appRolePassword);
connection.Open();
command.ExecuteNonQuery();
}
using (SqlCommand command = new SqlCommand("sp_GetTemplateData", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Masts", SqlDbType.Int).Value = mastData;
command.Parameters.AddWithValue("@Sharing", SqlDbType.Int).Value = sharing;
command.Parameters.AddWithValue("@UID", SqlDbType.VarChar).Value = uid;
SqlDataReader reader = command.ExecuteReader();
int rowCount = 0;
while (reader.Read())
{
if (rowCount == 0) //Data is duplicated in numerous rows
{
mastDataObject.VOAAddressLine1 = reader["Address1"].ToString();
mastDataObject.VOAAddressLine2 = reader["Address2"].ToString();
mastDataObject.VOAAddressLine3 = reader["Address3"].ToString();
mastDataObject.VOAAddressLine4 = reader["Address4"].ToString();
mastDataObject.VOAPostcode = reader["Post Code"].ToString();
mastDataObject.VOACounty = reader["County"].ToString();
mastDataObject.VOAMastOperator = reader["Operator"].ToString();
mastDataObject.VOAEffectiveFrom = reader["EffectiveDate"].ToString();
mastDataObject.VOAShared = Convert.ToDouble(reader["NumberOfSharers"]) > 0 ? "Yes" : "No";
mastDataObject.VOARateableValue = $"£{reader["AdoptedRV"]}";
//Hard coding as all Masts are the same.
mastDataObject.VOAPrimaryDescription = "COMMUNICATION STATION AND PREMISES";
}
rowCount++;
}
}
if (mastDataObject.VOAShared == "Yes")
{
int rowCount = 0;
sql = @"SELECT count(*) FROM [NBS2017_Masts].[dbo].[CMV2017D_Sharers] where UID = @UID";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@UID", SqlDbType.VarChar);
command.Parameters["@UID"].Value = uid;
rowCount = (Int32)command.ExecuteScalar();
}
sql = @"SELECT * FROM [NBS2017_Masts].[dbo].[CMV2017D_Sharers] where UID = @UID";
StringBuilder sharers = new StringBuilder();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@UID", SqlDbType.VarChar);
command.Parameters["@UID"].Value = uid;
SqlDataReader reader = command.ExecuteReader();
int count = 0;
while (reader.Read())
{
sharers.Append(reader["ItemName"]);
if (count < rowCount - 1)
{
sharers.Append(", ");
}
count++;
}
}
mastDataObject.VOASharedWith = sharers.ToString();
}
else
{
mastDataObject.VOASharedWith = "N/A";
}
}
return(mastDataObject);
}
public Karta(Mast mast, TypeKarta type)
{
Mast = mast;
Type = type;
}
public Card(Mast mast, Rank rank)
{
Mast = mast;
Rank = rank;
}
public Karta(Mast mastt, Rang rangg)
{
this.mast = mastt;
this.rang = rangg;
}
private DataTable SelectDataToPrint(DataSet dsData, ServiceType serviceType, PrintType printType)
{
Common objComman = new Common();
DataTable dtPrintData = new DataTable("PrintData");
try
{
if (serviceType == ServiceType.Pharmacy && printType == PrintType.Prescription)
{
if (dsData.Tables["INV_PAT_BILLING"] != null && dsData.Tables["Detail"] != null)
{
var BrandQuery = from emr in dsData.Tables["Detail"].AsEnumerable().Where(r => r.RowState != DataRowState.Deleted)
join inv in dsData.Tables["INV_PAT_BILLING"].AsEnumerable().Where(r => r.RowState != DataRowState.Deleted)
on emr.Field <Decimal>("EMR_PAT_DTLS_INV_ORDER_ID") equals
inv.Field <Decimal>("EMR_PAT_DTLS_MEDICATION_ID")
select new
{
EMR_PAT_DTLS_INV_ORDER_ID = emr.Field <decimal?>("EMR_PAT_DTLS_INV_ORDER_ID"),
MEDICINE_TYPE = emr.Field <decimal?>("MEDICINE_TYPE"),
BRAND_GENERIC = emr.Field <string>("NAME"),
ROUTE = emr.Field <string>("ROUTE"),
FORM = emr.Field <string>("FORM"),
DURATION = emr.Field <decimal?>("DURATION"),
ADMINISTRATION_INSTRUCTION = emr.Field <string>("ADMINISTRATION_INSTRUCTION"),
DURATION_TYPE = emr.Field <decimal?>("DURATION_TYPE"),
QUANTITY = emr.Field <decimal?>("QUANTITY"),
QUANTITY_UNIT = emr.Field <string>("QUANTITY_UNIT"),
FREQUENCY = emr.Field <decimal?>("FREQUENCY"),
FREQUENCY_VALUE = emr.Field <decimal?>("FREQUENCY_VALUE"),
REMARKS = emr.Field <string>("REMARKS"),
ADMIN_TIME = emr.Field <string>("ADMIN_TIME"),
START_DATE = emr.Field <DateTime?>("START_DATE"),
SPECIAL_INSTRUCTIONS = emr.Field <string>("CONDITIONAL_FREQUENCY"),
ISLIFELONG = emr.Field <decimal?>("ISLIFELONG"),
BRAND_NAME = inv.Field <string>("NAME")
};
dtPrintData = objComman.LINQToDataTable(BrandQuery);
//Join to get the dosage .
var DosageQuery = from Mast in dtPrintData.AsEnumerable().Where(r => r.RowState != DataRowState.Deleted)
join emr in dsData.Tables["EMR_LOOKUP"].AsEnumerable().Where(r => r.RowState != DataRowState.Deleted)
on Mast.Field <Decimal>("FREQUENCY") equals
emr.Field <Decimal>("EMR_LOOKUP_ID")
select new
{
EMR_PAT_DTLS_INV_ORDER_ID = Mast.Field <decimal?>("EMR_PAT_DTLS_INV_ORDER_ID"),
MEDICINE_TYPE = Mast.Field <decimal?>("MEDICINE_TYPE"),
BRAND_GENERIC = Mast.Field <string>("BRAND_GENERIC"),
ROUTE = Mast.Field <string>("ROUTE"),
FORM = Mast.Field <string>("FORM"),
DURATION = Mast.Field <decimal?>("DURATION"),
ADMINISTRATION_INSTRUCTION = Mast.Field <string>("ADMINISTRATION_INSTRUCTION"),
DURATION_TYPE = Mast.Field <decimal?>("DURATION_TYPE"),
QUANTITY = Mast.Field <decimal?>("QUANTITY"),
QUANTITY_UNIT = Mast.Field <string>("QUANTITY_UNIT"),
FREQUENCY = Mast.Field <decimal?>("FREQUENCY"),
FREQUENCY_VALUE = Mast.Field <decimal?>("FREQUENCY_VALUE"),
REMARKS = Mast.Field <string>("REMARKS"),
ADMIN_TIME = Mast.Field <string>("ADMIN_TIME"),
START_DATE = Mast.Field <DateTime?>("START_DATE"),
SPECIAL_INSTRUCTIONS = Mast.Field <string>("SPECIAL_INSTRUCTIONS"),
ISLIFELONG = Mast.Field <decimal?>("ISLIFELONG"),
BRAND_NAME = Mast.Field <string>("BRAND_NAME"),
DOSE_VALUE = emr.Field <string>("LOOKUP_VALUE"),
DOSE_TYPE = emr.Field <string>("FIELD2"),
DOSE_PRN = emr.Field <string>("FIELD5")
};
dtPrintData = objComman.LINQToDataTable(DosageQuery);
//Join to get the duration type from enum.
CommonFunctions objCommon = new CommonFunctions();
DataTable dtDurationType = objCommon.EnumToDataTable(typeof(Enumerators.EMR.DurationType));
var DurationQuery = from Mast in dtPrintData.AsEnumerable().Where(r => r.RowState != DataRowState.Deleted)
join dur in dtDurationType.AsEnumerable().Where(r => r.RowState != DataRowState.Deleted)
on Convert.ToString(Mast["DURATION_TYPE"]) equals
Convert.ToString(dur["KEY"]) into joinedPatBilling
from dur in joinedPatBilling.DefaultIfEmpty()
select new
{
EMR_PAT_DTLS_INV_ORDER_ID = Mast.Field <decimal?>("EMR_PAT_DTLS_INV_ORDER_ID"),
MEDICINE_TYPE = Mast.Field <decimal?>("MEDICINE_TYPE"),
BRAND_GENERIC = Mast.Field <string>("BRAND_GENERIC"),
ROUTE = Mast.Field <string>("ROUTE"),
FORM = Mast.Field <string>("FORM"),
DURATION = Mast.Field <decimal?>("DURATION"),
ADMINISTRATION_INSTRUCTION = Mast.Field <string>("ADMINISTRATION_INSTRUCTION"),
DURATION_TYPE = Mast.Field <decimal?>("DURATION_TYPE"),
QUANTITY = Mast.Field <decimal?>("QUANTITY"),
QUANTITY_UNIT = Mast.Field <string>("QUANTITY_UNIT"),
FREQUENCY = Mast.Field <decimal?>("FREQUENCY"),
FREQUENCY_VALUE = Mast.Field <decimal?>("FREQUENCY_VALUE"),
REMARKS = Mast.Field <string>("REMARKS"),
ADMIN_TIME = Mast.Field <string>("ADMIN_TIME"),
START_DATE = Mast.Field <DateTime?>("START_DATE"),
SPECIAL_INSTRUCTIONS = Mast.Field <string>("SPECIAL_INSTRUCTIONS"),
ISLIFELONG = Mast.Field <decimal?>("ISLIFELONG"),
BRAND_NAME = Mast.Field <string>("BRAND_NAME"),
DOSE_VALUE = Mast.Field <string>("DOSE_VALUE"),
DOSE_TYPE = Mast.Field <string>("DOSE_TYPE"),
DOSE_PRN = Mast.Field <string>("DOSE_PRN"),
DURATION_TYPE_VALUE = dur != null?dur.Field <string>("VALUE") : null
};
dtPrintData = objComman.LINQToDataTable(DurationQuery);
}
}
else if (serviceType == ServiceType.Investigation && printType == PrintType.BarCode)
{
if (dsData.Tables["LIS_MAST_SAMPLE_COLLECTION"] != null)
{
//Create table to print
dtPrintData.Columns.Add("LIS_SAMPLE_NO", typeof(String));
dtPrintData.Columns.Add("MRNO", typeof(String));
dtPrintData.Columns.Add("PATIENT_NAME", typeof(String));
dtPrintData.Columns.Add("BILL_NO", typeof(String));
dtPrintData.Columns.Add("ISSTICKER", typeof(String));
dtPrintData.Columns.Add("BARCODE_COUNT", typeof(Decimal));
dtPrintData.Columns.Add("SPECIMEN_NAME", typeof(String));
dtPrintData.Columns.Add("ISPATIENT", typeof(Decimal));
//Add necessary data from dataset to datatable to print
foreach (DataRow dr in dsData.Tables["LIS_MAST_SAMPLE_COLLECTION"].Rows)
{
DataRow drNew = dtPrintData.NewRow();
drNew["LIS_SAMPLE_NO"] = dr["LIS_SAMPLE_NO"].ToString();
drNew["MRNO"] = dr["MRNO"].ToString();
drNew["PATIENT_NAME"] = dr["PATIENT_NAME"].ToString();
drNew["BILL_NO"] = dr["BILL_NO"].ToString();
drNew["ISSTICKER"] = dr["ISSTICKER"].ToString();
drNew["BARCODE_COUNT"] = Convert.ToDecimal(dr["BARCODE_COUNT"].ToString());
drNew["SPECIMEN_NAME"] = dr["SPECIMEN_NAME"].ToString();
drNew["ISPATIENT"] = Convert.ToDecimal(dr["ISPATIENT"].ToString());
dtPrintData.Rows.Add(drNew);
}
////
}
}
return(dtPrintData);
}
catch
{
throw;
}
}
