public void ActualizarCMC(int IdCartel,
int IdModelo,
List <SCE_CARTEL_MODELO_CAMPO_BE> lstCartelModelosCampos,
int numMaxDigitos)
{
string CeroDigitos = string.Empty;
try
{
BE = new SCE_CARTEL_MODELO_BE();
BE.ID_CARTEL = IdCartel;
BE.ID_MODELO = IdModelo;
BE.CAMPOS = lstCartelModelosCampos;
DA.SCE_CARTEL_MODELO_DA DA = new DA.SCE_CARTEL_MODELO_DA(usrLogin);
DA.SCE_CARTEL_DA DA1 = new DA.SCE_CARTEL_DA(usrLogin);
CeroDigitos = DA1.EsCartelModeloCeroDigitos(IdCartel);
using (TransactionScope scope = new TransactionScope())
{
DA.ActualizarCMC(BE, numMaxDigitos, CeroDigitos);
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Insertar(string nombre,
List <SCE_CARTEL_MODELO_BE> lstModelos,
int numMaxDigitos,
bool CeroDigitos)
{
string strCeroDigitos = string.Empty;
try
{
BE = new SCE_CARTEL_BE();
BE.NOM_CARTEL = nombre;
BE.MODELOS = lstModelos;
DA.SCE_CARTEL_DA DA = new DA.SCE_CARTEL_DA(usrLogin);
using (TransactionScope scope = new TransactionScope())
{
if (CeroDigitos == true)
{
strCeroDigitos = "S";
}
else
{
strCeroDigitos = "N";
}
DA.Insertar(BE, numMaxDigitos, strCeroDigitos);
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
//-------------------------------------------------------------------------------------------------------
public void ActualizarCMCP(string IdCartelModelo,
int Digitos,
List <SCE_CARTEL_MODELO_CATEGORIA_PROMOCION_BE> lstCartelModelosCategPromo)
{
string CeroDigitos = string.Empty;
int IdCartel = Convert.ToInt32(IdCartelModelo.Substring(0, 4).ToString().Trim());
int IdModelo = Convert.ToInt32(IdCartelModelo.Substring(4, 2).ToString().Trim());
try
{
BE = new SCE_CARTEL_MODELO_BE();
BE.ID_CARTEL = IdCartel;
BE.ID_MODELO = IdModelo;
BE.CATEGS_PROMOS = lstCartelModelosCategPromo;
DA.SCE_CARTEL_MODELO_DA DA = new DA.SCE_CARTEL_MODELO_DA(usrLogin);
DA.SCE_CARTEL_DA DA1 = new DA.SCE_CARTEL_DA(usrLogin);
CeroDigitos = DA1.EsCartelModeloCeroDigitos(IdCartel);
using (TransactionScope scope = new TransactionScope())
{
DA.ActualizarCMCP(BE, Digitos, CeroDigitos);
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public SCE_CARTEL_BE ObtenerPorID(int Id)
{
try
{
DA.SCE_CARTEL_DA DA = new DA.SCE_CARTEL_DA(usrLogin);
return(DA.ObtenerPorID(Id));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Eliminar(int Id)
{
try
{
DA.SCE_CARTEL_DA DA = new DA.SCE_CARTEL_DA(usrLogin);
return(DA.Eliminar(Id));
}
catch (Exception ex)
{
throw ex;
}
}
public string IsValid(int Id, string nombre, bool operacion)
{
string mensaje = "";
try
{
if ((nombre == null) || (nombre.Length == 0))
{
return(mensaje = System.Configuration.ConfigurationManager.AppSettings["MC_CN"]);
}
DA.SCE_CARTEL_DA DA = new DA.SCE_CARTEL_DA(usrLogin);
List <SCE_CARTEL_BE> plista = DA.Listar();
if (operacion == false)
{
for (int i = 0; i < plista.Count; i++)
{
if ((plista[i].ID_CARTEL != Id) && (plista[i].CARTEL == nombre))
{
return(mensaje = System.Configuration.ConfigurationManager.AppSettings["MC_ND"]);
}
}
}
else
{
for (int i = 0; i < plista.Count; i++)
{
if (plista[i].CARTEL == nombre)
{
return(mensaje = System.Configuration.ConfigurationManager.AppSettings["MC_ND"]);
}
}
}
return(mensaje);
}
catch (Exception ex)
{
throw ex;
}
}
public string ValidarIntegridad(int IdCartel, int IdModelo)
{
try
{
DA.SCE_CARTEL_DA DA = new DA.SCE_CARTEL_DA(usrLogin);
if (DA.ExisteCartelModeloInTB_CMC(IdCartel, IdModelo))
{
return(System.Configuration.ConfigurationManager.AppSettings["MC_VIR"]);
}
if (DA.ExisteCartelModeloInTB_CMCP(IdCartel, IdModelo))
{
return(System.Configuration.ConfigurationManager.AppSettings["MC_VIR"]);
}
return("");
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable Listar()
{
int numMaxDigitos = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["NroMaxDigitos"]);
System.Data.DataTable dt = new System.Data.DataTable();
dt = null;
try
{
DA.SCE_CARTEL_DA DA = new DA.SCE_CARTEL_DA(usrLogin);
if (DA.Listar().Count > 0)
{
return(PivotDtCartelXModelo(ListToDataTable(DA.Listar()), "NOM_MODELO", numMaxDigitos));
}
else
{
return(dt);
}
}
catch (Exception ex)
{
throw ex;
}
}