public int confirmarAlterandoDAL(string val, string data, string servicos)
{
con = new ClasseConexao();
string[] info = val.Split(';');
string[] lstServicos = servicos.Split(',');
if (data.Equals(DateTime.Now.ToString().Split(' ')[0]))
{
con.executarSQL_NoQuery("UPDATE tblReserva SET idFuncionario = " + info[1] + ", codQuarto = " + info[2] + ", qtdeHospede = " + info[3] + ", dataEntrada = '" + info[4] + "', dataSaida = '" + info[5] + "', statusReserva = 's' WHERE codReserva = " + info[0]);
}
else
{
con.executarSQL_NoQuery("UPDATE tblReserva SET idFuncionario = " + info[1] + ", codQuarto = " + info[2] + ", qtdeHospede = " + info[3] + ", dataEntrada = '" + info[4] + "', dataSaida = '" + info[5] + " WHERE codReserva = " + info[0]);
}
con = new ClasseConexao();
con.executarSQL("DELETE tblReserva_Servico WHERE codReserva = " + info[0]);
for (int i = 0; i < lstServicos.Length; i++)
{
///if (lstServicos[i].Length == 6)
//{
con = new ClasseConexao();
con.executarSQL_NoQuery("INSERT INTO tblReserva_Servico VALUES(" + info[0] + ", " + lstServicos[i] + ")");
// }
}
con = new ClasseConexao();
return(con.executarSQL_NoQuery("UPDATE tblCliente SET nomeCliente = '" + info[6] + "', cpfCliente = '" + info[7] + "', dataNascimentoCliente = '" + info[8] + "', cepCliente = '" + info[9] + "', emailCliente = '" + info[10] + "', telefoneCliente = '" + info[11] + "' WHERE codCliente = " + info[12]));
}
public int realizarNoShow(string codReserva)
{
con = new ClasseConexao();
con.executarSQL_NoQuery("INSERT INTO tblNoShow values (" + codReserva + ", '" + DateTime.Now + "'");
con = new ClasseConexao();
return(con.executarSQL_NoQuery("EXEC usp_realizarNoShow " + codReserva));
}
public int finalizarReserva(String codReserva)
{
try
{
conexao = new ClasseConexao();
data = new DataSet();
String sql = "UPDATE tblReserva SET statusReserva = 'E' WHERE codReserva =" + codReserva;
return(conexao.executarSQL_NoQuery(sql));
}
catch (Exception)
{
return(0);
}
}
public int cancelarReserva(string codReserva)
{
con = new ClasseConexao();
return(con.executarSQL_NoQuery("EXEC usp_cancelarReserva " + codReserva));
}
