public ActionResult Index(string result) { GymProcessEntities1 db = new GymProcessEntities1(); result = (Convert.ToString(Session["userId"])); ViewBag.resultquery = db.sp_getUserDetail(result).FirstOrDefault(); if (User.Identity.IsAuthenticated) { var user = User.Identity; ViewBag.Name = user.Name; // ApplicationDbContext context = new ApplicationDbContext(); // var UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context)); //var s= UserManager.GetRoles(user.GetUserId()); ViewBag.displayMenu = "No"; if (isAdminUser()) { ViewBag.displayMenu = "Yes"; // ViewBag.resultquery = (from c in db.Tbl_Member where c.MemberId == Convert.ToInt32(Session["userId"]) select c); } return(View()); } else { ViewBag.Name = "Not Logged IN"; } Session.Abandon(); return(View()); }
public ActionResult GetList() { using (GymProcessEntities1 db = new GymProcessEntities1()) { var memberList = db.Tbl_Member.ToList <Tbl_Member>(); db.Configuration.LazyLoadingEnabled = false; return(Json(new { data = memberList }, JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { GymProcessEntities1 i = new GymProcessEntities1(); var user = i.AspNetUsers.Where(x => x.UserName == model.UserName).SingleOrDefault(); //var user = i.Tbl_Member.Where(x => x.MemberName == model.UserName).FirstOrDefault(); Session["userId"] = user.Id; if (!ModelState.IsValid) { return(View(model)); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout : false); switch (result) { case SignInStatus.Success: return(RedirectToLocal(returnUrl)); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.RequiresVerification: return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe })); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return(View(model)); } }
public ActionResult Index(string sortOrder, string CurrentSort, string Filter_Value, int?page, string searchString) { GymProcessEntities1 db = new GymProcessEntities1(); int pageSize = 10; int pageIndex = 1; pageIndex = page.HasValue ? Convert.ToInt32(page) : 1; ViewBag.CurrentSort = sortOrder; sortOrder = String.IsNullOrEmpty(sortOrder) ? "Member" : sortOrder; if (searchString != null) { page = 1; } else { searchString = Filter_Value; } ViewBag.FilterValue = searchString; var members = from mem in db.Tbl_Member select mem; if (!String.IsNullOrEmpty(searchString)) { members = members.Where(mem => mem.MemberName.ToUpper().Contains(searchString.ToUpper()) || mem.MemberType.ToUpper().Contains(searchString.ToUpper())); } IPagedList <Tbl_Member> employees = null; switch (sortOrder) { case "Member": if (sortOrder.Equals(CurrentSort)) { employees = db.Tbl_Member.OrderByDescending (m => m.MemberName).ToPagedList(pageIndex, pageSize); } else { employees = db.Tbl_Member.OrderBy (m => m.MemberName).ToPagedList(pageIndex, pageSize); } break; case "Email": if (sortOrder.Equals(CurrentSort)) { employees = db.Tbl_Member.OrderByDescending (m => m.Email).ToPagedList(pageIndex, pageSize); } else { employees = db.Tbl_Member.OrderBy (m => m.Email).ToPagedList(pageIndex, pageSize); } break; case "Phone": if (sortOrder.Equals(CurrentSort)) { employees = db.Tbl_Member.OrderByDescending (m => m.Mobile).ToPagedList(pageIndex, pageSize); } else { employees = db.Tbl_Member.OrderBy (m => m.Mobile).ToPagedList(pageIndex, pageSize); } break; case "Default": employees = db.Tbl_Member.OrderBy (m => m.MemberName).ToPagedList(pageIndex, pageSize); break; } return(View(employees)); }
public ActionResult exportExel() { GymProcessEntities1 db = new GymProcessEntities1(); DataTable dt = new DataTable("Grid"); dt.Columns.AddRange(new DataColumn[11] { new DataColumn("MemberId"), new DataColumn("MemberName"), new DataColumn("mobile"), new DataColumn("Email"), new DataColumn("Address"), new DataColumn("Height"), new DataColumn("Weight"), new DataColumn("BloodGroup"), new DataColumn("MemberType"), new DataColumn("Scheme"), new DataColumn("PayementDetail") }); var member = from Tbl_Member in db.Tbl_Member.Take(10) select Tbl_Member; foreach (var Tbl_Member in member) { dt.Rows.Add(Tbl_Member.MemberId, Tbl_Member.MemberName, Tbl_Member.Mobile, Tbl_Member.Email, Tbl_Member.Addess, Tbl_Member.Height, Tbl_Member.Weight, Tbl_Member.BloodGroup, Tbl_Member.MemberName, Tbl_Member.Scheme, Tbl_Member.PaymentDetail); } using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt); Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename=SqlExport.xlsx"); wb.Worksheet(1).Cells("A1:k1").Style.Fill.BackgroundColor = XLColor.White; wb.ShowGridLines = false; for (int i = 1; i <= dt.Rows.Count; i++) { //A resembles First Column while C resembles Third column. //Header row is at Position 1 and hence First row starts from Index 2. string cellRange = string.Format("A{0}:k{0}", i + 1); if (i % 2 != 0) { wb.Worksheet(1).Cells(cellRange).Style.Fill.BackgroundColor = XLColor.WhiteSmoke; } else { wb.Worksheet(1).Cells(cellRange).Style.Fill.BackgroundColor = XLColor.DimGray; } } // font Size wb.Worksheet(1).Cells("A1:K1").Style.Font.Bold = true; //Adjust widths of Columns. wb.Worksheet(1).Columns().AdjustToContents(); using (MemoryStream stream = new MemoryStream()) { wb.SaveAs(stream); stream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Grid.xlsx")); } } }