public bool Select(int Id, Models.User user)
{
bool ok = false;
//string select = "select * from user where IdUser = "******"select * from user where IdUser = {Id}";
DbDataReader dr = _db.ExecuteSelect(select);
if (dr.HasRows)
{
ok = true;
user = Map(dr).First();
}
_db.Close();
return(ok);
}
public bool Insert(Models.User user)
{
MySQLPersistence db = new MySQLPersistence(true);
bool ok = false;
try
{
db.StartTransaction();
//Mapeamento Objeto-Relacional
string sql = @"insert user (Name, Email, Password) values (@Name, @Email, @Password)";
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("@Name", user.Name);
param.Add("@Email", user.Email);
param.Add("@Password", user.Password);
int qtdLinhas = db.ExecuteNonQuery(sql, param);
/*db.CleanParam();
*
* sql = @"insert user (Name, Email, Password) values (@Name, @Email, @Password)";
*
* param.Clear();
* param.Add("@Name", user.Name);
* param.Add("@Email", user.Email);
* param.Add("@Password", user.Password);
*
* qtdLinhas = db.ExecuteNonQuery(sql, param);*/
ok = qtdLinhas > 0;
db.TransactionCommit();
}
catch
{
db.TransactionRollback();
}
finally
{
db.Close();
}
return(ok);
}
public List <Models.Product> Search(string name)
{
List <Models.Product> products = new List <Models.Product>();
string select = $"select * from product where Name like @name";
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("@name", "%" + name + "%");
DbDataReader dr = _db.ExecuteSelect(select, param);
products = Map(dr);
_db.Close();
return(products);
}