public bool InsertNew(string brand, string username)
{
bool res;
using (var db = new ImageServerEntities())
{
try
{
Credential credential = new Credential()
{
Id = 1,
Username = username,
Brand = brand
};
db.Credentials.Add(credential);
db.SaveChanges();
res = true;
}
catch (Exception)
{
res = false;
}
}
return(res);
}
public bool RemoveRecord(Folder targetfolder)
{
bool res = false;
using (var db = new ImageServerEntities())
{
try
{
Folder folder = db.Folders.Find(targetfolder.Id);
if (folder != null)
{
db.Folders.Remove(folder);
db.SaveChanges();
res = true;
}
else
{
res = false;
}
}
catch (Exception e)
{
res = false;
}
}
return(res);
}
public string InsertNew(string brand, string path, int parentId)
{
string res;
using (var db = new ImageServerEntities())
{
try
{
string token = GenToken(DateTime.Now);
Folder folder = new Folder()
{
Id = 1,
Brand = brand,
Path = path,
ParentPathId = parentId,
Token = token
};
db.Folders.Add(folder);
db.SaveChanges();
res = token;
}
catch (Exception)
{
res = "";
}
}
return(res);
}
public void abc()
{
using (var db = new ImageServerEntities())
{
var result = db.Books.SingleOrDefault(b => b.BookNumber == bookNumber);
if (result != null)
{
result.SomeValue = "Some new value";
db.SaveChanges();
}
}
}
public bool CheckUserBrand(string username, string brand)
{
using (var db = new ImageServerEntities())
{
var result = db.Credentials.Where(q => q.Username == username && q.Brand == brand).FirstOrDefault();
if (result != null)
{
return(true);
}
}
return(false);
}
public Folder GetByToken(string token)
{
using (var db = new ImageServerEntities())
{
var result = db.Folders.Where(q => q.Token == token).FirstOrDefault();
if (result != null)
{
return(result);
}
}
return(null);
}
public bool RemoveRecord(string username, string brand)
{
bool res = false;
using (var db = new ImageServerEntities())
{
try
{
Credential credential = db.Credentials.Where(q => q.Username == username && q.Brand == brand).FirstOrDefault();
if (credential != null)
{
db.Credentials.Remove(credential);
db.SaveChanges();
res = true;
}
res = false;
}
catch (Exception)
{
res = false;
}
}
return(res);
}
