public string actualizarReserva(List <elReserva> lelReserva)
{
int result = 0;
int result2 = 0;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
string correos = "";
dlReserva odlReserva = new dlReserva();
correos = odlReserva.actualizarReserva(lelReserva, con);
//correos = odlReserva.obtenerCorreosXidReserva(lelReserva, con);
string[] correo = correos.Split('#');
result = correo.Length;
for (int j = 0; j < result; j++)
{
result2 += EnviarVariosCorreo(correo[j]);
}
}
catch (Exception ex)
{
string url = HttpContext.Current.Request.Url.ToString();
Log.Error(logPath, "blReserva_actualizarReserva", url, ex);
}
}
return(result + "|" + result2);
}
public int guardarReserva(List <elReserva> lelReserva)
{
int result = 0;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
dlReserva odlReserva = new dlReserva();
result = odlReserva.guardarReserva(lelReserva, con);
}
catch (Exception ex)
{
string url = HttpContext.Current.Request.Url.ToString();
Log.Error(logPath, "blReserva_guardarReserva", url, ex);
}
}
return(result);
}
public string CheckList(int idReserva, int iniFin, string checkList)
{
string result = "";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
dlReserva odlReserva = new dlReserva();
result = odlReserva.CheckList(idReserva, iniFin, checkList, con);
}
catch (Exception ex)
{
string url = HttpContext.Current.Request.Url.ToString();
Log.Error(logPath, "blReserva_CheckList", url, ex);
}
}
return(result);
}
public List <elReserva> obtenerReservaxUsuario(int salaId, int userId, int idSede, int estado)
{
List <elReserva> lelReserva = null;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
lelReserva = new List <elReserva>();
con.Open();
dlReserva odlReserva = new dlReserva();
lelReserva = odlReserva.obtenerReservaxUsuario(salaId, userId, idSede, estado, con);
}
catch (Exception ex)
{
string url = HttpContext.Current.Request.Url.ToString();
Log.Error(logPath, "blReserva_reservaXsalaEvents", url, ex);
}
}
return(lelReserva);
}
public List <elReserva> reservaXsalaEvents(int salaId, string fhinicio, string fhfin)
{
List <elReserva> lelReserva = null;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
lelReserva = new List <elReserva>();
con.Open();
dlReserva odlReserva = new dlReserva();
lelReserva = odlReserva.reservaXsalaEvents(salaId, fhinicio, fhfin, con);
}
catch (Exception ex)
{
string url = HttpContext.Current.Request.Url.ToString();
Log.Error(logPath, "blReserva_reservaXsalaEvents", url, ex);
}
}
return(lelReserva);
}
public int EnviarCorreo(List <elReserva> lelReserva)
{
int result = 0;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
string correos = "";
dlReserva odlReserva = new dlReserva();
correos = odlReserva.obtenerCorreos(lelReserva[0].idSala, lelReserva[0].idCreator, con);
result = EnviarCorreo(lelReserva, correos);
}
catch (Exception ex)
{
string url = HttpContext.Current.Request.Url.ToString();
Log.Error(logPath, "blReserva_EnviarCorreo", url, ex);
}
}
return(result);
}
