public void saveBilet(Bilet b)
{
try
{
IDbConnection con = factory.createConnection();
con.Open();
using (var com = con.CreateCommand())
{
com.CommandText = "INSERT INTO BILET VALUES (@p1, @p2, @p3)";
var param = com.CreateParameter();
param.ParameterName = "@p1";
param.Value = b.Customer;
com.Parameters.Add(param);
var param2 = com.CreateParameter();
param2.ParameterName = "@p2";
param2.Value = b.ConcertID;
com.Parameters.Add(param2);
var param3 = com.CreateParameter();
param3.ParameterName = "@p3";
param3.Value = b.Seats;
com.Parameters.Add(param3);
com.ExecuteNonQuery();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public int CheckLoginCredentials(string user, string pass)
{
int rez = -1;
try
{
IDbConnection con = utile.createConnection();
using (IDbCommand cmd = con.CreateCommand())
{
con.Open();
cmd.CommandText = "SELECT ID FROM USER WHERE NUME = @p1 and PAROLA = @p2";
var par1 = cmd.CreateParameter();
par1.Value = user;
par1.ParameterName = "@p1";
cmd.Parameters.Add(par1);
var par2 = cmd.CreateParameter();
par2.Value = pass;
par2.ParameterName = "@p2";
cmd.Parameters.Add(par2);
int aux = (int)cmd.ExecuteScalar();
if (aux > 0)
{
rez = aux;
Console.Write("USER REPO - Utilizator gasit\n");
}
else
{
Console.WriteLine("USER REPO - Autentificare nereusita\n");
}
}
}
catch (Exception e)
{
Console.Write(e.Message);
}
return(rez);
}