public List <int> ObtenerLideresSubarea(int ta201_idsubareapreventa)
{
OpenDbConn();
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
return(cFiguraSubareaPreventa.ObtenerLideresSubarea(ta201_idsubareapreventa));
}
internal List <Models.FiguraSubareaPreventa> Catalogo(Models.FiguraSubareaPreventa oFiguraSubareaPreventaFilter)
{
OpenDbConn();
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
return(cFiguraSubareaPreventa.Catalogo(oFiguraSubareaPreventaFilter));
}
internal Models.FiguraSubareaPreventa Select(Int32 ta201_idsubareapreventa, Int32 t001_idficepi, String ta203_figura)
{
OpenDbConn();
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
return(cFiguraSubareaPreventa.Select(ta201_idsubareapreventa, t001_idficepi, ta203_figura));
}
public List <Models.FiguraSubareaPreventa> Catalogo(Int32 ta201_idsubareapreventa)
{
OpenDbConn();
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
return(cFiguraSubareaPreventa.Catalogo(ta201_idsubareapreventa));
}
//public int Delete(Int32 ta201_idsubareapreventa, Int32 t001_idficepi)
//{
// Guid methodOwnerID = new Guid("b6a8a7d3-00cd-461c-8224-0e14e1671b67");
// OpenDbConn();
// if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.beginTransaction(methodOwnerID);
// try
// {
// DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
// int result = cFiguraSubareaPreventa.Delete(ta201_idsubareapreventa, t001_idficepi);
// //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 DeleteFigura(Int32 ta201_idsubareapreventa, Int32 t001_idficepi, String ta203_figura)
//{
// Guid methodOwnerID = new Guid("85eaefff-ed87-41b2-bbbc-c81469b10758");
// OpenDbConn();
// if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.beginTransaction(methodOwnerID);
// try
// {
// DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
// int result = cFiguraSubareaPreventa.DeleteFigura(ta201_idsubareapreventa, t001_idficepi, ta203_figura);
// //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 void ActualizarFiguras(Int32 ta201_idsubareapreventa, List <IB.SUPER.ADM.SIC.Models.FiguraSubareaPreventa> lstFiguras)
{
Guid methodOwnerID = new Guid("0F1686CA-A369-4850-B591-9F57F5129E34");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
DataTable dtFiguras = new DataTable();
try
{
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
#region Creo el datatable para pasarselo al proc almacenado
//dtFiguras.Columns.Add(new DataColumn("item", typeof(int)));
dtFiguras.Columns.Add(new DataColumn("t001_idficepi", typeof(int)));
dtFiguras.Columns.Add(new DataColumn("figura", typeof(char)));
foreach (IB.SUPER.ADM.SIC.Models.FiguraSubareaPreventa oFigura in lstFiguras)
{
DataRow row = dtFiguras.NewRow();
//row["item"] = oFigura.ta201_idsubareapreventa;
row["t001_idficepi"] = oFigura.t001_idficepi;
row["figura"] = oFigura.ta203_figura;
dtFiguras.Rows.Add(row);
}
#endregion
cFiguraSubareaPreventa.ActualizarFiguras(ta201_idsubareapreventa, dtFiguras);
//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;
}
finally
{
dtFiguras.Dispose();
}
}
internal int Update(Models.FiguraSubareaPreventa oFiguraSubareaPreventa)
{
Guid methodOwnerID = new Guid("4dbc8b52-bdb6-4aeb-bdb6-13e1e4bddb3e");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
int result = cFiguraSubareaPreventa.Update(oFiguraSubareaPreventa);
//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;
}
}
internal int Insert(Models.FiguraSubareaPreventa oFiguraSubareaPreventa)
{
Guid methodOwnerID = new Guid("9467a74f-e890-4cf2-9e12-4930dca042e1");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
int idFiguraSubareaPreventa = cFiguraSubareaPreventa.Insert(oFiguraSubareaPreventa);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(idFiguraSubareaPreventa);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
internal int Delete(Int32 ta201_idsubareapreventa, Int32 t001_idficepi, String ta203_figura)
{
Guid methodOwnerID = new Guid("85eaefff-ed87-41b2-bbbc-c81469b10758");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.FiguraSubareaPreventa cFiguraSubareaPreventa = new DAL.FiguraSubareaPreventa(cDblib);
int result = cFiguraSubareaPreventa.Delete(ta201_idsubareapreventa, t001_idficepi, ta203_figura);
//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 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);
}