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 Insertar(SCE_CARTEL_BE BE, int numMaxDigitos, string CeroDigitos)
{
try
{
using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin)))
{
cn.Open();
string sqlCartel = "SP_SCE_CARTEL_INS";
using (SqlCommand cmd = new SqlCommand(sqlCartel, cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NOM_CARTEL", BE.NOM_CARTEL);
cmd.Parameters.AddWithValue("@CERO_DIGITOS", CeroDigitos);
cmd.Parameters.Add("@ID_CARTEL", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
BE.ID_CARTEL = (int)cmd.Parameters["@ID_CARTEL"].Value;
}
string sqlCartelModeloDigito = "SP_SCE_CARTEL_MODELO_INS";
using (SqlCommand cmd = new SqlCommand(sqlCartelModeloDigito, cn))
{
cmd.CommandType = CommandType.StoredProcedure;
foreach (SCE_CARTEL_MODELO_BE CARTEL_MODELO_BE in BE.MODELOS)
{
if (CeroDigitos == "S")
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL);
cmd.Parameters.AddWithValue("@ID_MODELO", CARTEL_MODELO_BE.ID_MODELO);
cmd.Parameters.AddWithValue("@DIGITOS", 0);
cmd.ExecuteNonQuery();
}
else if (CeroDigitos == "N")
{
for (int i = 1; i <= numMaxDigitos; i++)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID_CARTEL", BE.ID_CARTEL);
cmd.Parameters.AddWithValue("@ID_MODELO", CARTEL_MODELO_BE.ID_MODELO);
cmd.Parameters.AddWithValue("@DIGITOS", i);
cmd.ExecuteNonQuery();
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void grvTipoCartel_RowCommand(object sender, GridViewCommandEventArgs e)
{
Session["operacion"] = false;
try
{
int index = Convert.ToInt32(e.CommandArgument);
int id = Convert.ToInt32(grvTipoCartel.DataKeys[index].Value);
hidId.Value = Convert.ToString(id);
if (e.CommandName == "Editar")
{
txtDescripcion.Text = Convert.ToString(grvTipoCartel.Rows[index].Cells[3].Text);
CARTEL_BE = CARTEL_BL.ObtenerPorID(Convert.ToInt32(hidId.Value));
chkCeroDigitos.Checked = Convert.ToBoolean(CARTEL_BE.CERO_DIGITOS);
grvModelos.DataSource = CARTEL_BE.MODELOS;
grvModelos.DataBind();
System.Text.StringBuilder sbScript = new System.Text.StringBuilder();
sbScript.AppendFormat("document.getElementById('{0}').disabled=true;", txtDescripcion.ClientID);
if (CTieneCM() == 0)
{
sbScript.AppendFormat("document.getElementById('{0}').disabled=false;", chkCeroDigitos.ClientID);
}
else if (CTieneCM() > 0)
{
sbScript.AppendFormat("document.getElementById('{0}').disabled=true;", chkCeroDigitos.ClientID);
}
pnlDetalle.Visible = true;
Util.RegisterScript(upnlCarteles, "__DesabilitaCtrol__", sbScript.ToString());
}
else if (e.CommandName == "Eliminar")
{
if (CARTEL_BL.Eliminar(Convert.ToInt32(hidId.Value)) == false)
{
LoadData();
Util.RegisterAsyncAlert(upnlCarteles, "__Alerta__", Resources.Mensajes.msgCartelAlertEliminacion);
}
else
{
Util.RegisterAsyncAlert(upnlCarteles, "__Alerta__", Resources.Mensajes.msgCartelAlertIR);
}
}
}
catch
{
}
}
public List <SCE_CARTEL_BE> Listar()
{
List <SCE_CARTEL_BE> lstBE = new List <SCE_CARTEL_BE>();
SCE_CARTEL_BE BE = null;
try
{
using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin)))
{
cn.Open();
string sql = "SP_SCE_CARTEL_SEL";
using (SqlCommand cmd = new SqlCommand(sql, cn))
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BE = new SCE_CARTEL_BE();
BE.ID_CARTEL = Convert.ToInt32(reader["ID_CARTEL"]);
BE.CARTEL = Convert.ToString(reader["CARTEL"]);
BE.NOM_MODELO = Convert.ToString(reader["NOM_MODELO"]);
BE.FLAGPERTENECE = Convert.ToInt32(reader["FLAGPERTENECE"]);
lstBE.Add(BE);
}
return(lstBE);
}
}
}
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;
}
}
