Example #1
0
 private void FillRepTask(string sqlstring, string sqlstring2)
 {
     RepTask.DataSource = DatabaseConnection.CreateDataset(sqlstring);
     RepTask.DataBind();
     if (RepTask.Items.Count == 0)
     {
         RepeaterInfo.Text    = Root.rm.GetString("CRMTodtxt6");
         RepeaterInfo.Visible = true;
         RepTask.Visible      = false;
     }
     RepTask2.DataSource = DatabaseConnection.CreateDataset(sqlstring2);
     RepTask2.DataBind();
     if (RepTask2.Items.Count == 0)
     {
         RepeaterInfo2.Text    = Root.rm.GetString("CRMTodtxt6");
         RepeaterInfo2.Visible = true;
         RepTask2.Visible      = false;
     }
     Session["TaskFromFind"] = 1;
 }
Example #2
0
 private void FillRepTask()
 {
     RepTask.DataSource = DatabaseConnection.CreateDataset("SELECT * FROM CRM_TODOLIST_VIEW WHERE (EXPIRATIONDATE>='" + UC.LTZ.ToUniversalTime(DateTime.Now).ToString(@"yyyyMMdd") + "' OR (EXPIRATIONDATE<'" + UC.LTZ.ToUniversalTime(DateTime.Now).ToString(@"yyyyMMdd") + "' AND FLAGEXECUTED=0)) AND OWNERID=" + UC.UserId + " ORDER BY EXPIRATIONDATE ASC;");
     RepTask.DataBind();
     if (RepTask.Items.Count == 0)
     {
         RepeaterInfo.Text    = Root.rm.GetString("CRMTodtxt6");
         RepeaterInfo.Visible = true;
         RepTask.Visible      = false;
     }
     RepTask2.DataSource = DatabaseConnection.CreateDataset("SELECT * FROM CRM_TODOLIST_VIEW WHERE (EXPIRATIONDATE>='" + UC.LTZ.ToUniversalTime(DateTime.Now).ToString(@"yyyyMMdd") + "' OR (Expirationdate<'" + UC.LTZ.ToUniversalTime(DateTime.Now).ToString(@"yyyyMMdd") + "' AND FLAGEXECUTED=0)) AND (CREATEDBYID=" + UC.UserId + " AND OWNERID<>" + UC.UserId + ") ORDER BY EXPIRATIONDATE ASC;");
     RepTask2.DataBind();
     if (RepTask2.Items.Count == 0)
     {
         RepeaterInfo2.Text    = Root.rm.GetString("CRMTodtxt6");
         RepeaterInfo2.Visible = true;
         RepTask2.Visible      = false;
     }
     Session["TaskFromFind"] = null;
 }