public ReturnStatus SetRoom(SetRoom req) { using (var connection = new SqlConnection(_connectionString.HotelManagement)) { var cmd = new SqlCommand(p_Rooms_Set, connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@UserID", _requestInfo.UserId); cmd.Parameters.Add("@RetVal", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@RetMsg", SqlDbType.VarChar, 500).Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@RoomID", req.RoomId); cmd.Parameters.AddWithValue("@RoomNo", req.RoomNo); cmd.Parameters.AddWithValue("@RoomTypeID", req.RoomTypeId); cmd.Parameters.AddWithValue("@RoomRate", req.RoomRate); cmd.Parameters.AddWithValue("@RoomStatusID", req.RoomStatusId); cmd.Parameters.AddWithValue("@MaxCapacity", req.MaxCapacity); cmd.Parameters.AddWithValue("@Disable", req.Disable); connection.Open(); cmd.ExecuteNonQuery(); return(new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(), cmd.Parameters["@RetMsg"].Value.ToSafeString())); } }
public ReturnStatus SetRoom(SetRoom req) { return(null); }
public void SendSetRoom(SetRoom args) { Send("SetRoom", args); }