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)); }