public HttpResponseMessage List([FromBody] ReservationListRequest model)
{
var r = RBL.List(model);
if (r.Count > 0)
{
return(this.Request.CreateResponse(HttpStatusCode.OK, r));
}
else
{
return(this.Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public ActionResult ReservationsPrintVersion(int id)
{
ReservationListRequest ListRequest = new ReservationListRequest()
{
EventID = id,
GUID = null
};
var EventDetails = UBL.Details(id);
EventDetails.ReservationList = RBL.List(ListRequest);
return(View(EventDetails));
}
public HttpResponseMessage Print(int id)
{
ReservationListRequest ListRequest = new ReservationListRequest()
{
EventID = id,
GUID = null
};
var EventDetails = UPL.Details(id);
EventDetails.ReservationList = RBL.List(ListRequest);
string filename = "Reservas_"
+ EventDetails.Title + "_"
+ EventDetails.ScheduledDate.ToString().Substring(0, 13) + ".pdf";
return(Request.CreatePdfResponse("~/Views/Home/ReservationsPrintVersion.cshtml", model: EventDetails, filename));
}
public ActionResult ReservationsPDF(int id)
{
ReservationListRequest ListRequest = new ReservationListRequest()
{
EventID = id,
GUID = null
};
var EventDetails = UBL.Details(id);
EventDetails.ReservationList = RBL.List(ListRequest);
string filename = "Reservas_"
+ EventDetails.Title + "_"
+ EventDetails.ScheduledDate.ToString().Substring(0, 13) + ".pdf";
return(new ViewAsPdf("ReservationsPrintVersion", EventDetails)
{
FileName = filename
});
}
public List <Reservations> List(ReservationListRequest Model)
{
List <Reservations> Results = new List <Reservations>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[book].[uspReadReservation]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter pGUID = new SqlParameter
{
ParameterName = "@GUID",
SqlDbType = SqlDbType.VarChar,
Value = Model.GUID
};
SqlCmd.Parameters.Add(pGUID);
if (Model.EventID > 0)
{
SqlParameter pEventID = new SqlParameter
{
ParameterName = "@EventID",
SqlDbType = SqlDbType.Int,
Value = Model.EventID
};
SqlCmd.Parameters.Add(pEventID);
}
//Exec Command
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new Reservations
{
ReservationID = Convert.ToInt32(dr["ReservationID"]),
GUID = dr["GUID"].ToString(),
EventID = Convert.ToInt32(dr["EventID"]),
Title = dr["Title"].ToString(),
ScheduledDate = Convert.ToDateTime(dr["ScheduledDate"]),
BookedBy = Convert.ToInt32(dr["BookedBy"]),
BookedByName = dr["BookedByName"].ToString(),
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
IdentityID = dr["IdentityID"].ToString(),
ReservationDate = Convert.ToDateTime(dr["ReservationDate"])
};
Results.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(Results);
}
public List <Reservations> List(ReservationListRequest model)
{
return(RDAL.List(model));
}
private void OpenRsvList() => ReservationListRequest.Raise(new DataPassingNotification());
