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 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); } }