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