public JsonResult GetYearSale(string sId, string date)
        {
            ArrayList list = new ArrayList();

             //   int storeId = 1;

            int selectDateYear = DateTime.Now.Year;

            if (!ValidationUtility.IsNull(date))
            {
                selectDateYear = ValidationUtility.ToInteger(date);
            }

              int storeId = ValidationUtility.ToInteger(sId);
              LiveSaleModel liveSaleModel = new LiveSaleModel();

              if (storeId != 0)
              {

                  Dictionary<int, string> connectionString = (Dictionary<int, string>)Session["ConnectionString"];

                  string storeNameConnectionString = "";

                  if (connectionString.ContainsKey(storeId))
                  {
                      storeNameConnectionString = connectionString[storeId];

                  }

                  list.Add(liveSaleModel.GetYearSaleOfStore(storeId, selectDateYear, storeNameConnectionString));
              }
              else
              {

                  ArrayList storeList = null;
                  UserContext cont = (UserContext)Session["UserContext"];

                  if (!ValidationUtility.IsNull(cont) && ValidationUtility.IsEqual(cont.Role, "Corporate"))
                  {
                      storeList = ValidationUtility.GetCorporateUserAssignActiveStore(cont.Id, true);
                  }
                  else
                  {
                      storeList = ValidationUtility.GetActiveStoreList(true);
                  }

                  list.Add(liveSaleModel.GetYearSaleOfAllStore(selectDateYear, storeList));

              }

            return Json(list, JsonRequestBehavior.AllowGet);
        }