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