public static int UpdateDoc(Document iDocOld, Document iDocNew)
{
RemoveDoc(iDocOld.Id);
if (iDocNew.DocType == DocumentsType.exemption)
AddExemption(iDocNew);
else
AddPrescription(iDocNew);
return 0;
}
public static int AddExemption(Document iDoc)
{
if((GlobalVars.LoggedInUser.AccessLvl == AccessLevel.Doctor) || (GlobalVars.LoggedInUser.AccessLvl == AccessLevel.Admin))
{
GlobalVars.DocumentsList.Add(new Document(++GlobalVars.DocumentsIdCounter, iDoc.Pat, iDoc.DocType, iDoc.ExemptionFrom, iDoc.ExemptionTo, iDoc.ExemptionsNumber, iDoc.CompanyName, iDoc.OddzialNFZ));
Serialize(GlobalVars.DocumentsList, GlobalVars.DocumentsDbName);
CreatingDatabaseSelects.DocInsert(iDoc);
return 0;
}
return 1; //access error
}
public static void DocInsert(Document iDoc)
{
if (GlobalVars.ConnectedToDatabase)
{
MySqlConnection con = new MySqlConnection(MyConnectionString);
con.Open();
try
{
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "insert into document(id, patient_id, doc_type, ex_from, ex_to, ex_number, company_name, oddzial_nfz) values(" + iDoc.Id+","+iDoc.Pat.Id + ",'" + iDoc.DocType + "','" + iDoc.ExemptionFrom.ToString() + "','" + iDoc.ExemptionTo.ToString() + "','" + iDoc.ExemptionsNumber + "','" + iDoc.CompanyName + "','" + iDoc.OddzialNFZ +"');";
cmd.ExecuteNonQuery();
if(iDoc.MedicamentsList != null)
foreach (Medicament m in iDoc.MedicamentsList)
{
cmd.CommandText = "insert into medicaments(id, document_id, name, amount) values(" + iDoc.Id + 500 + "," + iDoc.Id + ",'" + m.Name + "','" + m.Amount + "');";
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
public static int AddPrescription(Document iDoc)
{
if ((GlobalVars.LoggedInUser.AccessLvl == AccessLevel.Doctor) || (GlobalVars.LoggedInUser.AccessLvl == AccessLevel.Admin))
{
GlobalVars.DocumentsList.Add(new Document(++GlobalVars.DocumentsIdCounter, iDoc.Pat, iDoc.DocType, iDoc.MedicamentsList));
Serialize(GlobalVars.DocumentsList, GlobalVars.DocumentsDbName);
CreatingDatabaseSelects.DocInsert(iDoc);
return 0;
}
return 1; //access lvl error
}
/* -- Documents -- */
public static void DocUpdate(Document iDoc)
{
if (GlobalVars.ConnectedToDatabase)
{
DocDelete(iDoc.Id);
DocInsert(iDoc);
}
}
