public JsonResult DepartmentDropDownFill()
{
try
{
int statusCode = 1;
BlPopulate blpopulate = new BlPopulate();
blpopulate.TableName = "Department";
blpopulate.ListFields = "DepName";
blpopulate.ValueFields = "ID_Department";
blpopulate.SortFields = "DepName,ID_Department";
blpopulate.Criteria = "Cancelled=0 AND Active=1 AND FK_Company= " + Session["ID_Company"].ToString();
DataTable dt = new DataTable();
dt = blpopulate.PopulateData();
return(Json(Converttojson(dt), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
///
return(Json(ex));
}
}
public JsonResult ProductDropDownFill()
{
try
{
int statusCode = 1;
BlPopulate blpopulate = new BlPopulate();
blpopulate.TableName = "Product P LEFT JOIN ClientDetails CD ON CD.FK_Product=P.ID_Product LEFT JOIN Client C ON C.ID_Client=CD.FK_Client LEFT JOIN Users U ON U.FK_Client=C.ID_Client";
blpopulate.ListFields = "P.ProdName";
blpopulate.ValueFields = "P.ID_Product";
blpopulate.SortFields = "P.ProdName,P.ID_Product";
blpopulate.Criteria = "U.Cancelled=0 AND P.Cancelled=0 AND CD.Cancelled=0 AND P.Active=1 AND C.Cancelled=0 AND U.ID_Users=" + Session["ID_Users"].ToString() + " AND U.FK_Company=" + Session["ID_Company"].ToString();
DataTable dt = new DataTable();
dt = blpopulate.PopulateData();
return(Json(Converttojson(dt), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
///
return(Json(ex));
}
}
public JsonResult FillMenu()
{
BlMenu ObjBlmenu = new BlMenu();
ObjBlmenu.UserCode = Convert.ToInt64(Session["ID_Agent"]);
ObjBlmenu.FK_Company = Convert.ToInt64(Session["ID_Company"]);
BlPopulate populate = new BlPopulate();
//dtblModules = ObjBlmenu.FillModules();
DataSet ds = new DataSet();
ds = ObjBlmenu.FillPages();
DataTable dtblPages = ds.Tables[0];
DataTable dtblAgent = ds.Tables[1];
DataTable dtblNotification = ds.Tables[2];
string strHtml = "", strNotiHtml = "", color = "", pageurl = "";
Int32 Count = 0;
strHtml = "<li class='header'>MAIN NAVIGATION</li>";
if (dtblPages.Rows.Count > 0)
{
ArrayList arr = new ArrayList();
for (int i = 0; i < dtblPages.Rows.Count; i++)
{
ObjBlmenu.UserCode = Convert.ToInt64(Session["ID_Agent"]);
ObjBlmenu.FK_Company = Convert.ToInt64(Session["ID_Company"]);
ObjBlmenu.ID_PageModule = Convert.ToInt32(dtblPages.Rows[i][0].ToString());
if ((!arr.Contains(dtblPages.Rows[i][0].ToString()) && i != 0))
{
strHtml = strHtml + "</ul>";
strHtml = strHtml + "</li>";
}
if (!arr.Contains(dtblPages.Rows[i][0].ToString()))
{
arr.Add(dtblPages.Rows[i][0].ToString());
strHtml = strHtml + " <li class='treeview'><a href='#'><i class='fa fa-" + dtblPages.Rows[i][2].ToString() + "'></i><span>" + dtblPages.Rows[i][1].ToString() + "</span><i class='fa fa-angle-left pull-right'></i></a>";
strHtml = strHtml + "<ul class='treeview-menu'>";
}
//String ClientURL = Page.ResolveClientUrl("~/HomePage.aspx");
string Ticketpendingcount = "";
if (Convert.ToInt32(dtblNotification.Rows[0]["Tasks"]) > 0)
{
Ticketpendingcount += "<span class='pull-right-container'>";
if (dtblPages.Rows[i][3].ToString() == "Tickets")
{
Ticketpendingcount += "<small class='label pull-right bg-green'>" + Convert.ToInt32(dtblNotification.Rows[0]["Tasks"]) + "</small>";
}
}
if (Convert.ToInt32(dtblNotification.Rows[0]["OverDueCount"]) > 0)
{
if (dtblPages.Rows[i][3].ToString() == "Tickets")
{
if (Ticketpendingcount == "")
{
Ticketpendingcount += "<span class='pull-right-container'>";
}
Ticketpendingcount += "<small class='label pull-right bg-red'>" + Convert.ToInt32(dtblNotification.Rows[0]["OverDueCount"]) + "</small>";
}
Ticketpendingcount += "</span>";
}
string Status = "";
if (dtblPages.Rows[i][3].ToString() == "Tickets")
{
Status = "?Status=0";
}
strHtml = strHtml + "<li><a href=../" + dtblPages.Rows[i][4].ToString() + "/" + dtblPages.Rows[i][5].ToString() + Status + "><i class='fa fa-circle-o text-aqua'></i>" + Ticketpendingcount + dtblPages.Rows[i][3].ToString() + "</a></li>";
if (i == dtblPages.Rows.Count - 1)
{
strHtml = strHtml + "</ul>";
strHtml = strHtml + "</li>";
}
}
}
strNotiHtml = strNotiHtml + "<a href='#' class='dropdown-toggle' data-toggle='dropdown'><i class='fa fa-flag-o'></i><span class='label label-danger'>" + Convert.ToInt32(dtblNotification.Rows[0]["Tasks"]) + "</span></a>";
strNotiHtml = strNotiHtml + "<ul class='dropdown-menu'><li class='header'>You have " + Convert.ToInt32(dtblNotification.Rows[0]["Tasks"]) + " tasks</li><li><ul class='menu'>";
if (dtblNotification.Rows.Count > 0)
{
for (int j = 1; j < 5; j++)
{
if (dtblNotification.Columns[j].ColumnName == "Pendingjobs")
{
color = "green";
pageurl = "/Tickets/Tickets?Status=-1";
}
else if (dtblNotification.Columns[j].ColumnName == "OpenTickets")
{
color = "aqua";
pageurl = "/Tickets/Tickets?Status=1";
}
else if (dtblNotification.Columns[j].ColumnName == "ResolvedTickets")
{
color = "yellow";
pageurl = "/Tickets/Tickets?Status=2";
}
else if (dtblNotification.Columns[j].ColumnName == "OverDue")
{
color = "red";
pageurl = "#";
}
else
{
color = "yellow";
}
Count = Convert.ToInt32(dtblNotification.Rows[0][dtblNotification.Columns[j].ColumnName]);
strNotiHtml = strNotiHtml + "<li><a href=" + pageurl + "><h3>" + dtblNotification.Columns[j].ColumnName + "<small class='pull-right'>" + Count + "%";
strNotiHtml = strNotiHtml + "</small></h3><div class='progress xs'><div class='progress-bar progress-bar-" + color + "' style='width:" + Count +
"%' role='progressbar' aria-valuenow='20' aria-valuemin='0' aria-valuemax='100'>";
strNotiHtml = strNotiHtml + "<span class='sr-only'>20% Complete</span></div></div></a></li>";
}
}
strNotiHtml = strNotiHtml + "</ul></li><li class='footer'><a href='../Tickets/Tickets'>View all tasks</a></li></ul>";
strNotiHtml = "";
ObjBlmenu = null;
return(Json(new { statusCode = "" + strHtml + "", Notification = "" + strNotiHtml + "", statusCodeAgent = "" + dtblAgent.Rows[0]["AgentName"].ToString() + "", table = "" + Converttojson(dtblAgent) + "" }, JsonRequestBehavior.AllowGet));
}
