protected void btnUpdate_Click1(object sender, EventArgs e) { //Check if invest package not expire - cannot buy new package PACKAGE_TRANSACTION obj = Singleton <PACKAGE_TRANSACTION_BC> .Inst.SelectActiveItem(Singleton <BITCurrentSession> .Inst.SessionMember.CodeId); if (txtPasswordPIN.Text != Singleton <BITCurrentSession> .Inst.SessionMember.Password_PIN) { TNotify.Toastr.Warning("Wrong transaction password, please try again", "Error", TNotify.NotifyPositions.toast_top_full_width, true); return; } try { //get temp object to insert, start date ,end date, expired date will be update after admin confirm transaction //PACKAGE_TRANSACTION obj = Singleton<PACKAGE_TRANSACTION_BC>.Inst.SelectActiveItem(Singleton<BITCurrentSession>.Inst.SessionMember.CodeId); PIN_TRANSACTION objPIN = new PIN_TRANSACTION(); objPIN.CODE_ID = Singleton <BITCurrentSession> .Inst.SessionMember.CodeId; objPIN.Package_TransactionID = obj.ID; objPIN.AMOUNT = Convert.ToDecimal(txtTotalAmount.Text); objPIN.CONFIRM_DATE = DateTime.Now; objPIN.CONFIRM_SEND = false; objPIN.CREATE_DATE = DateTime.Now; objPIN.FROM_DATE = DateTime.Now; switch (drTimeInvest.SelectedValue) { case "1": objPIN.TO_DATE = DateTime.Now.AddMonths(1); objPIN.MONTH = 1; break; case "2": objPIN.TO_DATE = DateTime.Now.AddMonths(2); objPIN.MONTH = 2; break; case "3": objPIN.TO_DATE = DateTime.Now.AddMonths(3); objPIN.MONTH = 3; break; } objPIN.TRANSACTION_PIN = txtTransaction.Text; //insert and update package_transaction Singleton <PIN_TRANSACTION_BC> .Inst.InsertItem(objPIN); TNotify.Alerts.Danger(string.Format("Extend Invest Package {0} Completed", lblCurrentPack.Text), true); Response.Redirect("../Admin/PIN.aspx"); } catch (Exception ex) { TNotify.Toastr.Warning("Error occur ! Please try again", "Error", TNotify.NotifyPositions.toast_top_full_width, true); } }
public void InsertItem(PIN_TRANSACTION obj) { defaultDB.ExecuteNonQuery("sp_PIN_TRANSACTION_Insert", obj.Package_TransactionID , obj.CODE_ID , obj.MONTH , obj.AMOUNT , obj.CONFIRM_SEND , obj.STATUS , obj.CREATE_DATE , obj.TRANSACTION_PIN , obj.CONFIRM_DATE , obj.FROM_DATE , obj.TO_DATE ); }
public void InsertItem(PIN_TRANSACTION obj) { ctl.InsertItem(obj); }