protected void btnEditOption_Click(object sender, EventArgs e)
{
int user = Convert.ToInt32(userLogin.UserId);
clientbus = new ClientBUS();
DataTable dtClient = new DataTable();
dtClient = clientbus.GetByID(user);
DateTime dateexpire = Convert.ToDateTime(dtClient.Rows[0]["expireDate"].ToString());
int registerId = Convert.ToInt32(dtClient.Rows[0]["registerId"].ToString());
int clientId = Convert.ToInt32(dtClient.Rows[0]["clientId"].ToString());
clientRegister = new ClientRegisterBUS();
DataTable dtClientRegister = new DataTable();
dtClientRegister = clientRegister.GetbyID(registerId);
int packageid = Convert.ToInt32(dtClientRegister.Rows[0]["packageId"].ToString());
int limitId = Convert.ToInt32(ddlLimitPackage.SelectedValue.ToString());
pkgBus = new PackageBUS();
DataTable dtpackage = new DataTable();
dtpackage = pkgBus.GetById(Convert.ToInt32(packageid));
int SubAccount = Convert.ToInt32(dtpackage.Rows[0]["subAccontCount"].ToString());
int totalFee = Convert.ToInt32(lblSumCost.Text);
int registerType = 3;
int packagetimeid = Convert.ToInt32(dtClientRegister.Rows[0]["packageTimeId"].ToString());
string from = Convert.ToDateTime(dtClientRegister.Rows[0]["from"].ToString()).ToString("dd/MM/yyyy");
string to = Convert.ToDateTime(dtClientRegister.Rows[0]["to"].ToString()).ToString("dd/MM/yyyy");
string lastRegisterFrom = Convert.ToDateTime(dtClientRegister.Rows[0]["lastRegisterFrom"].ToString()).ToString("dd/MM/yyyy");
string lastRegisterTo = Convert.ToDateTime(dtClientRegister.Rows[0]["lastRegisterTo"].ToString()).ToString("dd/MM/yyyy");
int lastRegisterFee = Convert.ToInt32(dtClientRegister.Rows[0]["lastRegisterFee"].ToString());
int lastRegisterFeeRemain = Convert.ToInt32(dtClientRegister.Rows[0]["lastRegisterFeeRemain"].ToString());
int newregisterid = clientRegister.UpdateUpgrade(clientId, packageid, limitId, SubAccount, totalFee, registerType, packagetimeid, from, to, lastRegisterFrom, lastRegisterTo, lastRegisterFee, lastRegisterFeeRemain);
clientbus.UpdateRegiterId(clientId, from, to, registerId, newregisterid);
foreach (RepeaterItem rptItems in rptListOptions.Items)
{
CheckBox chk = (CheckBox)rptItems.FindControl("chkOptions");
Label lbl = (Label)rptItems.FindControl("lblID");
int functionId = Convert.ToInt32(lbl.Text);
if (chk.Checked == true)
{
clientFunction = new ClientFunctionBUS();
clientFunction.UpdateFunction(newregisterid, clientId, functionId);
}
}
btnEditOption.Enabled = false;
btnEditOption.CssClass = "button round text-upper";
btnEditOption.Text = "Đã điều chỉnh chức năng gói!!!";
}
protected void btnGiahan_Click(object sender, EventArgs e)
{
if (Session["expireDays"] != null)
{
int user = Convert.ToInt32(userLogin.UserId);
clientbus = new ClientBUS();
DataTable dtClient = new DataTable();
dtClient = clientbus.GetByID(user);
int registerId = Convert.ToInt32(dtClient.Rows[0]["registerId"].ToString());
clientRegister = new ClientRegisterBUS();
DataTable dtClientRegister = new DataTable();
dtClientRegister = clientRegister.GetbyID(registerId);
int clientId = Convert.ToInt32(dtClientRegister.Rows[0]["clientId"].ToString());
int packageId = Convert.ToInt32(dtClientRegister.Rows[0]["packageId"].ToString());
int limitId = Convert.ToInt32(dtClientRegister.Rows[0]["limitId"].ToString());
int SubAccountCount = Convert.ToInt32(dtClientRegister.Rows[0]["subAccontCount"].ToString());
int emailCount = 0;
if(int.TryParse(dtClientRegister.Rows[0]["emailCount"].ToString(),out emailCount));
int totalFee = Convert.ToInt32(lblExtendCost.Text);
int registerType = Convert.ToInt32(dtClientRegister.Rows[0]["registerType"].ToString());
int packageTimeId = Convert.ToInt32(dtClientRegister.Rows[0]["packageTimeId"].ToString());
DateTime activeDate = DateTime.Now;
DateTime expireDate = Convert.ToDateTime(Session["expireDays"].ToString());
string from = activeDate.ToString("dd/MM/yyyy");
string to = expireDate.ToString("dd/MM/yyyy") ;
string lastRegisterFrom = Convert.ToDateTime(dtClientRegister.Rows[0]["from"].ToString()).ToString("dd/MM/yyyy");
string lastRegisterTo = Convert.ToDateTime(dtClientRegister.Rows[0]["to"].ToString()).ToString("dd/MM/yyyy");
int lastRegisterFee = Convert.ToInt32(dtClientRegister.Rows[0]["totalFee"].ToString());
int lastRegisterFeeRemain=0;
int newregisterid = clientRegister.UpdateUpgrade(clientId, packageId, limitId, SubAccountCount, totalFee, registerType, packageId, from, to, lastRegisterFrom, lastRegisterTo, lastRegisterFee, lastRegisterFeeRemain);
clientbus.UpdateRegiterId(clientId, from, to, registerId, newregisterid);
clientFunction = new ClientFunctionBUS();
DataTable dtRegisOldFunction = clientFunction.GetByregisterIdandclientId(registerId, clientId);
foreach (DataRow drRegisOldFunction in dtRegisOldFunction.Rows)
{
int functionId = Convert.ToInt32(drRegisOldFunction["functionId"].ToString());
clientFunction.UpdateFunction(newregisterid, clientId, functionId);
}
#region oldcode
expireDatesession = Session["expireDays"].ToString();
clientbus.UpdateExtendLicense(clientId.ToString(), activeDate, expireDate);
#endregion
}
LoadData();
}
protected void btnUpgrade_Click(object sender, EventArgs e)
{
//int limitId = Convert.ToInt32(ddlUpgradeServices.SelectedValue.ToString());
int packageid = Convert.ToInt32(ddlUpgradeServices.SelectedValue.ToString());
int user = Convert.ToInt32(userLogin.UserId);
clientbus = new ClientBUS();
DataTable dtClient = new DataTable();
dtClient = clientbus.GetByID(user);
DateTime dateexpire = Convert.ToDateTime(dtClient.Rows[0]["expireDate"].ToString());
int registerId = Convert.ToInt32(dtClient.Rows[0]["registerId"].ToString());
int clientId = Convert.ToInt32(dtClient.Rows[0]["clientId"].ToString());
DateTime dayactive = Convert.ToDateTime(dtClient.Rows[0]["activeDate"].ToString());
DateTime dayexpire = Convert.ToDateTime(dtClient.Rows[0]["expireDate"].ToString());
clientRegister = new ClientRegisterBUS();
DataTable dtClientRegister = new DataTable();
dtClientRegister = clientRegister.GetbyID(registerId);
int limitId = Convert.ToInt32(dtClientRegister.Rows[0]["limitId"].ToString());
string lastRegisterFrom = Convert.ToDateTime(dtClientRegister.Rows[0]["from"].ToString()).ToString("dd/MM/yyyy"); ;
string lastRegisterTo = Convert.ToDateTime(dtClientRegister.Rows[0]["to"].ToString()).ToString("dd/MM/yyyy");
clientRegister = new ClientRegisterBUS();
DataTable dtpackage = new DataTable();
pkgBus = new PackageBUS();
dtpackage = pkgBus.GetById(Convert.ToInt32(packageid));
int SubAccount = Convert.ToInt32(dtpackage.Rows[0]["subAccontCount"].ToString());
int packagelimitid = Convert.ToInt32(dtpackage.Rows[0]["limitid"].ToString());
DataTable dtlimit = new DataTable();
pkglimitBus = new PackageLimitBUS();
dtlimit = pkglimitBus.GetByUserIdPackageLimit(limitId);
pkgCostBus = new PackageCostBUS();
DataTable dtCost = pkgCostBus.GetPackageCost(packageid);
int cost = Convert.ToInt32(dtCost.Rows[0]["cost"].ToString());
int numberoftime = Convert.ToInt32(ddlUpgradeTime.SelectedValue);
int value = 0;
int totalFee = Convert.ToInt32(lblFee.Text);
string status = Request.QueryString["type"].ToString();
int registerType;
if (status == "extend")
{
registerType = 1;
}
else if (status == "upgrade")
{
registerType = 2;
}
else if (status == "addfunction")
{
registerType = 3;
}
else
{
registerType = 0;
}
string today = DateTime.Now.ToShortDateString();
int numberofday = Convert.ToInt32(ddlUpgradeTime.SelectedValue.ToString());
//DateTime expiredays = Convert.ToDateTime(today).AddMonths(numberofday);
//DateTime activedays = Convert.ToDateTime(today);
string registerDate = DateTime.Now.ToString("dd/MM/yyyy");
string registerTime = DateTime.Now.ToString("dd/MM/yyyy");
string from = DateTime.Now.ToString("dd/MM/yyyy");
string to = DateTime.Parse(Session["expireDays"].ToString()).ToString("dd/MM/yyyy");
int lastRegisterFee = Convert.ToInt32(dtClientRegister.Rows[0]["totalFee"].ToString());
int lastRegisterFeeRemain = Convert.ToInt32(lblFeeRemain.Text);
int packagetimeid = Convert.ToInt32(ddlUpgradeServices.SelectedValue);
int newregisterid = clientRegister.UpdateUpgrade(clientId, packageid, limitId, SubAccount, totalFee, registerType, packagetimeid, from, to, lastRegisterFrom, lastRegisterTo, lastRegisterFee, lastRegisterFeeRemain);
clientbus.UpdateRegiterId(clientId, from, to, registerId, newregisterid);
foreach (RepeaterItem rptItems in rptListOptionsUpgrade.Items)
{
CheckBox chk = (CheckBox)rptItems.FindControl("chkOptionsUpgrade");
Label lbl = (Label)rptItems.FindControl("lblIDUpgrade");
int functionId = Convert.ToInt32(lbl.Text);
if (chk.Checked == true)
{
clientFunction = new ClientFunctionBUS();
clientFunction.UpdateFunction(newregisterid, clientId, functionId);
}
}
btnUpgrade.Enabled = false;
btnUpgrade.CssClass = "button round text-upper";
btnUpgrade.Text = "Đã nâng cấp gói thành công!!!";
}
