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