public List <Models.AreaPreventa> getFiguras_Area(Int32 ta200_idareapreventa) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.getFiguras_Area(ta200_idareapreventa)); }
public List <Models.AreaPreventa> getareassubareasppl(int t001_idficepi) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); List <Models.AreaPreventa> lstDatos = cAreaPreventa.getareassubareasppl(t001_idficepi); List <Models.AreaPreventa> lstPosibleLider = cAreaPreventa.getpplporsubareaparaficepi(t001_idficepi); foreach (Models.AreaPreventa item in lstDatos) { for (int i = 0; i < lstPosibleLider.Count; i++) { if (item.ta201_idsubareapreventa == lstPosibleLider[i].ta201_idsubareapreventa) { item.profesional += lstPosibleLider[i].t001_idficepi + "@#@" + lstPosibleLider[i].profesional + "|"; } } //var lstPosibleLiderSubArea = (from p in lstPosibleLider // where p.ta201_idsubareapreventa == item.ta201_idsubareapreventa // //select new { p.profesional, p.t001_idficepi }).ToList(); // select p.profesional).ToList<String>(); //item.profesional = string.Join("|", lstPosibleLiderSubArea.ToArray()); } return(lstDatos); }
public Models.AreaPreventa Select(Int32 ta200_idareapreventa) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.Select(ta200_idareapreventa)); }
public List <Models.AreaPreventa> getAreasByFicepi(int t001_idficepi, bool actuocomoadministrador) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.getAreasByFicepi(t001_idficepi, actuocomoadministrador)); }
public List <Models.AreaPreventa> getpplporsubareaparaficepi(int t001_idficepi) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.getpplporsubareaparaficepi(t001_idficepi)); }
public List <Models.AreaPreventa> Catalogo(Models.AreaPreventa oAreaPreventaFilter) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.Catalogo(oAreaPreventaFilter)); }
public Models.AreaPreventa SelectPorDenominacion(string ta200_denominacion) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.SelectPorDenominacion(ta200_denominacion)); }
public int grabarArea(Models.AreaPreventa oAreaPreventa, List <Models.FiguraAreaPreventa> lstFigurasArea) { Guid methodOwnerID = new Guid("532e7c11-3ff0-4640-b531-d9a267300e9b"); int idAreaPreventa = 0; int nFiguras = 0; OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(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.FiguraAreaPreventa oFiguras in lstFigurasArea) { DataRow row = dtFiguras.NewRow(); row["col_1"] = oFiguras.t001_idficepi; row["col_2"] = oFiguras.ta202_figura; dtFiguras.Rows.Add(row); } idAreaPreventa = cAreaPreventa.grabarArea(oAreaPreventa); nFiguras = cAreaPreventa.grabarFigurasArea(oAreaPreventa.ta200_idareapreventa, dtFiguras); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idAreaPreventa); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public int Delete(Int32 ta200_idareapreventa) { Guid methodOwnerID = new Guid("d2fca125-dbf5-4382-8f71-5fc61bb37228"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); int result = cAreaPreventa.Delete(ta200_idareapreventa); //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 Update(Models.AreaPreventa oAreaPreventa) { Guid methodOwnerID = new Guid("7459cc8f-3373-46c0-8fb6-35fec66c15a8"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); int result = cAreaPreventa.Update(oAreaPreventa); //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 Insert(Models.AreaPreventa oAreaPreventa) { Guid methodOwnerID = new Guid("24190a12-df18-4b0c-9987-4a8a08956858"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); int idAreaPreventa = cAreaPreventa.Insert(oAreaPreventa); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idAreaPreventa); } 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); }