private void button3_Click(object sender, EventArgs e)
{
if (Convert.ToDouble(percTxt.Text) < 0)
{
percTxt.BackColor = Color.Red;
MessageBox.Show("Please input the percentage contribution !");
return;
}
string id = Guid.NewGuid().ToString();
ItemCoverage t = new ItemCoverage(id, TransID, ItemID, CoverID, Convert.ToDouble(percTxt.Text), Convert.ToDouble(amountTxt.Text), DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemCoverage.Add(t);
ItemCoverage c = new ItemCoverage(t.Id, t.CaseTransactionID, t.ItemID, t.CoverageID, t.Percentage, t.Amount, t.Created, "false", Helper.CompanyID);
string save = MySQL.Insert(c);
if (save != "")
{
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(save), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
}
this.DialogResult = DialogResult.OK;
this.Dispose();
}
private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("YES or No?", "Confirm submission ? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
foreach (var s in typeListBx.CheckedItems)
{
TypeDictionary.Add(s.ToString(), true);
}
foreach (var s in placeListBx.CheckedItems)
{
PlaceDictionary.Add(s.ToString(), true);
}
var TypeJson = JsonConvert.SerializeObject(TypeDictionary);
var PlaceJson = JsonConvert.SerializeObject(PlaceDictionary);
Cases i = new Cases(CaseID, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, providerNoTxt.Text, coverageID, CustomerID, PractitionerID, practictionerTypeCbx.Text, roleTypeCbx.Text, TypeJson, PlaceJson, informationTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Convert.ToDateTime(reqStart.Text).ToString("dd-MM-yyyy"), Convert.ToDateTime(reqEnd.Text).ToString("dd-MM-yyyy"), Convert.ToDateTime(reqStart.Text).ToString("dd-MM-yyyy"), Convert.ToDateTime(reqEnd.Text).ToString("dd-MM-yyyy"), "false", Helper.CompanyID);
string save = MySQL.Insert(i);
if (save != "")
{
Queries qi = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(save), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(qi);
foreach (CaseTransaction t in GenericCollection.caseTransactions)
{
CaseTransaction c = new CaseTransaction(t.Id, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, t.ItemID, CaseID, "", t.Qty, t.Cost, t.Units, t.Total, t.Tax, t.Coverage, t.Self, t.Payable, t.Limits, t.Setting, t.Period, t.Height, t.Weight, t.Instruction, t.Created, "false", Helper.CompanyID);
string saving = MySQL.Insert(c);
if (saving != "")
{
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(saving), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
}
}
//foreach (ICD10 t in GenericCollection.icd10)
//{
// ICD10 c = new ICD10(t.Id, CaseID, t.Code, t.Name, t.Created, "false", Helper.CompanyID);
// string doing = MySQL.Insert(c);
// if (doing != "")
// {
// Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(doing), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
// MySQL.Insert(q);
// }
//}
// ItemCoverage t = new ItemCoverage(id,TransID,ItemID,CoverID,Convert.ToDouble(percTxt.Text), Convert.ToDouble(amountTxt.Text),DateTime.Now.ToString("dd-MM-yyyy H:m:s"),"false",Helper.CompanyID);
foreach (ItemCoverage t in GenericCollection.itemCoverage)
{
ItemCoverage c = new ItemCoverage(t.Id, t.CaseTransactionID, t.ItemID, t.CoverageID, t.Percentage, t.Amount, t.Created, "false", Helper.CompanyID);
string mg = MySQL.Insert(c);
if (mg != "")
{
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(mg), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
}
}
MessageBox.Show("Information Saved");
this.Close();
}
}
}
private void button3_Click(object sender, EventArgs e)
{
string exists = "";
try
{
exists = MySQL.value("SELECT no FROM orders WHERE no = '" + noTxt.Text + "'");
}
catch (Exception y)
{
//MessageBox.Show( y.Message + noTxt.Text);
exists = "";
}
//.value(string table, string value, string column, string variable)
if (!string.IsNullOrEmpty(exists))
{
int no = Convert.ToInt32(exists);
MessageBox.Show("The order number " + noTxt.Text + " is already in use.New order number assigned:" + noTxt.Text);
noTxt.Text = (no + 1).ToString();
return;
}
if (string.IsNullOrEmpty(PractitionerID))
{
MessageBox.Show("Please select a Doctor ");
}
string hospital = hospitalChk.Checked ? "Yes" : "No";
string preopRm = preRmChk.Checked ? "Yes" : "No";
string postopRm = postRmChk.Checked ? "Yes" : "No";
string home = homeChk.Checked ? "Yes" : "No";
string preopHome = preHomeChk.Checked ? "Yes" : "No";
string facility = facilityChk.Checked ? "Yes" : "No";
string clinic = clinicChk.Checked ? "Yes" : "No";
string notified = notifiedChk.Checked ? "Yes" : "No";
string authorisation = authorisationChk.Checked ? "Yes" : "No";
string insurance = insuranceChk.Checked ? "Yes" : "No";
string contacted = contactedChk.Checked ? "Yes" : "No";
string sent = cmnSentChk.Checked ? "Yes" : "No";
string returned = cmnReturnedChk.Checked ? "Yes" : "No";
if (GenericCollection.caseTransactions.Count() < 1)
{
MessageBox.Show("Please select one or more products !");
return;
}
string id = Guid.NewGuid().ToString();
if (MessageBox.Show("YES or NO?", "Save information ? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
foreach (CaseTransaction t in GenericCollection.caseTransactions)
{
CaseTransaction c = new CaseTransaction(t.Id, Convert.ToDateTime(orderDateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, t.ItemID, noTxt.Text, "", t.Qty, t.Cost, t.Units, t.Total, t.Tax, t.Coverage, t.Self, t.Payable, t.Limits, t.Setting, t.Period, t.Height, t.Weight, t.Instruction, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
foreach (ItemCoverage t in GenericCollection.itemCoverage)
{
ItemCoverage c = new ItemCoverage(t.Id, t.CaseTransactionID, t.ItemID, t.CoverageID, t.Percentage, t.Amount, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
Orders i = new Orders(id, noTxt.Text, CustomerID, Helper.UserID, Convert.ToDateTime(orderDateTxt.Text).ToString("dd-MM-yyyy"), orderTimeTxt.Text, recievedCbx.Text, Convert.ToDateTime(dispenseDateTxt.Text).ToString("dd-MM-yyyy"), dispensedTimeTxt.Text, dispensedCbx.Text, typeCbx.Text, diagnosisTxt.Text, surgeryTxt.Text, Convert.ToDateTime(clinicalDateTxt.Text).ToString("dd-MM-yyyy"), specificTxt.Text, hospital, home, preopRm, preopHome, postopRm, roomTxt.Text, Convert.ToDateTime(setupDate.Text).ToString("dd-MM-yyyy"), Convert.ToDateTime(neededDateTxt.Text).ToString("dd-MM-yyyy"), facility, clinic, otherTxt.Text, notified, authorisation, insurance, contacted, sent, returned, Convert.ToDateTime(dateSentTxt.Text).ToString("dd-MM-yyyy"), Convert.ToDateTime(dateReturnedTxt.Text).ToString("dd-MM-yyyy"), PractitionerID, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
MySQL.Insert(i);
MessageBox.Show("Information Saved");
Helper.CurrentCustomer = "";
this.Close();
}
else
{
MessageBox.Show("Report can not be Generated unless information is saved !");
}
}
