public void Insertar_Paises(ref string sMsjError, ref cls_Paises_DAL ObjPaises_DAL)
{
cls_BaseDatos_DAL Obj_DAL = new cls_BaseDatos_DAL();
cls_Bases_BLL Obj_BLL = new cls_Bases_BLL();
Obj_BLL.TablaParametros(ref Obj_DAL);
Obj_DAL.DT_Parametros.Rows.Add("@NombrePais", 3, ObjPaises_DAL.sNombrePais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@CodigoISOPais", 2, ObjPaises_DAL.sCodigoISOPais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@CodigoAreaPais", 2, ObjPaises_DAL.sCodigoAreaPais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@IdEstado", 2, ObjPaises_DAL.cIdEstado.ToString().Trim());
Obj_DAL.sSentencia = ConfigurationManager.AppSettings["Insertar Paises"].ToString().Trim();
Obj_BLL.Ejec_Scalar(ref Obj_DAL);
if (Obj_DAL.sMsgError == string.Empty)
{
sMsjError = string.Empty;
ObjPaises_DAL.iIdPais = Obj_DAL.iValorScalar;
ObjPaises_DAL.cBandera = 'I';
}
else
{
sMsjError = Obj_DAL.sMsgError;
ObjPaises_DAL.cBandera = 'U';
ObjPaises_DAL.iIdPais = -1;
}
}
private void tls_btn_Modificar_Click(object sender, EventArgs e)
{
frm_Modificar_Paises ModificarPaises = new frm_Modificar_Paises();
if (dgv_Paises.RowCount > 0)
{
ObjPaises_DAL = new cls_Paises_DAL();
ObjPaises_DAL.cBandera = 'U';
ObjPaises_DAL.iIdPais = Convert.ToInt32(dgv_Paises.SelectedRows[0].Cells[0].Value);
ObjPaises_DAL.sNombrePais = dgv_Paises.SelectedRows[0].Cells[1].Value.ToString().Trim();
ObjPaises_DAL.sCodigoISOPais = dgv_Paises.SelectedRows[0].Cells[2].Value.ToString().Trim();
ObjPaises_DAL.sCodigoAreaPais = dgv_Paises.SelectedRows[0].Cells[3].Value.ToString().Trim();
ObjPaises_DAL.cIdEstado = Convert.ToChar(dgv_Paises.SelectedRows[0].Cells[4].Value);
ModificarPaises.Obj_Paises_DAL = ObjPaises_DAL;
Hide();
ModificarPaises.ShowDialog();
tls_txt_Filtro.Text = string.Empty;
CargarDatos();
}
else
{
MessageBox.Show("No se pueden realizar la acción, debido a que no existen datos por modificar", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void Modificar_Paises(ref string sMsjError, ref cls_Paises_DAL ObjPaises_DAL)
{
cls_BaseDatos_DAL Obj_DAL = new cls_BaseDatos_DAL();
cls_Bases_BLL Obj_BLL = new cls_Bases_BLL();
Obj_BLL.TablaParametros(ref Obj_DAL);
Obj_DAL.DT_Parametros.Rows.Add("@IdPais", 1, ObjPaises_DAL.iIdPais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@NombrePais", 3, ObjPaises_DAL.sNombrePais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@CodigoISOPais", 2, ObjPaises_DAL.sCodigoISOPais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@CodigoAreaPais", 2, ObjPaises_DAL.sCodigoAreaPais.ToString().Trim());
Obj_DAL.DT_Parametros.Rows.Add("@IdEstado", 2, ObjPaises_DAL.cIdEstado.ToString().Trim());
Obj_DAL.sSentencia = ConfigurationManager.AppSettings["Modificar Paises"].ToString().Trim();
Obj_BLL.Ejec_NonQuery(ref Obj_DAL);
if (Obj_DAL.sMsgError == string.Empty)
{
sMsjError = string.Empty;
}
else
{
sMsjError = Obj_DAL.sMsgError;
}
}
private void tls_btn_Nuevo_Click(object sender, EventArgs e)
{
ObjPaises_DAL = new cls_Paises_DAL();
frm_Modificar_Paises ModificarPaises = new frm_Modificar_Paises();
ObjPaises_DAL.cBandera = 'I';
ObjPaises_DAL.iIdPais = 0;
ObjPaises_DAL.sNombrePais = string.Empty;
ObjPaises_DAL.sCodigoISOPais = string.Empty;
ObjPaises_DAL.sCodigoAreaPais = string.Empty;
ObjPaises_DAL.cIdEstado = ' ';
ModificarPaises.Obj_Paises_DAL = ObjPaises_DAL;
Hide();
ModificarPaises.ShowDialog();
tls_txt_Filtro.Text = string.Empty;
CargarDatos();
}
