public void updateGH1(PACKAGE_TRANSACTION obj) { defaultDB.ExecuteNonQuery("sp_PACKAGE_TRANSACTION_UPDATE_GH1", obj.ID , obj.CODEID , obj.PACKAGEID , obj.AMOUNT ); }
protected void btnUpdate_Click1(object sender, EventArgs e) { //Check if invest package not expire - cannot buy new package 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; } if (!Singleton <PACKAGE_TRANSACTION_BC> .Inst.isAllPackageExpire(Singleton <BITCurrentSession> .Inst.SessionMember.CodeId)) { try { //get temp object to insert, start date ,end date, expired date will be update after admin confirm transaction PACKAGE_TRANSACTION obj = new PACKAGE_TRANSACTION(); obj.CODEID = Singleton <BITCurrentSession> .Inst.SessionMember.CodeId; obj.PACKAGEID = Convert.ToInt32(drPackSelectTion.SelectedValue); obj.START_DATE = DateTime.Now; switch (drTimeInvest.SelectedValue) { case "1": obj.END_DATE = DateTime.Now.AddMonths(1); break; case "2": obj.END_DATE = DateTime.Now.AddMonths(2); break; case "3": obj.END_DATE = DateTime.Now.AddMonths(3); break; } obj.EXPIRED = 0; obj.GH1 = DateTime.Now.AddDays(45); obj.GH2 = DateTime.Now.AddDays(90); obj.STATUS_GH = 0; obj.CREATE_DATE = DateTime.Now; obj.TRANSACTION_PACKAGE = txtTransaction.Text; obj.AMOUNT = Convert.ToDecimal(txtTotalAmount.Text); obj.STATUS_PH = 0; Singleton <PACKAGE_TRANSACTION_BC> .Inst.InsertItem(obj, Convert.ToInt32(drTimeInvest.SelectedValue)); TNotify.Alerts.Danger(string.Format("Buy Invest Package {0} Completed", drPackSelectTion.SelectedValue), true); Response.Redirect("../Admin/SelectPackInvest.aspx"); } catch (Exception ex) { TNotify.Toastr.Warning("Error occur ! Please try again", "Error", TNotify.NotifyPositions.toast_top_full_width, true); } } else { TNotify.Alerts.Danger(string.Format("You have Invest Package not complete, please check your Invest Package !", drPackSelectTion.SelectedValue), true); } }
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); } }
private void loadPackInfo() { //load packinfo PACKAGE_TRANSACTION pckActive = Singleton <PACKAGE_TRANSACTION_BC> .Inst.SelectActiveItem(Singleton <BITCurrentSession> .Inst.SessionMember.CodeId); if (pckActive != null) { lblCurrentPack.Text = pckActive.PACKAGEID.ToString(); hidPackage_transactionID.Value = pckActive.ID.ToString(); } //PIN spin = Singleton }
public string datecount(object startDate, object endate, object ID) { //return date count //check if enddate = datetime.now => update status_ph to 0 if (Convert.ToDateTime(endate).Date == DateTime.Now.Date) { PACKAGE_TRANSACTION pck = Singleton <PACKAGE_TRANSACTION_BC> .Inst.SelectItem(Convert.ToInt32(ID)); pck.STATUS_PH = 0; Singleton <PACKAGE_TRANSACTION_BC> .Inst.updateItem(pck); } return((DateTime.Now.DayOfYear - Convert.ToDateTime(startDate).DayOfYear).ToString()); }
public void updateItem(PACKAGE_TRANSACTION obj) { defaultDB.ExecuteNonQuery("sp_PACKAGE_TRANSACTION_UPDATE_BYID", obj.ID , obj.CODEID , obj.PACKAGEID , obj.START_DATE , obj.END_DATE , obj.EXPIRED , obj.GH1 , obj.GH2 , obj.STATUS_GH , obj.CREATE_DATE , obj.TRANSACTION_PACKAGE , obj.AMOUNT , obj.STATUS_PH ); }
public void InsertItem(PACKAGE_TRANSACTION obj, int month) { defaultDB.ExecuteNonQuery("sp_PACKAGE_TRANSACTION_Insert", obj.CODEID , obj.PACKAGEID , obj.START_DATE , obj.END_DATE , obj.EXPIRED , obj.GH1 , obj.GH2 , obj.STATUS_GH , obj.CREATE_DATE , obj.TRANSACTION_PACKAGE , obj.AMOUNT , obj.STATUS_PH , month ); }
protected void lnkConfirm_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)(sender); string ID = btn.CommandArgument; PACKAGE_TRANSACTION pck = Singleton <PACKAGE_TRANSACTION_BC> .Inst.SelectItem(Convert.ToInt32(ID)); //update pck ph_status = 1; //update members set startdate = pack startdate endate = packendate pck.STATUS_PH = 1; //create store update package and members Singleton <PACKAGE_TRANSACTION_BC> .Inst.updateItem(pck); MEMBERS objMem = Singleton <MEMBERS_BC> .Inst.SelectItem(pck.CODEID); objMem.ActiveDate = pck.START_DATE; objMem.ExpiredDate = pck.END_DATE; Singleton <MEMBERS_BC> .Inst.UpdateExpireDate(objMem); TNotify.Alerts.Danger(string.Format("Confirmed Invest Package {0} for User {1} Completed", pck.PACKAGEID, objMem.Username), true); Response.Redirect("../admin/adminselectpackInvest.aspx"); }
protected void btnGH2_Click(object sender, EventArgs e) { try { LinkButton btn = (LinkButton)(sender); string ID = btn.CommandArgument; PACKAGE_TRANSACTION pck = Singleton <PACKAGE_TRANSACTION_BC> .Inst.SelectItem(Convert.ToInt32(ID)); //update wallet + commission pck.STATUS_GH = 2; pck.EXPIRED = 1; //update package_transaction Singleton <PACKAGE_TRANSACTION_BC> .Inst.updateGH2(pck); Response.Redirect("../Admin/Withdraw.aspx"); TNotify.Toastr.Warning("GH Second time completed", "Completed", TNotify.NotifyPositions.toast_top_full_width, true); } catch (Exception ex) { TNotify.Toastr.Warning("Error occur ! Please try again", "Error", TNotify.NotifyPositions.toast_top_full_width, true); } }
protected void btnGH1_Click(object sender, EventArgs e) { try { LinkButton btn = (LinkButton)(sender); string ID = btn.CommandArgument; PACKAGE_TRANSACTION pck = Singleton <PACKAGE_TRANSACTION_BC> .Inst.SelectItem(Convert.ToInt32(ID)); //update wallet + commission pck.STATUS_GH = 1; //update package transaction Singleton <PACKAGE_TRANSACTION_BC> .Inst.updateGH1(pck); TNotify.Alerts.Danger(string.Format("GH Fist time completed", drPackSelectTion.SelectedValue), true); //TNotify.Toastr.Warning("GH Fist time completed", "Completed", TNotify.NotifyPositions.toast_top_full_width, true); Response.Redirect("../Admin/SelectPackInvest.aspx"); } catch (Exception ex) { TNotify.Toastr.Warning("Error occur ! Please try again", "Error", TNotify.NotifyPositions.toast_top_full_width, true); } }
public void updateGH1(PACKAGE_TRANSACTION obj) { ctl.updateGH1(obj); }
public void updateItem(PACKAGE_TRANSACTION obj) { ctl.updateItem(obj); }
public void InsertItem(PACKAGE_TRANSACTION obj, int month) { ctl.InsertItem(obj, month); }