void LoadGrid() { // format phone no. CommonCode objCommonCode = new CommonCode(); //FranchisorService service = new FranchisorService(); FranchisorDAL objFranchisorDal = new FranchisorDAL(); var currentSession = IoC.Resolve <ISessionContext>().UserSession; var listProspect = objFranchisorDal.GetUserProspect(string.Empty, Convert.ToInt32(currentSession.UserId), Convert.ToInt32(currentSession.CurrentOrganizationRole.RoleId), Convert.ToInt32(currentSession.CurrentOrganizationRole.OrganizationId), 0); EProspect[] arrProspect = null; if (listProspect != null) { arrProspect = listProspect.ToArray(); } if (arrProspect.Length > 0) { DataTable tblProspect = new DataTable(); tblProspect.Columns.Add("ProspectID", typeof(Int32)); tblProspect.Columns.Add("Name"); tblProspect.Columns.Add("Address"); tblProspect.Columns.Add("Phone"); tblProspect.Columns.Add("Email"); foreach (EProspect objProspect in arrProspect) { string address = objProspect.Address.Address1 + " " + objProspect.Address.City + " " + objProspect.Address.State + " " + objProspect.Address.Country + " " + objProspect.Address.ZipID.ToString(); tblProspect.Rows.Add(objProspect.ProspectID, objProspect.OrganizationName, address, objCommonCode.FormatPhoneNumberGet(objProspect.PhoneOffice), objProspect.EMailID); } //if ((SortDirection)ViewState["SortProspect"] == SortDirection.Descending) //{ // tblProspect.DefaultView.Sort = "name desc"; //} //else //{ // tblProspect.DefaultView.Sort = "name asc"; //} dgProspects.Visible = true; tblProspect = tblProspect.DefaultView.ToTable(); dgProspects.DataSource = tblProspect; ViewState["DSGRID"] = tblProspect; dgProspects.DataBind(); //errordiv.Visible = false; } else { dgProspects.Visible = false; errordiv.Visible = true; errordiv.InnerHtml = (String)GetGlobalResourceObject("Resource", "msgNoRecordFound"); btnConvertHost.Enabled = false; btnDelete.Enabled = false; divGrdProspect.Visible = false; } }