private void ListaCheck(int Idreserva)
{
try
{
// oCheckDL = new CheckListBL();
var oListcheck = oCheckDL.ListarChecklist(Idreserva);
btnAceptar.IsEnabled = true;
if (oListcheck.Count > 0)
{
oCheckBE = new CheckListBE();
oCheckBE = oListcheck.First();
switch (oCheckBE.TipoCheck)
{
case "Check In":
columnPdf.Visibility = Visibility.Visible;
break;
case "Check Out":
columnPdf.Visibility = Visibility.Collapsed;
break;
}
btnAceptar.IsEnabled = false;
}
else
{
cbxTipoCheck.IsEnabled = false;
}
gvCheckList.ItemsSource = oListcheck;
}
catch {
gvCheckList.ItemsSource = null;
}
}
public Multa(CheckListBE checkTemp, ReservaBE reservaTempo)
{
InitializeComponent();
reservaTemp = reservaTempo;
txtRutUsuario.Text = reservaTempo.Usuario.RutUsuario;
btnEditar.IsEnabled = false;
SnackbarError.Visibility = Visibility.Visible;
SnackbarCorrecto.Visibility = Visibility.Visible;
id_check_list = checkTemp.IdCheckIn;
oMultaBL = new MultaBL();
if (checkTemp.EntregaLlave.Equals("No"))
{
txtDescripcion.Text = "Se realiza cobro por lo siguiente:\n " + "No entregar llave\n";
}
if (checkTemp.EntregaControlTv.Equals("No"))
{
txtDescripcion.Text += "No entrega control TV\n";
}
if (checkTemp.EntregaControlAir.Equals("No"))
{
txtDescripcion.Text += "No entrega control aire";
}
ListaCheck(id_check_list);
}
public bool actualizarCheckList(CheckListBE ocheck)
{
try
{
return(ochecklistDA.actualizar(ocheck));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <CheckListBE> Listarchecklist(int Idreserva)
{
using (OracleCommand oOracleCommand = new OracleCommand("PKG_RESERVA.SP_LISTAR_CHECK_LIST", conn))
{
try
{
oOracleCommand.CommandType = CommandType.StoredProcedure;
oOracleCommand.CommandTimeout = 10;
oOracleCommand.Parameters.Add(new OracleParameter("PN_ID_RESERVA", Idreserva));
OracleParameter oParam = new OracleParameter("CUR_RESERVAS", OracleDbType.RefCursor);
oParam.Direction = ParameterDirection.Output;
oParam.Size = 128;
oOracleCommand.Parameters.Add(oParam);
DataTable oDataTable = new DataTable();
conn.Open();
oDataTable.Load(oOracleCommand.ExecuteReader());
conn.Close();
listCheck = new List <CheckListBE>();
foreach (DataRow item in oDataTable.Rows)
{
oChecklist = new CheckListBE();
oChecklist.IdCheckIn = int.Parse(item[0].ToString());
oChecklist.TipoCheck = item[1].ToString();
oChecklist.EntregaLlave = item[2].ToString();
oChecklist.EntregaControlTv = item[3].ToString();
oChecklist.EntregaControlAir = item[4].ToString();
oChecklist.RecibeRegalo = item[5].ToString();
listCheck.Add(oChecklist);
}
return(listCheck);
}
catch (Exception ex)
{
return(null);
// throw new Exception(ex.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
}
public bool agregar(CheckListBE ochech)
{
using (OracleCommand oOracleCommand = new OracleCommand("PKG_RESERVA.SP_CREAR_CHECK_LIST", conn))
{
try
{
switch (ochech.TipoCheck)
{
case "Check In":
tipo_Check = 0;
break;
case "Check Out":
tipo_Check = 1;
break;
}
switch (ochech.EntregaLlave)
{
case "Si":
llave = 1;
break;
case "No":
llave = 0;
break;
}
switch (ochech.EntregaControlTv)
{
case "Si":
control_tv = 1;
break;
case "No":
control_tv = 0;
break;
}
switch (ochech.EntregaControlAir)
{
case "Si":
control_air = 1;
break;
case "No":
control_air = 0;
break;
}
switch (ochech.RecibeRegalo)
{
case "Si":
regalo = 1;
break;
case "No":
regalo = 0;
break;
}
oOracleCommand.CommandType = CommandType.StoredProcedure;
oOracleCommand.CommandTimeout = 10;
oOracleCommand.Parameters.Add(new OracleParameter("PN_TIPO_CHECK", tipo_Check));
oOracleCommand.Parameters.Add(new OracleParameter("PN_ENTREGA_LLAVE", llave));
oOracleCommand.Parameters.Add(new OracleParameter("PN_ENTREGA_CONTROL_TV", control_tv));
oOracleCommand.Parameters.Add(new OracleParameter("PN_ENTREGA_CONTROL_AIR", control_air));
oOracleCommand.Parameters.Add(new OracleParameter("PN_RECIBE_REGALO", regalo));
oOracleCommand.Parameters.Add(new OracleParameter("PN_RESERVA_ID", ochech.Reserva.IdReserva));
OracleParameter oParam = new OracleParameter("S_RESULTADO", OracleDbType.Varchar2);
oParam.Direction = ParameterDirection.Output;
oParam.Size = 128;
oOracleCommand.Parameters.Add(oParam);
conn.Open();
oOracleCommand.ExecuteReader();
string respuesta = oOracleCommand.Parameters["S_RESULTADO"].Value.ToString();
//0 es igual a se realizo la acción.........
//1 es igual ocurrio algo que no se puedo realizar la acción
if (respuesta.Equals("0"))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
}
private async void btnEditar_Click(object sender, RoutedEventArgs e)
{
Task <bool> taskmensaje = new Task <bool>(CorreoBL.TimeMensaje);
try
{
oCheckBE = new CheckListBE();
int llave = 0;
int control_tv = 0;
int control_air = 0;
int regalo = 0;
if (cbLlave.IsChecked == true)
{
llave = 1;
}
if (cbControlTv.IsChecked == true)
{
control_tv = 1;
}
if (cbControlAir.IsChecked == true)
{
control_air = 1;
}
if (cbRegalo.IsChecked == true)
{
regalo = 1;
}
oCheckBE.IdCheckIn = id_Check;
oCheckBE.TipoCheck = cbxTipoCheck.SelectedIndex.ToString();
oCheckBE.EntregaLlave = llave.ToString();
oCheckBE.EntregaControlTv = control_tv.ToString();
oCheckBE.EntregaControlAir = control_air.ToString();
oCheckBE.RecibeRegalo = regalo.ToString();
btnEditar.IsEnabled = false;
SnackbarCorrecto.IsActive = true;
SnackbarCorrecto.Message.Content = $"Se esta modificando el {cbxTipoCheck.SelectedValue.ToString()}...";
taskmensaje.Start();
bool respp = await taskmensaje;
taskmensaje = new Task <bool>(CorreoBL.TimeMensaje);
if (oCheckDL.actualizarCheckList(oCheckBE))
{
Limpiar();
btnAceptar.IsEnabled = false;
SnackbarCorrecto.IsActive = true;
SnackbarCorrecto.Message.Content = "Se modificó correctamente el cheklist";
taskmensaje.Start();
bool resp = await taskmensaje;
if (resp)
{
SnackbarCorrecto.IsActive = false;
}
}
else
{
Limpiar();
SnackbarCorrecto.IsActive = false;
SnackbarError.IsActive = true;
SnackbarError.Message.Content = "Algo ocurrió, inténtelo más tarde ";
taskmensaje.Start();
bool resp = await taskmensaje;
if (resp)
{
SnackbarError.IsActive = false;
}
}
}
catch (Exception ex)
{
Limpiar();
SnackbarCorrecto.IsActive = false;
SnackbarError.IsActive = true;
SnackbarError.Message.Content = ex.Message;
taskmensaje.Start();
bool resp = await taskmensaje;
if (resp)
{
SnackbarError.IsActive = false;
}
}
}
private void GvcheckList_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
{
try
{
oListcheck = new List <CheckListBE>();
CheckListBE oCheck = new CheckListBE();
oCheck = (CheckListBE)((DataGrid)sender).CurrentItem;
var columna = ((DataGrid)sender).CurrentColumn.Header;
foreach (CheckListBE item in ((List <CheckListBE>)((DataGrid)sender).ItemsSource).ToList())
{
btnAceptar.IsEnabled = false;
oCheckBE = new CheckListBE();
oCheckBE = item;
if (item.IdCheckIn.Equals(oCheck.IdCheckIn))
{
oCheckBE.IsSelected = true;
btnEditar.IsEnabled = true;
btnRegistrarMulta.IsEnabled = true;
id_Check = item.IdCheckIn;
switch (item.TipoCheck)
{
case "Check In":
cbxTipoCheck.SelectedIndex = 0;
btnRegistrarMulta.IsEnabled = false;
cbRegalo.IsEnabled = true;
columnPdf.Visibility = Visibility.Visible;
break;
case "Check Out":
cbxTipoCheck.SelectedIndex = 1;
btnRegistrarMulta.IsEnabled = true;
cbRegalo.IsEnabled = false;
columnPdf.Visibility = Visibility.Collapsed;
break;
}
btnAceptar.IsEnabled = false;
if (oCheck.EntregaLlave.Equals("Si"))
{
cbLlave.IsChecked = true;
}
if (oCheck.EntregaControlAir.Equals("Si"))
{
cbControlAir.IsChecked = true;
}
if (oCheck.EntregaControlTv.Equals("Si"))
{
cbControlTv.IsChecked = true;
}
if (oCheck.RecibeRegalo.Equals("Si"))
{
cbRegalo.IsChecked = true;
}
}
oListcheck.Add(oCheckBE);
checktemp = new CheckListBE();
checktemp = oCheckBE;
}
((DataGrid)sender).ItemsSource = oListcheck;
if (columna.Equals(" "))
{
if (count < 1)
{
BtnPdf_Click(sender, null);
count++;
}
else
{
count = 0;
}
}
}
catch (Exception ex)
{
}
}
