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