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