Exemplo n.º 1
0
        public JsonResult GetAllLists()
        {
            //string LoginUser = (string)Session["LoginSAPID"];
            try
            {
                string userkey = ConfigurationManager.AppSettings["userkey"];
                string uid     = ConfigurationManager.AppSettings["uid"];

                TNS.TNS   tns = new TNS.TNS();
                DataTable dt  = tns.FetchAllList("", userkey, uid);
                dt.TableName = "FetchLists";
                dt.Columns.ToString();

                var lists = (from DataRow dr in dt.Rows
                             select new
                {
                    ID = dr["ID"].ToString(),
                    Listname = dr["Listname"].ToString(),
                    Listtype = dr["Listtype"].ToString(),
                }).ToList();
                return(Json(new { data = lists }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                //LogError logerror = new LogError();
                //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0);
                return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
            }
        }
Exemplo n.º 2
0
        public ActionResult Index()
        {
            string userkey = ConfigurationManager.AppSettings["userkey"];
            string uid     = ConfigurationManager.AppSettings["uid"];

            TNS.TNS   tns = new TNS.TNS();
            DataTable dt  = tns.FetchAllList("", userkey, uid);

            dt.TableName = "FetchList";
            dt.Columns.ToString();

            // var listCreated = tns.CreateListContent(LoginUser, "1", "OyeTunji", "Adelana", "*****@*****.**", "Stanbic IBTC", "Software Arc", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid);

            return(View());
        }
Exemplo n.º 3
0
        public JsonResult GetLists([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, String RequestId)
        {
            string userkey = ConfigurationManager.AppSettings["userkey"];
            string uid     = ConfigurationManager.AppSettings["uid"];

            //string LoginUser = (string)Session["LoginSAPID"];

            try
            {
                TNS.TNS   tns = new TNS.TNS();
                DataTable dt  = tns.FetchAllList("", userkey, uid);
                dt.TableName = "FetchLists";
                dt.Columns.ToString();

                List <ContactLists> contactLists = new List <ContactLists>();
                int startRec = requestModel.Start;
                int pageSize = requestModel.Length;


                List <ContactLists> listsCount = (from DataRow dr in dt.Rows
                                                  select new ContactLists()
                {
                    ID = dr["ID"].ToString()
                }).ToList();

                contactLists = (from DataRow dr in dt.Rows
                                orderby dr["ID"] descending
                                select new ContactLists()
                {
                    ID = dr["ID"].ToString(),
                    Listname = dr["Listname"].ToString(),
                    Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"),
                    CreatedBy = dr["CreatedBy"].ToString()
                }).Skip(startRec).Take(pageSize).ToList();

                var totalCount    = listsCount.Count();
                var filteredCount = contactLists.Count();

                if (requestModel.Search.Value != string.Empty)
                {
                    var value = requestModel.Search.Value.Trim();

                    listsCount = (from DataRow dr in dt.Rows
                                  where dr["Listname"].ToString().Contains(value)
                                  select new ContactLists()
                    {
                        ID = dr["ID"].ToString()
                    }).ToList();

                    contactLists = (from DataRow dr in dt.Rows
                                    orderby dr["ID"] descending
                                    where dr["Listname"].ToString().Contains(value)
                                    select new ContactLists()
                    {
                        ID = dr["ID"].ToString(),
                        Listname = dr["Listname"].ToString(),
                        Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"),
                        CreatedBy = dr["CreatedBy"].ToString()
                    }).Skip(startRec).Take(pageSize).ToList();

                    totalCount    = listsCount.Count();
                    filteredCount = contactLists.Count();
                }

                var sortedColumns = requestModel.Columns.GetSortedColumns();
                var orderByString = String.Empty;

                foreach (var column in sortedColumns)
                {
                    orderByString += orderByString != String.Empty ? "," : "";
                    orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
                }

                var data = contactLists.Select(emList => new
                {
                    ID          = emList.ID,
                    Listname    = emList.Listname,
                    Datecreated = emList.Datecreated,
                    CreatedBy   = emList.CreatedBy
                }).ToList();

                return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                //LogError logerror = new LogError();
                //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0);
                return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
            }
        }