private async void Btn_saveReportlang_Click(object sender, RoutedEventArgs e)
{
// string msg = "";
int msg = 0;
if (cb_reportlang.SelectedIndex != -1)
{
replangrow = replangList.Where(r => r.valId == (int)cb_reportlang.SelectedValue).FirstOrDefault();
replangrow.isDefault = 1;
msg = await setvalueModel.Save(replangrow);
// replangrow.valId=
await MainWindow.GetReportlang();
await fillRepLang();
if (msg > 0)
{
Toaster.ShowSuccess(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopSave"), animation: ToasterAnimation.FadeIn);
}
else
{
Toaster.ShowWarning(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopError"), animation: ToasterAnimation.FadeIn);
}
}
}
async Task fillRepLang()
{
langcomboList = new List <Replang>();
replangList = await setvalueModel.GetBySetName("report_lang");
foreach (var reprow in replangList)
{
// trEnglish resourcemanager.GetString("trMenu");
//trArabic
Replang comborow = new Replang();
comborow.langId = reprow.valId;
comborow.lang = reprow.value;
if (reprow.value == "ar")
{
comborow.trlang = MainWindow.resourcemanager.GetString("trArabic");
}
else if (reprow.value == "en")
{
comborow.trlang = MainWindow.resourcemanager.GetString("trEnglish");
}
else
{
comborow.trlang = "";
}
langcomboList.Add(comborow);
}
cb_reportlang.ItemsSource = langcomboList;
cb_reportlang.DisplayMemberPath = "trlang";
cb_reportlang.SelectedValuePath = "langId";
replangrow = replangList.Where(r => r.isDefault == 1).FirstOrDefault();
cb_reportlang.SelectedValue = replangrow.valId;
}
public string getshowHeader()
{
show_header_row = printList.Where(X => X.name == "show_header").FirstOrDefault();
show_header = show_header_row.value;
return(show_header);
}
public async Task <string> getdata()
{
PayOpModel = new PayOp();
PayOpModel = await PayOpModel.getLastPayOp(packUserRep.packageUserId);
if (PayOpModel.payOpId <= 0)
{
return("0");
}
else
{
agentmodel = await agentmodel.GetByID((int)packUserRep.userId);
cumstomerModel = await cumstomerModel.GetByID((int)packUserRep.customerId);
CountryPackageDateModel = await CountryPackageDateModel.GetByID((int)PayOpModel.countryPackageId);
PackagesModel = await PackagesModel.GetByID((int)PayOpModel.packageId);
SetValuesList = await terms.GetBySetName("sale_note");
terms = SetValuesList.FirstOrDefault();
// CountryPackageDateModel.monthCount;
return("1");
}
}
private async void Window_Loaded(object sender, RoutedEventArgs e)
{//load
try
{
HelpClass.StartAwait(grid_main);
// sale_note
requiredControlList = new List <string> {
""
};
#region translate
if (MainWindow.lang.Equals("en"))
{
grid_main.FlowDirection = FlowDirection.LeftToRight;
}
else
{
grid_main.FlowDirection = FlowDirection.RightToLeft;
}
translat();
#endregion
// List<SettingCls> settingsCls = await setModel.GetAll();
List <SetValues> settingsValues = await valueModel.GetBySetName("sale_note");
setVNote = settingsValues.FirstOrDefault();
tb_notes.Text = setVNote.value;
HelpClass.EndAwait(grid_main);
}
catch (Exception ex)
{
HelpClass.EndAwait(grid_main);
HelpClass.ExceptionMessage(ex, this);
}
}
public static async Task <SetValues> getDefaultPrintCount()
{
List <SettingCls> settingsCls = await setModel.GetAll();
List <SetValues> settingsValues = await valueModel.GetAll();
set = settingsCls.Where(s => s.name == "Allow_print_inv_count").FirstOrDefault <SettingCls>();
printCountId = set.settingId;
printCount = settingsValues.Where(i => i.settingId == printCountId).FirstOrDefault();
return(printCount);
}
private async Task <string> getUserLanguage(int userId)
{
SettingCls setModel = new SettingCls();
SettingCls set = new SettingCls();
SetValues valueModel = new SetValues();
List <SetValues> languages = new List <SetValues>();
UserSetValues usValueModel = new UserSetValues();
var lanSettings = await setModel.GetAll();
set = lanSettings.Where(l => l.name == "language").FirstOrDefault <SettingCls>();
var lanValues = await valueModel.GetAll();
if (lanValues.Count > 0)
{
languages = lanValues.Where(vl => vl.settingId == set.settingId).ToList <SetValues>();
usValues = await usValueModel.GetAll();
if (usValues.Count > 0)
{
var curUserValues = usValues.Where(c => c.userId == userId);
if (curUserValues.Count() > 0)
{
foreach (var l in curUserValues)
{
if (languages.Any(c => c.valId == l.valId))
{
usLanguage = l;
}
}
var lan = await valueModel.GetByID(usLanguage.valId.Value);
return(lan.value);
}
else
{
return("en");
}
}
else
{
return("en");
}
}
else
{
return("en");
}
}
private async void Btn_printCount_Click(object sender, RoutedEventArgs e)
{//save print count
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
SectionData.validateEmptyTextBox(tb_printCount, p_errorPrintCount, tt_errorPrintCount, "trEmptyPrintCount");
if (!tb_printCount.Text.Equals(""))
{
if (printCount == null)
{
printCount = new SetValues();
}
printCount.value = tb_printCount.Text;
printCount.isSystem = 1;
printCount.isDefault = 1;
printCount.settingId = printCountId;
int s = await valueModel.Save(printCount);
if (!s.Equals(0))
{
//update tax in main window
MainWindow.Allow_print_inv_count = printCount.value;
Toaster.ShowSuccess(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopSave"), animation: ToasterAnimation.FadeIn);
}
else
{
Toaster.ShowWarning(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopError"), animation: ToasterAnimation.FadeIn);
}
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
protected virtual string ToSingleSqlString(List <IGrouping <int, DbColumnInfo> > groupList)
{
string columnsString = string.Join(",", groupList.First().Where(it => it.IsPrimarykey == false && (it.IsIdentity == false || (IsOffIdentity && it.IsIdentity))).Select(it =>
{
if (SetValues.IsValuable())
{
var setValue = SetValues.Where(sv => it.IsPrimarykey == false && (it.IsIdentity == false || (IsOffIdentity && it.IsIdentity))).Where(sv => sv.Key == Builder.GetTranslationColumnName(it.DbColumnName) || sv.Key == Builder.GetTranslationColumnName(it.PropertyName));
if (setValue != null && setValue.Any())
{
return(setValue.First().Value);
}
}
var result = Builder.GetTranslationColumnName(it.DbColumnName) + "=" + this.Context.Ado.SqlParameterKeyWord + it.DbColumnName;
return(result);
}));
string whereString = null;
if (this.WhereValues.HasValue())
{
foreach (var item in WhereValues)
{
var isFirst = whereString == null;
whereString += (isFirst ? " WHERE " : " AND ");
whereString += item;
}
}
else if (PrimaryKeys.HasValue())
{
if (IsWhereColumns == false)
{
foreach (var item in PrimaryKeys)
{
var isFirst = whereString == null;
whereString += (isFirst ? " WHERE " : " AND ");
whereString += Builder.GetTranslationColumnName(item) + "=" + this.Context.Ado.SqlParameterKeyWord + item;
}
}
}
if (PrimaryKeys.HasValue() && IsWhereColumns)
{
foreach (var item in PrimaryKeys)
{
var isFirst = whereString == null;
whereString += (isFirst ? " WHERE " : " AND ");
whereString += Builder.GetTranslationColumnName(item) + "=" + this.Context.Ado.SqlParameterKeyWord + item;
}
}
return(string.Format(SqlTemplate, GetTableNameString, columnsString, whereString));
}
private async void Btn_itemsTaxNote_Click(object sender, RoutedEventArgs e)
{
try
{
SectionData.StartAwait(grid_main);
Window.GetWindow(this).Opacity = 0.2;
wd_notes w = new wd_notes();
w.maxLength = 100;
// w.note = "Test note...";
itemtax_note_row = printList.Where(X => X.name == "itemtax_note").FirstOrDefault();
itemtax_note = itemtax_note_row.value;
w.note = itemtax_note;
w.ShowDialog();
if (w.isOk)
{
// MessageBox.Show(w.note);
//save
int res = 0;
itemtax_note_row.value = w.note.Trim();
res = await setvalueModel.Save(itemtax_note_row);
if (res > 0)
{
Toaster.ShowSuccess(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopSave"), animation: ToasterAnimation.FadeIn);
}
else
{
Toaster.ShowWarning(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopError"), animation: ToasterAnimation.FadeIn);
}
await FillprintList();
await MainWindow.Getprintparameter();
}
Window.GetWindow(this).Opacity = 1;
SectionData.EndAwait(grid_main);
}
catch (Exception ex)
{
SectionData.EndAwait(grid_main);
SectionData.ExceptionMessage(ex, this);
}
}
async Task refreshWindow()
{
printList = await setvalueModel.GetBySetvalNote("print");
sale_copy_countrow = printList.Where(X => X.name == "sale_copy_count").FirstOrDefault();
sale_copy_count = sale_copy_countrow.value;
pur_copy_countrow = printList.Where(X => X.name == "pur_copy_count").FirstOrDefault();
pur_copy_count = pur_copy_countrow.value;
rep_copy_countrow = printList.Where(X => X.name == "rep_copy_count").FirstOrDefault();
rep_copy_count = rep_copy_countrow.value;
directentry_copy_countrow = printList.Where(X => X.name == "directentry_copy_count").FirstOrDefault();
directentry_copy_count = directentry_copy_countrow.value;
tb_purCopyCount.Text = pur_copy_count;
tb_saleCopyCount.Text = sale_copy_count;
tb_repPrintCount.Text = rep_copy_count;
tb_directEntry.Text = directentry_copy_count;
}
private async Task getUserPath()
{
#region get user path
UserSetValues uSetValueModel = new UserSetValues();
List <UserSetValues> lst = await uSetValueModel.GetAll();
SetValues setValueModel = new SetValues();
List <SetValues> setVLst = await setValueModel.GetBySetName("user_path");
firstId = setVLst[0].valId;
secondId = setVLst[1].valId;
//string firstPath = "" , secondPath = "";
try
{
firstUserSetValue = lst.Where(u => u.valId == firstId && u.userId == MainWindow.userID).FirstOrDefault();
secondUserSetValue = lst.Where(u => u.valId == secondId && u.userId == MainWindow.userID).FirstOrDefault();
foreach (var o in newlist)
{
if (o.name.Equals(SectionData.translate(firstUserSetValue.note)))
{
cb_firstLevel.SelectedValue = o.objectId;
break;
}
}
foreach (var o in newlist2)
{
if (o.name.Equals(SectionData.translate(secondUserSetValue.note)))
{
cb_secondLevel.SelectedValue = o.objectId;
break;
}
}
//cb_firstLevel.SelectedValue = cb_firstLevel.Items.IndexOf(firstUserSetValue.note);
}
catch { cb_firstLevel.SelectedIndex = -1; }
#endregion
}
async Task Getprintparameter()
{
printList = await setvalueModel.GetBySetvalNote("print");
print_on_save_salerow = printList.Where(X => X.name == "print_on_save_sale").FirstOrDefault();
print_on_save_sale = print_on_save_salerow.value;
//print_on_save_purrow = printList.Where(X => X.name == "print_on_save_pur").FirstOrDefault();
//print_on_save_pur = print_on_save_purrow.value;
email_on_save_salerow = printList.Where(X => X.name == "email_on_save_sale").FirstOrDefault();
email_on_save_sale = email_on_save_salerow.value;
//email_on_save_purrow = printList.Where(X => X.name == "email_on_save_pur").FirstOrDefault();
//email_on_save_pur = email_on_save_purrow.value;
if (print_on_save_sale == "1")
{
tgl_printOnSaveSale.IsChecked = true;
}
else
{
tgl_printOnSaveSale.IsChecked = false;
}
//
//////////////////
if (email_on_save_sale == "1")
{
tgl_emailOnSaveSale.IsChecked = true;
}
else
{
tgl_emailOnSaveSale.IsChecked = false;
}
}
private async Task saveTax()
{
if (!tb_tax.Text.Equals(""))
{
var setTax = set.Where(t => t.name == "tax").FirstOrDefault();
SetValues tax = new SetValues();
tax.value = tb_tax.Text;
tax.isSystem = 1;
tax.settingId = setTax.settingId;
int s = await valueModel.Save(tax);
if (!s.Equals(0))
{
//update tax in main window
MainWindow.tax = decimal.Parse(tax.value);
}
}
else
{
MainWindow.tax = 0;
}
}
private async Task saveDateform()
{
if (!cb_dateForm.Text.Equals(""))
{
var setDate = set.Where(t => t.name == "dateForm").FirstOrDefault();
SetValues dateForm = new SetValues();
dateForm.value = cb_dateForm.SelectedValue.ToString();
dateForm.isSystem = 1;
dateForm.settingId = setDate.settingId;
int s = await valueModel.Save(dateForm);
if (!s.Equals("0"))
{
//update dateForm in main window
MainWindow.dateFormat = dateForm.value;
}
}
else
{
MainWindow.dateFormat = "ShortDatePattern";
}
}
/// <summary>
/// Метод предлагает сделать изменения выбранной программы.
/// </summary>
public virtual void SetOfProgramChanges()
{
ShowMessages.ShowProgramChanges();
int selectionChanges = SetValues.ListOfChanges();
switch (selectionChanges)
{
case 1:
ShowMessages.ShowTemperatureChanges();
int selectionTemp = SetValues.ListOfTemperatureChanges();
switch (selectionTemp)
{
case 1:
_temperature = 0;
MoreChanges();
break;
case 2:
_temperature = 30;
MoreChanges();
break;
case 3:
_temperature = 40;
MoreChanges();
break;
case 4:
_temperature = 60;
MoreChanges();
break;
case 5:
_temperature = 95;
MoreChanges();
break;
}
break;
case 2:
ShowMessages.ShowRinseChanges();
int selectionRinse = SetValues.ListOfRinseChanges();
switch (selectionRinse)
{
case 1:
_numbRinses = 1;
MoreChanges();
break;
case 2:
_numbRinses = 2;
MoreChanges();
break;
case 3:
_numbRinses = 3;
MoreChanges();
break;
}
break;
case 3:
ShowMessages.ShowSpinningChanges();
int selectionSpinning = SetValues.ListOfSpinningChanges();
switch (selectionSpinning)
{
case 1:
_spinning = 0;
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("*Отжим отключен!");
Console.WriteLine("---------------");
Console.ResetColor();
MoreChanges();
break;
case 2:
_spinning = 400;
MoreChanges();
break;
case 3:
_spinning = 600;
MoreChanges();
break;
case 4:
_spinning = 800;
MoreChanges();
break;
case 5:
_spinning = 1000;
MoreChanges();
break;
case 6:
_spinning = 1200;
MoreChanges();
break;
}
break;
case 4:
ShowMessages.ShowEcobubleChanges();
int selectionEcobuble = SetValues.ListOfEcobubleChanges();
switch (selectionEcobuble)
{
case 1:
_ecobuble = "Включен";
MoreChanges();
break;
case 2:
_ecobuble = "Выключен";
MoreChanges();
break;
}
break;
case 5:
Console.Clear();
ShowMessages.ListOfPrograms();
SetValues.SelectionConditionsProgram();
break;
case 0:
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Стирка началась без изменений программы...");
Console.ResetColor();
break;
}
}
private async void Btn_save_Click(object sender, RoutedEventArgs e)
{//save
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
#region validate
if (tgl_invoiceTax.IsChecked == true)
{
SectionData.validateEmptyTextBox(tb_invoiceTax, p_errorInvoiceTax, tt_errorInvoiceTax, "trEmptyTax");
}
else
{
SectionData.clearValidate(tb_invoiceTax, p_errorInvoiceTax);
}
if (tgl_itemsTax.IsChecked == true)
{
SectionData.validateEmptyTextBox(tb_itemsTax, p_errorItemsTax, tt_errorItemsTax, "trEmptyTax");
}
else
{
SectionData.clearValidate(tb_itemsTax, p_errorItemsTax);
}
#endregion
if ((!tb_invoiceTax.Text.Equals("")))
{
if (setVInvoiceBool == null)
{
setVInvoiceBool = new SetValues();
}
//save bool invoice tax
setVInvoiceBool.value = tgl_invoiceTax.IsChecked.ToString();
setVInvoiceBool.isSystem = 1;
setVInvoiceBool.settingId = setInvoiceBool.settingId;
int invoiceBoolRes = await setValuesModel.Save(setVInvoiceBool);
if (setVInvoice == null)
{
setVInvoice = new SetValues();
}
//save invoice tax
string invTax = "0.000";
if (tgl_invoiceTax.IsChecked == true)
{
decimal d = decimal.Parse(tb_invoiceTax.Text); invTax = String.Format("{0:0.000}", d);
}
else
{
invTax = "0.000";
}
setVInvoice.value = invTax;
setVInvoice.isSystem = 1;
setVInvoice.settingId = setInvoice.settingId;
int invoiceRes = await setValuesModel.Save(setVInvoice);
if (setVItemBool == null)
{
setVItemBool = new SetValues();
}
//save bool item tax
setVItemBool.value = tgl_itemsTax.IsChecked.ToString();
setVItemBool.isSystem = 1;
setVItemBool.settingId = setItemBool.settingId;
int itemBoolRes = await setValuesModel.Save(setVItemBool);
if (setVItem == null)
{
setVItem = new SetValues();
}
//save item tax
string itemTax = "0.000";
if (tgl_itemsTax.IsChecked == true)
{
decimal d = decimal.Parse(tb_itemsTax.Text); itemTax = String.Format("{0:0.000}", d);
}
else
{
itemTax = "0.000";
}
setVItem.value = itemTax;
setVItem.isSystem = 1;
setVItem.settingId = setItem.settingId;
int itemRes = await setValuesModel.Save(setVItem);
if ((invoiceBoolRes > 0) && (invoiceRes > 0) && (itemBoolRes > 0) && (itemRes > 0))
{
//update tax in main window
MainWindow.invoiceTax_bool = bool.Parse(setVInvoiceBool.value);
MainWindow.invoiceTax_decimal = decimal.Parse(setVInvoice.value);
MainWindow.itemsTax_bool = bool.Parse(setVItemBool.value);
MainWindow.itemsTax_decimal = decimal.Parse(setVItem.value);
Toaster.ShowSuccess(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopSave"), animation: ToasterAnimation.FadeIn);
this.Close();
}
else
{
Toaster.ShowWarning(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trPopError"), animation: ToasterAnimation.FadeIn);
}
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
async Task Getprintparameter()
{
printList = await setvalueModel.GetBySetvalNote("print");
print_on_save_salerow = printList.Where(X => X.name == "print_on_save_sale").FirstOrDefault();
print_on_save_sale = print_on_save_salerow.value;
print_on_save_purrow = printList.Where(X => X.name == "print_on_save_pur").FirstOrDefault();
print_on_save_pur = print_on_save_purrow.value;
email_on_save_salerow = printList.Where(X => X.name == "email_on_save_sale").FirstOrDefault();
email_on_save_sale = email_on_save_salerow.value;
email_on_save_purrow = printList.Where(X => X.name == "email_on_save_pur").FirstOrDefault();
email_on_save_pur = email_on_save_purrow.value;
show_header_row = printList.Where(X => X.name == "show_header").FirstOrDefault();
show_header = show_header_row.value;
print_on_save_directentryrow = printList.Where(X => X.name == "print_on_save_directentry").FirstOrDefault();
print_on_save_directentry = print_on_save_directentryrow.value;
if (print_on_save_pur == "1")
{
tgl_printOnSavePur.IsChecked = true;
}
else
{
tgl_printOnSavePur.IsChecked = false;
}
//
if (print_on_save_sale == "1")
{
tgl_printOnSaveSale.IsChecked = true;
}
else
{
tgl_printOnSaveSale.IsChecked = false;
}
//
if (email_on_save_pur == "1")
{
tgl_emailOnSavePur.IsChecked = true;
}
else
{
tgl_emailOnSavePur.IsChecked = false;
}
//////////////////
if (email_on_save_sale == "1")
{
tgl_emailOnSaveSale.IsChecked = true;
}
else
{
tgl_emailOnSaveSale.IsChecked = false;
}
if (show_header == "1")
{
tgl_showHeader.IsChecked = true;
}
else
{
tgl_showHeader.IsChecked = false;
}
if (print_on_save_directentry == "1")
{
tgl_directEntry.IsChecked = true;
}
else
{
tgl_directEntry.IsChecked = false;
}
/*
* tgl_printOnSaveSale
* tgl_emailOnSavePur
* tgl_emailOnSaveSale
*/
}
private async void Window_Loaded(object sender, RoutedEventArgs e)
{//load
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
#region translate
if (winLogIn.lang.Equals("en"))
{
winLogIn.resourcemanager = new ResourceManager("POS.en_file", Assembly.GetExecutingAssembly());
grid_main.FlowDirection = FlowDirection.LeftToRight;
}
else
{
winLogIn.resourcemanager = new ResourceManager("POS.ar_file", Assembly.GetExecutingAssembly());
grid_main.FlowDirection = FlowDirection.RightToLeft;
}
translate();
#endregion
valuesLst = await setValuesModel.GetBySetvalNote("tax");
settingsLst = await settingModel.GetAll();
//get settingIds
setInvoiceBool = settingsLst.Where(v => v.name == "invoiceTax_bool").FirstOrDefault();
setInvoice = settingsLst.Where(v => v.name == "invoiceTax_decimal").FirstOrDefault();
setItemBool = settingsLst.Where(v => v.name == "itemsTax_bool").FirstOrDefault();
setItem = settingsLst.Where(v => v.name == "itemsTax_decimal").FirstOrDefault();
setVInvoiceBool = valuesLst.Where(v => v.settingId == setInvoiceBool.settingId).FirstOrDefault();
setVInvoice = valuesLst.Where(v => v.settingId == setInvoice.settingId).FirstOrDefault();
setVItemBool = valuesLst.Where(v => v.settingId == setItemBool.settingId).FirstOrDefault();
setVItem = valuesLst.Where(v => v.settingId == setItem.settingId).FirstOrDefault();
if (setVInvoiceBool != null)
{
tgl_invoiceTax.IsChecked = Convert.ToBoolean(setVInvoiceBool.value);
}
else
{
tgl_invoiceTax.IsChecked = false;
}
if (setVInvoice != null)
{
decimal d = decimal.Parse(setVInvoice.value);
tb_invoiceTax.Text = SectionData.PercentageDecTostring(d);
}
else
{
tb_invoiceTax.Text = "";
}
if (setVItemBool != null)
{
tgl_itemsTax.IsChecked = Convert.ToBoolean(setVItemBool.value);
}
else
{
tgl_itemsTax.IsChecked = false;
}
if (setVItem != null)
{
decimal d = decimal.Parse(setVItem.value);
tb_itemsTax.Text = SectionData.PercentageDecTostring(d);
}
else
{
tb_itemsTax.Text = "";
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
private async void Window_Loaded(object sender, RoutedEventArgs e)
{//load
try
{
if (sender != null)
{
HelpClass.StartAwait(grid_main);
}
requiredControlList = new List <string> {
"name", "address", "email", "mobile"
};
await fillCountries();
await fillCity();
List <SettingCls> settingsCls = await setModel.GetAll();
List <SetValues> settingsValues = await valueModel.GetAll();
#region get settings Ids
//get company name id
set = settingsCls.Where(s => s.name == "com_name").FirstOrDefault <SettingCls>();
nameId = set.settingId;
setVName = settingsValues.Where(i => i.settingId == nameId).FirstOrDefault();
//get company address id
set = settingsCls.Where(s => s.name == "com_address").FirstOrDefault <SettingCls>();
addressId = set.settingId;
setVAddress = settingsValues.Where(i => i.settingId == addressId).FirstOrDefault();
//get company email id
set = settingsCls.Where(s => s.name == "com_email").FirstOrDefault <SettingCls>();
emailId = set.settingId;
setVEmail = settingsValues.Where(i => i.settingId == emailId).FirstOrDefault();
//get company mobile id
set = settingsCls.Where(s => s.name == "com_mobile").FirstOrDefault <SettingCls>();
mobileId = set.settingId;
setVMobile = settingsValues.Where(i => i.settingId == mobileId).FirstOrDefault();
//get company phone id
set = settingsCls.Where(s => s.name == "com_phone").FirstOrDefault <SettingCls>();
phoneId = set.settingId;
setVPhone = settingsValues.Where(i => i.settingId == phoneId).FirstOrDefault();
//get company fax id
set = settingsCls.Where(s => s.name == "com_fax").FirstOrDefault <SettingCls>();
faxId = set.settingId;
setVFax = settingsValues.Where(i => i.settingId == faxId).FirstOrDefault();
//get company logo id
set = settingsCls.Where(s => s.name == "com_logo").FirstOrDefault <SettingCls>();
logoId = set.settingId;
setVLogo = settingsValues.Where(i => i.settingId == logoId).FirstOrDefault();
#endregion
if (!isFirstTime)
{
#region translate
if (MainWindow.lang.Equals("en"))
{
//MainWindow.resourcemanager = new ResourceManager("POS.en_file", Assembly.GetExecutingAssembly());
grid_main.FlowDirection = FlowDirection.LeftToRight;
}
else
{
//MainWindow.resourcemanager = new ResourceManager("POS.ar_file", Assembly.GetExecutingAssembly());
grid_main.FlowDirection = FlowDirection.RightToLeft;
}
translate();
#endregion
#region get values
//get company name
tb_name.Text = setVName.value;
//get company address
tb_address.Text = setVAddress.value;
//get company email
tb_email.Text = setVEmail.value;
//get company mobile
HelpClass.getMobile(setVMobile.value, cb_areaMobile, tb_mobile);
//get company phone
HelpClass.getPhone(setVPhone.value, cb_areaPhone, cb_areaPhoneLocal, tb_phone);
//get company fax
HelpClass.getPhone(setVFax.value, cb_areaFax, cb_areaFaxLocal, tb_fax);
//get company logo
await getImg();
#endregion
}
if (sender != null)
{
HelpClass.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
HelpClass.EndAwait(grid_main);
}
HelpClass.ExceptionMessage(ex, this);
}
}
protected internal void SetValue(SetValues value)
{
_flags = _flags | (int)value;
}
private async void Btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
if (sender != null)
{
HelpClass.StartAwait(grid_main);
}
//write here Mr.Naji
/////
int msg = 0;
setValues = setValuessQuery.Where(x => x.notes == "title").FirstOrDefault();
setValues.value = tb_title.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
//
setValues = setValuessQuery.Where(x => x.notes == "text1").FirstOrDefault();
setValues.value = tb_text1.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "text2").FirstOrDefault();
setValues.value = tb_text2.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link1text").FirstOrDefault();
setValues.value = tb_link1text.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link2text").FirstOrDefault();
setValues.value = tb_link2text.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link3text").FirstOrDefault();
setValues.value = tb_link3text.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link1url").FirstOrDefault();
setValues.value = tb_link1url.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link2url").FirstOrDefault();
setValues.value = tb_link2url.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link3url").FirstOrDefault();
setValues.value = tb_link3url.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
if (sender != null)
{
HelpClass.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
HelpClass.EndAwait(grid_main);
}
HelpClass.ExceptionMessage(ex, this);
}
}
public override void SetOfProgramChanges()
{
ShowMessages.ShowRinsePlusSpinCanges();
int selectionChanges = SetValues.ListOfRinsePlusSpinWash();
switch (selectionChanges)
{
case 1:
ShowMessages.ShowRinseChanges();
int selectionRinse = SetValues.ListOfRinseChanges();
switch (selectionRinse)
{
case 1:
_numbRinses = 1;
MoreChanges();
break;
case 2:
_numbRinses = 2;
MoreChanges();
break;
case 3:
_numbRinses = 3;
MoreChanges();
break;
}
break;
case 2:
ShowMessages.ShowSpinningChanges();
int selectionSpinning = SetValues.ListOfSpinningChanges();
switch (selectionSpinning)
{
case 1:
_spinning = 0;
MoreChanges();
break;
case 2:
_spinning = 400;
MoreChanges();
break;
case 3:
_spinning = 600;
MoreChanges();
break;
case 4:
_spinning = 800;
MoreChanges();
break;
case 5:
_spinning = 1000;
MoreChanges();
break;
case 6:
_spinning = 1200;
MoreChanges();
break;
}
break;
case 0:
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Стирка началась без изменений программы...");
Console.ResetColor();
break;
}
}
protected internal bool IsSet(SetValues value)
{
return((_flags & (int)value) > 0);
}
public void TestMethod1()
{
SetValues sv = new SetValues();
sv.SetThreeToDatabase();
}
protected internal void ClearValue(SetValues value)
{
_flags = _flags & ~(int)value;
}
protected override string TomultipleSqlString(List <IGrouping <int, DbColumnInfo> > groupList)
{
Check.Exception(PrimaryKeys == null || PrimaryKeys.Count == 0, " Update List<T> need Primary key");
int pageSize = 200;
int pageIndex = 1;
int totalRecord = groupList.Count;
int pageCount = (totalRecord + pageSize - 1) / pageSize;
StringBuilder batchUpdateSql = new StringBuilder();
while (pageCount >= pageIndex)
{
StringBuilder updateTable = new StringBuilder();
string setValues = string.Join(",", groupList.First().Where(it => it.IsPrimarykey == false && (it.IsIdentity == false || (IsOffIdentity && it.IsIdentity))).Select(it =>
{
if (SetValues.IsValuable())
{
var setValue = SetValues.Where(sv => sv.Key == Builder.GetTranslationColumnName(it.DbColumnName));
if (setValue != null && setValue.Any())
{
return(setValue.First().Value);
}
}
var result = string.Format("{0}=T.{0}", Builder.GetTranslationColumnName(it.DbColumnName));
return(result);
}));
string tempColumnValue = string.Join(",", groupList.First().Select(it =>
{
if (SetValues.IsValuable())
{
var setValue = SetValues.Where(sv => sv.Key == Builder.GetTranslationColumnName(it.DbColumnName));
if (setValue != null && setValue.Any())
{
return(setValue.First().Value);
}
}
var result = Builder.GetTranslationColumnName(it.DbColumnName);
return(result);
}));
batchUpdateSql.AppendFormat(SqlTemplateBatch.ToString(), setValues, GetTableNameStringNoWith, TableWithString);
int i = 0;
var tableColumnList = this.Context.DbMaintenance.GetColumnInfosByTableName(GetTableNameStringNoWith);
foreach (var columns in groupList.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList())
{
var isFirst = i == 0;
if (!isFirst)
{
updateTable.Append(SqlTemplateBatchUnion);
}
updateTable.Append("\r\n (" + string.Join(",", columns.Select(it =>
{
var columnInfo = tableColumnList.FirstOrDefault(x => x.DbColumnName.Equals(it.DbColumnName, StringComparison.OrdinalIgnoreCase));
var dbType = columnInfo?.DataType;
if (dbType == null)
{
var typeName = it.PropertyType.Name.ToLower();
if (typeName == "int32")
{
typeName = "int";
}
if (typeName == "int64")
{
typeName = "long";
}
if (typeName == "int16")
{
typeName = "short";
}
var isAnyType = PostgreSQLDbBind.MappingTypesConst.Where(x => x.Value.ToString().ToLower() == typeName).Any();
if (isAnyType)
{
dbType = PostgreSQLDbBind.MappingTypesConst.Where(x => x.Value.ToString().ToLower() == typeName).FirstOrDefault().Key;
}
else
{
dbType = "varchar";
}
}
return(string.Format("CAST({0} AS {1})", FormatValue(it.Value), dbType));
})) + ")");
++i;
}
pageIndex++;
updateTable.Append("\r\n");
string whereString = null;
if (this.WhereValues.HasValue())
{
foreach (var item in WhereValues)
{
var isFirst = whereString == null;
whereString += (isFirst ? null : " AND ");
whereString += item;
}
}
else if (PrimaryKeys.HasValue())
{
foreach (var item in PrimaryKeys)
{
var isFirst = whereString == null;
whereString += (isFirst ? null : " AND ");
whereString += string.Format("{0}.{1}=T.{1}", GetTableNameStringNoWith, Builder.GetTranslationColumnName(item));
}
}
var format = string.Format(SqlTemplateJoin, updateTable, whereString, tempColumnValue);
batchUpdateSql.Replace("${0}", format);
batchUpdateSql.Append(";");
}
return(batchUpdateSql.ToString());
}
protected virtual string TomultipleSqlString(List <IGrouping <int, DbColumnInfo> > groupList)
{
Check.Exception(PrimaryKeys == null || PrimaryKeys.Count == 0, " Update List<T> need Primary key");
int pageSize = 200;
int pageIndex = 1;
int totalRecord = groupList.Count;
int pageCount = (totalRecord + pageSize - 1) / pageSize;
StringBuilder batchUpdateSql = new StringBuilder();
while (pageCount >= pageIndex)
{
StringBuilder updateTable = new StringBuilder();
string setValues = string.Join(",", groupList.First().Where(it => it.IsPrimarykey == false && (it.IsIdentity == false || (IsOffIdentity && it.IsIdentity))).Select(it =>
{
if (SetValues.IsValuable())
{
var setValue = SetValues.Where(sv => sv.Key == Builder.GetTranslationColumnName(it.DbColumnName));
if (setValue != null && setValue.Any())
{
return(setValue.First().Value);
}
}
var result = string.Format("S.{0}=T.{0}", Builder.GetTranslationColumnName(it.DbColumnName));
return(result);
}));
batchUpdateSql.AppendFormat(SqlTemplateBatch.ToString(), setValues, GetTableNameStringNoWith, TableWithString);
int i = 0;
foreach (var columns in groupList.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList())
{
var isFirst = i == 0;
if (!isFirst)
{
updateTable.Append(SqlTemplateBatchUnion);
}
updateTable.Append("\r\n SELECT " + string.Join(",", columns.Select(it => string.Format(SqlTemplateBatchSelect, FormatValue(it.Value), Builder.GetTranslationColumnName(it.DbColumnName)))));
++i;
}
pageIndex++;
updateTable.Append("\r\n");
string whereString = null;
if (this.WhereValues.HasValue())
{
foreach (var item in WhereValues)
{
var isFirst = whereString == null;
whereString += (isFirst ? null : " AND ");
whereString += Regex.Replace(item, "\\" + this.Builder.SqlTranslationLeft, "S." + this.Builder.SqlTranslationLeft);
}
}
if (PrimaryKeys.HasValue())
{
foreach (var item in PrimaryKeys)
{
var isFirst = whereString == null;
whereString += (isFirst ? null : " AND ");
whereString += string.Format("S.{0}=T.{0}", Builder.GetTranslationColumnName(item));
}
}
batchUpdateSql.AppendFormat(SqlTemplateJoin, updateTable, whereString);
}
return(batchUpdateSql.ToString());
}
private async void Btn_save_Click(object sender, RoutedEventArgs e)
{//update
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
if (MainWindow.groupObject.HasPermissionAction(savePermission, MainWindow.groupObjects, "one"))
{
//write here Mr.Naji
/////
int msg = 0;
setValues = setValuessQuery.Where(x => x.notes == "title").FirstOrDefault();
setValues.value = tb_title.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
//
setValues = setValuessQuery.Where(x => x.notes == "text1").FirstOrDefault();
setValues.value = tb_text1.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "text2").FirstOrDefault();
setValues.value = tb_text2.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link1text").FirstOrDefault();
setValues.value = tb_link1text.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link2text").FirstOrDefault();
setValues.value = tb_link2text.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link3text").FirstOrDefault();
setValues.value = tb_link3text.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link1url").FirstOrDefault();
setValues.value = tb_link1url.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link2url").FirstOrDefault();
setValues.value = tb_link2url.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
setValues = setValuessQuery.Where(x => x.notes == "link3url").FirstOrDefault();
setValues.value = tb_link3url.Text;
msg += await setValuesModel.SaveValueByNotes(setValues);
}
else
{
Toaster.ShowInfo(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trdontHavePermission"), animation: ToasterAnimation.FadeIn);
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
