public int Add(CumpridorEnt cumpridor)
{
var connectionString = this.GetConnection();
int count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "INSERT INTO Cumpridor(Nome, Cpf, Email, Senha) VALUES(@Nome, @Cpf, @Email, @Senha); SELECT CAST(SCOPE_IDENTITY() as INT); ";
count = con.Execute(query, cumpridor);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(count);
}
}
public CumpridorEnt LogOn(CumpridorEnt login)
{
var connectionString = this.GetConnection();
CumpridorEnt cumpridor = new CumpridorEnt();
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "SELECT * FROM Cumpridor where Email = @Email and Senha = @Senha";
cumpridor = con.Query <CumpridorEnt>(query, new { login.Email, login.Senha }).First();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(cumpridor);
}
}
public int Edit(CumpridorEnt cumpridor)
{
throw new NotImplementedException();
}
