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