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); } }