public void Insertar_Aerolineas(ref string sMsjError, ref cls_Aerolineas_DAL objDAL_Aerolineas) { 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("@NombreAerolinea", 3, objDAL_Aerolineas.sNombreAerolinea.ToString().Trim()); Obj_DAL.DT_Parametros.Rows.Add("@IdEstado", 2, objDAL_Aerolineas.cIdEstado.ToString().Trim()); Obj_DAL.sSentencia = ConfigurationManager.AppSettings["Insertar_Aerolineas"].ToString().Trim(); Obj_BLL.Ejec_Scalar(ref Obj_DAL); if (Obj_DAL.sMsgError == string.Empty) { sMsjError = string.Empty; objDAL_Aerolineas.iIdAerolinea = Obj_DAL.iValorScalar; objDAL_Aerolineas.cBandera = 'I'; } else { sMsjError = Obj_DAL.sMsgError; objDAL_Aerolineas.cBandera = 'U'; objDAL_Aerolineas.iIdAerolinea = -1; } }
private void bnt_Nuevo_Click(object sender, EventArgs e) { frm_ModificarAerolineas Pantalla = new frm_ModificarAerolineas(); objDal_Aerolinea = new cls_Aerolineas_DAL(); objDal_Aerolinea.cBandera = 'I'; Pantalla.objDAL_Aerolinea = objDal_Aerolinea; Hide(); Pantalla.ShowDialog(); Show(); txtFiltro.Text = string.Empty; CargarDatos(); }
private void dgv_Aerolineas_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { objDal_Aerolinea = new cls_Aerolineas_DAL(); objDal_Aerolinea.cBandera = 'U'; objDal_Aerolinea.iIdAerolinea = Convert.ToInt32(dgv_Aerolineas.SelectedRows[0].Cells[0].Value.ToString().Trim()); objDal_Aerolinea.sNombreAerolinea = dgv_Aerolineas.SelectedRows[0].Cells[1].Value.ToString().Trim(); objDal_Aerolinea.cIdEstado = Convert.ToChar(dgv_Aerolineas.SelectedRows[0].Cells[2].Value.ToString().Trim()); frm_ModificarAerolineas Pantalla = new frm_ModificarAerolineas(); Hide(); Pantalla.objDAL_Aerolinea = objDal_Aerolinea; Pantalla.ShowDialog(); Show(); txtFiltro.Text = string.Empty; CargarDatos(); }
private void btn_Modificar_Click(object sender, EventArgs e) { if (dgv_Aerolineas.RowCount == 0) { MessageBox.Show("No existen datos para modificar", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { objDal_Aerolinea = new cls_Aerolineas_DAL(); objDal_Aerolinea.cBandera = 'U'; objDal_Aerolinea.iIdAerolinea = Convert.ToInt32(dgv_Aerolineas.SelectedRows[0].Cells[0].Value.ToString().Trim()); objDal_Aerolinea.sNombreAerolinea = dgv_Aerolineas.SelectedRows[0].Cells[1].Value.ToString().Trim(); objDal_Aerolinea.cIdEstado = Convert.ToChar(dgv_Aerolineas.SelectedRows[0].Cells[2].Value.ToString().Trim()); frm_ModificarAerolineas Pantalla = new frm_ModificarAerolineas(); Pantalla.objDAL_Aerolinea = objDal_Aerolinea; Hide(); Pantalla.ShowDialog(); Show(); txtFiltro.Text = string.Empty; CargarDatos(); } }
public void Modificar_Aerolineas(ref string sMsjError, ref cls_Aerolineas_DAL objDAL_Aerolineas) { 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("@IdAerolinea", 1, objDAL_Aerolineas.iIdAerolinea.ToString().Trim()); Obj_DAL.DT_Parametros.Rows.Add("@NombreAerolinea", 3, objDAL_Aerolineas.sNombreAerolinea.ToString().Trim()); Obj_DAL.DT_Parametros.Rows.Add("@IdEstado", 2, objDAL_Aerolineas.cIdEstado.ToString().Trim()); Obj_DAL.sSentencia = ConfigurationManager.AppSettings["Modificar_Aerolineas"].ToString().Trim(); Obj_BLL.Ejec_NonQuery(ref Obj_DAL); if (Obj_DAL.sMsgError == string.Empty) { sMsjError = string.Empty; } else { sMsjError = Obj_DAL.sMsgError; } }