public List <int> ObtenerLideresSubarea(int ta201_idsubareapreventa) { OpenDbConn(); DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); return(cFiguraSubareaPreventa.ObtenerLideresSubarea(ta201_idsubareapreventa)); }
internal List <Models.FiguraSubareaPreventa> Catalogo(Models.FiguraSubareaPreventa oFiguraSubareaPreventaFilter) { OpenDbConn(); DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); return(cFiguraSubareaPreventa.Catalogo(oFiguraSubareaPreventaFilter)); }
internal Models.FiguraSubareaPreventa Select(Int32 ta201_idsubareapreventa, Int32 t001_idficepi, String ta203_figura) { OpenDbConn(); DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); return(cFiguraSubareaPreventa.Select(ta201_idsubareapreventa, t001_idficepi, ta203_figura)); }
public List <Models.FiguraSubareaPreventa> Catalogo(Int32 ta201_idsubareapreventa) { OpenDbConn(); DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); return(cFiguraSubareaPreventa.Catalogo(ta201_idsubareapreventa)); }
//public int Delete(Int32 ta201_idsubareapreventa, Int32 t001_idficepi) //{ // Guid methodOwnerID = new Guid("b6a8a7d3-00cd-461c-8224-0e14e1671b67"); // OpenDbConn(); // if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.beginTransaction(methodOwnerID); // try // { // DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); // int result = cFiguraSubareaPreventa.Delete(ta201_idsubareapreventa, t001_idficepi); // //Finalizar transacción // if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) cDblib.commitTransaction(methodOwnerID); // return result; // } // catch (Exception ex) // { // //rollback // if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID); // throw ex; // } //} //public int DeleteFigura(Int32 ta201_idsubareapreventa, Int32 t001_idficepi, String ta203_figura) //{ // Guid methodOwnerID = new Guid("85eaefff-ed87-41b2-bbbc-c81469b10758"); // OpenDbConn(); // if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.beginTransaction(methodOwnerID); // try // { // DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); // int result = cFiguraSubareaPreventa.DeleteFigura(ta201_idsubareapreventa, t001_idficepi, ta203_figura); // //Finalizar transacción // if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) cDblib.commitTransaction(methodOwnerID); // return result; // } // catch (Exception ex) // { // //rollback // if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID); // throw ex; // } //} public void ActualizarFiguras(Int32 ta201_idsubareapreventa, List <IB.SUPER.ADM.SIC.Models.FiguraSubareaPreventa> lstFiguras) { Guid methodOwnerID = new Guid("0F1686CA-A369-4850-B591-9F57F5129E34"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } DataTable dtFiguras = new DataTable(); try { DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); #region Creo el datatable para pasarselo al proc almacenado //dtFiguras.Columns.Add(new DataColumn("item", typeof(int))); dtFiguras.Columns.Add(new DataColumn("t001_idficepi", typeof(int))); dtFiguras.Columns.Add(new DataColumn("figura", typeof(char))); foreach (IB.SUPER.ADM.SIC.Models.FiguraSubareaPreventa oFigura in lstFiguras) { DataRow row = dtFiguras.NewRow(); //row["item"] = oFigura.ta201_idsubareapreventa; row["t001_idficepi"] = oFigura.t001_idficepi; row["figura"] = oFigura.ta203_figura; dtFiguras.Rows.Add(row); } #endregion cFiguraSubareaPreventa.ActualizarFiguras(ta201_idsubareapreventa, dtFiguras); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } finally { dtFiguras.Dispose(); } }
internal int Update(Models.FiguraSubareaPreventa oFiguraSubareaPreventa) { Guid methodOwnerID = new Guid("4dbc8b52-bdb6-4aeb-bdb6-13e1e4bddb3e"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); int result = cFiguraSubareaPreventa.Update(oFiguraSubareaPreventa); //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 Insert(Models.FiguraSubareaPreventa oFiguraSubareaPreventa) { Guid methodOwnerID = new Guid("9467a74f-e890-4cf2-9e12-4930dca042e1"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); int idFiguraSubareaPreventa = cFiguraSubareaPreventa.Insert(oFiguraSubareaPreventa); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idFiguraSubareaPreventa); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
internal int Delete(Int32 ta201_idsubareapreventa, Int32 t001_idficepi, String ta203_figura) { Guid methodOwnerID = new Guid("85eaefff-ed87-41b2-bbbc-c81469b10758"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib); int result = cFiguraSubareaPreventa.Delete(ta201_idsubareapreventa, t001_idficepi, ta203_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; } }
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); }