private void LoadStore()
 {
     try
     {
         var row = aStoreBll.GetStoreByProjectCodeByLocation(((SessionUser)Session["SessionUser"]).OCode);
         if (row.Count > 0)
         {
             ddlStoreName.DataSource     = row.ToList();
             ddlStoreName.DataTextField  = "StoreName";
             ddlStoreName.DataValueField = "Store_Code";
             ddlStoreName.DataBind();
             ddlStoreName.Items.Insert(0, new ListItem("---Select---", "0"));
         }
     }
     catch
     {
     }
 }
 private void GetAllStore()
 {
     try
     {
         var result = aStoreBll.GetStoreByProjectCodeByLocation(((SessionUser)Session["SessionUser"]).OCode);
         if (result.Count > 0)
         {
             ddlStore.DataSource     = result.ToList();
             ddlStore.DataTextField  = "StoreName";
             ddlStore.DataValueField = "Store_Code";
             ddlStore.DataBind();
             ddlStore.Items.Insert(0, new ListItem("---Select---", "0"));
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
     }
 }