// Método que permite consultar Presentación de productos /// <summary> /// Modificiación: se quita parametro de consulta id_ProductPresentation y se agregan 2: id_ProductCategory y id_Brand y se modifica tipo de dato de string a long para: lidProductPresentation /// 24/08/2010 Magaly Jiménez /// </summary> /// <param name="sid_ProductCategory"></param> /// <param name="iid_Brand"></param> /// <param name="sProductPresentationName"></param> /// <returns>dtPresentation</returns> public DataTable BuscarPresentation(string sid_ProductCategory, int iid_Brand, string sProductPresentationName) { DProduct_Presentations odsPresentation = new DProduct_Presentations(); EProduct_Presentations oePresentation = new EProduct_Presentations(); DataTable dtPresentation = odsPresentation.ConsultarPresentacion(sid_ProductCategory, iid_Brand, sProductPresentationName); odsPresentation = null; return(dtPresentation); }
/// <summary> /// Inserta presentaciones en la Bd intermedia /// 31/01/2011 Magaly jiménez /// </summary> /// <param name="sidProductPresentation"></param> /// <param name="sProductPresentationName"></param> /// <param name="dProductPresentation_Neto"></param> /// <param name="iid_UnitOfMeasure"></param> /// <param name="bProductPresentation_Status"></param> /// <returns></returns> public EProduct_Presentations RegistrarPresentationTMP(string sidProductPresentation, string sProductPresentationName, decimal dProductPresentation_Neto, int iid_UnitOfMeasure, bool bProductPresentation_Status) { DProduct_Presentations odrPresentationtmp = new DProduct_Presentations(); EProduct_Presentations oePresentationtmp = odrPresentationtmp.RegistrarPresentationPKTMP(sidProductPresentation, sProductPresentationName, dProductPresentation_Neto, iid_UnitOfMeasure, bProductPresentation_Status); odrPresentationtmp = null; return(oePresentationtmp); }
//Metodo que permite actualizar Presentación de productos /// <summary> /// Modificiación: se agregan 3 columnas para actualzación id_ProductCategory, id_Subcategory y id_Brand y se modifica tipo de dato de string a long para: lidProductPresentation /// 24/08/2010 Magaly Jiménez /// 30/08/2010 se agregan dos parametros nuevos sEmpaquetamiento, iUnidad_Empaque . Ing. Mauricio Ortiz /// </summary> /// <param name="sidProductPresentation"></param> /// <param name="sid_ProductCategory"></param> /// <param name="lid_Subcategory"></param> /// <param name="iid_Brand"></param> /// <param name="sEmpaquetamiento"></param> /// <param name="sUnidad_Empaque"></param> /// <param name="sProductPresentationName"></param> /// <param name="dProductPresentation_Neto"></param> /// <param name="iid_UnitOfMeasure"></param> /// <param name="bProductPresentation_Status"></param> /// <param name="sProductPresentation_ModiBy"></param> /// <param name="tProductPresentation_DateModiBy"></param> /// <returns>oeaPresentation</returns> public EProduct_Presentations ActualizarPresentation(string sidProductPresentation, string sid_ProductCategory, long lid_Subcategory, int iid_Brand, string sEmpaquetamiento, string sUnidad_Empaque, string sProductPresentationName, decimal dProductPresentation_Neto, int iid_UnitOfMeasure, bool bProductPresentation_Status, string sProductPresentation_ModiBy, DateTime tProductPresentation_DateModiBy) { DProduct_Presentations odaPresentation = new DProduct_Presentations(); EProduct_Presentations oeaPresentation = odaPresentation.ActualizarPresentation(sidProductPresentation, sid_ProductCategory, lid_Subcategory, iid_Brand, sEmpaquetamiento, sUnidad_Empaque, sProductPresentationName, dProductPresentation_Neto, iid_UnitOfMeasure, bProductPresentation_Status, sProductPresentation_ModiBy, tProductPresentation_DateModiBy); odaPresentation = null; return(oeaPresentation); }