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