/// <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);
}
