public void Show() { try { var connection = ActiveRecord.Open(); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = "SELECT * FROM Prescriptions"; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Console.WriteLine(); Console.WriteLine("ID: " + sqlDataReader["ID"]); Console.WriteLine("Nazwa Klienta: " + sqlDataReader["CustomerName"]); Console.WriteLine("Pesel: " + sqlDataReader["PESEL"]); Console.WriteLine("Numer recepty: " + sqlDataReader["PrescriptionNumber"]); Console.WriteLine(); } Console.ReadLine(); } } catch (Exception e) { Console.WriteLine(e); } }
public static bool Check(int ID) { try { var connection = ActiveRecord.Open(); int id = 0; id = ID; using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = "SELECT COUNT(*) FROM Prescriptions WHERE ID = @id"; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@id" }; sqlCommand.Parameters.Add(sqlIDParam); int userCount = (int)sqlCommand.ExecuteScalar(); if (userCount >= 0) { return(true); } else { return(false); } } } catch (Exception e) { Console.WriteLine("Nie ma takiego id"); Console.WriteLine(e.Message); return(false); } }
public void Show() { try { var connection = ActiveRecord.Open(); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = "SELECT * FROM Medicines"; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Console.WriteLine(); Console.WriteLine("ID: " + sqlDataReader["ID"]); Console.WriteLine("Nazwa: " + sqlDataReader["Name"]); Console.WriteLine("Producent: " + sqlDataReader["Manufacturer"]); Console.WriteLine("Cena: " + sqlDataReader["Price"]); Console.WriteLine("Ilość: " + sqlDataReader["Amount"]); Console.Write("Na recepte: "); if (Convert.ToBoolean(sqlDataReader["WithPrescription"]) == true) { Console.Write("Tak"); } else { Console.Write("Nie"); } Console.WriteLine(); } Console.ReadLine(); } } catch (Exception e) { Console.WriteLine(e); } }
public void Show() { try { var connection = ActiveRecord.Open(); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = "SELECT * FROM Orders"; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Console.WriteLine(); Console.WriteLine("ID: " + sqlDataReader["ID"]); Console.WriteLine("ID leku: " + sqlDataReader["MedicinID"]); Console.WriteLine("ID recepty: " + sqlDataReader["PrescriptionID"]); Console.WriteLine("Data: " + sqlDataReader["Date"]); Console.WriteLine("Ilość: " + sqlDataReader["Amount"]); Console.WriteLine(); } Console.ReadLine(); } } catch (Exception e) { Console.WriteLine(e); } }
public override void Reload() { var connection = ActiveRecord.Open(); do { try { Console.WriteLine("Podaj Id do modyfikacji: "); string ID = Console.ReadLine(); if (Prescription.Check(Int32.Parse(ID)) == false) { Console.ReadKey(); return; } Console.WriteLine("Nazwa klienta: "); string customerName = Console.ReadLine(); Console.WriteLine("PESEL: "); string pesel = Console.ReadLine(); Console.WriteLine("Numer recepty: "); string prescriptionNumber = Console.ReadLine(); Prescription prescription = new Prescription(customerName, pesel, prescriptionNumber); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"UPDATE Prescriptions SET CustomerName = @customerName, PESEL = @pesel, PrescriptionNumber = @prescriptionNumber WHERE ID = @ID"; var sqlCustomerNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = prescription.CustomerName, ParameterName = "@customerName" }; var sqlPESELParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = prescription.PESEL, ParameterName = "@pesel" }; var sqlPrescriptionNumberParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = prescription.PrescriptionNumber, ParameterName = "@prescriptionNumber" }; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlCustomerNameParam); sqlCommand.Parameters.Add(sqlPESELParam); sqlCommand.Parameters.Add(sqlPrescriptionNumberParam); sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteNonQuery(); } askTheUser2: Console.WriteLine("Chcesz zmodyfikować kolejną pozycję? (T/N): "); string addAnother = Console.ReadLine().Trim().ToLower(); if (addAnother == "t") { continue; } else if (addAnother == "n") { break; } else { Console.WriteLine("Nieznana odpowiedź"); goto askTheUser2; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } while (true); }
public override void Save() { do { try { var connection = ActiveRecord.Open(); Console.WriteLine("Nazwa klienta: "); string customerName = Console.ReadLine(); Console.WriteLine("PESEL: "); string pesel = Console.ReadLine(); Console.WriteLine("Numer recepty: "); string prescriptionNumber = Console.ReadLine(); Prescription prescription = new Prescription(customerName, pesel, prescriptionNumber); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"INSERT INTO Prescriptions (CustomerName, PESEL, PrescriptionNumber) VALUES (@CustomerName, @PESEL, @PrescriptionNumber)" ; var sqlCustomerNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = prescription.CustomerName, ParameterName = "@customerName" }; var sqlPESELParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = prescription.PESEL, ParameterName = "@pesel" }; var sqlPrescriptionNumberParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = prescription.PrescriptionNumber, ParameterName = "@prescriptionNumber" }; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlCustomerNameParam); sqlCommand.Parameters.Add(sqlPESELParam); sqlCommand.Parameters.Add(sqlPrescriptionNumberParam); sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteNonQuery(); } askTheUser2: Console.WriteLine("Chcesz dodać kolejną pozycję? (T/N): "); string addAnother = Console.ReadLine().Trim().ToLower(); if (addAnother == "t") { continue; } else if (addAnother == "n") { break; } else { Console.WriteLine("Nieznana odpowiedź"); goto askTheUser2; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } while (true); }
public override void Remove() { do { try { Console.WriteLine("Podaj Id do usuniecia: "); string ID = Console.ReadLine(); if (Prescription.Check(Int32.Parse(ID)) == false) { Console.ReadKey(); return; } var connection = ActiveRecord.Open(); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"DELETE FROM Prescriptions WHERE ID = @ID"; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteNonQuery(); } askTheUser2: Console.WriteLine("Chcesz usunąć kolejną pozycję? (T/N): "); string addAnother = Console.ReadLine().Trim().ToLower(); if (addAnother == "t") { continue; } else if (addAnother == "n") { break; } else { Console.WriteLine("Nieznana odpowiedź"); goto askTheUser2; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } while (true); }
public override void Reload() { var connection = ActiveRecord.Open(); do { try { Console.WriteLine("Podaj numer Id zamówienia do modyfikacji: "); string ID = Console.ReadLine(); if (Order.Check(Int32.Parse(ID)) == false) { Console.ReadKey(); return; } Console.WriteLine("Id leku: "); int medicinId = Int32.Parse(Console.ReadLine()); Console.WriteLine("Id recepty: "); int prescriptionId = Int32.Parse(Console.ReadLine()); Console.WriteLine("Data: "); DateTime date = DateTime.Parse(Console.ReadLine(), System.Globalization.CultureInfo.InvariantCulture); Console.WriteLine("Ilość: "); int amount = Int32.Parse(Console.ReadLine()); Order order = new Order(medicinId, prescriptionId, date, amount); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"UPDATE Orders SET MedicinID = @medicinId, PrescriptionID = @prescriptionId, Date = @date, Amount = @amount WHERE ID = @ID"; var sqlMedicinIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = order.MedicinID, ParameterName = "@medicinId" }; var sqlPrescriptionIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = order.PrescriptionID, ParameterName = "@prescriptionId" }; var sqlDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = order.Date, ParameterName = "@date" }; var sqlAmountParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = order.Amount, ParameterName = "@amount" }; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlMedicinIDParam); sqlCommand.Parameters.Add(sqlPrescriptionIDParam); sqlCommand.Parameters.Add(sqlDateParam); sqlCommand.Parameters.Add(sqlAmountParam); sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteNonQuery(); } askTheUser2: Console.WriteLine("Chcesz zmodyfikować kolejną pozycję? (T/N): "); string addAnother = Console.ReadLine().Trim().ToLower(); if (addAnother == "t") { continue; } else if (addAnother == "n") { break; } else { Console.WriteLine("Nieznana odpowiedź"); goto askTheUser2; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } while (true); }
public override void Save() { do { try { var connection = ActiveRecord.Open(); Console.WriteLine("Id leku: "); int medicinId = Int32.Parse(Console.ReadLine()); Console.WriteLine("Id recepty: "); int prescriptionId = Int32.Parse(Console.ReadLine()); Console.WriteLine("Data: "); DateTime date = DateTime.Parse(Console.ReadLine(), System.Globalization.CultureInfo.InvariantCulture); Console.WriteLine("Ilość: "); int amount = Int32.Parse(Console.ReadLine()); Order order = new Order(medicinId, prescriptionId, date, amount); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"INSERT INTO Orders (Orders.MedicinID, Orders.PrescriptionID, Date, Amount) VALUES ( (select ID from Medicines where ID = @medicinId), (select ID from Prescriptions where ID = @prescriptionId), @date, @amount)" ; var sqlMedicinIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = order.MedicinID, ParameterName = "@medicinId" }; var sqlPrescriptionIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = order.PrescriptionID, ParameterName = "@prescriptionId" }; var sqlDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = order.Date, ParameterName = "@date" }; var sqlAmountParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = order.Amount, ParameterName = "@amount" }; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlMedicinIDParam); sqlCommand.Parameters.Add(sqlPrescriptionIDParam); sqlCommand.Parameters.Add(sqlDateParam); sqlCommand.Parameters.Add(sqlAmountParam); sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteNonQuery(); } askTheUser2: Console.WriteLine("Chcesz dodać kolejną pozycję? (T/N): "); string addAnother = Console.ReadLine().Trim().ToLower(); if (addAnother == "t") { continue; } else if (addAnother == "n") { break; } else { Console.WriteLine("Nieznana odpowiedź"); goto askTheUser2; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } while (true); }
public override void Reload() { var connection = ActiveRecord.Open(); do { try { Console.WriteLine("Podaj Id do modyfikacji: "); string ID = Console.ReadLine(); if (Medicin.Check(Int32.Parse(ID)) == false) { Console.ReadKey(); return; } Console.WriteLine("Nazwa: "); string name = Console.ReadLine(); Console.WriteLine("Producent: "); string manufacturer = Console.ReadLine(); Console.WriteLine("Cena: "); decimal price = Decimal.Parse(Console.ReadLine()); Console.WriteLine("Ilość: "); int amount = Int32.Parse(Console.ReadLine()); askTheUser: Console.WriteLine("Na recepte (T/N): "); string tempPerscription = Console.ReadLine().ToLower().Trim(); bool withPrescription = false; if (tempPerscription == "t") { withPrescription = true; } else if (tempPerscription == "n") { withPrescription = false; } else { Console.WriteLine("Błędny format."); goto askTheUser; } Medicin medicin = new Medicin(name, manufacturer, price, amount, withPrescription); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"UPDATE Medicines SET Name = @name, Manufacturer = @Manufacturer, Price = @Price, Amount = @Amount, WithPrescription = @WithPrescription WHERE ID = @ID"; var sqlNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = medicin.Name, ParameterName = "@name" }; var sqlManufacturerParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = medicin.Manufacturer, ParameterName = "@Manufacturer" }; var sqlPriceParam = new SqlParameter { DbType = System.Data.DbType.Decimal, Value = medicin.Price, ParameterName = "@Price" }; var sqlAmountParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = medicin.Amount, ParameterName = "@Amount" }; var sqlWithPrescriptionParam = new SqlParameter { DbType = System.Data.DbType.Boolean, Value = medicin.WithPrescription, ParameterName = "@WithPrescription" }; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlNameParam); sqlCommand.Parameters.Add(sqlManufacturerParam); sqlCommand.Parameters.Add(sqlPriceParam); sqlCommand.Parameters.Add(sqlAmountParam); sqlCommand.Parameters.Add(sqlWithPrescriptionParam); sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteNonQuery(); } askTheUser2: Console.WriteLine("Chcesz zmodyfikować kolejną pozycję? (T/N): "); string addAnother = Console.ReadLine().Trim().ToLower(); if (addAnother == "t") { continue; } else if (addAnother == "n") { break; } else { Console.WriteLine("Nieznana odpowiedź"); goto askTheUser2; } } catch (Exception ex) { Console.WriteLine(ex.Message); } } while (true); }