void FillGridTodays_Activity() { if ((string)Session["AdminSessionID"] != null) { SqlDataAdapter GDA = new SqlDataAdapter(" " + " select Code, NextADate=convert(varchar(11),NextActionDate,105), ActionTime " + " ,Activity=isnull((select Name from fp_combodetail where Code=am.Activity),'No Activity') " + " ,ActivityCode=isnull(Activity,-1) " + " ,ClientName=(select Name from fp_prospects where Code=am.ClientCode ) " + " ,ClientPhone = (select Mobile1 from fp_prospects where Code=am.ClientCode ) " + " ,ClientEmail = (select Email1 from fp_prospects where Code=am.ClientCode ) " + " ,AMStatus=isnull(AMStatus,'Open') " + " from fp_ActivityMonitor am " + " where PlannerCode=(select code from fp_Planner where userid='" + ViewState["xUserID"] + "') " + " and NextActionDate between dateadd(dd,-3,getdate()) and getdate()+1 order by NextActionDate desc " + " ", Con); DataSet GDS = new DataSet(); Con.Open(); GDA.Fill(GDS); Con.Close(); GVToDaysActivity.DataSource = GDS; GVToDaysActivity.DataBind(); } else { Response.Redirect("SessionExpired.aspx"); } }
protected void btnActivitySearch_Click(object sender, System.EventArgs e) { if ((string)Session["AdminSessionID"] != null) { String xADate = searchDate.Text; xADate = "'" + xADate.Substring(6, 4) + '-' + xADate.Substring(3, 2) + '-' + xADate.Substring(0, 2) + "'"; SqlDataAdapter GDA = new SqlDataAdapter(" " + " select Code, NextADate=convert(varchar(11),NextActionDate,105), ActionTime " + " ,Activity=isnull((select Name from fp_combodetail where Code=am.Activity),'No Activity') " + " ,ActivityCode=isnull(Activity,-1) " + " ,ClientName=(select Name from fp_prospects where Code=am.ClientCode ) " + " ,ClientPhone = (select Mobile1 from fp_prospects where Code=am.ClientCode ) " + " ,ClientEmail = (select Email1 from fp_prospects where Code=am.ClientCode ) " + " ,AMStatus=isnull(AMStatus,'Open') " + " from fp_ActivityMonitor am " + " where PlannerCode=(select code from fp_Planner where userid='" + ViewState["xUserID"] + "') " + " and NextActionDate=" + xADate + " order by NextActionDate desc " + " ", Con); DataSet GDS = new DataSet(); Con.Open(); GDA.Fill(GDS); Con.Close(); GVToDaysActivity.DataSource = GDS; GVToDaysActivity.DataBind(); } else { Response.Redirect("SessionExpired.aspx"); } }