private int AddCreditCard(CreditCardDetail crdObj)
{
if (crdObj == null)
{
return(0);
}
string queryString = @"IF (NOT EXISTS(SELECT id FROM master.[dbproject].[CreditCard] WHERE [cardNumber] = @cardNumber))
BEGIN
INSERT INTO master.[dbproject].[CreditCard]([cardHolderName], [cardNumber], [expiryDate], [code], [bankName])
VALUES(@cardHolderName, @cardNumber, @expiryDate, @code, @bankName)
END
ELSE
BEGIN
UPDATE master.[dbproject].[CreditCard]
SET [cardHolderName] = @cardHolderName,
[expiryDate] = @expiryDate,
[code] = @code,
[bankName] = @bankName
WHERE [cardNumber] = @cardNumber
END ";
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@cardHolderName", crdObj.cardHolderName);
param[1] = new SqlParameter("@cardNumber", crdObj.cardNumber);
param[2] = new SqlParameter("@expiryDate", crdObj.expiryDate);
param[3] = new SqlParameter("@code", crdObj.code);
param[4] = new SqlParameter("@bankName", crdObj.bankName);
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();
}