public void Actualiza(TypeProductBE pItem) { try { TypeProductDL TypeProduct = new TypeProductDL(); TypeProduct.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public void Elimina(TypeProductBE pItem) { try { TypeProductDL TypeProduct = new TypeProductDL(); TypeProduct.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public TypeProductBE SeleccionaDescripcion(int IdCompany, string NameTypeProduct) { try { TypeProductDL TypeProduct = new TypeProductDL(); TypeProductBE objEmp = TypeProduct.SeleccionaDescripcion(IdCompany, NameTypeProduct); return(objEmp); } catch (Exception ex) { throw ex; } }
public TypeProductBE Selecciona(int IdTypeProduct) { try { TypeProductDL TypeProduct = new TypeProductDL(); TypeProductBE objEmp = TypeProduct.Selecciona(IdTypeProduct); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(TypeProductBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeProduct_Elimina"); db.AddInParameter(dbCommand, "pIdTypeProduct", DbType.Int32, pItem.IdTypeProduct); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany); db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login); db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine); db.ExecuteNonQuery(dbCommand); }
public TypeProductBE Selecciona(int IdTypeProduct) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeProduct_Selecciona"); db.AddInParameter(dbCommand, "pidTypeProduct", DbType.Int32, IdTypeProduct); IDataReader reader = db.ExecuteReader(dbCommand); TypeProductBE TypeProduct = null; while (reader.Read()) { TypeProduct = new TypeProductBE(); TypeProduct.IdTypeProduct = Int32.Parse(reader["idTypeProduct"].ToString()); TypeProduct.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); TypeProduct.NameTypeProduct = reader["NameTypeProduct"].ToString(); TypeProduct.FlagState = Boolean.Parse(reader["FlagState"].ToString()); } reader.Close(); reader.Dispose(); return(TypeProduct); }
public List <TypeProductBE> ListaTodosActivo(int IdCompany) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeProduct_ListaTodosActivo"); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany); IDataReader reader = db.ExecuteReader(dbCommand); List <TypeProductBE> TypeProductlist = new List <TypeProductBE>(); TypeProductBE TypeProduct; while (reader.Read()) { TypeProduct = new TypeProductBE(); TypeProduct.IdTypeProduct = Int32.Parse(reader["idTypeProduct"].ToString()); TypeProduct.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); TypeProduct.NameTypeProduct = reader["NameTypeProduct"].ToString(); TypeProduct.FlagState = Boolean.Parse(reader["FlagState"].ToString()); TypeProductlist.Add(TypeProduct); } reader.Close(); reader.Dispose(); return(TypeProductlist); }