protected void cashout_Click(object sender, EventArgs e) { if (Session["CashoutAmount"] == null) { Response.Write("<script>alert('Please select Reward Amount you want to get')</script>"); } else { SqlConnection sc = new SqlConnection(); sc.ConnectionString = ConfigurationManager.ConnectionStrings["GroupProjectConnectionString"].ConnectionString; sc.Open(); SqlCommand insert = new SqlCommand(); insert.Connection = sc; insert.CommandText = "SELECT [TotalAmount] FROM [MoneyTransaction] where MoneyTransactionID=(select max(MoneyTransactionID) from MoneyTransaction)"; SqlDataReader reader = insert.ExecuteReader(); if (reader.HasRows) { reader.Read(); int totalPoints = Convert.ToInt32(reader["TotalAmount"]); int transactionAmount = Convert.ToInt32(rblcashout.SelectedValue); reader.Close(); if (totalPoints >= transactionAmount && (Convert.ToInt32(Session["PointsBalance"]) > transactionAmount)) { MoneyTransaction newTransaction = new MoneyTransaction(totalPoints, DateTime.Today.ToShortDateString(), transactionAmount, DateTime.Today.ToShortDateString(), Session["loggedIn"].ToString(), Convert.ToInt32(Session["ID"])); insert.CommandText = "INSERT INTO [dbo].[MoneyTransaction] ([Date],[TotalAmount],[TransactionAmount],[LastUpdated],[LastUpdatedBy],[PersonID])" + "VALUES (@Date,@TotalAmount,@TransactionAmount,@LastUpdated,@LastUpdatedBy,@PersonID)"; insert.Parameters.AddWithValue("@TotalAmount", totalPoints - transactionAmount); insert.Parameters.AddWithValue("@Date", newTransaction.getDate()); insert.Parameters.AddWithValue("@TransactionAmount", newTransaction.getTransactionAmount()); insert.Parameters.AddWithValue("@LastUpdated", newTransaction.getLUD()); insert.Parameters.AddWithValue("@LastUpdatedBy", newTransaction.getLUDB()); insert.Parameters.AddWithValue("@PersonID", newTransaction.getPersonID()); insert.ExecuteNonQuery(); sc.Close(); Response.Write("<script>alert('Transaction Submited')</script>"); Send_Mail(Session["E-mail"].ToString(), newTransaction.getTransactionAmount()); rewardpool(); } else { Response.Write("<script>alert('personal points not enough or Bank balance low')</script>"); } } } }
protected void cashout_Click(object sender, EventArgs e) { if (Session["CashoutAmount"] == null) { Response.Write("<script>alert('Please select Reward Amount you want to get')</script>"); } else { SqlConnection sc = new SqlConnection(); sc.ConnectionString = ConfigurationManager.ConnectionStrings["GroupProjectConnectionString"].ConnectionString; sc.Open(); SqlCommand insert = new SqlCommand(); insert.Connection = sc; insert.CommandText = "SELECT [TotalAmount] FROM [MoneyTransaction] where MoneyTransactionID=(select max(MoneyTransactionID) from MoneyTransaction)"; SqlDataReader reader = insert.ExecuteReader(); if (reader.HasRows) { reader.Read(); int totalPoints = Convert.ToInt32(reader["TotalAmount"]); reader.Close(); int sessionID = (int)(Session["ID"]); SqlCommand trans = new SqlCommand("select value from giftcard where giftcardID = @giftcardID"); trans.Parameters.AddWithValue("@giftcardID", rblcashout.SelectedValue); trans.Connection = sc; SqlDataReader transReader = trans.ExecuteReader(); transReader.Read(); Session["transAmount"] = Convert.ToInt32(transReader["value"]); int transactionAmount = (int)(Session["transAmount"]); transReader.Close(); if (totalPoints >= transactionAmount && (Convert.ToInt32(Session["PointsBalance"]) > transactionAmount)) { MoneyTransaction newTransaction = new MoneyTransaction(totalPoints, DateTime.Today.ToShortDateString(), transactionAmount, DateTime.Today.ToShortDateString(), Session["loggedIn"].ToString(), Convert.ToInt32(Session["ID"])); insert.CommandText = "INSERT INTO [dbo].[MoneyTransaction] ([Date],[TotalAmount],[TransactionAmount],[LastUpdated],[LastUpdatedBy],[PersonID])" + "VALUES (@Date,@TotalAmount,@TransactionAmount,@LastUpdated,@LastUpdatedBy,@PersonID)"; insert.Parameters.AddWithValue("@TotalAmount", totalPoints - transactionAmount); insert.Parameters.AddWithValue("@Date", newTransaction.getDate()); insert.Parameters.AddWithValue("@TransactionAmount", newTransaction.getTransactionAmount()); insert.Parameters.AddWithValue("@LastUpdated", newTransaction.getLUD()); insert.Parameters.AddWithValue("@LastUpdatedBy", newTransaction.getLUDB()); insert.Parameters.AddWithValue("@PersonID", newTransaction.getPersonID()); insert.ExecuteNonQuery(); //amount to pay billyjacks son, this is Session["payProvider"] = newTransaction.getTransactionAmount(); Session["providerToPaypal"] = "*****@*****.**";//sql statement to grab email of the provider of giftcard based on provider name of card - from/in table provider // string payp = Session["PointsBalance"].ToString(); var apiContext = Configuration.GetAPIContext(); // ### Initialize `Payout` Object // Initialize a new `Payout` object with details of the batch payout to be created. var payout = new Payout { // #### sender_batch_header // Describes how the payments defined in the `items` array are to be handled. sender_batch_header = new PayoutSenderBatchHeader { sender_batch_id = "batch_" + System.Guid.NewGuid().ToString().Substring(0, 8), email_subject = "You have a payment" }, // #### items // The `items` array contains the list of payout items to be included in this payout. // If `syncMode` is set to `true` when calling `Payout.Create()`, then the `items` array must only // contain **one** item. If `syncMode` is set to `false` when calling `Payout.Create()`, then the `items` // array can contain more than one item. items = new List <PayoutItem> { new PayoutItem { recipient_type = PayoutRecipientType.EMAIL, amount = new Currency { value = payp,//paypalAmount.ToString(), currency = "USD" }, receiver = "*****@*****.**",//Session["providerToPaypal"].ToString(), note = "Thank you.", sender_item_id = "item_1" }//, //new PayoutItem //{ // recipient_type = PayoutRecipientType.EMAIL, // amount = new Currency // { // value = "0.90", // currency = "USD" // }, // receiver = "*****@*****.**", // note = "Thank you.", // sender_item_id = "item_2" //}, //new PayoutItem //{ // recipient_type = PayoutRecipientType.EMAIL, // amount = new Currency // { // value = "2.00", // currency = "USD" // }, // receiver = "*****@*****.**", // note = "Thank you.", // sender_item_id = "item_3" //} } }; // ^ Ignore workflow code segment //#region Track Workflow //this.flow.AddNewRequest("Create payout", payout); //#endregion // ### Payout.Create() // Creates the batch payout resource. // `syncMode = false` indicates that this call will be performed **asynchronously**, // and will return a `payout_batch_id` that can be used to check the status of the payouts in the batch. // `syncMode = true` indicates that this call will be performed **synchronously** and will return once the payout has been processed. // > **NOTE**: The `items` array can only have **one** item if `syncMode` is set to `true`. var createdPayout = payout.Create(apiContext, false); //RunSample(); //employee receipt SqlCommand insertgcr = new SqlCommand(); insertgcr.Connection = sc; insertgcr.CommandText = "INSERT INTO [dbo].[GiftCardReceipt]([GiftCardID],[PersonID],[PurchaseDate],[LastUpdated],[LastUpdatedBy],[ConfirmationNumber]) VALUES ( @GiftCardID, @PersonID, @PurchaseDate, @LastUpdated, @LastUpdatedBy, @ConfirmationNumber)"; string giftcardID = rblcashout.SelectedValue; Random rnd = new Random(); int confirmation = rnd.Next(5, 100); insertgcr.Parameters.AddWithValue("@GiftCardReceiptID", 1); insertgcr.Parameters.AddWithValue("@GiftCardID", giftcardID); insertgcr.Parameters.AddWithValue("@PersonID", Session["ID"]); insertgcr.Parameters.AddWithValue("@PurchaseDate", DateTime.Now); insertgcr.Parameters.AddWithValue("@LastUpdated", DateTime.Now); insertgcr.Parameters.AddWithValue("@LastUpdatedby", Session["loggedIn"].ToString()); insertgcr.Parameters.AddWithValue("@ConfirmationNumber", confirmation); insertgcr.ExecuteNonQuery(); Response.Redirect("EmployeeReciept.aspx"); SqlCommand getItBoy = new SqlCommand(); //employee receipt end sc.Close(); Response.Write("<script>alert('Transaction Submited')</script>"); rewardpool(); } else { Response.Write("<script>alert('personal points not enough or Bank balance low')</script>"); } SampleItem newPayout = new SampleItem { Title = "Create a payout", ExecutePage = "PayoutCreate.aspx", HasSourcePage = true }; } } }