/// <summary> /// Получаем текст из необходимого словаря /// </summary> /// <param name="elName">Название элемента</param> /// <returns>Текст на определенном языке или название элемента</returns> public static string GetTextInSetLaunguage(string elName) { string textTarg; switch (UISettings.Current.language) { case UISettingsAttributes.Language.English: textTarg = English.ContainsKey(elName)? English[elName] : String.Empty; break; case UISettingsAttributes.Language.Lithuanian: textTarg = Lithuanian.ContainsKey(elName) ? Lithuanian[elName] : String.Empty; break; case UISettingsAttributes.Language.Russian: textTarg = Russian.ContainsKey(elName) ? Russian[elName] : String.Empty; break; default: textTarg = English.ContainsKey(elName) ? English[elName] : String.Empty; Debug.Assert(false, "Unknown Language"); break; } Debug.Assert(!String.IsNullOrEmpty(textTarg), "Can't find translation of:\t" + elName); return(!String.IsNullOrEmpty(textTarg) ? textTarg : "Error!!! " + elName); }
public ActionResult DeleteConfirmed(int id) { Russian russian = db.Russians.Find(id); db.Russians.Remove(russian); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Not more then one instance at one time /// </summary> /// <returns>Exemplar of class</returns> public static Russian GetInstance() { if (_instance == null) { _instance = new Russian(); } return(_instance); }
public ActionResult Edit([Bind(Include = "Id,Title,Body,Date")] Russian russian) { if (ModelState.IsValid) { db.Entry(russian).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(russian)); }
public ActionResult Create([Bind(Include = "Id,Title,Body,Date")] Russian russian) { if (ModelState.IsValid) { db.Russians.Add(russian); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(russian)); }
public string Message(ILanguage Language) { if (Language == Russian.GetLanguage()) { return(MessageRussian); } else { return("Error"); } }
/// <summary> /// </summary> /// <param name="cultureInfo"> </param> public static void Update(CultureInfo cultureInfo) { var culture = cultureInfo.TwoLetterISOLanguageName; ResourceDictionary dictionary; if (Constants.Supported.Contains(culture)) { switch (culture) { case "fr": dictionary = French.Context(); break; case "ja": dictionary = Japanese.Context(); break; case "de": dictionary = German.Context(); break; case "zh": dictionary = Chinese.Context(); break; case "ru": dictionary = Russian.Context(); break; case "ko": dictionary = Korean.Context(); break; default: dictionary = English.Context(); break; } } else { dictionary = English.Context(); } var locale = dictionary.Cast <DictionaryEntry>() .ToDictionary(item => (string)item.Key, item => (string)item.Value); AppViewModel.Instance.Locale = locale; foreach (var pluginInstance in App.Plugins.Loaded.Cast <PluginInstance>() .Where(pluginInstance => pluginInstance.Loaded)) { pluginInstance.Instance.Locale = locale; } }
// GET: Russians/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Russian russian = db.Russians.Find(id); if (russian == null) { return(HttpNotFound()); } return(View(russian)); }
/// <summary> /// </summary> /// <param name="cultureInfo"> </param> public static void Update(CultureInfo cultureInfo) { var culture = cultureInfo.TwoLetterISOLanguageName; Dictionary <string, string> dictionary; if (Constants.Supported.Contains(culture)) { switch (culture) { case "fr": dictionary = French.Context(); break; case "ja": dictionary = Japanese.Context(); break; case "de": dictionary = German.Context(); break; case "zh": dictionary = Chinese.Context(); break; case "ru": dictionary = Russian.Context(); break; case "ko": dictionary = Korean.Context(); break; default: dictionary = English.Context(); break; } } else { dictionary = English.Context(); } AppViewModel.Instance.Locale = dictionary; foreach (PluginInstance pluginInstance in App.Plugins.Loaded.Cast <PluginInstance>().Where(pluginInstance => pluginInstance.Loaded)) { pluginInstance.Instance.Locale = dictionary; } }
/// <summary> /// </summary> /// <param name="cultureInfo"> </param> public static Dictionary <string, string> Update(CultureInfo cultureInfo) { var culture = cultureInfo.TwoLetterISOLanguageName; Dictionary <string, string> dictionary; if (Constants.Supported.Contains(culture)) { switch (culture) { case "fr": dictionary = French.Context(); break; case "ja": dictionary = Japanese.Context(); break; case "de": dictionary = German.Context(); break; case "zh": dictionary = Chinese.Context(); break; case "ru": dictionary = Russian.Context(); break; default: dictionary = English.Context(); break; } } else { dictionary = English.Context(); } var e = dictionary.ToDictionary(val => val.Key, val => val.Value); return(e); }
/// <summary> /// </summary> /// <param name="cultureInfo"> </param> public static Dictionary <string, string> Update(CultureInfo cultureInfo) { var culture = cultureInfo.TwoLetterISOLanguageName; ResourceDictionary dictionary; if (Constants.Supported.Contains(culture)) { switch (culture) { case "fr": dictionary = French.Context(); break; case "ja": dictionary = Japanese.Context(); break; case "de": dictionary = German.Context(); break; case "zh": dictionary = Chinese.Context(); break; case "ru": dictionary = Russian.Context(); break; default: dictionary = English.Context(); break; } } else { dictionary = English.Context(); } return(dictionary.Cast <DictionaryEntry>().ToDictionary(item => (string)item.Key, item => (string)item.Value)); }
private bool ChooseLanguage() { SendMessage("Choose you language (type \"rus\" for russian or \"eng\" for english)\nВыберите язык (введите \"rus\" для русского или \'eng\' для английского)\n>"); string answer = GetMessage(); if (answer.StartsWith("rus")) { text = Russian.GetLanguage(); } else if (answer.StartsWith("eng")) { text = English.GetLanguage(); } else { SendMessage("I cannot understand you, try again\nЯ не могу понять вас, попробуйте еще\n\n"); CloseConnection(); return(false); } return(true); }
public int GetUniqueKey() => English.GetHashCode() ^ Russian.GetHashCode() ^ Description.GetHashCode();
public ActionResult Torg12(string List) { var stream = new MemoryStream(); var ids = List.Split <int>(";"); var orders = DB.Orders.Where(x => ids.Contains(x.ID) && x.Shop != null && x.Shop.Owner == CurrentUser.ShopOwnerID).ToList(); var workbook = new HSSFWorkbook(); using (var fs = new FileStream(Server.MapPath("~/Content/TORG12.xls"), FileMode.Open)) { var example = new HSSFWorkbook(fs); int index = 0; foreach (var order in orders) { var sheet = (HSSFSheet)example.GetSheetAt(0); sheet.CopyTo(workbook, "Заказ №" + order.OrderNumberOrID.Replace("'", "").Replace("[", "@").Replace("]", "@"), true, false); var copied = (HSSFSheet)workbook.GetSheetAt(index); copied.GetRow(2).GetCell(1).SetCellValue(order.Requisites); copied.GetRow(9).GetCell(3).SetCellValue(order.Requisites); copied.GetRow(7).GetCell(3).SetCellValue(order.Receiver); copied.GetRow(11).GetCell(3).SetCellValue(order.Receiver); copied.GetRow(3).GetCell(37).SetCellValue(order.Shop.GetSetting("OKPO")); copied.GetRow(8).GetCell(37).SetCellValue(order.Shop.GetSetting("OKPO")); copied.GetRow(16).GetCell(10).SetCellValue(order.OrderNumberOrID); copied.GetRow(16).GetCell(14).SetCellValue(DateTime.Now.ToString("dd.MM.yyyy")); if (order.OrderedProducts.Count > 1) { for (int i = 1; i < order.OrderedProducts.Count; i++) { copied.GetRow(22).CopyRowTo(23); } } int oi = 0; foreach (var product in order.OrderedProducts) { var row = copied.GetRow(22 + oi); row.GetCell(1).SetCellValue(oi + 1); row.GetCell(2).SetCellValue(product.Product.Name); row.GetCell(6).SetCellValue(product.Product.Article); row.GetCell(7).SetCellValue(product.Product.AmountUnitName); row.GetCell(11).SetCellValue(product.Product.UnitCode); row.GetCell(21).SetCellValue(product.Amount); row.GetCell(23).SetCellValue((product.PriceWithoutNDS).ToString("f2")); row.GetCell(25).SetCellValue((product.PriceWithoutNDS * product.Amount).ToString("f2")); row.GetCell(30).SetCellValue("18%"); row.GetCell(33).SetCellValue((product.NDS * product.Amount).ToString("f2")); row.GetCell(36).SetCellValue((product.Price * product.Amount).ToString("f2")); oi++; } var rws1 = copied.GetRow(22 + oi); var rws2 = copied.GetRow(22 + oi + 1); rws1.GetCell(21).SetCellValue(order.OrderedProducts.Sum(x => x.Amount)); rws2.GetCell(21).SetCellValue(order.OrderedProducts.Sum(x => x.Amount)); rws1.GetCell(23).SetCellValue("X"); rws2.GetCell(23).SetCellValue("X"); rws1.GetCell(25).SetCellValue(order.OrderedProducts.Sum(x => x.Amount * x.PriceWithoutNDS).ToString("f2")); rws2.GetCell(25).SetCellValue(order.OrderedProducts.Sum(x => x.Amount * x.PriceWithoutNDS).ToString("f2")); rws1.GetCell(30).SetCellValue("X"); rws2.GetCell(30).SetCellValue("X"); rws1.GetCell(33).SetCellValue(order.OrderedProducts.Sum(x => x.Amount * x.NDS).ToString("f2")); rws2.GetCell(33).SetCellValue(order.OrderedProducts.Sum(x => x.Amount * x.NDS).ToString("f2")); rws1.GetCell(36).SetCellValue(order.OrderedProducts.Sum(x => x.Amount * x.Price).ToString("f2")); rws2.GetCell(36).SetCellValue(order.OrderedProducts.Sum(x => x.Amount * x.Price).ToString("f2")); copied.GetRow(22 + oi + 3) .GetCell(5) .SetCellValue(Russian.ToString(order.OrderedProducts.Count, Gender.Masculine)); var all = order.OrderedProducts.Sum(x => x.Price * x.Amount); var allStr = Russian.ToString((int)all, Gender.Masculine, true) + " рублей " + ((int)((all - (int)all) * 100)).ToString("d2") + " копеек"; copied.GetRow(22 + oi + 13) .GetCell(1) .SetCellValue(allStr); index++; } workbook.Write(stream); } return(File(stream.ToArray(), MIMETypeWrapper.GetMIME("xls"), "Torg12_" + List.Trim(';').Replace(";", "_") + ".xls")); }
Russian.IParse Russian.IDeclension.Parse(string s, Russian.ParseArgs args) { return new Russian.Parse (soapClient.GetXml (credentials, s), s); }
public static void SaveToDB(Phrase p) { using (SQLiteConnection conn = new SQLiteConnection(stringConnection)) { conn.Open(); using (SQLiteTransaction transaction = conn.BeginTransaction()) { SQLiteCommand command = new SQLiteCommand(conn); command.Transaction = transaction; English e = new English() { Sentence_eng = p.EnglishPhrase, Sound_eng = p.Sound }; Russian r = new Russian() { Sentence_ru = p.RussianPhrase }; command.CommandText = $"SELECT same_ru FROM russian WHERE sentence_ru = \"{r.Sentence_ru}\""; e.Same_eng = Convert.ToInt32(command.ExecuteScalar()); command.CommandText = $"SELECT same_eng FROM english WHERE sentence_eng = \"{e.Sentence_eng}\""; r.Same_ru = Convert.ToInt32(command.ExecuteScalar()); if (e.Same_eng > 0 && r.Same_ru == 0) { command.CommandText = $"SELECT same_russian FROM translate WHERE same_english == {e.Same_eng}"; r.Same_ru = Convert.ToInt32(command.ExecuteScalar()); } if (e.Same_eng == 0 && r.Same_ru > 0) { command.CommandText = $"SELECT same_english FROM translate WHERE same_russian == {r.Same_ru}"; e.Same_eng = Convert.ToInt32(command.ExecuteScalar()); } if (e.Same_eng == 0) { command.CommandText = $"SELECT same_eng FROM english ORDER BY same_eng DESC LIMIT 1"; int lastSame = Convert.ToInt32(command.ExecuteScalar()); e.Same_eng = lastSame + 1; } if (r.Same_ru == 0) { command.CommandText = $"SELECT same_ru FROM russian ORDER BY same_ru DESC LIMIT 1"; int lastSame = Convert.ToInt32(command.ExecuteScalar()); r.Same_ru = lastSame + 1; } if (e.Sound_eng == null || e.Sound_eng == "") { command.CommandText = $"INSERT OR IGNORE INTO english (sentence_eng, sound_eng, same_eng) VALUES (\"{e.Sentence_eng}\", null, {e.Same_eng})"; command.ExecuteNonQuery(); } else { command.CommandText = $"INSERT OR IGNORE INTO english (sentence_eng, sound_eng, same_eng) VALUES (\"{e.Sentence_eng}\", \"{e.Sound_eng}\", {e.Same_eng})"; command.ExecuteNonQuery(); } command.CommandText = $"INSERT OR IGNORE INTO russian (sentence_ru, same_ru) VALUES (\"{r.Sentence_ru}\", {r.Same_ru})"; command.ExecuteNonQuery(); Translate t = new Translate() { Same_English = e.Same_eng, Same_Russian = r.Same_ru, DateAdd = DateTime.Now.ToString("yyyy.MM.dd") }; command.CommandText = $"INSERT OR IGNORE INTO translate (same_english, same_russian, dateadd) VALUES ({t.Same_English}, {t.Same_Russian}, \"{t.DateAdd}\")"; command.ExecuteNonQuery(); transaction.Commit(); } conn.Close(); } //English english = new English(); //Russian russian = new Russian(); ////List<int> listAnalogEnglish = new List<int>(); ////List<int> listAnalogRussian = new List<int>(); //using (SQLiteConnection conn = new SQLiteConnection(stringConnection)) //{ // conn.Open(); // using (SQLiteTransaction transaction = conn.BeginTransaction()) // { // using (SQLiteCommand command = new SQLiteCommand(conn)) // { // command.Transaction = transaction; // command.CommandText = $"SELECT id FROM english WHERE {nameof(English.Sentence).ToString().ToLower()} = \"{phrase.EnglishPhrase}\""; // object temp = command.ExecuteScalar(); // if (!(temp == null)) // english.ID = int.Parse(temp.ToString()); // command.CommandText = $"SELECT id FROM russian WHERE {nameof(Russian.Sentence).ToString().ToLower()} = \"{phrase.RussianPhrase}\""; // temp = command.ExecuteScalar(); // if (!(temp == null)) // russian.ID = int.Parse(temp.ToString()); // } // transaction.Commit(); // } // conn.Close(); //} //if (english.ID == 0) //{ // english.Sentence = phrase.EnglishPhrase; // english.Sound = phrase.Sound; // InsertRow(english); //} //if (russian.ID == 0) //{ // russian.Sentence = phrase.RussianPhrase; // InsertRow(russian); //} ////using (SQLiteConnection conn = new SQLiteConnection(stringConnection)) ////{ //// conn.Open(); //// using (SQLiteTransaction transaction = conn.BeginTransaction()) //// { //// using (SQLiteCommand command = new SQLiteCommand(conn)) //// { //// command.Transaction = transaction; //// command.CommandText = $"SELECT id_english FROM translate WHERE id_russian IN (SELECT id_russian FROM translate WHERE {nameof(Translate.ID_English).ToString().ToLower()} = \"{english.ID}\")"; //// using (SQLiteDataReader reader = command.ExecuteReader()) //// { //// while (reader.Read()) //// { //// int id = Convert.ToInt32(reader[nameof(Translate.ID_English).ToString().ToLower()]); //// listAnalogEnglish.Add(id); //// } //// } //// command.CommandText = $"SELECT id_russian FROM translate WHERE id_english IN (SELECT id_english FROM translate WHERE {nameof(Translate.ID_Russian).ToString().ToLower()} = \"{russian.ID}\")"; //// using (SQLiteDataReader reader = command.ExecuteReader()) //// { //// while (reader.Read()) //// { //// int id = Convert.ToInt32(reader[nameof(Translate.ID_Russian).ToString().ToLower()]); //// listAnalogRussian.Add(id); //// } //// } //// } //// transaction.Commit(); //// } //// conn.Close(); ////} //Translate trans = new Translate(); //trans.Same_English = english.Same; //trans.Same_Russian = russian.Same; //trans.DateAdd = DateTime.Now.ToString("yyyy.MM.dd"); //try //{ // InsertRow(trans); //} //catch //{ // MessageBox.Show($"Row same_eng={trans.Same_English} - same_rus={trans.Same_Russian}"); //} ////foreach (var item in listAnalogRussian) ////{ //// Translate translate = new Translate(); //// translate.ID_English = english.ID; //// translate.ID_Russian = item; //// translate.DateAdd = DateTime.Now.ToString("yyyy.MM.dd"); //// try //// { //// InsertRow(translate); //// } //// catch //// { //// MessageBox.Show($"Row id_eng={translate.ID_English} - id_rus={translate.ID_Russian}"); //// } ////} ////foreach (var item in listAnalogEnglish) ////{ //// Translate translate = new Translate(); //// translate.ID_English = item; //// translate.ID_Russian = russian.ID; //// translate.DateAdd = DateTime.Now.ToString("yyyy.MM.dd"); //// try //// { //// InsertRow(translate); //// } //// catch //// { //// MessageBox.Show($"Row id_eng={translate.ID_English} - id_rus={translate.ID_Russian}"); //// } ////} }