public ActionResult Index(string seller, string search, string sortOrder, int arjPage = 1) { ViewBag.Notes = "active"; ViewBag.ARN = "active"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.SellerSortParm = sortOrder == "Seller" ? "Seller_desc" : "Seller"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.RejectBySortParm = sortOrder == "RejectBy" ? "RejectBy_desc" : "RejectBy"; ViewBag.RemarkSortParm = sortOrder == "Remark" ? "Remark_desc" : "Remark"; var Notes = db.SellerNotes.Where(x => x.IsActive == true && x.Status == 5).ToList(); ViewBag.Seller = Notes.Select(x => x.User1.FirstName).OrderBy(x => x).Distinct().ToList(); if (!String.IsNullOrEmpty(seller)) { Notes = Notes.Where(x => (x.User1.FirstName + " " + x.User1.LastName).Contains(seller)).ToList(); } if (!String.IsNullOrEmpty(search)) { Notes = Notes.Where(x => x.User1.FirstName.Contains(search) || x.User1.LastName.Contains(search) || x.Title.Contains(search) || x.NoteCategory.Name.Contains(search) || (x.User1.FirstName + " " + x.User1.LastName).Contains(search) || x.User.FirstName.Contains(search) || x.User.LastName.Contains(search) || (x.User.FirstName + " " + x.User.LastName).Contains(search) || x.AdminRemarks.Contains(search)).ToList(); } switch (sortOrder) { case "Title_desc": Notes = Notes.OrderByDescending(s => s.Title).ToList(); break; case "Title": Notes = Notes.OrderBy(s => s.Title).ToList(); break; case "Category_desc": Notes = Notes.OrderByDescending(s => s.NoteCategory.Name).ToList(); break; case "Category": Notes = Notes.OrderBy(s => s.NoteCategory.Name).ToList(); break; case "Seller_desc": Notes = Notes.OrderByDescending(s => s.User1.FirstName).ToList(); break; case "Seller": Notes = Notes.OrderBy(s => s.User1.FirstName).ToList(); break; case "Date_desc": Notes = Notes.OrderByDescending(s => s.ModifiedDate).ToList(); break; case "Date": Notes = Notes.OrderBy(s => s.ModifiedDate).ToList(); break; case "RejectBy_desc": Notes = Notes.OrderByDescending(s => s.User.FirstName).ToList(); break; case "RejectBy": Notes = Notes.OrderBy(s => s.User.FirstName).ToList(); break; case "Remark_desc": Notes = Notes.OrderByDescending(s => s.AdminRemarks).ToList(); break; case "Remark": Notes = Notes.OrderBy(s => s.AdminRemarks).ToList(); break; default: Notes = Notes.OrderByDescending(s => s.ModifiedDate).ToList(); break; } var pager = new ADPager(Notes.Count(), arjPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = arjPage; ViewBag.srno = arjPage; ViewBag.TotalAdminRJPage = Math.Ceiling(Notes.Count() / 5.0); Notes = Notes.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Notes)); }
public ActionResult Index(string search, string sortOrder, int amPage = 1) { ViewBag.Members = "active"; ViewBag.FNameSortParm = sortOrder == "FName" ? "FName_desc" : "FName"; ViewBag.LNameSortParm = sortOrder == "LName" ? "LName_desc" : "LName"; ViewBag.EmailSortParm = sortOrder == "Email" ? "Email_desc" : "Email"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.NURSortParm = sortOrder == "NUR" ? "NUR_desc" : "NUR"; ViewBag.PnSortParm = sortOrder == "Pn" ? "Pn_desc" : "Pn"; ViewBag.DnSortParm = sortOrder == "Dn" ? "Dn_desc" : "Dn"; ViewBag.TExpanseSortParm = sortOrder == "TExpanse" ? "TExpanse_desc" : "TExpanse"; ViewBag.TEarnSortParm = sortOrder == "TEarn" ? "TEarn_desc" : "TEarn"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); var Users = db.Users.Where(x => x.IsActive == true && x.RoleID == 1).ToList(); if (!String.IsNullOrEmpty(search)) { Users = Users.Where(x => x.FirstName.Contains(search) || x.LastName.Contains(search) || x.Email.Contains(search) || x.CreatedDate.ToString().Contains(search)).ToList(); } List <AdminMemberModel> list = new List <AdminMemberModel>(); foreach (var item in Users) { int tex, ter; int nur = db.SellerNotes.Where(x => x.IsActive == true && x.SellerID == item.ID && (x.Status == 2 || x.Status == 3)).Count(); int pn = db.SellerNotes.Where(x => x.IsActive == true && x.SellerID == item.ID && x.Status == 4).Count(); int dn = db.Downloads.Where(x => x.Downloader == item.ID && x.IsSellerHasAllowedDownload == true).Count(); var texList = db.Downloads.Where(x => x.Downloader == item.ID && x.IsSellerHasAllowedDownload == true).ToList(); if (texList == null) { tex = 0; } else { tex = (int)texList.Sum(x => x.PurchasedPrice); } var terList = db.Downloads.Where(x => x.Seller == item.ID && x.IsSellerHasAllowedDownload == true).ToList(); if (terList == null) { ter = 0; } else { ter = (int)terList.Sum(x => x.PurchasedPrice); } AdminMemberModel adminMember = new AdminMemberModel() { User = item, NoteUnderReview = nur, PublishedNote = pn, DownloadedNote = dn, TotalExpanses = tex, TotalEarning = ter }; list.Add(adminMember); } switch (sortOrder) { case "FName_desc": list = list.OrderByDescending(s => s.User.FirstName).ToList(); break; case "FName": list = list.OrderBy(s => s.User.FirstName).ToList(); break; case "LName_desc": list = list.OrderByDescending(s => s.User.LastName).ToList(); break; case "LName": list = list.OrderBy(s => s.User.LastName).ToList(); break; case "Email_desc": list = list.OrderByDescending(s => s.User.Email).ToList(); break; case "Email": list = list.OrderBy(s => s.User.Email).ToList(); break; case "Date_desc": list = list.OrderByDescending(s => s.User.CreatedDate).ToList(); break; case "Date": list = list.OrderBy(s => s.User.Email).ToList(); break; case "NUR_desc": list = list.OrderByDescending(s => s.NoteUnderReview).ToList(); break; case "NUR": list = list.OrderBy(s => s.NoteUnderReview).ToList(); break; case "Pn_desc": list = list.OrderByDescending(s => s.PublishedNote).ToList(); break; case "Pn": list = list.OrderBy(s => s.PublishedNote).ToList(); break; case "Dn_desc": list = list.OrderByDescending(s => s.DownloadedNote).ToList(); break; case "Dn": list = list.OrderBy(s => s.DownloadedNote).ToList(); break; case "TExpanse_desc": list = list.OrderByDescending(s => s.TotalExpanses).ToList(); break; case "TExpanse": list = list.OrderBy(s => s.TotalExpanses).ToList(); break; case "TEarn_desc": list = list.OrderByDescending(s => s.TotalEarning).ToList(); break; case "TEarn": list = list.OrderBy(s => s.TotalEarning).ToList(); break; default: list = list.OrderByDescending(s => s.User.CreatedDate).ToList(); break; } var pager = new ADPager(list.Count(), amPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = amPage; ViewBag.srno = amPage; ViewBag.TotalMemberPage = Math.Ceiling(list.Count() / 5.0); list = list.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(list)); }
public ActionResult MemberDetail(int id, string sortOrder, int mdPage = 1) { ViewBag.Members = "active"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); var Users = db.Users.Where(x => x.IsActive == true && x.ID == id).FirstOrDefault(); var UsersProfile = db.UserProfiles.Where(x => x.UserID == Users.ID).FirstOrDefault(); int c = Convert.ToInt32(UsersProfile.Country); var Country = db.Countries.Where(x => x.ID == c && x.IsActive == true).FirstOrDefault(); var Notes = db.SellerNotes.Where(x => x.IsActive == true && x.SellerID == Users.ID && (x.Status != 1)).ToList(); List <MemberNotes> list = new List <MemberNotes>(); foreach (var item in Notes) { int dn = db.Downloads.Where(x => x.NoteID == item.ID && x.IsSellerHasAllowedDownload == true && x.Seller == Users.ID).Count(); int te; var teList = db.Downloads.Where(x => x.NoteID == item.ID && x.IsSellerHasAllowedDownload == true && x.Seller == Users.ID).ToList(); if (teList == null) { te = 0; } else { te = (int)teList.Sum(x => x.PurchasedPrice); } MemberNotes members = new MemberNotes() { SellerNote = item, DownloadedNotes = dn, TotalEarning = te }; list.Add(members); } ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.StatusSortParm = sortOrder == "Status" ? "Status_desc" : "Status"; ViewBag.DnSortParm = sortOrder == "Dn" ? "Dn_desc" : "Dn"; ViewBag.TeSortParm = sortOrder == "Te" ? "Te_desc" : "Te"; ViewBag.ADateSortParm = sortOrder == "ADate" ? "ADate_desc" : "ADate"; ViewBag.PDateSortParm = sortOrder == "PDate" ? "PDate_desc" : "pDate"; switch (sortOrder) { case "Title_desc": list = list.OrderByDescending(s => s.SellerNote.Title).ToList(); break; case "Title": list = list.OrderBy(s => s.SellerNote.Title).ToList(); break; case "Category_desc": list = list.OrderByDescending(s => s.SellerNote.NoteCategory.Name).ToList(); break; case "Category": list = list.OrderBy(s => s.SellerNote.NoteCategory.Name).ToList(); break; case "Status_desc": list = list.OrderByDescending(s => s.SellerNote.ReferenceData.Value).ToList(); break; case "Status": list = list.OrderBy(s => s.SellerNote.ReferenceData.Value).ToList(); break; case "Dn_desc": list = list.OrderByDescending(s => s.DownloadedNotes).ToList(); break; case "Dn": list = list.OrderBy(s => s.DownloadedNotes).ToList(); break; case "Te_desc": list = list.OrderByDescending(s => s.TotalEarning).ToList(); break; case "Te": list = list.OrderBy(s => s.TotalEarning).ToList(); break; case "ADate_desc": list = list.OrderByDescending(s => s.SellerNote.CreatedDate).ToList(); break; case "ADate": list = list.OrderBy(s => s.SellerNote.CreatedDate).ToList(); break; case "PDate_desc": list = list.OrderByDescending(s => s.SellerNote.PublishedDate).ToList(); break; case "PDate": list = list.OrderBy(s => s.SellerNote.PublishedDate).ToList(); break; default: list = list.OrderBy(s => s.SellerNote.CreatedDate).ToList(); break; } var pager = new ADPager(list.Count(), mdPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = mdPage; ViewBag.srno = mdPage; ViewBag.TotalMemberDetailPage = Math.Ceiling(list.Count() / 5.0); list = list.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); MemberDetailModel member = new MemberDetailModel(); member.User = Users; member.UserProfile = UsersProfile; member.Notes = list; member.CountryName = Country == null ? "" :Country.Name; return(View(member)); }
public ActionResult Index(string search, string seller, string sortOrder, string Sid, int apnPage = 1) { ViewBag.Notes = "active"; ViewBag.APN = "active"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.SellTypeSortParm = sortOrder == "SellType" ? "SellType_desc" : "SellType"; ViewBag.PriceSortParm = sortOrder == "Price" ? "Price_desc" : "Price"; ViewBag.SellerSortParm = sortOrder == "Seller" ? "Seller_desc" : "Seller"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.ApproveBySortParm = sortOrder == "ApproveBy" ? "ApproveBy_desc" : "ApproveBy"; ViewBag.NoOfDownloadSortParm = sortOrder == "NoOfDownload" ? "NoOfDownload_desc" : "NoOfDownload"; var Notes = db.SellerNotes.Where(x => x.IsActive == true && x.Status == 4).ToList(); if (!String.IsNullOrEmpty(Sid)) { Notes = Notes.Where(x => x.SellerID == Convert.ToInt32(Sid)).ToList(); } ViewBag.Seller = Notes.Select(x => x.User1.FirstName).OrderBy(x => x).Distinct().ToList(); if (!String.IsNullOrEmpty(seller)) { Notes = Notes.Where(x => x.User1.FirstName.Contains(seller)).ToList(); } if (!String.IsNullOrEmpty(search)) { Notes = Notes.Where(x => x.User1.FirstName.Contains(search) || x.User1.LastName.Contains(search) || x.Title.Contains(search) || x.NoteCategory.Name.Contains(search) || x.ReferenceData.Value.Contains(search) || (x.User1.FirstName + " " + x.User1.LastName).Contains(search) || x.User.FirstName.Contains(search) || x.User.LastName.Contains(search) || (x.User.FirstName + " " + x.User.LastName).Contains(search)).ToList(); } switch (sortOrder) { case "Title_desc": Notes = Notes.OrderByDescending(s => s.Title).ToList(); break; case "Title": Notes = Notes.OrderBy(s => s.Title).ToList(); break; case "Category_desc": Notes = Notes.OrderByDescending(s => s.NoteCategory.Name).ToList(); break; case "Category": Notes = Notes.OrderBy(s => s.NoteCategory.Name).ToList(); break; case "SellType_desc": Notes = Notes.OrderByDescending(s => s.IsPaid).ToList(); break; case "SellType": Notes = Notes.OrderBy(s => s.IsPaid).ToList(); break; case "Price_desc": Notes = Notes.OrderByDescending(s => s.SellingPrice).ToList(); break; case "Price": Notes = Notes.OrderBy(s => s.SellingPrice).ToList(); break; case "Seller_desc": Notes = Notes.OrderByDescending(s => s.User1.FirstName).ToList(); break; case "Seller": Notes = Notes.OrderBy(s => s.User1.FirstName).ToList(); break; case "Date_desc": Notes = Notes.OrderByDescending(s => s.PublishedDate).ToList(); break; case "Date": Notes = Notes.OrderBy(s => s.PublishedDate).ToList(); break; case "ApproveBy_desc": Notes = Notes.OrderByDescending(s => s.User.FirstName).ToList(); break; case "ApproveBy": Notes = Notes.OrderBy(s => s.User.FirstName).ToList(); break; case "NoOfDownload_desc": Notes = Notes.OrderByDescending(x => x.Downloads.Where(s => s.IsSellerHasAllowedDownload == true).Count()).ToList(); break; case "NoOfDownload": Notes = Notes.OrderBy(x => x.Downloads.Where(s => s.IsSellerHasAllowedDownload == true).Count()).ToList(); break; default: Notes = Notes.OrderByDescending(s => s.PublishedDate).ToList(); break; } var pager = new ADPager(Notes.Count(), apnPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = apnPage; ViewBag.srno = apnPage; ViewBag.TotalAdminPNPage = Math.Ceiling(Notes.Count() / 5.0); Notes = Notes.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Notes)); }
public ActionResult Index(string search, string sortOrder, int mcPage = 1) { ViewBag.Setting = "active"; ViewBag.MCategory = "active"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.DescriptSortParm = sortOrder == "Descript" ? "Descript_desc" : "Descript"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.AddedBySortParm = sortOrder == "AddedBy" ? "AddedBy_desc" : "AddedBy"; ViewBag.ActiveSortParm = sortOrder == "Active" ? "Active_desc" : "Active"; var Category = db.NoteCategories.Select(x => x).ToList(); if (!String.IsNullOrEmpty(search)) { Category = Category.Where(x => x.Name.Contains(search) || x.Description.Contains(search) || x.CreatedDate.ToString().Contains(search) || (db.Users.Where(z => z.ID == x.CreatedBy).FirstOrDefault().FirstName + " " + db.Users.Where(z => z.ID == x.CreatedBy).FirstOrDefault().LastName).Contains(search)).ToList(); } switch (sortOrder) { case "Category_desc": Category = Category.OrderByDescending(s => s.Name).ToList(); break; case "Category": Category = Category.OrderBy(s => s.Name).ToList(); break; case "Descript_desc": Category = Category.OrderByDescending(s => s.Description).ToList(); break; case "Descript": Category = Category.OrderBy(s => s.Description).ToList(); break; case "AddedBy_desc": Category = Category.OrderByDescending(s => (db.Users.Where(x => x.ID == s.CreatedBy).FirstOrDefault().FirstName)).ToList(); break; case "AddedBy": Category = Category.OrderBy(s => (db.Users.Where(x => x.ID == s.CreatedBy).FirstOrDefault().FirstName)).ToList(); break; case "Active_desc": Category = Category.OrderByDescending(s => s.IsActive).ToList(); break; case "Active": Category = Category.OrderBy(s => s.IsActive).ToList(); break; case "Date_desc": Category = Category.OrderByDescending(s => s.CreatedDate).ToList(); break; case "Date": Category = Category.OrderBy(s => s.CreatedDate).ToList(); break; default: Category = Category.OrderByDescending(s => s.CreatedDate).ToList(); break; } var pager = new ADPager(Category.Count(), mcPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = mcPage; ViewBag.srno = mcPage; ViewBag.TotalCategoryPage = Math.Ceiling(Category.Count() / 5.0); Category = Category.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Category)); }
public ActionResult Index(string month, string search, string sortOrder, int adpage = 1) { ViewBag.Dashboard = "active"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); AdminDashboardModel adminDashboard = new AdminDashboardModel(); //InReview Note adminDashboard.InReview = db.SellerNotes.Where(x => x.IsActive == true && (x.Status == 2 || x.Status == 3)).Count(); //Last 7 day Download Note adminDashboard.Downlaod = db.Downloads.Where(x => x.ModifiedDate < DateTime.Now).ToList() .Where(x => x.ModifiedDate > DateTime.Now.AddDays(-7.0)).Count(); //Last 7 day Registration adminDashboard.SignUp = db.Users.Where(x => x.ModifiedDate < DateTime.Now).ToList() .Where(x => x.ModifiedDate > DateTime.Now.AddDays(-7.0)).Count(); DateTime dt = DateTime.Now; List <int> list = new List <int>(); list.Add(dt.Month); for (int i = 1; i < 6; i++) { list.Add(dt.Month - i <= 0 ? (dt.Month - i) + 12 : dt.Month - i); } ViewBag.MonthList = new List <SelectListItem> { new SelectListItem { Text = list[0].ToString(), Value = "0" }, new SelectListItem { Text = list[1].ToString(), Value = "1" }, new SelectListItem { Text = list[2].ToString(), Value = "2" }, new SelectListItem { Text = list[3].ToString(), Value = "3" }, new SelectListItem { Text = list[4].ToString(), Value = "4" }, new SelectListItem { Text = list[5].ToString(), Value = "5" } }; var Notes = db.SellerNotes.Where(x => x.IsActive == true && x.Status == 4).ToList(); if (!String.IsNullOrEmpty(search)) { Notes = Notes.Where(x => x.Title.Contains(search) || x.NoteCategory.Name.Contains(search) || (x.User1.FirstName + " " + x.User1.LastName).Contains(search) || x.User1.LastName.Contains(search) || x.User1.FirstName.Contains(search)).ToList(); } if (String.IsNullOrEmpty(month) || Convert.ToInt32(month) == 0) { dt = DateTime.Now; var firstDayOfMonth = new DateTime(dt.Year, dt.Month, 1); var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); Notes = Notes.Where(x => x.PublishedDate >= firstDayOfMonth && x.PublishedDate <= lastDayOfMonth).OrderByDescending(x => x.PublishedDate).ToList(); } else { DateTime PreviousMonth = DateTime.Now.AddMonths(-(Convert.ToInt32(month))); var firstDayOfPMonth = new DateTime(PreviousMonth.Year, PreviousMonth.Month, 1); var lastDayOfPMonth = new DateTime(PreviousMonth.Year, PreviousMonth.Month, DateTime.DaysInMonth(PreviousMonth.Year, PreviousMonth.Month)); Notes = Notes.Where(x => x.PublishedDate >= firstDayOfPMonth && x.PublishedDate <= lastDayOfPMonth).OrderByDescending(x => x.PublishedDate).ToList(); } ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.SellTypeSortParm = sortOrder == "SellType" ? "SellType_desc" : "SellType"; ViewBag.PriceSortParm = sortOrder == "Price" ? "Price_desc" : "Price"; ViewBag.PublisherSortParm = sortOrder == "Publisher" ? "Publisher_desc" : "Publisher"; ViewBag.NoOfDownloadSortParm = sortOrder == "NoOfDownload" ? "NoOfDownload_desc" : "NoOfDownload"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; switch (sortOrder) { case "Title_desc": Notes = Notes.OrderByDescending(s => s.Title).ToList(); break; case "Title": Notes = Notes.OrderBy(s => s.Title).ToList(); break; case "Category_desc": Notes = Notes.OrderByDescending(s => s.NoteCategory.Name).ToList(); break; case "Category": Notes = Notes.OrderBy(s => s.NoteCategory.Name).ToList(); break; case "SellType_desc": Notes = Notes.OrderByDescending(s => s.IsPaid).ToList(); break; case "SellType": Notes = Notes.OrderBy(s => s.IsPaid).ToList(); break; case "Price_desc": Notes = Notes.OrderByDescending(s => s.SellingPrice).ToList(); break; case "Price": Notes = Notes.OrderBy(s => s.SellingPrice).ToList(); break; case "Publisher_desc": Notes = Notes.OrderByDescending(s => s.User1.FirstName).ToList(); break; case "Publisher": Notes = Notes.OrderBy(s => s.User1.FirstName).ToList(); break; case "NoOfDownload_desc": Notes = Notes.OrderByDescending(x => x.Downloads.Where(s => s.IsSellerHasAllowedDownload == true).Count()).ToList(); break; case "NoOfDownload": Notes = Notes.OrderBy(x => x.Downloads.Where(s => s.IsSellerHasAllowedDownload == true).Count()).ToList(); break; case "Date_desc": Notes = Notes.OrderByDescending(s => s.PublishedDate).ToList(); break; case "Date": Notes = Notes.OrderBy(s => s.PublishedDate).ToList(); break; default: Notes = Notes.OrderByDescending(s => s.PublishedDate).ToList(); break; } var pager = new ADPager(Notes.Count(), adpage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = adpage; ViewBag.srno = adpage; ViewBag.TotalADPage = Math.Ceiling(Notes.Count() / 5.0); adminDashboard.SellerNotes = Notes.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(adminDashboard)); }
public ActionResult Index(string search, string sortOrder, string seller, string buyer, string note, string noteId, string Bid, int adlPage = 1) { ViewBag.Notes = "active"; ViewBag.ADN = "active"; ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.SellerSortParm = sortOrder == "Seller" ? "Seller_desc" : "Seller"; ViewBag.BuyerSortParm = sortOrder == "Buyer" ? "Buyer_desc" : "Buyer"; ViewBag.SellTypeSortParm = sortOrder == "SellType" ? "SellType_desc" : "SellType"; ViewBag.PriceSortParm = sortOrder == "Price" ? "Price_desc" : "Price"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); var Notes = db.Downloads.Where(x => x.IsSellerHasAllowedDownload == true).ToList(); if (!String.IsNullOrEmpty(Bid)) { Notes = Notes.Where(x => x.Downloader == Convert.ToInt32(Bid)).ToList(); } if (!String.IsNullOrEmpty(noteId)) { Notes = Notes.Where(x => x.NoteID == Convert.ToInt32(noteId)).ToList(); } ViewBag.Seller = Notes.Select(x => (x.User1.FirstName + " " + x.User1.LastName)).OrderBy(x => x).Distinct().ToList(); ViewBag.Buyer = Notes.Select(x => (x.User.FirstName + " " + x.User.LastName)).OrderBy(x => x).Distinct().ToList(); ViewBag.Note = Notes.Select(x => x.NoteTitle).OrderBy(x => x).Distinct().ToList(); if (seller != null) { Notes = Notes.Where(x => (x.User1.FirstName + " " + x.User1.LastName).Contains(seller)).ToList(); } if (buyer != null) { Notes = Notes.Where(x => (x.User.FirstName + " " + x.User.LastName).Contains(buyer)).ToList(); } if (note != null) { Notes = Notes.Where(x => x.NoteTitle.Contains(note)).ToList(); } if (search != null) { Notes = Notes.Where(x => x.NoteTitle.Contains(search) || x.NoteCategory.Contains(search) || x.User1.FirstName.Contains(search) || x.User1.LastName.Contains(search) || (x.User1.FirstName + " " + x.User1.LastName).Contains(search) || x.User.FirstName.Contains(search) || x.User.LastName.Contains(search) || (x.User.FirstName + " " + x.User.LastName).Contains(search) || x.PurchasedPrice.ToString().Contains(search) || x.IsPaid.ToString().Contains(search)).ToList(); } switch (sortOrder) { case "Title_desc": Notes = Notes.OrderByDescending(s => s.NoteTitle).ToList(); break; case "Title": Notes = Notes.OrderBy(s => s.NoteTitle).ToList(); break; case "Category_desc": Notes = Notes.OrderByDescending(s => s.NoteCategory).ToList(); break; case "Category": Notes = Notes.OrderBy(s => s.NoteCategory).ToList(); break; case "SellType_desc": Notes = Notes.OrderByDescending(s => s.IsPaid).ToList(); break; case "SellType": Notes = Notes.OrderBy(s => s.IsPaid).ToList(); break; case "Price_desc": Notes = Notes.OrderByDescending(s => s.PurchasedPrice).ToList(); break; case "Price": Notes = Notes.OrderBy(s => s.PurchasedPrice).ToList(); break; case "Seller_desc": Notes = Notes.OrderByDescending(s => s.User1.FirstName).ToList(); break; case "Seller": Notes = Notes.OrderBy(s => s.User1.FirstName).ToList(); break; case "Buyer_desc": Notes = Notes.OrderByDescending(s => s.User.FirstName).ToList(); break; case "Buyer": Notes = Notes.OrderBy(s => s.User.FirstName).ToList(); break; case "Date_desc": Notes = Notes.OrderByDescending(s => s.AttachmentDownloadedDate).ToList(); break; case "Date": Notes = Notes.OrderBy(s => s.AttachmentDownloadedDate).ToList(); break; default: Notes = Notes.OrderByDescending(s => s.AttachmentDownloadedDate).ToList(); break; } var pager = new ADPager(Notes.Count(), adlPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = adlPage; ViewBag.srno = adlPage; ViewBag.TotalAdminDLPage = Math.Ceiling(Notes.Count() / 5.0); Notes = Notes.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Notes)); }
public ActionResult Index(string search, string seller, string sortOrder, string Sid, int anurPage = 1) { ViewBag.Notes = "active"; ViewBag.ANUR = "active"; ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.SellerSortParm = sortOrder == "Seller" ? "Seller_desc" : "Seller"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.StatusSortParm = sortOrder == "Status" ? "Status_desc" : "Status"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); var Notes = db.SellerNotes.Where(x => x.IsActive == true && (x.Status == 2 || x.Status == 3)).ToList(); ViewBag.Seller = Notes.Select(x => x.User1.FirstName).OrderBy(x => x).Distinct().ToList(); if (!String.IsNullOrEmpty(Sid)) { Notes = Notes.Where(x => x.SellerID == Convert.ToInt32(Sid)).ToList(); } if (!String.IsNullOrEmpty(seller)) { Notes = Notes.Where(x => x.User1.FirstName.Contains(seller)).ToList(); } if (!String.IsNullOrEmpty(search)) { Notes = Notes.Where(x => x.User1.FirstName.Contains(search) || (x.User1.FirstName + " " + x.User1.LastName).Contains(search) || x.User1.LastName.Contains(search) || x.Title.Contains(search) || x.NoteCategory.Name.Contains(search) || x.ReferenceData.Value.Contains(search)).ToList(); } switch (sortOrder) { case "Title_desc": Notes = Notes.OrderByDescending(s => s.Title).ToList(); break; case "Title": Notes = Notes.OrderBy(s => s.Title).ToList(); break; case "Category_desc": Notes = Notes.OrderByDescending(s => s.NoteCategory.Name).ToList(); break; case "Category": Notes = Notes.OrderBy(s => s.NoteCategory.Name).ToList(); break; case "Seller_desc": Notes = Notes.OrderByDescending(s => s.User1.FirstName).ToList(); break; case "Seller": Notes = Notes.OrderBy(s => s.User1.FirstName).ToList(); break; case "Status_desc": Notes = Notes.OrderByDescending(s => s.ReferenceData.Value).ToList(); break; case "Status": Notes = Notes.OrderBy(s => s.ReferenceData.Value).ToList(); break; case "Date_desc": Notes = Notes.OrderByDescending(s => s.CreatedDate).ToList(); break; case "Date": Notes = Notes.OrderBy(s => s.CreatedDate).ToList(); break; default: Notes = Notes.OrderBy(s => s.CreatedDate).ToList(); break; } var pager = new ADPager(Notes.Count(), anurPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = anurPage; ViewBag.srno = anurPage; ViewBag.TotalAdminNURPage = Math.Ceiling(Notes.Count() / 5.0); Notes = Notes.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Notes)); }
public ActionResult Index(string search, string sortOrder, int maPage = 1) { var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); ViewBag.Setting = "active"; ViewBag.MAdmin = "active"; ViewBag.FNameSortParm = sortOrder == "FName" ? "FName_desc" : "FName"; ViewBag.LNameSortParm = sortOrder == "LName" ? "LName_desc" : "LName"; ViewBag.EmailSortParm = sortOrder == "Email" ? "Email_desc" : "Email"; ViewBag.PhoneSortParm = sortOrder == "Phone" ? "Phone_desc" : "Phone"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.ActiveSortParm = sortOrder == "Active" ? "Active_desc" : "Active"; var Admin = db.Users.Where(x => x.RoleID == 2).ToList(); if (!String.IsNullOrEmpty(search)) { Admin = Admin.Where(x => x.FirstName.Contains(search) || x.LastName.Contains(search) || x.Email.Contains(search) || x.CreatedDate.ToString().Contains(search) || db.UserProfiles.Where(s => s.UserID == x.ID).FirstOrDefault().PhoneNumber.Contains(search)).ToList(); } switch (sortOrder) { case "FName_desc": Admin = Admin.OrderByDescending(s => s.FirstName).ToList(); break; case "FName": Admin = Admin.OrderBy(s => s.FirstName).ToList(); break; case "LName_desc": Admin = Admin.OrderByDescending(s => s.LastName).ToList(); break; case "LName": Admin = Admin.OrderBy(s => s.LastName).ToList(); break; case "Email_desc": Admin = Admin.OrderByDescending(s => s.Email).ToList(); break; case "Email": Admin = Admin.OrderBy(s => s.Email).ToList(); break; case "Phone_desc": Admin = Admin.OrderByDescending(x => (db.UserProfiles.Where(s => s.UserID == x.ID).FirstOrDefault().PhoneNumber)).ToList(); break; case "Phone": Admin = Admin.OrderBy(x => (db.UserProfiles.Where(s => s.UserID == x.ID).FirstOrDefault().PhoneNumber)).ToList(); break; case "Active_desc": Admin = Admin.OrderByDescending(s => s.IsActive).ToList(); break; case "Active": Admin = Admin.OrderBy(s => s.IsActive).ToList(); break; case "Date_desc": Admin = Admin.OrderByDescending(s => s.CreatedDate).ToList(); break; case "Date": Admin = Admin.OrderBy(s => s.CreatedDate).ToList(); break; default: Admin = Admin.OrderByDescending(s => s.CreatedDate).ToList(); break; } var pager = new ADPager(Admin.Count(), maPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = maPage; ViewBag.srno = maPage; ViewBag.TotalAdminPage = Math.Ceiling(Admin.Count() / 5.0); Admin = Admin.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Admin)); }
public ActionResult Index(string search, string sortOrder, int srPage = 1) { ViewBag.Reports = "active"; ViewBag.SpamReport = "active"; ViewBag.RBySortParm = sortOrder == "RBy" ? "RBy_desc" : "RBy"; ViewBag.TitleSortParm = sortOrder == "Title" ? "Title_desc" : "Title"; ViewBag.CategorySortParm = sortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date"; ViewBag.RemarkSortParm = sortOrder == "Remark" ? "Remark_desc" : "Remark"; var user = db.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault(); var Spam = db.SellerNotesReportedIssues.Where(x => x.SellerNote.Status == 4).ToList(); if (!String.IsNullOrEmpty(search)) { Spam = Spam.Where(x => (x.User.FirstName + " " + x.User.LastName).Contains(search) || x.SellerNote.Title.Contains(search) || x.SellerNote.NoteCategory.Name.Contains(search) || x.CreatedDate.ToString().Contains(search) || x.Remarks.Contains(search)).ToList(); } switch (sortOrder) { case "Title_desc": Spam = Spam.OrderByDescending(x => x.SellerNote.Title).ToList(); break; case "Title": Spam = Spam.OrderBy(x => x.SellerNote.Title).ToList(); break; case "Category_desc": Spam = Spam.OrderByDescending(x => x.SellerNote.NoteCategory.Name).ToList(); break; case "Category": Spam = Spam.OrderBy(x => x.SellerNote.NoteCategory.Name).ToList(); break; case "Date_desc": Spam = Spam.OrderByDescending(x => x.CreatedDate).ToList(); break; case "Date": Spam = Spam.OrderBy(x => x.CreatedDate).ToList(); break; case "RBy_desc": Spam = Spam.OrderByDescending(x => x.User.FirstName).ToList(); break; case "RBy": Spam = Spam.OrderBy(x => x.User.FirstName).ToList(); break; case "Remark_desc": Spam = Spam.OrderByDescending(x => x.Remarks).ToList(); break; case "Remark": Spam = Spam.OrderBy(x => x.Remarks).ToList(); break; default: Spam = Spam.OrderByDescending(x => x.CreatedDate).ToList(); break; } var pager = new ADPager(Spam.Count(), srPage); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.pageNumber = srPage; ViewBag.srno = srPage; ViewBag.TotalSpamReportPage = Math.Ceiling(Spam.Count() / 5.0); Spam = Spam.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize).ToList(); return(View(Spam)); }