public List <Models.FiguraAreaPreventa> Catalogo(Int32 ta200_idareapreventa) { OpenDbConn(); DAL.FiguraAreaPreventa cFiguraAreaPreventa = new DAL.FiguraAreaPreventa(cDblib); return(cFiguraAreaPreventa.Catalogo(ta200_idareapreventa)); }
public Models.FiguraAreaPreventa Select(Int32 ta200_idareapreventa, Int32 t001_idficepi) { OpenDbConn(); DAL.FiguraAreaPreventa cFiguraAreaPreventa = new DAL.FiguraAreaPreventa(cDblib); return(cFiguraAreaPreventa.Select(ta200_idareapreventa, t001_idficepi)); }
public int Insert(Models.FiguraAreaPreventa oFiguraAreaPreventa) { Guid methodOwnerID = new Guid("f7969532-eb41-40a0-98b2-15dfb5c2d980"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.FiguraAreaPreventa cFiguraAreaPreventa = new DAL.FiguraAreaPreventa(cDblib); int idFiguraAreaPreventa = cFiguraAreaPreventa.Insert(oFiguraAreaPreventa); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idFiguraAreaPreventa); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public int DeleteFigura(Int32 ta200_idareapreventa, Int32 t001_idficepi, string ta202_figura) { Guid methodOwnerID = new Guid("b7799c05-6e4b-46da-aded-27b48d4b078b"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.FiguraAreaPreventa cFiguraAreaPreventa = new DAL.FiguraAreaPreventa(cDblib); int result = cFiguraAreaPreventa.DeleteFigura(ta200_idareapreventa, t001_idficepi, ta202_figura); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(result); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
internal int Update(Models.FiguraAreaPreventa oFiguraAreaPreventa) { Guid methodOwnerID = new Guid("b6a8a7d3-00cd-461c-8224-0e14e1671b67"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.FiguraAreaPreventa cFiguraAreaPreventa = new DAL.FiguraAreaPreventa(cDblib); int result = cFiguraAreaPreventa.Update(oFiguraAreaPreventa); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(result); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public Models.PerfilesEdicion obtenerPerfilesEdicionUsuario(System.Security.Principal.IPrincipal User, bool soyLider, int ta201_idsubareapreventa) { OpenDbConn(); Models.PerfilesEdicion oPE = new Models.PerfilesEdicion(); //ficepi oPE.idficepi = int.Parse(HttpContext.Current.Session["IDFICEPI_PC_ACTUAL"].ToString()); //Lider oPE.soyLider = soyLider; //Administrador if (User.IsInRole("A") || User.IsInRole("SA")) { oPE.soyAdministrador = true; } //Super editor if (oPE.soyAdministrador || oPE.soyLider) { oPE.soySuperEditor = true; } //Figura área if (User.IsInRole("RAPREV") || User.IsInRole("DAPREV") || User.IsInRole("CAPREV") || User.IsInRole("IAPREV")) { oPE.soyFiguraArea = true; } //Figura subárea if (User.IsInRole("RSAPREV") || User.IsInRole("DSAPREV") || User.IsInRole("CSAPREV")) { oPE.soyFiguraSubarea = true; } //Figura subarea actual y posible lider DAL.SubareaPreventa cSubarea = new DAL.SubareaPreventa(cDblib); Models.SubareaPreventa oSubarea = cSubarea.Select(ta201_idsubareapreventa); if (oSubarea != null && oSubarea.t001_idficepi_responsable == oPE.idficepi) { oPE.soyFiguraSubareaActual = true; } DAL.FiguraSubareaPreventa cFSP = new DAL.FiguraSubareaPreventa(cDblib); List <Models.FiguraSubareaPreventa> lstFSP = cFSP.ObtenerFigurasSubareaUsuario(ta201_idsubareapreventa, oPE.idficepi); foreach (Models.FiguraSubareaPreventa o in lstFSP) { if (o.ta203_figura == "L") { oPE.soyPosibleLider = true; } else { oPE.soyFiguraSubareaActual = true; } } //Figura area actual if (oSubarea != null) { DAL.AreaPreventa cArea = new DAL.AreaPreventa(cDblib); Models.AreaPreventa oArea = cArea.Select(oSubarea.ta200_idareapreventa); if (oArea != null && oArea.t001_idficepi_responsable == oPE.idficepi) { oPE.soyFiguraAreaActual = true; } DAL.FiguraAreaPreventa cFAP = new DAL.FiguraAreaPreventa(cDblib); List <Models.FiguraAreaPreventa> lstFAP = cFAP.ObtenerFigurasAreaUsuario(oArea.ta200_idareapreventa, oPE.idficepi); if (lstFAP.Count > 0) { oPE.soyFiguraAreaActual = true; } } //comercial if (User.IsInRole("COMS")) { oPE.soyComercial = true; } return(oPE); }