public static projectinfo getprojectbyid(int id)
{
TrDAL td = new TrDAL();
projectinfo project = td.projects.Where(p => p.Id == id).FirstOrDefault();
return(project);
}
public static userinfo getUser(string username)
{
TrDAL td = new TrDAL();
userinfo user = td.users.Where(u => u.username == username).FirstOrDefault();
return(user);
}
public static projectinfo getproject(string projectname)
{
TrDAL td = new TrDAL();
projectinfo project = td.projects.Where(p => p.projectname == projectname).FirstOrDefault();
return(project);
}
public static translationinfo Upload(int id, string Text, string username)
{
TrDAL td = new TrDAL();
textinfo ti = td.texts.Where(t => t.Id == id).FirstOrDefault();
if (td.translations.Where(t => t.textinfo.Id == ti.Id).Count() > 0)
{
translationinfo oldtranslation = td.translations.Where(t => t.textinfo.Id == ti.Id).FirstOrDefault();
oldtranslation.userinfo = td.users.Where(u => u.username == username).FirstOrDefault();
oldtranslation.textinfo = ti;
oldtranslation.translatedText = Text;
oldtranslation.updateTime = DateTime.Now;
td.SaveChanges();
return(oldtranslation);
}
else
{
translationinfo translation = new translationinfo()
{
userinfo = td.users.Where(u => u.username == username).FirstOrDefault(),
textinfo = ti,
translatedText = Text,
updateTime = DateTime.Now
};
td.translations.Add(translation);
td.SaveChanges();
return(translation);
}
}
public bool Upload(List <textinfo> textinfo, string projectname)
{
TrDAL td = new TrDAL();
projectinfo project = td.projects.Where(p => p.projectname == projectname).FirstOrDefault();
textinfo.ForEach(text =>
{
text.project = project;
td.texts.Add(text);
});
td.SaveChanges();
return(true);
}
public Task <bool> Add(userinfo user)
{
return(Task.Run(() =>
{
TrDAL td = new TrDAL();
int i = td.users.Where(u => u.username == user.username).Count();
if (i == 0)
{
td.users.Add(user);
td.SaveChanges();
return true;
}
else
{
return false;
}
}
));
}
public Task <string> loginAsync(userinfo user)
{
return(Task.Run(() =>
{
TrDAL td = new TrDAL();
var userlist = td.users.Where(u => u.username == user.username && u.password == user.password);
if (userlist.Count() > 0)
{
if (userlist.First().rights == "admin")
{
return "admin";
}
else
{
return "user";
}
}
else
{
return "NoUser";
}
}));
}
public bool Upload(HomeViewModel hvm)
{
TrDAL td = new TrDAL();
projectinfo project = new projectinfo()
{
projectname = hvm.projectname,
user = td.users.Where(u => u.username == hvm.username).FirstOrDefault(),
message = hvm.message,
createtime = DateTime.Now
};
int i = td.projects.Where(p => p.projectname == project.projectname).Count();
if (i == 0)
{
td.projects.Add(project);
td.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public List <userinfo> GetUserInfo()
{
TrDAL td = new TrDAL();
return(td.users.ToList());
}
public List <textinfo> GetTextInfo()
{
TrDAL td = new TrDAL();
return(td.texts.ToList());
}
public List <projectinfo> GetProjectInfo()
{
TrDAL td = new TrDAL();
return(td.projects.ToList());
}
public List <translationinfo> GetTranslationInfo()
{
TrDAL td = new TrDAL();
return(td.translations.ToList());
}
