protected void ddlUpgradeTime_SelectedIndexChanged(object sender, EventArgs e)
{
int value=Convert.ToInt32(ddlUpgradeServices.SelectedValue);
if (value != 0 )
{
string today = DateTime.Now.ToShortDateString();
int packageId = Convert.ToInt32(ddlUpgradeServices.SelectedValue);
int numberofday = Convert.ToInt32(ddlUpgradeTime.SelectedValue.ToString());
pkgCostBus = new PackageCostBUS();
DataTable dtCost = pkgCostBus.GetPackageCost(packageId);
int cost = Convert.ToInt32(dtCost.Rows[0]["cost"].ToString());
int numberoftime = Convert.ToInt32(ddlUpgradeTime.SelectedValue);
double dayleft = Convert.ToDouble(Session["totalDayLeft"]);
int totalFee = cost * numberoftime;
double costperday = cost / 30;
double feeRemain = GetFeeRemain(Convert.ToInt32(userLogin.UserId));
double finalFeeRemain = Math.Round(feeRemain * dayleft);
if (numberofday > 0)
{
DateTime expiredays = Convert.ToDateTime(today).AddMonths(numberofday);
if (dayleft != null)
{
expiredays = expiredays.AddDays(Convert.ToInt32(dayleft));
double daybonus = (finalFeeRemain / costperday);
string temp = daybonus.ToString();
if (temp == "NaN")
{
daybonus = 0;
}
expiredays = expiredays.AddDays(Math.Round(daybonus));
if (daybonus > 0)
{
lblUpgradeExpireTime.Text = expiredays.ToString("dd/MM/yyyy") + " (+" + Math.Round(daybonus) + " ngày)";
Session["expireDays"] = expiredays.ToString();
}
else
{
lblUpgradeExpireTime.Text = expiredays.ToString("dd/MM/yyyy");
Session["expireDays"] = expiredays.ToString();
}
}
else
{
lblUpgradeExpireTime.Text = expiredays.ToString("dd/MM/yyyy");
Session["expireDays"] = expiredays.ToString();
}
btnUpgrade.Enabled = true;
btnUpgrade.CssClass = "button round blue image-right ic-add text-upper";
lblFee.Text = totalFee.ToString();
lblFeeRemain.Text = finalFeeRemain.ToString();
}
else
{
DateTime expiredays = Convert.ToDateTime(today).AddMonths(numberofday);
if (dayleft != null)
{
expiredays = expiredays.AddDays(Convert.ToInt32(dayleft));
lblUpgradeExpireTime.Text = expiredays.ToString("dd/MM/yyyy");
Session["expireDays"] = expiredays.ToString();
}
else
{
lblUpgradeExpireTime.Text = expiredays.ToString("dd/MM/yyyy");
Session["expireDays"] = expiredays.ToString();
}
lblFee.Text = totalFee.ToString();
lblFeeRemain.Text = Math.Round(feeRemain).ToString();
}
#region loadfunction
pkgFunctionBus = new PackageFunctionBUS();
DataTable dtfunction = pkgFunctionBus.GetFunctionbyPackageId(Convert.ToInt32(packageId));
DataTable dtFunctionTemmp = new DataTable();
dtFunctionTemmp.Columns.Add("functionId");
dtFunctionTemmp.Columns.Add("functionName");
dtFunctionTemmp.Columns.Add("cost");
dtFunctionTemmp.Columns.Add("isDefault");
foreach (DataRow drfunction in dtfunction.Rows)
{
int id = Convert.ToInt32(drfunction["functionId"].ToString());
function = new FunctionBUS();
DataTable dtTemp = function.GetByUserId(id);
DataRow dr = dtFunctionTemmp.NewRow();
dr["functionId"] = dtTemp.Rows[0]["functionId"].ToString();
dr["functionName"] = dtTemp.Rows[0]["functionName"].ToString();
dr["cost"] = dtTemp.Rows[0]["cost"].ToString();
dr["isDefault"] = dtTemp.Rows[0]["isDefault"].ToString();
dtFunctionTemmp.Rows.Add(dr);
}
rptListOptionsUpgrade.DataSource = dtFunctionTemmp;
rptListOptionsUpgrade.DataBind();
pkgBus = new PackageBUS();
DataTable dtPackage = pkgBus.GetById(Convert.ToInt32(packageId));
int currentLimitID = Convert.ToInt32(dtPackage.Rows[0]["limitId"].ToString());
pkglimitBus = new PackageLimitBUS();
DataTable dtTempp = pkglimitBus.GetAll();
ddlPackageLimitUpgrade.DataSource = dtTempp;
ddlPackageLimitUpgrade.DataTextField = "namepackagelimit";
ddlPackageLimitUpgrade.DataValueField = "limitId";
ddlPackageLimitUpgrade.DataBind();
ddlPackageLimitUpgrade.SelectedValue = currentLimitID.ToString();
#endregion
}
}
private void LoadData()
{
if (Request.QueryString["type"] != null)
{
string status = Request.QueryString["type"].ToString();
int userid = Convert.ToInt32(userLogin.UserId);
if (status == "extend")
{
#region Extend
lblTitle.Text = "Gia hạn dịch vụ";
extendbox.Visible = true;
upgradeservices.Visible = false;
btnGiahan.Enabled = false; ;
btnGiahan.CssClass = "button round image-right ic-add text-upper";
if (userid != null)
{
int user = userid;//Convert.ToInt32(Request.QueryString["user"].ToString());
clientbus = new ClientBUS();
DataTable dtClient = new DataTable();
dtClient = clientbus.GetByID(user);
string email = dtClient.Rows[0]["email"].ToString();
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);
string packageid = dtClientRegister.Rows[0]["packageId"].ToString();
DataTable dtpackage = new DataTable();
pkgBus = new PackageBUS();
dtpackage = pkgBus.GetById(Convert.ToInt32(packageid));
int packagelimitid = Convert.ToInt32(dtClientRegister.Rows[0]["limitId"].ToString());
DataTable dtlimit = new DataTable();
pkglimitBus = new PackageLimitBUS();
dtlimit = pkglimitBus.GetByUserIdPackageLimit(packagelimitid);
DateTime NgayHetHan = Convert.ToDateTime(dtClient.Rows[0]["expireDate"].ToString());
string todays = DateTime.Now.ToString("yyyy-MM-dd");
DateTime today = Convert.ToDateTime(todays);
DateTime expireDay = Convert.ToDateTime(NgayHetHan);
if (today > expireDay)
{
lblExpireDate.Text = NgayHetHan.ToString("dd/MM/yyyy") + " (Đã hết hạn) ";
}
else if (expireDay > today)
{
string totalday = (expireDay - today).TotalDays.ToString();
dayleft = totalday;
lblExpireDate.Text = NgayHetHan.ToString("dd/MM/yyyy") + "(Còn " + totalday + " ngày)";
btnGiahan.Enabled = false;
btnGiahan.CssClass = "button round image-right ic-add text-upper";
ddlExtend.Enabled = false;
Session["totalDayLeft"] = totalday;
}
else if (expireDay == today)
{
double totalday = (expireDay - today).TotalMinutes;
if (totalday > 0)
{
lblExpireDate.Text = NgayHetHan.ToString("dd/MM/yyyy") + "(Còn " + totalday + " phút)";
btnGiahan.Enabled = false;
btnGiahan.CssClass = "button round image-right ic-add text-upper";
ddlExtend.Enabled = false;
}
else
{
lblExpireDate.Text = NgayHetHan.ToString("dd/MM/yyyy") + " (Đã hết hạn) ";
}
}
}
#endregion
}
else if (status == "upgrade")
{
#region Upgrade
lblTitle.Text = "Nâng cấp dịch vụ";
extendbox.Visible = false;
upgradeservices.Visible = true;
ddlUpgradeTime.Enabled = false;
optionchkbox.Attributes.Add("disabled","true");
if (userid != null)
{
int user = userid;
clientbus = new ClientBUS();
DataTable dtClient = new DataTable();
dtClient = clientbus.GetByID(user);
string email = dtClient.Rows[0]["email"].ToString();
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);
string packageid = dtClientRegister.Rows[0]["packageId"].ToString();
DataTable dtpackage = new DataTable();
pkgBus = new PackageBUS();
dtpackage = pkgBus.GetById(Convert.ToInt32(packageid));
int packagelimitid = Convert.ToInt32(dtClientRegister.Rows[0]["limitid"].ToString());
DataTable dtlimit = new DataTable();
pkglimitBus = new PackageLimitBUS();
dtlimit = pkglimitBus.GetByUserIdPackageLimit(packagelimitid);
lblTenGoi.Text = dtpackage.Rows[0]["packageName"].ToString();
#region loadpackage
pkgFunctionBus = new PackageFunctionBUS();
DataTable dtfunction = pkgFunctionBus.GetFunctionbyPackageId(Convert.ToInt32(packageid));
DataTable dtFunctionTemmp = new DataTable();
dtFunctionTemmp.Columns.Add("functionId");
dtFunctionTemmp.Columns.Add("functionName");
dtFunctionTemmp.Columns.Add("cost");
dtFunctionTemmp.Columns.Add("isDefault");
foreach (DataRow drfunction in dtfunction.Rows)
{
int id = Convert.ToInt32(drfunction["functionId"].ToString());
function = new FunctionBUS();
DataTable dtTemp = function.GetByUserId(id);
DataRow dr = dtFunctionTemmp.NewRow();
dr["functionId"] = dtTemp.Rows[0]["functionId"].ToString();
dr["functionName"] = dtTemp.Rows[0]["functionName"].ToString();
dr["cost"] = dtTemp.Rows[0]["cost"].ToString();
dr["isDefault"] = dtTemp.Rows[0]["isDefault"].ToString();
dtFunctionTemmp.Rows.Add(dr);
}
rptListOptionsUpgrade.DataSource = dtFunctionTemmp;
rptListOptionsUpgrade.DataBind();
pkgBus = new PackageBUS();
DataTable dtPackage = pkgBus.GetById(Convert.ToInt32(packageid));
int currentLimitID = Convert.ToInt32(dtPackage.Rows[0]["limitId"].ToString());
pkglimitBus = new PackageLimitBUS();
DataTable dtTempp = pkglimitBus.GetAll();
ddlPackageLimitUpgrade.DataSource = dtTempp;
ddlPackageLimitUpgrade.DataTextField = "namepackagelimit";
ddlPackageLimitUpgrade.DataValueField = "limitId";
ddlPackageLimitUpgrade.DataBind();
ddlPackageLimitUpgrade.SelectedValue = currentLimitID.ToString();
#endregion
DateTime today = DateTime.Now;
DateTime dayexpire = Convert.ToDateTime(dtClient.Rows[0]["expireDate"].ToString());
string totaldayleft,hoursleft;
if (dayexpire > today)
{
totaldayleft = Math.Round((dateexpire - today).TotalDays).ToString();
hoursleft = Math.Round(Convert.ToDouble((dateexpire - today).TotalHours-(24*Convert.ToDouble(totaldayleft)))).ToString();
double comparetime=Convert.ToDouble(totaldayleft);
double comparehours = Convert.ToDouble(hoursleft);
if (comparetime >= 1&&comparehours>0)
{
lblTimeLeft.Text =dateexpire.ToString("dd/MM/yyyy")+ " (Còn " + totaldayleft +" ngày "+hoursleft+" giờ)";
dayleft = totaldayleft;
Session["totalDayLeft"] = totaldayleft;
}
else if(comparetime>=1&&comparehours<=0)
{
lblTimeLeft.Text = dateexpire.ToString("dd/MM/yyyy") + " (Còn " + totaldayleft + " ngày)";
dayleft = totaldayleft;
Session["totalDayLeft"] = totaldayleft;
}
else
{
totaldayleft = (dateexpire - today).TotalHours.ToString();
comparetime = Convert.ToDouble(totaldayleft);
lblTimeLeft.Text = "Còn " + Math.Round(comparetime) + " giờ";
//sdayleft = totaldayleft;
}
}
else if(dayexpire<today)
{
lblTimeLeft.Text = dayexpire + " (Đã hết hạn)";
}
btnUpgrade.Enabled = false;
btnUpgrade.CssClass = "button round image-right ic-add text-upper";
}
#endregion
}
else if (status == "editoption")
{
#region EditOption
lblTitle.Text = "Thay đổi chức năng dịch vụ";
extendbox.Visible = false;
upgradeservices.Visible = false;
changeoptionbox.Visible = true;
if (userid != null)
{
int user = userid;
clientbus = new ClientBUS();
DataTable dtClient = new DataTable();
dtClient = clientbus.GetByID(user);
string email = dtClient.Rows[0]["email"].ToString();
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);
string packageid = dtClientRegister.Rows[0]["packageId"].ToString();
pkgFunctionBus=new PackageFunctionBUS();
DataTable dtfunction = pkgFunctionBus.GetFunctionbyPackageId(Convert.ToInt32(packageid));
DataTable dtFunctionTemmp = new DataTable();
dtFunctionTemmp.Columns.Add("functionId");
dtFunctionTemmp.Columns.Add("functionName");
dtFunctionTemmp.Columns.Add("cost");
dtFunctionTemmp.Columns.Add("isDefault");
foreach (DataRow drfunction in dtfunction.Rows)
{
int id = Convert.ToInt32(drfunction["functionId"].ToString());
function = new FunctionBUS();
DataTable dtTemp = function.GetByUserId(id);
DataRow dr = dtFunctionTemmp.NewRow();
dr["functionId"] = dtTemp.Rows[0]["functionId"].ToString();
dr["functionName"] = dtTemp.Rows[0]["functionName"].ToString();
dr["cost"] = dtTemp.Rows[0]["cost"].ToString();
dr["isDefault"] = dtTemp.Rows[0]["isDefault"].ToString();
dtFunctionTemmp.Rows.Add(dr);
}
rptListOptions.DataSource = dtFunctionTemmp;
rptListOptions.DataBind();
pkgBus=new PackageBUS();
DataTable dtPackage = pkgBus.GetById(Convert.ToInt32(packageid));
int currentLimitID = Convert.ToInt32(dtPackage.Rows[0]["limitId"].ToString());
pkglimitBus = new PackageLimitBUS();
DataTable dtTempp = pkglimitBus.GetAll();
ddlLimitPackage.DataSource = dtTempp;
ddlLimitPackage.DataTextField = "namepackagelimit";
ddlLimitPackage.DataValueField = "limitId";
ddlLimitPackage.DataBind();
ddlLimitPackage.SelectedValue = currentLimitID.ToString();
pkglimitBus = new PackageLimitBUS();
DataTable dtCosts = pkglimitBus.GetByUserIdPackageLimit(currentLimitID);
int value2 = Convert.ToInt32(dtCosts.Rows[0]["cost"].ToString());
foreach (RepeaterItem rptItems in rptListOptions.Items)
{
CheckBox chk = (CheckBox)rptItems.FindControl("chkOptions");
Label lbl = (Label)rptItems.FindControl("lblCost");
if (chk.Checked == true)
{
value2 += Convert.ToInt32(lbl.Text);
}
}
lblSumCost.Text = (value2).ToString();
}
#endregion
}
}
}
protected void ddlUpgradeServices_SelectedIndexChanged(object sender, EventArgs e)
{
int packageId = Convert.ToInt32(ddlUpgradeServices.SelectedValue);
if (packageId != 0)
{
pkgFunctionBus = new PackageFunctionBUS();
DataTable dtfunction = pkgFunctionBus.GetFunctionbyPackageId(Convert.ToInt32(packageId));
DataTable dtFunctionTemmp = new DataTable();
dtFunctionTemmp.Columns.Add("functionId");
dtFunctionTemmp.Columns.Add("functionName");
dtFunctionTemmp.Columns.Add("cost");
dtFunctionTemmp.Columns.Add("isDefault");
foreach (DataRow drfunction in dtfunction.Rows)
{
int id = Convert.ToInt32(drfunction["functionId"].ToString());
function = new FunctionBUS();
DataTable dtTemp = function.GetByUserId(id);
DataRow dr = dtFunctionTemmp.NewRow();
dr["functionId"] = dtTemp.Rows[0]["functionId"].ToString();
dr["functionName"] = dtTemp.Rows[0]["functionName"].ToString();
dr["cost"] = dtTemp.Rows[0]["cost"].ToString();
dr["isDefault"] = dtTemp.Rows[0]["isDefault"].ToString();
dtFunctionTemmp.Rows.Add(dr);
}
rptListOptionsUpgrade.DataSource = dtFunctionTemmp;
rptListOptionsUpgrade.DataBind();
pkgBus = new PackageBUS();
DataTable dtPackage = pkgBus.GetById(Convert.ToInt32(packageId));
int currentLimitID = Convert.ToInt32(dtPackage.Rows[0]["limitId"].ToString());
pkglimitBus = new PackageLimitBUS();
DataTable dtTempp = pkglimitBus.GetAll();
ddlPackageLimitUpgrade.DataSource = dtTempp;
ddlPackageLimitUpgrade.DataTextField = "namepackagelimit";
ddlPackageLimitUpgrade.DataValueField = "limitId";
ddlPackageLimitUpgrade.DataBind();
ddlPackageLimitUpgrade.SelectedValue = currentLimitID.ToString();
ddlUpgradeTime.Enabled = true;
//ddlUpgradeTime.SelectedValue = 1+"";
int value = 0;
int Id = Convert.ToInt32(ddlPackageLimitUpgrade.SelectedValue.ToString());
int numberoftime = Convert.ToInt32(ddlUpgradeTime.SelectedValue);
pkglimitBus = new PackageLimitBUS();
DataTable dtTemps = pkglimitBus.GetByUserIdPackageLimit(Id);
if (numberoftime > 0)
{
foreach (RepeaterItem rptItems in rptListOptionsUpgrade.Items)
{
CheckBox chk = (CheckBox)rptItems.FindControl("chkOptionsUpgrade");
Label lbl = (Label)rptItems.FindControl("lblCostUpgrade");
if (chk.Checked == true)
{
value += Convert.ToInt32(lbl.Text);
}
else
{
//value = value;
}
}
int value2 = Convert.ToInt32(dtTemps.Rows[0]["cost"].ToString());
if (numberoftime == 0)
{
lblFee.Text = (value + value2).ToString();
}
else if (numberoftime > 0)
{
int sum = ((value + value2) * numberoftime);
lblFee.Text = sum.ToString();
}
}
else
{
}
}
}
