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());