public List <Guest> GetGuests(GetGuests req)
{
return(null);
}
public ApiResponse <List <Guest> > GetGuests(GetGuests req)
{
var result = null as List <Guest>;
using (var connection = new SqlConnection(_connectionString.HotelManagement))
{
var cmd = new SqlCommand(p_Guests_Get, 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.IncludeBlackListed);
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();
using (var dr = cmd.ExecuteReader())
{
result = new List <Guest>();
while (dr.Read())
{
result.Add(new Guest
{
GuestId = dr["GuestID"].ToSafeInt32(),
FirstName = dr["FirstName"].ToSafeString(),
MidName = dr["MidName"].ToSafeString(),
LastName1 = dr["LastName1"].ToSafeString(),
LastName2 = dr["LastName2"].ToSafeString(),
GuestTypeId = dr["GuestTypeID"].ToSafeInt32(),
DLNo = dr["DLNo"].ToSafeString(),
BlackListed = dr["BlackListed"].ToSafeBool(),
BlackListDate = dr["BlackListDate"].ToSafeDateTime(),
StreetAddress = dr["StreetAddress"].ToSafeString(),
CityId = dr["CityId"].ToSafeInt32(),
StateId = dr["StateId"].ToSafeInt32(),
CountryId = dr["CountryId"].ToSafeInt32(),
PostalCode = dr["PostalCode"].ToSafeString(),
Email = dr["Email"].ToSafeString(),
PhoneNumber = dr["PhoneNumber"].ToSafeString(),
Comment = dr["Comment"].ToSafeString(),
CreatedId = dr["CreatedID"].ToSafeInt32(),
CreatedBy = dr["CreatedBy"].ToSafeString(),
CreatedDateTime = dr["CreatedDateTime"].ToSafeDateTime(),
ModifiedId = dr["ModifiedID"].ToSafeInt32(),
ModifiedBy = dr["ModifiedBy"].ToSafeString(),
ModifiedDateTime = dr["ModifiedDateTime"].ToSafeDateTime()
});
}
}
return(new ApiResponse <List <Guest> >
{
Content = result,
Status = new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(),
cmd.Parameters["@RetMsg"].Value.ToSafeString())
});
}
}
