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