protected void rgActionItem_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
objBLL = new MetisBLL();
DataTable dt = new DataTable();
if (chkbArchive.Checked)
{
dt = objBLL.getAllArchiveActionItem();
}
else
{
dt = objBLL.getAllActionItem();
}
DataView dv = new DataView(dt);
dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
rgActionItem.DataSource = dv;
}
protected void btnEmail_Click(object sender, ImageClickEventArgs e)
{
objBLL = new MetisBLL();
DataTable dtActionItem = new DataTable();
DataTable dtDistinctResourceEmail = new DataTable();
if (chkbArchive.Checked)
{
dtActionItem = objBLL.getAllArchiveActionItem();
}
else
{
dtActionItem = objBLL.getAllActionItem();
}
dtDistinctResourceEmail = objBLL.getAllActionItemsResourceEmail(); // get distinct email
DataView dv = new DataView(dtActionItem);
DataView dv2 = new DataView(dtDistinctResourceEmail);
GridColumn gridResourceColumn = rgActionItem.MasterTableView.GetColumnSafe("Resource_name");
GridColumn gridActionItemColumn = rgActionItem.MasterTableView.GetColumnSafe("ActionItem");
dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'" +
" AND Resource_name like '%" + (gridResourceColumn.CurrentFilterValue.ToString().Replace("'", "''") == String.Empty ? "" : gridResourceColumn.CurrentFilterValue.ToString().Replace("'", "''")) + "%'" +
" AND Action_Item like '%" + (gridActionItemColumn.CurrentFilterValue.ToString().Replace("'", "''") == String.Empty ? "" : gridActionItemColumn.CurrentFilterValue.ToString().Replace("'", "''")) + "%'";
dv2.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
//Storing ResourceName and Email in Dictionary
mapDataTableToDictionary(dv2);
/// loop through DV (DataView) and transform datarows to html Table
foreach (DataRowView drv in dv)
{
transformRowsToHTMLTable(drv);
}
string cc = ConfigurationSettings.AppSettings["ActionItemsCC"];
string from = ConfigurationSettings.AppSettings["ActionItemsFrom"];
string replyto = ConfigurationSettings.AppSettings["ActionItemsReplyto"];
for (int i = 0; i < emailBodyList.Count; i++)
{
SendMail("smtp.gmail.com", from, emailBodyList.ElementAt(i).Key + "@streebo.com", cc, replyto, "<b>To do List</b><br/>" + emailBodyList.ElementAt(i).Value + "</table>", "Your Action Items", true);
}
}
//protected void Page_Load(object sender, EventArgs e)
//{
// if (!IsPostBack)
// {
// objBLL = new MetisBLL();
// DataTable dt = objBLL.getDeparments();
// ddlDepartment.DataSource = dt;
// ddlDepartment.DataTextField = dt.Columns[1].ToString();
// ddlDepartment.DataValueField = dt.Columns[0].ToString();
// ddlDepartment.DataBind();
// ddlDepartment.SelectedValue = "dpt_02";
// dt = new DataTable();
// dt = objBLL.getAllActionItem();
// DataView dv = new DataView(dt);
// dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
// rgActionItem.DataSource = dv;
// rgActionItem.DataBind();
// dt = new DataTable();
// dt = objBLL.getAllUpComingProject();
// dv = new DataView(dt);
// dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
// rgUpComingProject.DataSource = dv;
// }
//}
protected void Page_Load(object sender, EventArgs e)
{
//int x = Convert.ToInt32(Session["isLogin"]);
//if (x == 0)
// RFSs.Visible = false;
//else
// RFSs.Visible = true;
if (!IsPostBack)
{
#region Check Login
if (Convert.ToString(Session["user"]) == "")
{
Response.Redirect("Login.aspx");
}
#endregion
#region Check Rights
b_CanView = false;
objBLL = new MetisBLL();
System.Data.DataTable dt = objBLL.getAccessRights(Convert.ToString(Session["user"]));
foreach (System.Data.DataRow row in dt.Rows)
{
if (row["EntityName"].ToString() == "UpcomingProj")
{
b_CanView = Convert.ToBoolean(row["Can_View"]);
}
}
// If Admin thn bypass security
if (b_CanView == false)
{
objBLL = new MetisBLL();
if (Convert.ToBoolean(objBLL.IsAdmin(Convert.ToString(Session["user"]))))
{
b_CanView = true;
}
}
#endregion
if (b_CanView)
{
objBLL = new MetisBLL();
dt = depManager.getDeparments();
ddlDepartment.DataSource = dt;
ddlDepartment.DataTextField = dt.Columns[1].ToString();
ddlDepartment.DataValueField = dt.Columns[0].ToString();
ddlDepartment.DataBind();
ddlDepartment.SelectedValue = "dpt_01"; // IM - SSL By Default
if (Session["ddlDepartment"] != null)
{
ddlDepartment.SelectedValue = Session["ddlDepartment"].ToString();
}
Session["ddlDepartment"] = ddlDepartment.SelectedValue;
dt = new DataTable();
dt = objBLL.getAllActionItem();
DataView dv = new DataView(dt);
dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
rgActionItem.DataSource = dv;
rgActionItem.DataBind();
dt = new DataTable();
dt = objBLL.getAllUpComingProject();
dv = new DataView(dt);
dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
rgUpComingProject.DataSource = dv;
}
else
{
main.Visible = false;
lblErr.Text = "403 Forbidden";
}
}
}
