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