public static int GetUserIDByUsername(string username)
{
using (SastaServicesDBEntities db = new SastaServicesDBEntities())
{
int ID = db.StpUsers.Where(a => a.UserName == username).Select(a => a.ID).FirstOrDefault();
return(ID);
}
}
public static string GetHashedPassByUsername(string username)
{
using (SastaServicesDBEntities db = new SastaServicesDBEntities())
{
string hashedPassword = db.StpUsers.Where(a => a.UserName == username).Select(a => a.Password).FirstOrDefault();
return(hashedPassword);
}
}
public static bool IsEmailExist(string emailID)
{
using (SastaServicesDBEntities db = new SastaServicesDBEntities())
{
var v = db.StpUsers.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public static bool IsUsernameExist(string username)
{
using (SastaServicesDBEntities db = new SastaServicesDBEntities())
{
var v = db.StpUsers.Where(a => a.UserName == username).FirstOrDefault();
return(v != null);
}
}
public JsonResult ProductGridList(string Category, int?page)
{
using (var db = new SastaServicesDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
int CategoryID = db.STPProductTypes.Where(x => x.ProductTypeName == Category).Select(x => x.ID).FirstOrDefault();
if (CategoryID > 0)
{
var ProductRow = db.STPProductLists.Where(x => x.STPProductTypeID == CategoryID).ToList();
if (page > 0)
{
page = page;
}
else
{
page = 1;
}
int start = (int)(page - 1) * 9;
ViewBag.pageCurrent = page;
int totalPage = ProductRow.Count();
float totalNumsize = (totalPage / (float)9);
int numSize = (int)Math.Ceiling(totalNumsize);
ViewBag.numSize = numSize;
var dataPost = ProductRow.OrderBy(x => x.ID).Skip(start).Take(9);
List <STPProductList> ListProduct = new List <STPProductList>();
ListProduct = dataPost.ToList();
int TotalRecords = ProductRow.Count();
int CurrentItem = ListProduct.Count();
return(Json(new { data = ListProduct, pageCurrent = page, numSize = numSize, currentRecords = CurrentItem, totalItem = TotalRecords }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
}
