private void k100_() { try { Barco = Barcode.Text + "\n"; DataTable Datatable = new DataTable(); DataTable _datatable = new DataTable(); var OracleData = new Assest.OrcDataAcess(); OracleData.Show(Datatable); listStrings.Clear(); listStrings1.Clear(); listStrings2.Clear(); liqua.Clear(); liststring4.Clear(); foreach (DataRow Dt in Datatable.Rows) { listStrings.Add(Dt.Field <string>("BARCODE")); listStrings1.Add(Dt.Field <string>("NAME")); listStrings2.Add(Dt.Field <string>("PRICE")); liqua.Add(Dt.Field <string>("QUANTITY")); liststring4.Add(Dt.Field <String>("ID")); liststring8.Add(Dt.Field <String>("Dis")); } int numric = 0; for (int i = 0; i < listStrings.Count; i++) { if (listStrings[i] == Barcode.Text || listStrings[i] == Barcode.Text + "\n") { Name.Text = listStrings1[i]; price.Text = getwholeprice(i, listStrings2, liststring8).ToString(); Quan_li = int.Parse(liqua[i]); id_li = liststring4[i]; numric++; break; } } if (numric == 0) { DXMessageBox.Show("لم يتم العثور على نتيجة", "خطـأ", MessageBoxButton.OK, MessageBoxImage.Error); Exists = 0; } if (numric != 0) { Exists = 1; PPP(); } } catch (Exception ex) { } }
public ObservableCollectionCore <Coustomer> Sales(string name) { var NAME = new List <string>(); var PRICE = new List <string>(); var PRICE_A = new List <string>(); var DAT = new List <string>(); var QUANTITY = new List <string>(); var BARCODE = new List <string>(); var Dis = new List <string>(); var Price_F = new List <string>(); var ID = new List <string>(); DataTable dt = new DataTable(); var Getdata = new Assest.OrcDataAcess(); Getdata.Show(dt); foreach (DataRow item in dt.Rows) { NAME.Add(item.Field <String>("NAME")); PRICE.Add(item.Field <String>("PRICE")); PRICE_A.Add(item.Field <String>("PRICE_A")); DAT.Add(item.Field <String>("DAT")); QUANTITY.Add(item.Field <String>("QUANTITY")); BARCODE.Add(item.Field <String>("BARCODE")); Dis.Add(item.Field <String>("Dis")); Price_F.Add(item.Field <String>("Price_F")); ID.Add(item.Field <String>("ID")); } ObservableCollectionCore <Coustomer> sales = new ObservableCollectionCore <Coustomer>(); for (int i = 0; i < NAME.Count; i++) { if (NAME[i].Contains(name)) { sales.Add(new Coustomer() { QUANTITY = QUANTITY[i], NAME = NAME[i], BARCODE = BARCODE[i], DAT = DAT[i], PRICE_A = PRICE_A[i], Dis = Dis[i], PRICE = PRICE[i], Price_F = Price_F[i], ID = ID[i], }); } } return(sales); }
public static void FillData(DevExpress.Xpf.Grid.GridControl GC) { var helper = new HelperData <Coustomer>(); var datatable = new System.Data.DataTable(); var GetData = new Assest.OrcDataAcess(); GetData.Show(datatable); foreach (System.Data.DataRow item in datatable.Rows) { helper.Fill().Add(new Coustomer() { NAME = item.Field <string>("NAME"), BARCODE = item.Field <string>("BARCODE"), DAT = item.Field <string>("DAT"), Price_F = item.Field <string>("Price_F"), Dis = item.Field <string>("Dis"), ID = item.Field <string>("ID"), PRICE = item.Field <string>("PRICE"), PRICE_A = item.Field <string>("PRICE_A"), QUANTITY = item.Field <string>("QUANTITY") }); } GC.ItemsSource.Equals(helper.Fill()); }
private void Print_Click(object sender, RoutedEventArgs e) { var SumPricee = new FunctionsOfSum(); var Fa_delete = new Assest.OrcDataAcess(); var FA = new Assest.OrcDataAcess(); try { double afo = 0; var Filtring = new List <string>(); foreach (string item in PriceList) { Filtring.Add(item.Replace("SAR", "")); } var accc = new Assest.OrcDataAcess(); List <string> L0 = new List <string>(); List <string> L1 = new List <string>(); List <string> L2 = new List <string>(); List <string> L3 = new List <string>(); List <string> L4 = new List <string>(); List <string> L5 = new List <string>(); List <string> L6 = new List <string>(); // List <string> L7 = new List <string>(); //dis List <string> L8 = new List <string>(); //pricef List <string> L9 = new List <string>(); //dat /* * * * */ DataTable tt = new DataTable(); accc.Show(tt); // Finall_Price = (Double)((Price * Discount) / 100) - Price; foreach (DataRow r in tt.Rows) { L1.Add(r.Field <string>("NAME")); L2.Add(r.Field <string>("BARCODE")); L3.Add(r.Field <string>("PRICE_A")); L4.Add(r.Field <string>("PRICE")); L5.Add(r.Field <string>("ID")); L6.Add(r.Field <string>("QUANTITY")); L7.Add(r.Field <string>("Dis")); L8.Add(r.Field <string>("Price_F")); } tt.Clear(); accc.show3(tt); foreach (DataRow r in tt.Rows) { L0.Add(r.Field <String>("NUMF")); } foreach (string asf in Filtring) { afo += double.Parse(asf); } PriceList.Add(afo.ToString()); Pricce.Text = "SAR " + afo.ToString(); var RepHelper = new ReportHelper(); var ILIST = new List <ReportHelper>(); ILIST.Add(new ReportHelper() { Getprice_ = Pricce.Text }); XtraReport3 report = new XtraReport3(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); string id_3 = ""; //int finalprice = int.Parse(SumPricee.sumPrice().Replace("SAR", "").Replace(",", "")); //double Ristt = double.Parse(afo.ToString().Replace("SAR", "").Replace(",", "")); //double FInaal = finalprice + Ristt; for (int i = 0; i < L1.Count; i++) { if (L1[i] == Name.Text) { id_3 = L5[i]; } } List <int> sawf = new List <int>(); foreach (string d in L0) { sawf.Add(int.Parse(d)); } #region Convert Days to arabic language string dayoftheweek = ""; switch (DateTime.Now.DayOfWeek) { case DayOfWeek.Sunday: { dayoftheweek = ".الاحد"; break; } case DayOfWeek.Monday: { dayoftheweek = ".الاثنين"; break; } case DayOfWeek.Thursday: { dayoftheweek = ".الخميس"; break; } case DayOfWeek.Saturday: { dayoftheweek = ".السبت"; break; } case DayOfWeek.Friday: { dayoftheweek = "الجمعة."; break; } case DayOfWeek.Tuesday: { dayoftheweek = "الثلاثاء."; break; } case DayOfWeek.Wednesday: { dayoftheweek = "الاربعاء."; break; } } #endregion if (L0.Count == 0) { //null } else { numfa = sawf.Max() + 1; } if (sawf.Count == 0) { UmAlQuraCalendar um = new UmAlQuraCalendar(); String CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() : um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString(); for (int i = 0; i < L1.Count; i++) { double Price = 0; double Discount = 0; double Finall_Price = 0; string Result = ""; DateTime dtttt = new DateTime(); for (int ii = 0; ii < asdf.Count; ii++) { if (L1[i] == asdf[ii]) { accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text); Price = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", "")); Discount = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", "")); Finall_Price = (Double)((Price * Discount) / 100) - Price; Finall_Price = Finall_Price * int.Parse(L6[i]); Result = "SAR " + Finall_Price.ToString("N2").Replace("-", ""); var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result); mainwi.EDIT_MAX(); } /* * * L1.Add(r.Field<string>("NAME")); * L2.Add(r.Field<string>("BARCODE")); * L3.Add(r.Field<string>("PRICE_A")); * L4.Add(r.Field<string>("PRICE")); * L5.Add(r.Field<string>("ID")); * L6.Add(r.Field<string>("QUANTITY")); * L7.Add(r.Field<string>("Dis")); * L8.Add(r.Field<string>("Price_F")); */ } } if (GID.Count > 0) { for (int i = 0; i < GID.Count; i++) { FA.Delete(GID[i]); } } } else { #region Date UmAlQuraCalendar um = new UmAlQuraCalendar(); String CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() : um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString(); #endregion for (int i = 0; i < L1.Count; i++) { double Price = 0; double Discount = 0; double Finall_Price = 0; string Result = ""; DateTime dtttt = new DateTime(); for (int ii = 0; ii < asdf.Count; ii++) { if (L1[i] == asdf[ii]) { accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text); Price = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", "")); Discount = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", "")); Finall_Price = (Double)((Price * Discount) / 100) - Price; Finall_Price = Finall_Price * int.Parse(L6[i]); Result = "SAR " + Finall_Price.ToString("N2").Replace("-", ""); var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result); mainwi.EDIT_MAX(); } } } if (GID.Count > 0) { for (int i = 0; i < GID.Count; i++) { FA.Updating_QUa("0", GID[i].ToString()); } } } asdf.Clear(); for (int i = 0; i < PriceList.Count; i++) { Fa_delete._Delete(double.Parse(PriceList[i].Replace("SAR", "").Replace(",", ""))); } } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message + ":" + ex.HResult.ToString()); } DD.ItemsSource = ""; Observ.Clear(); NameList.Clear(); PriceList.Clear(); }
public void PPP() { try { int Update = 0; DataTable H10 = new DataTable(); DataTable H11 = new DataTable(); var FA = new Assest.OrcDataAcess(); FA.Show(H11); FA.Show_(H10); JSum = H10.Compute("Sum(PRICE)", ""); //listStrings5.Clear(); foreach (DataRow DR in H10.Rows) { listStrings5.Add(DR.Field <string>("BARCODE")); } bool eleno = false; for (int i = 0; i < listStrings.Count; i++) { if (listStrings[i] == listStrings[i] || listStrings[i] == listStrings[i] + "\n") { eleno = true; } } if (eleno == true) { for (int j = 0; j < 1; j++) { if (Quan_li < 1) { DXMessageBox.Show(string.Format("لم يتم العثور على اي نتائج", Name.Text), "خطأ", MessageBoxButton.OK, MessageBoxImage.Error); GID.Add(int.Parse(id_li)); Exists = 0; } else { if (Exists == 1) { Add(); var oracleClassAdd = new Assest.OrcDataAcess(); oracleClassAdd._Add(Name.Text, price.Text, Barcode.Text); A_qua = j; Update = Quan_li - 1;//تنقيص من الكمية الموجودة بالمخزن FA.Updating_QUa(Update.ToString(), id_li); foreach (string s in Price_Report) { price_p += int.Parse(s); } var mainwindow = new MainWindow(); mainwindow.button7_Copy1d_Click(null, null); } else { } } //FA.Updating_QUa(Update.ToString(), liststring4[j]); } } } catch (Exception ex) { } }