public ActionResult FilesReadAdmin([DataSourceRequest] DataSourceRequest request)
{
var db = new DetergentsEntities();
try
{
var userFiles = db.UserFiles.Select(
f => new UserFileViewModel
{
Id = f.fileID,
Name = f.fileName,
productID = f.productID,
productDescription = f.productID.ToString(),
sheetTypeName = f.SheetType.sheetTypeName,
sheetTypeID = f.sheetTypeID,
vendorID = f.vendorID,
adminApproved = f.adminApproved,
oldFile = f.oldFile,
languageType = f.languageType
});
return(Json(userFiles.ToDataSourceResult(request)));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
//
public ActionResult FilesReadAll([DataSourceRequest] DataSourceRequest request)
{
var db = new DetergentsEntities();
try
{
var result = db.UserFiles;
var fileList = new List <UserFileViewModel>();
foreach (var item in result)
{
var userFile = new UserFileViewModel()
{
Id = item.fileID,
Name = item.fileName,
productID = item.productID,
sheetTypeName = item.SheetType.sheetTypeName,
sheetTypeID = item.sheetTypeID,
adminApproved = item.adminApproved
};
var fileListName = db.UserFiles
.Where(file => file.productID == item.productID).ToList();
if (fileListName != null)
{
userFile.listOfFiles = new List <UserFile>();
foreach (var file in fileListName)
{
var userFiles = new UserFile
{
fileName = file.fileName,
fileID = file.fileID,
SheetType = new SheetType
{
sheetTypeID = file.SheetType.sheetTypeID,
sheetTypeName = file.SheetType.sheetTypeName
}
};
userFiles.SheetType.sheetTypeName = file.SheetType.sheetTypeName;
userFile.listOfFiles.Add(userFiles);
}
}
fileList.Add(userFile);
}
return(Json(fileList.ToTreeDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
private static IQueryable <ProductViewModel> GetCategory()
{
var northwind = new DetergentsEntities();
var products = northwind.Products.Select(product => new ProductViewModel
{
categoryID = product.categoryID,
categoryName = product.Category.categoryName
});
return(products);
}
public ActionResult Country()
{
var dataContext = new DetergentsEntities();
var country = dataContext.Country
.Select(c => new countryViewModel
{
CountryID = c.CountryID,
CountryName = c.CountryName
})
.OrderBy(e => e.CountryName);
return(Json(country, JsonRequestBehavior.AllowGet));
}
public ActionResult vendorLogin(vendorLogin _login, string userName, string password)
{
if (ModelState.IsValid) //validating the user inputs
{
var f_password = GetMD5(password);
var isExist = false;
using (var _entity = new DetergentsEntities()) // out Entity name is "SampleMenuMasterDBEntites"
{
isExist = _entity.vendorLogin
.Any(x => x.userName.Trim().ToLower() == _login.userName.Trim().ToLower() &&
x.password ==
f_password); //validating the user name in tblLogin table whether the user name is exist or not
if (isExist)
{
var _loginCredentials = _entity.vendorLogin.ToList()
.Where(x => x.userName.Trim().ToLower() == _login.userName.Trim().ToLower()).Select(x =>
new vendorLogin
{
userName = x.userName,
Id = x.Id,
password = x.password
}).FirstOrDefault(); // Get the login user details and bind it to LoginModels class
//Get the Menu details from entity and bind it in MenuModels list.
FormsAuthentication.SetAuthCookie(_loginCredentials.userName,
true); // set the formauthentication cookie
Session["LoginCredentials"] =
_loginCredentials; // Bind the _logincredentials details to "LoginCredentials" session
Session["UserName"] = _loginCredentials.userName;
return(RedirectToAction("Index", "Vendor"));
}
ViewBag.ErrorMsg = "Please enter the valid credentials!...";
return(View());
}
}
return(View());
}
public ActionResult FilesRead([DataSourceRequest] DataSourceRequest request, int productID, int sheetTypeID,
string productName)
{
var db = new DetergentsEntities();
try
{
var userFiles = db.UserFiles.Where(x => x.productID == productID && x.adminApproved == true).Select(
f => new UserFileViewModel
{
Id = f.fileID,
Name = f.fileName,
productID = f.productID,
sheetTypeID = f.sheetTypeID
});
return(Json(userFiles.ToDataSourceResult(request)));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
