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