public ReturnStatus SetGuest(SetGuest req) { using (var connection = new SqlConnection(_connectionString.HotelManagement)) { var cmd = new SqlCommand(p_Guests_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("@GuestID", req.GuestId); cmd.Parameters.AddWithValue("@FirstName", req.FirstName); cmd.Parameters.AddWithValue("@MidName", req.MidName); cmd.Parameters.AddWithValue("@LastName1", req.LastName1); cmd.Parameters.AddWithValue("@LastName2", req.LastName2); cmd.Parameters.AddWithValue("@GuestTypeID", req.GuestTypeId); cmd.Parameters.AddWithValue("@DLNo", req.DLNo); cmd.Parameters.AddWithValue("@BlackList", req.BlackList); cmd.Parameters.AddWithValue("@BlackListDate", req.BlackListDate); cmd.Parameters.AddWithValue("@StreetAddress", req.StreetAddress); cmd.Parameters.AddWithValue("@CityID", req.CityId); cmd.Parameters.AddWithValue("@StateID", req.StateId); cmd.Parameters.AddWithValue("@CountryID", req.CountryId); cmd.Parameters.AddWithValue("@PostalCode", req.PostalCode); cmd.Parameters.AddWithValue("@Email", req.Email); cmd.Parameters.AddWithValue("@PhoneNumber", req.PhoneNumber); cmd.Parameters.AddWithValue("@Comment", req.Comment); connection.Open(); cmd.ExecuteNonQuery(); return(new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(), cmd.Parameters["@RetMsg"].Value.ToSafeString())); } }
public ReturnStatus SetGuest(SetGuest req) { return(null); }