/// <summary> /// Obtiene un AreaPreventa a partir del id unidad de preventa y denominación /// </summary> internal Models.AreaPreventa SelectPorDenominacion(string ta200_denominacion) { Models.AreaPreventa oAreaPreventa = null; IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.ta200_denominacion, ta200_denominacion) }; dr = cDblib.DataReader("SIC_AREAPREVENTA_SN", dbparams); if (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.ta200_idareapreventa = Convert.ToInt32(dr["ta200_idareapreventa"]); } return(oAreaPreventa); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
public List <Models.AreaPreventa> Catalogo(Models.AreaPreventa oAreaPreventaFilter) { OpenDbConn(); DAL.AreaPreventa cAreaPreventa = new DAL.AreaPreventa(cDblib); return(cAreaPreventa.Catalogo(oAreaPreventaFilter)); }
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; } }
/// <summary> /// Obtiene un AreaPreventa a partir del id /// </summary> internal Models.AreaPreventa Select(Int32 ta200_idareapreventa) { Models.AreaPreventa oAreaPreventa = null; IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.ta200_idareapreventa, ta200_idareapreventa) }; dr = cDblib.DataReader("SIC_AREAPREVENTA_S1", dbparams); if (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.ta200_idareapreventa = Convert.ToInt32(dr["ta200_idareapreventa"]); oAreaPreventa.ta200_denominacion = Convert.ToString(dr["ta200_denominacion"]); oAreaPreventa.ta200_estadoactiva = Convert.ToBoolean(dr["ta200_estadoactiva"]); if (!Convert.IsDBNull(dr["t001_idficepi_responsable"])) { oAreaPreventa.t001_idficepi_responsable = Convert.ToInt32(dr["t001_idficepi_responsable"]); } oAreaPreventa.ta199_idunidadpreventa = Convert.ToInt16(dr["ta199_idunidadpreventa"]); if (!Convert.IsDBNull(dr["ta199_denominacion"])) { oAreaPreventa.ta199_denominacion = Convert.ToString(dr["ta199_denominacion"]); } if (!Convert.IsDBNull(dr["t331_idpt"])) { oAreaPreventa.t331_idpt = Convert.ToInt32(dr["t331_idpt"]); } if (!Convert.IsDBNull(dr["Responsable"])) { oAreaPreventa.responsable = Convert.ToString(dr["Responsable"]); } } return(oAreaPreventa); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
/// <summary> /// Obtiene todos los AreaPreventa /// </summary> internal List <Models.AreaPreventa> Catalogo(Models.AreaPreventa oAreaPreventaFilter) { Models.AreaPreventa oAreaPreventa = null; List <Models.AreaPreventa> lst = new List <Models.AreaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[5] { Param(enumDBFields.ta200_denominacion, oAreaPreventaFilter.ta200_denominacion), Param(enumDBFields.ta200_estadoactiva, oAreaPreventaFilter.ta200_estadoactiva), Param(enumDBFields.t001_idficepi_responsable, oAreaPreventaFilter.t001_idficepi_responsable), Param(enumDBFields.ta199_idunidadpreventa, oAreaPreventaFilter.ta199_idunidadpreventa), Param(enumDBFields.t331_idpt, oAreaPreventaFilter.t331_idpt) }; dr = cDblib.DataReader("SUPER.SIC_AreaPreventa_CAT", dbparams); while (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.ta200_idareapreventa = Convert.ToInt32(dr["ta200_idareapreventa"]); oAreaPreventa.ta200_denominacion = Convert.ToString(dr["ta200_denominacion"]); oAreaPreventa.ta200_estadoactiva = Convert.ToBoolean(dr["ta200_estadoactiva"]); oAreaPreventa.t001_idficepi_responsable = Convert.ToInt32(dr["t001_idficepi_responsable"]); oAreaPreventa.ta199_idunidadpreventa = Convert.ToInt16(dr["ta199_idunidadpreventa"]); if (!Convert.IsDBNull(dr["t331_idpt"])) { oAreaPreventa.t331_idpt = Convert.ToInt32(dr["t331_idpt"]); } lst.Add(oAreaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
internal List <Models.AreaPreventa> getFiguras_Area(Int32 ta200_idareapreventa) { Models.AreaPreventa oAreaPreventa = null; List <Models.AreaPreventa> lst = new List <Models.AreaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.ta200_idareapreventa, ta200_idareapreventa) }; dr = cDblib.DataReader("SIC_GETFIGURAS_AREA", dbparams); while (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.t001_idficepi = Convert.ToInt32(dr["t001_idficepi"]); if (!Convert.IsDBNull(dr["ta202_figura"])) { oAreaPreventa.ta202_figura = Convert.ToString(dr["ta202_figura"]); } if (!Convert.IsDBNull(dr["profesional"])) { oAreaPreventa.profesional = Convert.ToString(dr["profesional"]); } lst.Add(oAreaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
internal int grabarArea(Models.AreaPreventa oArea) { try { SqlParameter[] dbparams = new SqlParameter[5] { Param(enumDBFields.ta200_idareapreventa, oArea.ta200_idareapreventa), Param(enumDBFields.ta200_denominacion, oArea.ta200_denominacion), Param(enumDBFields.ta200_estadoactiva, null), Param(enumDBFields.t001_idficepi_responsable, oArea.t001_idficepi_responsable), Param(enumDBFields.ta199_idunidadpreventa, null) }; return((int)cDblib.Execute("SIC_AREAPREVENTA_U", dbparams)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Inserta un AreaPreventa /// </summary> internal int Insert(Models.AreaPreventa oAreaPreventa) { try { SqlParameter[] dbparams = new SqlParameter[5] { Param(enumDBFields.ta199_idunidadpreventa, oAreaPreventa.ta199_idunidadpreventa), Param(enumDBFields.ta200_denominacion, oAreaPreventa.ta200_denominacion), Param(enumDBFields.ta200_estadoactiva, oAreaPreventa.ta200_estadoactiva), Param(enumDBFields.t001_idficepi_responsable, oAreaPreventa.t001_idficepi_responsable), Param(enumDBFields.t331_idpt, oAreaPreventa.t331_idpt) }; return((int)cDblib.ExecuteScalar("SIC_AREAPREVENTA_I", dbparams)); } catch (Exception ex) { throw ex; } }
internal List <Models.AreaPreventa> getAreasByFicepi(int t001_idficepi, bool actuocomoadministrador) { Models.AreaPreventa oAreaPreventa = null; List <Models.AreaPreventa> lst = new List <Models.AreaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[2] { Param(enumDBFields.t001_idficepi, t001_idficepi), Param(enumDBFields.actuocomoadministrador, actuocomoadministrador) }; dr = cDblib.DataReader("SIC_GETAREASPORFICEPI_CAT", dbparams); while (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.ta200_idareapreventa = Convert.ToInt32(dr["id"]); oAreaPreventa.ta200_denominacion = Convert.ToString(dr["value"]); oAreaPreventa.responsable = Convert.ToString(dr["responsable"]); //oAreaPreventa.ta199_idunidadpreventa = Convert.ToInt16(dr["ta199_idunidadpreventa"]); oAreaPreventa.ta199_denominacion = Convert.ToString(dr["ta199_denominacion"]); oAreaPreventa.accesoadetalle = Convert.ToBoolean(dr["accesoadetalle"]); lst.Add(oAreaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
internal List <Models.AreaPreventa> getareassubareasppl(int t001_idficepi) { Models.AreaPreventa oAreaPreventa = null; List <Models.AreaPreventa> lst = new List <Models.AreaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.t001_idficepi, t001_idficepi) }; dr = cDblib.DataReader("SIC_GETAREASSUBAREASPPL", dbparams); while (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.ta200_idareapreventa = Convert.ToInt32(dr["ta200_idareapreventa"]); oAreaPreventa.ta200_denominacion = Convert.ToString(dr["ta200_denominacion"]); oAreaPreventa.ta201_idsubareapreventa = Convert.ToInt32(dr["ta201_idsubareapreventa"]); oAreaPreventa.ta201_denominacion = Convert.ToString(dr["ta201_denominacion"]); lst.Add(oAreaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
internal List <Models.AreaPreventa> getpplporsubareaparaficepi(int t001_idficepi) { Models.AreaPreventa oAreaPreventa = null; List <Models.AreaPreventa> lst = new List <Models.AreaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.t001_idficepi, t001_idficepi) }; dr = cDblib.DataReader("SIC_GETPPLPORSUBAREAPARAFICEPI", dbparams); while (dr.Read()) { oAreaPreventa = new Models.AreaPreventa(); oAreaPreventa.ta201_idsubareapreventa = Convert.ToInt32(dr["ta201_idsubareapreventa"]); oAreaPreventa.t001_idficepi = Convert.ToInt32(dr["t001_idficepi"]); oAreaPreventa.profesional = Convert.ToString(dr["posiblelider"]); lst.Add(oAreaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
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); }