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