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