public static bool CheckToken(string token)
{
DBWikiEntities we = new DBWikiEntities();
var q = we.AccServices.Any(s => s.tokenString == token && s.sttAS == true);
return(q);
}
public static Category GetCateByID(int idCate)
{
DBWikiEntities we = new DBWikiEntities();
var cate = we.Categories.SingleOrDefault(s => s.idCate == idCate);
return(cate);
}
public static bool CreateCate(Category cate)
{
DBWikiEntities we = new DBWikiEntities();
we.Categories.Add(cate);
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool CreateEI(EditInfo e)
{
DBWikiEntities we = new DBWikiEntities();
we.EditInfoes.Add(e);
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool DelEIByID(int idEI)
{
DBWikiEntities we = new DBWikiEntities();
var e = we.EditInfoes.SingleOrDefault(s => s.idEI == idEI);
we.EditInfoes.Remove(e);
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool ReadEINew(int idEI)
{
DBWikiEntities we = new DBWikiEntities();
var q = we.EditInfoes.SingleOrDefault(s => s.idEI == idEI);
q.newEI = false;
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool UpdateCate(Category c)
{
DBWikiEntities we = new DBWikiEntities();
var cate = we.Categories.SingleOrDefault(s => s.idCate == c.idCate);
cate.nameCate = c.nameCate;
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool DelIF(int idIF)
{
DBWikiEntities we = new DBWikiEntities();
var i = we.Information.SingleOrDefault(w => w.idInfor == idIF);
we.Information.Remove(i);
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool ReadInfoNew(int idIF)
{
DBWikiEntities we = new DBWikiEntities();
var q = we.Information.SingleOrDefault(w => w.idInfor == idIF);
q.newInfo = false;
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool ChangePwd(int idUser, string pwdOld, string pwdNew)
{
DBWikiEntities we = new DBWikiEntities();
var pass = we.Users.SingleOrDefault(s => s.idUser == idUser && s.pwd == pwdOld);
if (pass == null)
{
return(false);
}
var user = we.Users.SingleOrDefault(s => s.idUser == idUser);
user.pwd = pwdNew;
we.SaveChanges();
return(true);
}
public static bool UpdateInfo(Information i)
{
DBWikiEntities we = new DBWikiEntities();
var q = we.Information.SingleOrDefault(w => w.idInfor == i.idInfor);
q.titleInfo = i.titleInfo;
q.idCate = i.idCate;
q.contentInfo = i.contentInfo;
q.nameUnsigned = CommonHelper.RemoveUnicode.RemoveSign4VietnameseString(i.titleInfo);
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool DelCate(int idCate)
{
try
{
DBWikiEntities we = new DBWikiEntities();
var cate = we.Categories.SingleOrDefault(s => s.idCate == idCate);
we.Categories.Remove(cate);
we.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static int CreateUser(User u)
{
DBWikiEntities we = new DBWikiEntities();
var user = we.Users.SingleOrDefault(s => s.email == u.email);
var service = we.AccServices.SingleOrDefault(s => s.emailAS == u.email);
if (user != null || service != null)
{
return(0);
}
u.active = true;
u.idR = 2;
we.Users.Add(u);
we.SaveChanges();
return(1);
}
public static bool CreateInfo(Information i)
{
try
{
i.token = Convert.ToBase64String(Guid.NewGuid().ToByteArray());
i.nameUnsigned = CommonHelper.RemoveUnicode.RemoveSign4VietnameseString(i.titleInfo);
DBWikiEntities we = new DBWikiEntities();
we.Information.Add(i);
we.SaveChanges();
return(true);
//aaaaaaaa
}
catch (Exception)
{
return(false);
}
}
public static bool CreateAccService(AccService a)
{
DBWikiEntities we = new DBWikiEntities();
User user = we.Users.SingleOrDefault(s => s.email == a.emailAS);
AccService service = we.AccServices.SingleOrDefault(s => s.emailAS == a.emailAS);
if (user != null || service != null)
{
return(false);
}
a.sttAS = true;
a.tokenString = Convert.ToBase64String(Guid.NewGuid().ToByteArray());
//a.tokenString = CommonHelper.Tokenizer.Generate(64);
we.AccServices.Add(a);
we.SaveChanges();
return(true);
}
public static int UpdateInfoUser(User u)
{
DBWikiEntities we = new DBWikiEntities();
var mail = we.Users.SingleOrDefault(s => s.email == u.email && s.idUser != u.idUser);
var service = we.AccServices.SingleOrDefault(s => s.emailAS == u.email);
if (mail != null || service != null)
{
return(0);
}
var user = we.Users.SingleOrDefault(s => s.idUser == u.idUser);
user.nameUser = u.nameUser;
user.email = u.email;
we.SaveChanges();
return(1);
}
public static bool ActiveUser(int idUser)
{
DBWikiEntities we = new DBWikiEntities();
var q = we.Users.SingleOrDefault(s => s.idUser == idUser);
if (q.active == true)
{
q.active = false;
}
else
{
q.active = true;
}
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static bool HideInfo(int idIF)
{
DBWikiEntities we = new DBWikiEntities();
var q = we.Information.SingleOrDefault(w => w.idInfor == idIF);
if (q.hideInfo == false)
{
q.hideInfo = true;
}
else
{
q.hideInfo = false;
}
if (we.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public static int CheckRoleLogin(string mail, string pwd)
{
DBWikiEntities we = new DBWikiEntities();
var ad = we.Users.SingleOrDefault(s => s.email == mail && s.pwd == pwd && s.active == true && s.idR == 1);
if (ad != null)
{
return(1);
}
var user = we.Users.SingleOrDefault(s => s.email == mail && s.pwd == pwd && s.active == true && s.idR == 2);
var service = we.AccServices.SingleOrDefault(s => s.emailAS == mail && s.pwdAS == pwd && s.sttAS == true);
if (user != null)
{
return(2);
}
if (service != null)
{
return(3);
}
return(0);
}
public static List <AccService> GetAllAS()
{
DBWikiEntities we = new DBWikiEntities();
return(we.AccServices.ToList());
}
public static AccService AccLogin(string mail)
{
DBWikiEntities we = new DBWikiEntities();
return(we.AccServices.SingleOrDefault(s => s.emailAS == mail));
}
public static Information GetInfoByID(int idIF)
{
DBWikiEntities we = new DBWikiEntities();
return(we.Information.SingleOrDefault(w => w.idInfor == idIF));
}
public static List <Information> GetInfoHideByIDUser(int idUser)
{
DBWikiEntities we = new DBWikiEntities();
return(we.Information.Where(w => w.idUser == idUser && w.hideInfo == true).OrderByDescending(o => o.dayCreateInfo).ToList());
}
public ProductDao()
{
db = new DBWikiEntities();
}
public static Information GetInfoByToken(string token)
{
DBWikiEntities we = new DBWikiEntities();
return(we.Information.SingleOrDefault(w => w.token == token && w.hideInfo == false));
}
public static List <Information> GetAllInfoByValueSearch(string value)
{
DBWikiEntities we = new DBWikiEntities();
return(we.Information.Where(w => w.titleInfo.Contains(value) || w.nameUnsigned.Contains(value) && w.hideInfo == false).ToList());
}
public CategoryDao()
{
db = new DBWikiEntities();
}
public static List <Information> GetInfoByIDCate(int idCate)
{
DBWikiEntities we = new DBWikiEntities();
return(we.Information.Where(w => w.idCate == idCate && w.hideInfo == false).OrderByDescending(o => o.dayCreateInfo).ToList());
}
public UserDao()
{
db = new DBWikiEntities();
}
public static List <Information> GetAllInfoAdminHide()
{
DBWikiEntities we = new DBWikiEntities();
return(we.Information.Where(w => w.hideInfo == true && w.User.idR == 1).OrderByDescending(o => o.dayCreateInfo).ToList());
}
