private void btn_reserve_Click(object sender, EventArgs e) { var firstName = txt_first_name.Text; var lastName = txt_last_name.Text; var phoneNumber = txt_phone_number.Text; if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(phoneNumber)) { MessageBox.Show("Please fill all inputs !"); } else { Reserver reserver = new Reserver(); reserver.FirstName = firstName; reserver.LastName = lastName; reserver.PhoneNumber = phoneNumber; var success = DataBaseManager.Instance.SetReserver(book, reserver); if (success) { MessageBox.Show("This book reserverd successfully"); btn_reserve.Enabled = false; btn_unreserve.Enabled = true; } } }
public async Task <ActionResult <Reserver> > PostReserver(Reserver reserver) { _context.Reservers.Add(reserver); await _context.SaveChangesAsync(); return(RedirectToAction("GetReserver", new { id = reserver.Id })); }
public async Task <IActionResult> PutReserver(int id, Reserver reserver) { if (id != reserver.Id) { return(BadRequest()); } _context.Entry(reserver).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ReserverExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public bool Unreserver(Reserver reserver, Book book) { using (var connection = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;New=True;")) { try { int result = 0; connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "DELETE FROM " + RESERVE_TABLE_NAME + " WHERE reserve_id=" + reserver.ReserveID; result = command.ExecuteNonQuery(); } connection.Close(); book.IsReserverd = false; bool bookIsUpdated = UpdateBook(book); return(result > 0 && bookIsUpdated); } catch (Exception ex) { return(false); } finally { connection.Close(); } } }
public LoginForm(Reserver form) { InitializeComponent(); reserverForm = form; metroTextBoxLoginFormPassword.PasswordChar = '*'; using (FbConnection connection = new FbConnection(reserverForm.ConnectionString)) { try { connection.Open(); string queryGetVersion = string.Format(@" SELECT FIRST 1 codice FROM versioni ORDER BY data DESC"); FbCommand getVersion = new FbCommand(queryGetVersion, connection); string versione = (string)getVersion.ExecuteScalar(); reserverForm.CurrentVersion = versione; } catch (Exception ex) { MessageBox.Show("Richiesta fallita", "Errore di comunicazione con il server", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); Logger.LogStack("Errore.", ex.StackTrace.ToString()); } finally { connection.Close(); } } }
public ActionResult DeleteConfirmed(int id) { Reserver reserver = db.Reservers.Find(id); db.Reservers.Remove(reserver); db.SaveChanges(); return(RedirectToAction("Index")); }
public ServerStatusForm(Reserver form) { InitializeComponent(); reserverForm = form; privateFontCollection = new PrivateFontCollection(); privateFontCollection.AddFontFile(Directory.GetCurrentDirectory() + "\\font\\Quicksand-Light.ttf"); LoadInterface(reserverForm); }
public AcceptanceTestsForm(Reserver form) { InitializeComponent(); reserverForm = form; metroComboBoxStartHour.SelectedIndex = 0; metroComboBoxEndHour.SelectedIndex = metroComboBoxEndHour.Items.Count - 1; AcceptanceTestsServers_Load(); AcceptanceTests_Load(); }
public static ReserverDTO ConvertReserver(Reserver item) { return(new ReserverDTO() { ID = item.ID, ItemID = item.ItemID, Name = item.Name, QuantityReserved = item.QuantityReserved }); }
public async Task CreateAsync(Reserver reserver) { try { _context.Reservations.Add(reserver); await _context.SaveChangesAsync(); } catch (Exception e) { throw new Exception("Error in Insert Reservations " + e.Message); } }
public List <Dictionary <string, string> > GetCarListTest(Reserver filter, CancellationToken token) { ValidateLicense(); var path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "auto.json"); var content = File.ReadAllText(path); var list = new List <Dictionary <string, string> >(100); var autoResponse = JsonConvert.DeserializeObject <AutoResponse>(content); var parsedResponse = ParseResponse(autoResponse); list.AddRange(parsedResponse); return(list); }
public ActionResult Edit([Bind(Include = "IdReservation,Date2Debut,Date2Fin,SalleID,EMID")] Reserver reserver) { if (ModelState.IsValid) { db.Entry(reserver).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EMID = new SelectList(db.Equipement_Mobile, "EMID", "NomEM", reserver.EMID); ViewBag.SalleID = new SelectList(db.Salles, "SalleID", "NomSalle", reserver.SalleID); return(View(reserver)); }
public async Task StatusReserverAsync(Reserver reserver) { try { _context.Reservations.Attach(reserver); _context.Entry(reserver).Property(x => x.Status).IsModified = true; await _context.SaveChangesAsync(); } catch (Exception e) { throw new Exception("Error in Update Reservations" + e.Message); } }
// GET: Reservers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Reserver reserver = db.Reservers.Find(id); if (reserver == null) { return(HttpNotFound()); } return(View(reserver)); }
public async Task TakeAsync(int id) { try { var statusUpdate = new Reserver() { Id = id, Status = ReserveStatus.FINISHED }; await _repository.StatusReserverAsync(statusUpdate); } catch (Exception e) { throw new Exception("Error in Update Reservations" + e.Message); } }
// GET: Reservers/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Reserver reserver = db.Reservers.Find(id); if (reserver == null) { return(HttpNotFound()); } ViewBag.EMID = new SelectList(db.Equipement_Mobile, "EMID", "NomEM", reserver.EMID); ViewBag.SalleID = new SelectList(db.Salles, "SalleID", "NomSalle", reserver.SalleID); return(View(reserver)); }
public bool SetReserver(Book book, Reserver reserver) { bool bookIsUpdated = false; using (SQLiteConnection sqliteConnection = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;New=False;")) { try { sqliteConnection.Open(); //open the connection: var sqlCommand = sqliteConnection.CreateCommand(); sqlCommand.CommandText = "CREATE TABLE IF NOT EXISTS [" + RESERVE_TABLE_NAME + "]" + "([reserve_id]INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," + "[reserver_first_name]NVARCHAR(100) NOT NULL," + "[reserver_last_name]NVARCHAR(100) NOT NULL," + "[reserver_phone_number]NVARCHAR(100))"; sqlCommand.ExecuteNonQuery(); string query = "INSERT INTO " + RESERVE_TABLE_NAME + "(reserver_first_name,reserver_last_name,reserver_phone_number)" + "VALUES(@reserver_first_name,@reserver_last_name,@reserver_phone_number)"; int pk = 0; using (SQLiteCommand command = new SQLiteCommand(query, sqliteConnection)) { using (var transaction = command.Connection.BeginTransaction()) { command.Parameters.AddWithValue("@reserver_first_name", reserver.FirstName); command.Parameters.AddWithValue("@reserver_last_name", reserver.LastName); command.Parameters.AddWithValue("@reserver_phone_number", reserver.PhoneNumber); pk = command.ExecuteNonQuery(System.Data.CommandBehavior.KeyInfo); transaction.Commit(); book.ReserveID = pk; book.IsReserverd = true; bookIsUpdated = UpdateBook(book); } } return(pk > 0 && bookIsUpdated); } catch { } } return(false); }
public ReserveBookForm(Book book) { InitializeComponent(); this.book = book; if (book.IsReserverd) { btn_unreserve.Enabled = true; Reserver = DataBaseManager.Instance.GetReserverWithID(book.ReserveID); if (Reserver != null) { txt_first_name.Text = Reserver.FirstName; txt_last_name.Text = Reserver.LastName; txt_phone_number.Text = Reserver.PhoneNumber; } } else { btn_reserve.Enabled = true; } }
/// <summary> /// Получить список автомобилей по фильтру. /// </summary> /// <param name="filter"> Фильтр.</param> /// <param name="token"> Токен отмены.</param> /// <returns> Ответ от сервера</returns> public async Task <List <Dictionary <string, string> > > GetCarListAsync(Reserver filter, CancellationToken token) { Logger.Debug("HttpClient. /a/auto/auto.json"); var url = _address + "/a/auto/auto.json"; var start = 0; var list = new List <Dictionary <string, string> >(100); try { ValidateLicense(); while (true) { var req = new HttpRequestMessage(HttpMethod.Post, url) { Content = new FormUrlEncodedContent(filter.ToListKeyValuePair(start)) }; var response = await _client.SendAsync(req, token); var content = await response.Content.ReadAsStringAsync(); var autoResponse = JsonConvert.DeserializeObject <AutoResponse>(content); var parsedResponse = ParseResponse(autoResponse); list.AddRange(parsedResponse); start++; if (list.Count >= autoResponse.Results) { break; } } return(list); } catch (Exception e) { Logger.Write("HttpClient. GetCarListAsync. ", e); } return(null); }
public List <Reserver> Reservers() { List <Reserver> Results = new List <Reserver>(); try { SqlCon.Open(); var SqlCmd = new SqlCommand("[book].[uspReadReservers]", SqlCon) { CommandType = CommandType.StoredProcedure }; //Exec Command using (var dr = SqlCmd.ExecuteReader()) { while (dr.Read()) { var detail = new Reserver { FirstName = dr["FirstName"].ToString(), LastName = dr["LastName"].ToString(), IdentityID = dr["IdentityID"].ToString() }; Results.Add(detail); } } } catch (Exception ex) { throw ex; } if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } return(Results); }
public Reserver GetReserverWithID(long reserveID) { using (var connection = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;New=True;")) { try { connection.Open(); string query = "SELECT * FROM " + RESERVE_TABLE_NAME + " WHERE reserve_id=" + reserveID; using (SQLiteCommand command = new SQLiteCommand(query, connection)) { using (SQLiteDataReader reader = command.ExecuteReader()) { if (reader.Read()) { Reserver reserver = new Reserver(); reserver.ReserveID = reader.GetInt64(0); reserver.FirstName = reader.GetString(1); reserver.LastName = reader.GetString(2); reserver.PhoneNumber = reader.GetString(3); return(reserver); } } } return(null); } catch (Exception ex) { return(null); } finally { connection.Close(); } } }
public SlotReservationForm(Reserver form) { InitializeComponent(); reserverForm = form; }
public void LoadInterface(Reserver reserverForm) { // POSSIBILI TODO: // // - Nuovo stato COLLAUDO giallo al posto di rosso / verde? // // - Chiudere reader vari nel codice // // - // using (FbConnection connection = new FbConnection(reserverForm.ConnectionString)) { try { connection.Open(); string queryStatusInfo = string.Format(@" SELECT s.descrizione, r.stato, s.codice FROM statiservers r JOIN servers s ON s.idserver = r.idserver"); FbCommand getStatusInfo = new FbCommand(queryStatusInfo, connection); FbDataAdapter dataReader = new FbDataAdapter(getStatusInfo); DataTable tableStatusInfo = new DataTable(); dataReader.Fill(tableStatusInfo); int top = 70; int insideLeft = 25; foreach (DataRow row in tableStatusInfo.Rows) { Label labelServerDescription = new Label(); labelServerDescription.Top = top; labelServerDescription.Left = 50; labelServerDescription.Size = new Size(200, 60); labelServerDescription.BackColor = Color.FromArgb(92, 162, 150); labelServerDescription.Text = row["DESCRIZIONE"].ToString(); labelServerDescription.TextAlign = ContentAlignment.MiddleCenter; // Esempio modifica Font // labelServerDescription.Font = new Font("Verdana", 9F, FontStyle.Regular, GraphicsUnit.Point, 0); labelServerDescription.Font = new Font(privateFontCollection.Families[0], 11, FontStyle.Bold); labelServerDescription.Name = "groupBox" + row["CODICE"].ToString(); panelServerStatus.Controls.Add(labelServerDescription); Panel panelServerInfo = new Panel(); panelServerInfo.Top = top; panelServerInfo.Left = 250; panelServerInfo.Size = new Size(450, 60); panelServerInfo.BackColor = Color.FromArgb(142, 198, 189); panelServerStatus.Controls.Add(panelServerInfo); MetroFramework.Controls.MetroButton button = new MetroFramework.Controls.MetroButton(); button.Left = insideLeft; button.Size = new Size(150, 25); button.Top = 20; button.Name = row["CODICE"].ToString(); button.FontSize = MetroFramework.MetroButtonSize.Small; button.FontWeight = MetroFramework.MetroButtonWeight.Regular; // Verifica utenti con rilasci attivi che hanno chiuso l'applicazione string queryCheckRilasciAttivi = string.Format(@" SELECT s.idserver FROM servers s JOIN storicorilasci sr ON s.idserver = sr.idserver WHERE s.codice = '{0}' AND sr.idutente = {1} AND sr.attivo = 1", row["CODICE"].ToString(), reserverForm.CurrentUserID); FbCommand getCheckRilasciAttivi = new FbCommand(queryCheckRilasciAttivi, connection); FbDataReader readerGetCheckRilasciAttivi = getCheckRilasciAttivi.ExecuteReader(); button.Text = readerGetCheckRilasciAttivi.Read() ? "Rilascio concluso" : "Rilascia"; readerGetCheckRilasciAttivi.Close(); button.Click += new EventHandler(this.ReleaseButton_Click); Label statusLabel = new Label(); statusLabel.Left = insideLeft + 175; statusLabel.Top = 20; statusLabel.Size = new Size(25, 25); statusLabel.Name = "status" + row["CODICE"].ToString(); statusLabel.Font = new Font("Verdana", 9F, FontStyle.Regular, GraphicsUnit.Point, 0); Label dateLabel = new Label(); dateLabel.Left = insideLeft + 225; dateLabel.Top = 20; dateLabel.AutoSize = false; dateLabel.TextAlign = ContentAlignment.MiddleCenter; dateLabel.Font = new Font("Verdana", 8F, FontStyle.Regular, GraphicsUnit.Point, 0); dateLabel.Size = new Size(100, 25); dateLabel.Name = "date" + row["CODICE"].ToString(); toolTip = new ToolTip(); toolTip.SetToolTip(dateLabel, null); Label avatarLabel = new Label(); avatarLabel.Left = insideLeft + 350; avatarLabel.Top = 5; avatarLabel.Size = new Size(50, 50); avatarLabel.Name = "icon" + row["CODICE"].ToString(); toolTip = new ToolTip(); toolTip.SetToolTip(avatarLabel, null); panelServerInfo.Controls.Add(button); panelServerInfo.Controls.Add(statusLabel); panelServerInfo.Controls.Add(dateLabel); panelServerInfo.Controls.Add(avatarLabel); top += labelServerDescription.Height + 10; } } catch (Exception ex) { MessageBox.Show("Richiesta fallita", "Errore di comunicazione con il server", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); Logger.LogStack("Errore.", ex.StackTrace.ToString()); } finally { connection.Close(); UpdateStatus(); } } }
public ReleaseHistoryForm(Reserver form) { InitializeComponent(); reserverForm = form; ReleaseHistoryForm_Load(); }
public async Task DeleteAsync(Reserver reserver) { _context.Reservations.Remove(reserver); await _context.SaveChangesAsync(); }