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