public bool AddProducto(Product ProductoPeluche)
{
try {
using (GiftShopDBEntities db = new GiftShopDBEntities())
{
db.Products.Add(ProductoPeluche);
db.SaveChanges();
return(true);
}
} catch (Exception ex) { throw ex; }
}
public bool IsValidUser(User u)
{
try
{
using (GiftShopDBEntities db = new GiftShopDBEntities())
{
User obj = (from user in db.Users
where
user.password == u.password && user.userid == u.userid
select user).FirstOrDefault();
if (obj != null)
{
return(true);
}
else
{
return(false);
}
}
// List<OracleParameter> param = new List<OracleParameter>()
//{
// new OracleParameter("p_user_id",OracleDbType.Int32, u.USER_ID, ParameterDirection.Input),
// new OracleParameter("p_password", OracleDbType.Varchar2, u.PASSWORDX, ParameterDirection.Input){Size=200},
// new OracleParameter("p_valid", OracleDbType.Varchar2, ParameterDirection.Output){Size=200},
// new OracleParameter("p_site_id",OracleDbType.Int32,ParameterDirection.Output),
// new OracleParameter("p_active", OracleDbType.Varchar2,ParameterDirection.Output){Size=200},
// new OracleParameter("p_role",OracleDbType.Varchar2,ParameterDirection.Output){Size=200},
// new OracleParameter("p_force_pswd_change",OracleDbType.Varchar2,ParameterDirection.Output){Size=200}
//};
// OracleParameterCollection Coll = new ClsSQL().ExecuteSPOutputParams("TS_VALIDATE_USER", param);
// string userid = Coll["p_user_id"].Value.ToString();
// User user = new UserService().GetUser(decimal.Parse(Coll["p_user_id"].Value.ToString()), Coll["p_password"].Value.ToString());
// log.Info(string.Format("User {0} was logged correctly ", user.USER_ID.ToString()));
return(true);
}
catch (Exception Exception)
{
//log.Error(Exception);
throw Exception;
}
}
public bool RegistraProducto(GiftShop.core.ShoppingCart Product)
{
try
{
using (GiftShopDBEntities db = new GiftShopDBEntities())
{
db.ShoppingCarts.Add(Product);
db.SaveChanges();
return(true);
}
}
catch (Exception ex) { throw ex; }
}
public User GetUser(string UserID, string password)
{
try
{
using (GiftShopDBEntities db = new GiftShopDBEntities())
{
return(db.Users.Find(UserID));
}
}
catch (Exception ex)
{
// log.Error(ex);
throw ex;
}
}
public bool EliminaProducto(GiftShop.core.ShoppingCart Product)
{
try
{
using (GiftShopDBEntities db = new GiftShopDBEntities())
{
var entry = db.Entry(Product);
if (entry.State == EntityState.Detached)
{
db.ShoppingCarts.Attach(Product);
}
db.ShoppingCarts.Remove(Product);
db.SaveChanges();
return(true);
}
}
catch (Exception ex) { throw ex; }
}
public RepositoryBase()
{
this._context = new GiftShopDBEntities();
this._collection = this._context.Set <TEntity>();
}
