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