public BookingCateringModel cateringGet(int id) { BookingCateringModel rtn = null; SqlParameter[] parameters = { new SqlParameter { ParameterName = "@id", Value = id, DbType = DbType.Int32 } }; DataTable dt = base.ExecuteDataTable("usp_booking_s_catering", parameters); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; rtn = new BookingCateringModel { id = id, idBooking = Convert.ToInt16(dr["idBooking"]), idCatering = Convert.ToInt16(dr["idCatering"]), quantity = Convert.ToInt16(dr["quantity"]), unitPrice = Convert.ToDecimal(dr["unitPrice"]), amount = Convert.ToDecimal(dr["amount"]), createdAt = Convert.ToDateTime(dr["createdAt"]), updatedAt = Convert.ToDateTime(dr["updatedAt"]) }; } return(rtn); }
public bool cateringUpdate(int id, BookingCateringModel bc) { bool rtn = false; SqlParameter[] parameters = { new SqlParameter { ParameterName = "@id", Value = id }, new SqlParameter { ParameterName = "@idCatering", Value = bc.idCatering }, new SqlParameter { ParameterName = "@quantity", Value = bc.quantity }, new SqlParameter { ParameterName = "@result", Direction = ParameterDirection.Output, DbType = DbType.Int32 } }; SqlParameter[] outputs = base.ExecuteNonQuery("usp_booking_u_catering", parameters); if (outputs != null && outputs.Length > 0) { rtn = Convert.ToBoolean(outputs[0].Value); } return(rtn); }
public IActionResult cateringGet(int id) { BookingService service = new BookingService(); var status = true; BookingCateringModel result = null; try{ result = service.cateringGet(id); }catch (System.Exception) { status = false; } var rtn = new { status = status, result = result }; return(Ok(rtn)); }
public IActionResult cateringUpdate(int id, BookingCateringModel bc) { BookingService service = new BookingService(); var status = true; bool result = false; try{ result = service.cateringUpdate(id, bc); }catch (System.Exception) { status = false; } var rtn = new { status = status, result = result }; return(Ok(rtn)); }
public bool cateringUpdate(int id, BookingCateringModel bc) { BookingData droom = new BookingData(); return(droom.cateringUpdate(id, bc)); }
/* Catering */ public bool cateringInsert(int idBooking, BookingCateringModel bc) { BookingData droom = new BookingData(); return(droom.cateringInsert(idBooking, bc)); }