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