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