private int AddGuest(GuestDetail gdObj, string ccNum)
{
if (gdObj == null || string.IsNullOrEmpty(ccNum))
{
return(0);
}
string queryString = @"IF (NOT EXISTS(SELECT id FROM master.[dbproject].[Guest] WHERE validIdNumber = @idNumber AND validIdType = @idType))
BEGIN
INSERT INTO master.[dbproject].[Guest](name, address, validIdType, validIdNumber, gmailAddress, creditCardId)
VALUES(@fullName, @fullAddress, @idType, @idNumber, @gmailAddress, (SELECT id FROM master.[dbproject].[CreditCard] WHERE [cardNumber] = @ccNum))
END
ELSE
BEGIN
UPDATE master.[dbproject].[Guest]
SET [name] = @fullName,
[address] = @fullAddress,
[creditCardId] = (SELECT id FROM master.[dbproject].[CreditCard] WHERE [cardNumber] = @ccNum)
WHERE validIdNumber = @idNumber
AND validIdType = @idType
END ";
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@idNumber", gdObj.idNumber);
param[1] = new SqlParameter("@idType", gdObj.idType);
param[2] = new SqlParameter("@fullName", gdObj.fullName);
param[3] = new SqlParameter("@fullAddress", gdObj.address + ", " + gdObj.city + ", " + gdObj.state + ", " + gdObj.pinCode);
param[4] = new SqlParameter("@ccNum", ccNum);
param[5] = new SqlParameter("@gmailAddress", gdObj.emailAddr);
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Connection.Open();
if (param != null)
{
command.Parameters.AddRange(param);
}
return(command.ExecuteNonQuery());
}
}
}
public BookViewModel(RoomDetail roomDetail)
{
this.roomDetail = roomDetail;
creditCardDetail = new CreditCardDetail();
guestDetail = new GuestDetail();
}
