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