public bool TieneCPConfiguradoCM(int IdCategoria, int IdPromocion) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlCartel = "SP_HAVE_CATEG_PROM_CARTEL_MODELO_CONFIG"; using (SqlCommand cmd = new SqlCommand(sqlCartel, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CATEGORIA", IdCategoria); cmd.Parameters.AddWithValue("@ID_PROMOCION", IdPromocion); cmd.Parameters.Add("@EXISTE", SqlDbType.Bit).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); bool Existe = Convert.ToBoolean(cmd.Parameters["@EXISTE"].Value); if (Existe == false) { return(false); } else { return(true); } } } } catch (Exception ex) { throw ex; } }
//------------------------------------------------------------------------------- //------------------------------------------------------------------------------- //------------------------------------------------------------------------------- public bool ExisteCartelModelo(int IdCartel, int IdModelo) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlCartel = "SP_SCE_CARTEL_MODELO_EXISTE"; using (SqlCommand cmd = new SqlCommand(sqlCartel, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", IdCartel); cmd.Parameters.AddWithValue("@ID_MODELO", IdModelo); cmd.Parameters.Add("@EXISTE", SqlDbType.Bit).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); byte Existe = Convert.ToByte(cmd.Parameters["@EXISTE"].Value); if (Existe == 0) { return(false); } else { return(true); } } } } catch (Exception ex) { throw ex; } }
public bool EsCampoValidable(int IdCartel, int IdCampo) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlCartel = "SP_ES_CAMPO_VALIDABLE"; using (SqlCommand cmd = new SqlCommand(sqlCartel, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", IdCartel); cmd.Parameters.AddWithValue("@ID_CAMPO", IdCampo); cmd.Parameters.Add("@RSPTA", SqlDbType.Bit).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); bool Rspta = Convert.ToBoolean(cmd.Parameters["@RSPTA"].Value); if (Rspta == false) { return(false); } else { return(true); } } } } catch (Exception ex) { throw ex; } }
public SCE_CAMPO_BE ObtenerPorID(int Id) { SCE_CAMPO_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CAMPO_GET"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CAMPO", Id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { BE = new SCE_CAMPO_BE(); BE.ID_CAMPO = Convert.ToInt32(reader["ID_CAMPO"]); BE.ALIAS = Convert.ToString(reader["ALIAS"]); BE.NOM_CAMPO = Convert.ToString(reader["NOM_CAMPO"]); } return(BE); } } } catch (Exception ex) { throw ex; } }
public List <SCE_FILE_GUIA_MASIVA_BE> CboFilesGuia() { List <SCE_FILE_GUIA_MASIVA_BE> lstBE = new List <SCE_FILE_GUIA_MASIVA_BE>(); SCE_FILE_GUIA_MASIVA_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_FILE_GUIA_MASIVA_CBO"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BE = new SCE_FILE_GUIA_MASIVA_BE(); BE.ID_FILE = Convert.ToInt32(reader["ID_FILE"]); BE.NOM_FILE = Convert.ToString(reader["NOM_FILE"]); lstBE.Add(BE); } return(lstBE); } } } catch (Exception ex) { throw ex; } }
public void BajaFileGuia(int idFile, string User) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlGuia = "SP_SCE_FILE_GUIA_MASIVA_BAJA"; using (SqlCommand cmd = new SqlCommand(sqlGuia, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_FILE", idFile); cmd.Parameters.AddWithValue("@USER_MOD", User); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void CargarFileGuia(SCE_FILE_GUIA_MASIVA_BE BE) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlGuia = "SP_SCE_FILE_GUIA_MASIVA_INS"; using (SqlCommand cmd = new SqlCommand(sqlGuia, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NOM_FILE", BE.NOM_FILE); cmd.Parameters.AddWithValue("@USER_CRE", BE.USER_CRE); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void Insertar(SCE_CATEGORIA_BE BE) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CATEGORIA_INS"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NOM_CATEGORIA", BE.NOM_CATEGORIA); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void Eliminar(int Id) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_MODELO_DEL"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_MODELO", Id); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void Actualizar(SCE_CARTEL_BE BE, int numMaxDigitos, string CeroDigitos) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlCartelModelo = "SP_SCE_CARTEL_UPD"; using (SqlCommand cmd = new SqlCommand(sqlCartelModelo, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd.Parameters.AddWithValue("@NOM_CARTEL", BE.NOM_CARTEL); cmd.Parameters.AddWithValue("@CERO_DIGITOS", CeroDigitos); cmd.ExecuteNonQuery(); } //Evaluamos si existe en registro en la tabla y su flag si es 1 o 0 string sqlCartelModelo1 = "SP_SCE_CARTEL_MODELO_EXISTE"; using (SqlCommand cmd = new SqlCommand(sqlCartelModelo1, cn)) { cmd.CommandType = CommandType.StoredProcedure; foreach (SCE_CARTEL_MODELO_BE CARTEL_MODELO_BE in BE.MODELOS) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd.Parameters.AddWithValue("@ID_MODELO", CARTEL_MODELO_BE.ID_MODELO); cmd.Parameters.Add("@EXISTE", SqlDbType.Bit).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); bool Existe = Convert.ToBoolean(cmd.Parameters["@EXISTE"].Value); if (Existe == true && CARTEL_MODELO_BE.FLAGPERTENECE == 1) { //No pasa nada porque no se ha seleccionado el registro y ya //estaba seleccionado previamente } else if (Existe == true && CARTEL_MODELO_BE.FLAGPERTENECE == 0) { //Elimino el registros que he deseleccionado teniendo //en cuenta que ya se valido si este registro no tiene //registros relacionados string sqlCartelModelo2 = "SP_SCE_CARTEL_MODELO_DEL1"; using (SqlCommand cmd1 = new SqlCommand(sqlCartelModelo2, cn)) { cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Clear(); cmd1.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd1.Parameters.AddWithValue("@ID_MODELO", CARTEL_MODELO_BE.ID_MODELO); cmd1.ExecuteNonQuery(); } } else if (Existe == false && CARTEL_MODELO_BE.FLAGPERTENECE == 1) { // Inserto los digitos del nuevo cartel-modelo string sqlCartelModeloDigito2 = "SP_SCE_CARTEL_MODELO_INS"; using (SqlCommand cmd1 = new SqlCommand(sqlCartelModeloDigito2, cn)) { cmd1.CommandType = CommandType.StoredProcedure; if (CeroDigitos == "S") { cmd1.Parameters.Clear(); cmd1.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd1.Parameters.AddWithValue("@ID_MODELO", CARTEL_MODELO_BE.ID_MODELO); cmd1.Parameters.AddWithValue("@DIGITOS", 0); cmd1.ExecuteNonQuery(); } else if (CeroDigitos == "N") { for (int i = 1; i <= numMaxDigitos; i++) { cmd1.Parameters.Clear(); cmd1.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd1.Parameters.AddWithValue("@ID_MODELO", CARTEL_MODELO_BE.ID_MODELO); cmd1.Parameters.AddWithValue("@DIGITOS", i); cmd1.ExecuteNonQuery(); } } } } else if (Existe == false && CARTEL_MODELO_BE.FLAGPERTENECE == 0) { //No pasa nada ya que el registro de la matriz no esta en //la tabla } } } } } catch (Exception ex) { throw ex; } }
public SCE_CARTEL_BE ObtenerPorID(int Id) { SCE_CARTEL_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CARTEL_GET"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", Id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { BE = new SCE_CARTEL_BE(); BE.ID_CARTEL = Convert.ToInt32(reader["ID_CARTEL"]); BE.NOM_CARTEL = Convert.ToString(reader["NOM_CARTEL"]); if (Convert.ToString(reader["CERO_DIGITOS"]) == "S") { BE.CERO_DIGITOS = 1; } else if (Convert.ToString(reader["CERO_DIGITOS"]) == "N") { BE.CERO_DIGITOS = 0; } /* LLENA LA LISTA DE MODELOS DEL CARTEL */ List <SCE_CARTEL_MODELO_BE> lstMODELOS = new List <SCE_CARTEL_MODELO_BE>(); SqlDataReader drMODELOS = null; drMODELOS = getModelos(Id); while (drMODELOS.Read()) { SCE_CARTEL_MODELO_BE MODELO = new SCE_CARTEL_MODELO_BE(); MODELO.ID_MODELO = drMODELOS.GetInt32(0); MODELO.NOM_MODELO = drMODELOS.GetString(1); MODELO.FLAGPERTENECE = drMODELOS.GetInt32(2); lstMODELOS.Add(MODELO); } BE.MODELOS = lstMODELOS; } return(BE); } } } catch (Exception ex) { throw ex; } }
public void ActualizarCMC1(SCE_CARTEL_MODELO_BE BE, string PosFCX, string PosFCY) { try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sqlCartelModelo = "SP_SCE_CARTEL_MODELO_UPD"; using (SqlCommand cmd = new SqlCommand(sqlCartelModelo, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd.Parameters.AddWithValue("@ID_MODELO", BE.ID_MODELO); cmd.Parameters.AddWithValue("@DIGITOS", BE.DIGITOS); cmd.Parameters.AddWithValue("@NOM_PLANTILLA", BE.NOM_PLANTILLA); cmd.ExecuteNonQuery(); } string sqlCartelModelo3 = "SP_SCE_CARTEL_MODELO_UPD1"; using (SqlCommand cmd = new SqlCommand(sqlCartelModelo3, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd.Parameters.AddWithValue("@ID_MODELO", BE.ID_MODELO); cmd.Parameters.AddWithValue("@DIGITOS", BE.DIGITOS); cmd.Parameters.AddWithValue("@POS_FC_X", PosFCX); cmd.Parameters.AddWithValue("@POS_FC_Y", PosFCY); cmd.ExecuteNonQuery(); } string sqlCartelModelo1 = "SP_SCE_CARTEL_MODELO_CAMPO_DEL"; using (SqlCommand cmd = new SqlCommand(sqlCartelModelo1, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd.Parameters.AddWithValue("@ID_MODELO", BE.ID_MODELO); cmd.Parameters.AddWithValue("@DIGITOS", BE.DIGITOS); cmd.ExecuteNonQuery(); } string sqlCartelModelo2 = "SP_SCE_CARTEL_MODELO_CAMPO_UPD"; using (SqlCommand cmd = new SqlCommand(sqlCartelModelo2, cn)) { cmd.CommandType = CommandType.StoredProcedure; foreach (SCE_CARTEL_MODELO_CAMPO_BE CARTEL_MODELO_CAMPO_BE in BE.CAMPOS) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL); cmd.Parameters.AddWithValue("@ID_MODELO", BE.ID_MODELO); cmd.Parameters.AddWithValue("@DIGITOS", BE.DIGITOS); cmd.Parameters.AddWithValue("@ID_CAMPO", CARTEL_MODELO_CAMPO_BE.ID_CAMPO); cmd.Parameters.AddWithValue("@POS_X", CARTEL_MODELO_CAMPO_BE.POSX); cmd.Parameters.AddWithValue("@POS_Y", CARTEL_MODELO_CAMPO_BE.POSY); cmd.ExecuteNonQuery(); } } } } catch (Exception ex) { throw ex; } }
public SCE_CARTEL_MODELO_BE ObtenerPorID1(int IdCartel, int IdModelo, int Digitos) { SCE_CARTEL_MODELO_BE BE = null; try { using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin))) { cn.Open(); string sql = "SP_SCE_CARTEL_MODELO_GET2"; using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_CARTEL", IdCartel); cmd.Parameters.AddWithValue("@ID_MODELO", IdModelo); cmd.Parameters.AddWithValue("@DIGITOS", Digitos); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { BE = new SCE_CARTEL_MODELO_BE(); BE.NOM_CARTEL = Convert.ToString(reader["NOM_CARTEL"]).Trim(); BE.NOM_MODELO = Convert.ToString(reader["NOM_MODELO"]).Trim(); BE.DESCRIPCION = Convert.ToString(reader["NOM_CARTEL"]).Trim() + '-' + Convert.ToString(reader["NOM_MODELO"]).Trim(); BE.NRODIGITOS = Convert.ToString(reader["NRODIGITOS"]).Trim(); BE.NOM_PLANTILLA = Convert.ToString(reader["NOM_PLANTILLA"]).Trim(); /* LLENA LA LISTA DE CAMPOS DEL CARTEL-MODELO */ List <SCE_CARTEL_MODELO_CAMPO_BE> lstCARTELMODELOCAMPO = new List <SCE_CARTEL_MODELO_CAMPO_BE>(); SqlDataReader drCARTELMODELOCAMPO = null; drCARTELMODELOCAMPO = getCampos1(IdCartel, IdModelo, Digitos); while (drCARTELMODELOCAMPO.Read()) { SCE_CARTEL_MODELO_CAMPO_BE CARTEL_MODELO_CAMPO = new SCE_CARTEL_MODELO_CAMPO_BE(); CARTEL_MODELO_CAMPO.ID_CAMPO = drCARTELMODELOCAMPO.GetInt32(0); CARTEL_MODELO_CAMPO.CAMPO = drCARTELMODELOCAMPO.GetString(1).Trim(); CARTEL_MODELO_CAMPO.DESCRIPCION = drCARTELMODELOCAMPO.GetString(2).Trim(); if (!drCARTELMODELOCAMPO.IsDBNull(drCARTELMODELOCAMPO.GetOrdinal("POS_X"))) { CARTEL_MODELO_CAMPO.POSX = drCARTELMODELOCAMPO.GetString(3).Trim(); } if (!drCARTELMODELOCAMPO.IsDBNull(drCARTELMODELOCAMPO.GetOrdinal("POS_Y"))) { CARTEL_MODELO_CAMPO.POSY = drCARTELMODELOCAMPO.GetString(4).Trim(); } lstCARTELMODELOCAMPO.Add(CARTEL_MODELO_CAMPO); } BE.CAMPOS = lstCARTELMODELOCAMPO; } return(BE); } } } catch (Exception ex) { throw ex; } }