コード例 #1
0
        public static void MedicamentsInsert(Medicament iM)
        {
            if (GlobalVars.ConnectedToDatabase)
            {
                MySqlConnection con = new MySqlConnection(MyConnectionString);
                con.Open();

                try
                {
                    MySqlCommand cmd = con.CreateCommand();
                    cmd.CommandText = "insert into medicaments(id, document_id, name, amount) values(" + GlobalVars.MedicamentsIdCounter + "," + GlobalVars.DocumentsIdCounter + ",'" + iM.Name + "','" + iM.Amount + "');";
                    cmd.ExecuteNonQuery();
                }
                catch (Exception)
                { 
                }
                finally
                {
                    if (con.State == ConnectionState.Open)
                    {
                        con.Close();
                    }
                }
            }
        }
コード例 #2
0
 public static int AddMedicament(Medicament iMed)
 {
     GlobalVars.MedicamentsList.Add(new Medicament(++GlobalVars.MedicamentsIdCounter, iMed.Name, iMed.Amount));
     Serialize(GlobalVars.MedicamentsList, GlobalVars.MedicamentsDbName);
     CreatingDatabaseSelects.MedicamentsInsert(iMed);
     return 0;
 }
コード例 #3
0
 /* -- MEdicaments -- */
 public static void MedicamentsUpdate(Medicament iM)
 {
     if (GlobalVars.ConnectedToDatabase)
     {
         MedicamentsDelete(iM.Id);
         MedicamentsInsert(iM);
     }
 }