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!!!"; }