public static bool VerifyUser(string name, string password)
{
int id = 0;
using (var db = new DummyPerceptualCont())
{
var myQry = from user in db.Users
where user.Login == name && user.Password == password
select user.Id;
var result = "";
foreach (var item in myQry)
{
result = item.ToString();
}
if (result != null)
{
id = Convert.ToInt32(result);
HttpContext.Current.Session["UserId"] = id;
return(true);
}
}
return(false);
}
public static List <String> GetSimilarImages(string dummyPerceptualHash)
{
List <string> paths = new List <string>();
using (var db = new DummyPerceptualCont())
{
var clientIdParameter = new SqlParameter("@param1", dummyPerceptualHash);
var procedureResult = db.Database.SqlQuery <String>("sp_get_similar_photo @param1", clientIdParameter);
foreach (string result in procedureResult)
{
paths.Add(result);
}
}
return(paths);
}
public static List <Models.Image> GetImages(int userId)
{
List <Models.Image> imgs = new List <Image>();
using (var db = new DummyPerceptualCont())
{
var myQry = from image in db.Images
where image.User.Id == userId
select image;
foreach (var item in myQry)
{
Models.Image img = new Models.Image {
Id = item.Id, path = item.path, md5 = item.md5, dph = item.dph
};
imgs.Add(img);
}
return(imgs);
}
}
public static void SaveImage(int userId, string path, string dph, string md5)
{
using (var db = new DummyPerceptualCont())
{
User user = null;
var result = from u in db.Users
where u.Id == userId
select u;
foreach (var item in result)
{
user = item as User;
}
var images = db.Set <Image>();
images.Add(new Models.Image {
dph = dph, md5 = md5, path = path, User = user
});
db.SaveChanges();
}
}