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 static List <textinfo> GetText(HomeViewModel hvm)
{
StreamReader csvreader = new StreamReader(hvm.fileUpload.InputStream);
JavaScriptSerializer Serializer = new JavaScriptSerializer();
List <filetext> filetext = Serializer.Deserialize <List <filetext> >(csvreader.ReadToEnd());
List <textinfo> textinfo = new List <textinfo>();
foreach (var ft in filetext)
{
textinfo ti = new textinfo()
{
key = ft.key,
text = ft.text
};
textinfo.Add(ti);
}
return(textinfo);
}
