private void FillRepeaterActivityDay(bool my)
{
DateTime fromToday = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0, 0);
DateTime today = fromToday.AddMinutes(1439);
DataTable dtA;
string fromDate = UC.LTZ.ToUniversalTime(fromToday).ToString(@"yyyyMMdd HH:mm:ss").Replace('.', ':');
string toDate = UC.LTZ.ToUniversalTime(today).ToString(@"yyyyMMdd HH:mm:ss").Replace('.', ':');
string tempQuery = String.Format("(ACTIVITYDATE BETWEEN '{0}' AND '{1}')", fromDate, toDate);
Trace.Warn("actoday", "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE TODO=0 AND (" + tempQuery + ") AND ((" + GroupsSecure() + ") OR OWNERID=" + UC.UserId + ") ORDER BY ACTIVITYDATE");
if (my)
{
dtA = DatabaseConnection.CreateDataset("SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE TODO=0 AND (" + tempQuery + ") AND ((" + GroupsSecure() + ") OR OWNERID=" + UC.UserId + ") ORDER BY ACTIVITYDATE").Tables[0];
}
else
{
dtA = DatabaseConnection.CreateDataset("SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE TODO=0 AND (" + tempQuery + ") AND (OWNERID=" + UC.UserId + ") ORDER BY ACTIVITYDATE").Tables[0];
}
if (dtA.Rows.Count > 0)
{
RepeaterActivityDay.DataSource = dtA;
RepeaterActivityDay.DataBind();
LitRepeaterActivityDayInfo.Visible = false;
}
else
{
LitRepeaterActivityDayInfo.Text = Root.rm.GetString("Acttxt40");
LitRepeaterActivityDayInfo.Visible = true;
RepeaterActivityDay.Visible = false;
}
}
private void FillRepeaterActivityLost(bool onlyMy)
{
DateTime today = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
DataTable dtA = new DataTable();
if (!onlyMy)
{
dtA = DatabaseConnection.CreateDataset("SELECT TOP 10 * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE TODO=0 AND ACTIVITYDATE< '" + UC.LTZ.ToUniversalTime(today).ToString(@"yyyyMMdd HH.mm.ss").Replace('.', ':') + "' AND ((" + GroupsSecure() + ") OR OWNERID=" + UC.UserId + ") ORDER BY ACTIVITYDATE").Tables[0];
}
else
{
dtA = DatabaseConnection.CreateDataset("SELECT TOP 10 * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE TODO=0 AND ACTIVITYDATE< '" + UC.LTZ.ToUniversalTime(today).ToString(@"yyyyMMdd HH.mm.ss").Replace('.', ':') + "' AND (OWNERID=" + UC.UserId + ") ORDER BY ACTIVITYDATE").Tables[0];
}
if (dtA.Rows.Count > 0)
{
RepeaterActivityDay.DataSource = dtA;
RepeaterActivityDay.DataBind();
LitRepeaterActivityDayInfo.Visible = false;
}
else
{
LitRepeaterActivityDayInfo.Text = Root.rm.GetString("Acttxt40");
LitRepeaterActivityDayInfo.Visible = true;
RepeaterActivityDay.Visible = false;
}
}
private void FillRepeaterActivityDayFromSearch(string contactID, string order)
{
string query = string.Empty;
switch (contactID.Substring(0, 1))
{
case "C":
if (Request["oppID"] != null && Request["oppID"].Length > 0)
{
query = "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE OPPORTUNITYID=" + Request["oppID"] + " AND REFERRERID=" + contactID.Substring(1) + " ORDER BY " + order + " DESC";
}
else
{
query = "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE REFERRERID=" + contactID.Substring(1) + " ORDER BY " + order + " DESC";
}
break;
case "L":
if (Request["oppID"] != null && Request["oppID"].Length > 0)
{
query = "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE OPPORTUNITYID=" + Request["oppID"] + " AND LEADID=" + contactID.Substring(1) + " ORDER BY " + order + " DESC";
}
else
{
query = "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE LEADID=" + contactID.Substring(1) + " ORDER BY " + order + " DESC";
}
break;
case "A":
if (Request["oppID"] != null && Request["oppID"].Length > 0)
{
query = "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE OPPORTUNITYID=" + Request["oppID"] + " AND COMPANYID=" + contactID.Substring(1) + " ORDER BY " + order + " DESC";
}
else
{
query = "SELECT * FROM CRM_WORKACTIVITYSEARCH_VIEW WHERE COMPANYID=" + contactID.Substring(1) + " ORDER BY " + order + " DESC";
}
break;
}
DataTable dtA = DatabaseConnection.CreateDataset(query).Tables[0];
if (dtA.Rows.Count > 0)
{
RepeaterActivityDay.DataSource = dtA;
RepeaterActivityDay.DataBind();
LitRepeaterActivityDayInfo.Visible = false;
RepeaterActivityDay.Visible = true;
}
else
{
LitRepeaterActivityDayInfo.Text = Root.rm.GetString("Acttxt40");
LitRepeaterActivityDayInfo.Visible = true;
RepeaterActivityDay.Visible = false;
}
}
private void FillRepeaterActivityDay(bool my)
{
DataTable dtA = ActivityToday(my);
RepeaterActivityDay.DataSource = dtA;
RepeaterActivityDay.DataBind();
if (RepeaterActivityDay.Items.Count > 0)
{
AttInDay.Visible = true;
}
else
{
AttInDay.Visible = false;
}
}
