public Models.SubareaPreventa Select2(Int32 ta201_idsubareapreventa) { OpenDbConn(); DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); return(cSubareaPreventa.Select2(ta201_idsubareapreventa)); }
public List <Models.SubareaPreventa> getFiguras_SubArea(Int32 ta201_idsubareapreventa) { OpenDbConn(); DAL.SubareaPreventa cSubAreaPreventa = new DAL.SubareaPreventa(cDblib); return(cSubAreaPreventa.getFiguras_SubArea(ta201_idsubareapreventa)); }
public Models.SubareaPreventa SelectPorDenominacion(string t201_denominacion, Int32 ta200_idareapreventa) { OpenDbConn(); DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); return(cSubareaPreventa.SelectPorDenominacion(t201_denominacion, ta200_idareapreventa)); }
public List <Models.SubareaPreventa> getSubAreasByFicepi(Int32 ta200_idareapreventa, Int32 t001_idficepi, bool actuocomoadministrador) { OpenDbConn(); DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); return(cSubareaPreventa.getSubAreasByFicepi(ta200_idareapreventa, t001_idficepi, actuocomoadministrador)); }
/// <summary> /// Obteniene la lista de subareas para la ayuda de subareas filtrado por area /// </summary> public List <IB.SUPER.APP.Models.KeyValue> ObtenerSubareasDeArea(BLL.Ayudas.enumAyuda enumlst, int ta200_idareapreventa, bool admin) { OpenDbConn(); DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); return(cSubareaPreventa.ObtenerSubareasDeArea(enumlst, (int)System.Web.HttpContext.Current.Session["IDFICEPI_PC_ACTUAL"], ta200_idareapreventa, admin)); }
public int grabarSubArea(Models.SubareaPreventa oSubAreaPreventa, List <Models.FiguraSubareaPreventa> lstFigurasArea) { Guid methodOwnerID = new Guid("91fe2269-b98f-4376-bcdb-06a3e750c744"); int idSubAreaPreventa = 0; int nFiguras = 0; OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.SubareaPreventa cSubAreaPreventa = new DAL.SubareaPreventa(cDblib); DataTable dtFiguras = new DataTable(); dtFiguras.Columns.Add(new DataColumn("col_1", typeof(int))); dtFiguras.Columns.Add(new DataColumn("col_2", typeof(char))); //Recorremos la lista foreach (Models.FiguraSubareaPreventa oFiguras in lstFigurasArea) { DataRow row = dtFiguras.NewRow(); row["col_1"] = oFiguras.t001_idficepi; row["col_2"] = oFiguras.ta203_figura; dtFiguras.Rows.Add(row); } idSubAreaPreventa = cSubAreaPreventa.grabarSubArea(oSubAreaPreventa); nFiguras = cSubAreaPreventa.grabarFigurasSubArea(oSubAreaPreventa.ta201_idsubareapreventa, dtFiguras); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idSubAreaPreventa); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public int Insert(Models.SubareaPreventa oSubareaPreventa) { Guid methodOwnerID = new Guid("f70cdb21-9a9c-47a4-8046-4a0725a74b3d"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); int idSubareaPreventa = cSubareaPreventa.Insert(oSubareaPreventa); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idSubareaPreventa); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public int Delete(Int32 ta201_idsubareapreventa) { Guid methodOwnerID = new Guid("584034d9-404c-495e-bb43-a35c6471e9a7"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); int result = cSubareaPreventa.Delete(ta201_idsubareapreventa); //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 int Update(Models.SubareaPreventa oSubareaPreventa) { Guid methodOwnerID = new Guid("9acb94e8-95f9-4ce9-9e2b-8500e4840b0e"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.SubareaPreventa cSubareaPreventa = new DAL.SubareaPreventa(cDblib); int result = cSubareaPreventa.Update(oSubareaPreventa); //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 void grabar(List <Models.SubareaPreventa> lstSubareas) { Guid methodOwnerID = new Guid("8bf259c7-135e-4a96-8703-9da7e697a68d"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.SubareaPreventa cSubAreaPreventa = new DAL.SubareaPreventa(cDblib); string cadenaFicepis = ""; int ta201_idsubareapreventa = 0; for (int i = 0; i < lstSubareas.Count; i++) { DataTable dtTablappl = null; dtTablappl = new DataTable(); dtTablappl.Columns.Add(new DataColumn("col_1", typeof(int))); ta201_idsubareapreventa = lstSubareas[i].ta201_idsubareapreventa; cadenaFicepis = lstSubareas[i].profesionales; //Recorremos la lista string[] ficepis = Regex.Split(cadenaFicepis, "@#@"); //tratamos los profesionales for (int j = 0; j < ficepis.Length; j++) { if (ficepis[j] != "") { DataRow row = dtTablappl.NewRow(); row["col_1"] = int.Parse(ficepis[j]); dtTablappl.Rows.Add(row); } } cSubAreaPreventa.grabarppldesubarea(ta201_idsubareapreventa, dtTablappl); //dtTablappl.Clear(); } //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; } }
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); }