public void fofo() { try { //-------- List <string> ListSt1 = new List <string>(); List <string> ListSt2 = new List <string>(); List <string> ListSt3 = new List <string>(); var accc = new Assest.OrcDataAcess(); DataTable DT = new DataTable(); accc.Show_(DT); try { foreach (DataRow DR in DT.Rows) { ListSt1.Add(DR.Field <string>("NAME")); ListSt2.Add(DR.Field <string>("BARCODE")); ListSt3.Add(DR.Field <string>("PRICE")); } } catch (Exception ex) { DXMessageBox.Show(ex.Message, "خطأ", MessageBoxButton.OK, MessageBoxImage.Error); } } catch (Exception ex) { } }
private void FixIKONData(DateTime RunDate) { string StartDate = RunDate.ToString(Mirror.AxessDateFormat); string EndDate = RunDate.AddDays(1).ToString(Mirror.AxessDateFormat); string TQ = $"SELECT saledate, sum(tfactor) AS tfactor, sum(tariff) AS tariff FROM applications.salesdata where tgroup = 'EX' and validtill between '{StartDate}' and '{EndDate}' and nkassanr <> 33 group by saledate"; using (DataTable DT = CF.LoadTable(DW.dwConn, TQ, "DT")) { if (CF.TableHasData(DT)) { foreach (DataRow DR in DT.Rows) { string TFilter = $"saledate = '{DR.Field<DateTime>("saledate").ToString(Mirror.AxessDateFormat)}' AND type = 'DT'"; decimal Amt = DR.Field <decimal>("tariff"); decimal Qty = DR.Field <decimal>("tfactor"); if (Qty < 0) { Amt = -Amt; } if (CF.RowExists(DW.dwConn, $"{DW.ActiveDatabase}.altasum", TFilter)) { TQ = $"UPDATE {DW.ActiveDatabase}.altasum SET expsales = {DR["tariff"].ToString()}, expsalesq = {DR["tfactor"].ToString()} WHERE {TFilter}"; } else { TQ = ""; } CF.ExecuteSQL(DW.dwConn, TQ); } } } }
private void LOAD_GRID_VIEW() { try { double TOTAL = 0; CONNECTION.open_connection(); using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT tax_type_id,tax_type,precentage FROM tax_details", CONNECTION.CON)) { DataTable DT = new DataTable(); DA.Fill(DT); if (DT.Rows.Count > 0) { DGV_TAV.DataSource = DT; DGV_TAV.AutoGenerateColumns = false; foreach (DataRow DR in DT.Rows) { TOTAL = TOTAL + DR.Field <double>(2); } TXT_TOTAL_TAX.Text = TOTAL.ToString("F2"); } else { DGV_TAV.DataSource = null; } } } catch (Exception EX) { } }
private void UpdateExportStatus(DataTable dt) { foreach (DataRow DR in dt.Rows) { CostSharingRequest Request = _presenter.GetCostSharingRequest(DR.Field <string>("RefNumber")); Request.ExportStatus = "Exported"; _presenter.UpdateCostSharingPaymentRequestExportStatus(Request); } }
private void LOAD_ITEMS_TO_LISTVIEW() { try { using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT i.item_id,i.barcode,i.item_category,i.item_name FROM item AS i WHERE (i.barcode LIKE @barcode OR i.item_name LIKE @item_name)", CONNECTION.CON)) { DA.SelectCommand.Parameters.Clear(); DA.SelectCommand.Parameters.AddWithValue("@barcode", "%" + TXT_ITEMNAME.Text + "%"); DA.SelectCommand.Parameters.AddWithValue("@item_name", "%" + TXT_ITEMNAME.Text + "%"); DataTable DT = new DataTable(); DA.Fill(DT); if (DT.Rows.Count > 0) { LST_ITEM_LIST.Items.Clear(); foreach (DataRow DR in DT.Rows) { ListViewItem LST = new ListViewItem(DR.Field <int>(0).ToString()); { LST.SubItems.Add(DR.Field <string>(1)); LST.SubItems.Add(DR.Field <string>(3)); } LST_ITEM_LIST.Items.Add(LST); } if (LST_ITEM_LIST.Items.Count > 0) { LST_ITEM_LIST.Visible = true; LST_ITEM_LIST.Size = new Size(687, 335); } else { LST_ITEM_LIST.Hide(); } } else { LST_ITEM_LIST.Items.Clear(); } } } catch (Exception EX) { MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error()); mdg.ShowDialog(); } }
private void LOAD_GUESTS_TO_LISTVIEW() { try { CONNECTION.open_connection(); using (MySqlDataAdapter DA = new MySqlDataAdapter("SELECT id_no,first_name,last_name,mobile_no,gender,passport_no,address,email,country.country_name,guest_id FROM guest INNER JOIN country ON (country.id=guest.country_id) WHERE id_no LIKE @id_no", CONNECTION.CON)) { DA.SelectCommand.Parameters.Clear(); DA.SelectCommand.Parameters.AddWithValue("@id_no", "%" + TXT_NIC_NO.Text + "%"); DataTable DT = new DataTable(); DA.Fill(DT); if (DT.Rows.Count > 0) { LST_GUEST_LIST.Items.Clear(); foreach (DataRow DR in DT.Rows) { ListViewItem LST = new ListViewItem(DR.Field <string>(0)); { LST.SubItems.Add(DR.Field <string>(1)); LST.SubItems.Add(DR.Field <string>(2)); LST.SubItems.Add(DR.Field <string>(3)); LST.SubItems.Add(DR.Field <string>(4)); LST.SubItems.Add(DR.Field <string>(5)); LST.SubItems.Add(DR.Field <string>(6)); LST.SubItems.Add(DR.Field <string>(7)); LST.SubItems.Add(DR.Field <string>(8)); LST.SubItems.Add(DR.Field <string>(9)); } LST_GUEST_LIST.Items.Add(LST); } LST_GUEST_LIST.Size = new Size(493, 221); LST_GUEST_LIST.Show(); } else { LST_GUEST_LIST.Hide(); } } } catch (Exception EX) { MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error()); mdg.ShowDialog(); } }
public bool ValidVerification(IConnectToDB _Connect, string VerificationString, string validation_type) { _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures(); List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>(); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "UUID_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = VerificationString }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "VALIDATION_TYPE_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = validation_type }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "ENABLED_", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = "Y" }); Filters.Add(new DynamicModels.RootReportFilter { FilterName = "WHERE", DBType = SqlDbType.VarChar, SearchParamSize = -1, ParamValue = "DT_CREATED > DATEADD(minute, -15, GETDATE())" }); DataTable DT = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__VERIFY_SEARCH", new DataTableDotNetModelMetaData { length = -1, order = "1 asc", start = 0, verify = "T" }, Filters); string UUID = ""; try { foreach (DataRow DR in DT.Rows) { UUID = DR.Field <string>("UUID"); if (UUID == VerificationString) { return(true); } } } catch { return(false); } return(false); }
private void SetTodaysSkierVisits() { lblLastUpdate.Text = CF.GetSQLField(AM.MirrorConn, "SELECT TIME(MAX(dtverwdat)) FROM axess_cwc.tablesertrans"); //dateTimePicker1.Value = DateTime.Today.AddDays(-1); //set to DateTime.Today for release; string Today = DateTime.Today.ToString(Mirror.AxessDateFormat); string Tomorrow = DateTime.Today.AddDays(1).ToString(Mirror.AxessDateFormat); //System.Data.DataTable dtTodaysSkierVisits = CF.LoadTable(DW.dwConn, $"SELECT A.tgroup, A.descrip, COUNT(*) AS Visits FROM {DW.ActiveDatabase}.tgroups AS A inner join {DW.ActiveDatabase}.skivisits AS B ON B.tgroup=A.tgroup LEFT JOIN {DW.ActiveDatabase}.altadata AS C ON C.descrip = A.descrip WHERE B.readdate='{DateTime.Today.ToString(Mirror.AxessDateFormat)}' AND B.ALTAFLAG='Y' AND A.tgroup NOT IN ('AJ','AR','SC','SS','GC','SO') GROUP BY A.tgroup ORDER BY C.sorder", "SkiVisits"); System.Data.DataTable dtTodaysSkierVisits = CF.LoadTable(AM.MirrorConn, $"SELECT HOUR(DTVERWDAT) AS SkierHour, COUNT(DISTINCT concat_ws(' - ',nkassanr, nseriennr)) AS SkierRides FROM axess_cwc.tablesertrans WHERE dtverwdat >= '{Today}' AND dtverwdat < '{Tomorrow}' AND NZUTRNR < 50 GROUP BY HOUR(dtverwdat)", "todaysreads"); //Int32 SkierVisitsTotal = 0; //foreach (DataRow tRow in dtTodaysSkierVisits.Rows) //{ // SkierVisitsTotal += Convert.ToInt32(tRow["Visits"].ToString()); //} object[] rowVals = new object[2]; System.Data.DataTable table = new System.Data.DataTable(); table.Columns.Add("SkierHour", typeof(string)); table.Columns.Add("SkierRides", typeof(Int64)); DataRowCollection rowCollection = table.Rows; foreach (DataRow DR in dtTodaysSkierVisits.Rows) { rowVals[0] = Hours[DR.Field <Int64>("SkierHour")]; rowVals[1] = DR.Field <Int64>("SkierRides"); DataRow row = rowCollection.Add(rowVals); } System.Data.DataTable DTSkiers = new System.Data.DataTable(); DTSkiers.Columns.Add("SkierHour", typeof(string)); DTSkiers.Columns.Add("SkierRides", typeof(Int64)); foreach (DataRow row in rowCollection) { DTSkiers.ImportRow(row); } gvTodaysSkierVisits.DataSource = DTSkiers; lblLastUpdate.Text = CF.GetSQLField(AM.MirrorConn, $"SELECT MAX(dtverwdat) FROM {AM.ActiveDatabase}.tablesertrans"); txtTodayVisits.Text = CF.GetSQLField(AM.MirrorConn, $"SELECT COUNT(DISTINCT concat_ws('-',nkassanr, nseriennr)) FROM {AM.ActiveDatabase}.tablesertrans WHERE dtverwdat >= '{Today}' AND dtverwdat < '{Tomorrow}' AND nzutrnr < 50"); Refresh(); }
private void FindError() { try { List <string> Lol = new List <string>(); DataTable datatable = new DataTable(); var a = new Assest.Account(); a.Show(datatable); foreach (DataRow DR in datatable.Rows) { Lol.Add(DR.Field <string>("NAME")); } for (int i = 0; i < Lol.Count; i++) { if (Lol[i] == name.Text || Lol[i] + "\n" == name.Text) { DXMessageBox.Show("هذا الاسم مستخدم سابقاً", "خطأ", MessageBoxButton.OK, MessageBoxImage.Error); NUMError = 1; break; } else { FindErrors = 0; } } if (FindErrors == 1 && NUMError != 1 || FindErrors == 0 && NUMError != 1) { FindError2 = 1; } else { FindError2--; } } catch (Exception ex) { } }
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) { } }
private void UpdateExportStatus(DataTable dt) { foreach (DataRow DR in dt.Rows) { TravelAdvanceRequest Request = _presenter.GetTravelAdvanceRequestRequest(DR.Field <string>("RefNumber")); Request.ExportStatus = "Exported"; _presenter.UpdateTravelAdvanceRequestExportStatus(Request); } }
public GuadagnoPerPeriodoList GetDeltaPeriod(IList <RegistryOwner> _selectedOwners, IList <int> _selectedYears, bool isYear, bool isAggregated) { GuadagnoPerPeriodoList GPPL = new GuadagnoPerPeriodoList(); string gestione = "A.id_gestione = "; foreach (RegistryOwner RO in _selectedOwners) { gestione += RO.Id_gestione; gestione += " OR A.id_gestione = "; } gestione = gestione.Substring(0, gestione.Length - 20); string anni = "YEAR(data_movimento) = "; foreach (int anno in _selectedYears) { anni += anno + " OR YEAR(data_movimento) = "; } anni = anni.Substring(0, anni.Length - 27); string query = string.Format("AND ({0}) AND ({1})", gestione, anni); try { using (MySqlDataAdapter dbAdapter = new MySqlDataAdapter()) { dbAdapter.SelectCommand = new MySqlCommand(); dbAdapter.SelectCommand.CommandType = CommandType.Text; if (isYear && isAggregated) { dbAdapter.SelectCommand.CommandText = string.Format(ReportScripts.GetDeltaPerYearTot, query); } else if (isYear && !isAggregated) { dbAdapter.SelectCommand.CommandText = string.Format(ReportScripts.GetDeltaPerYear, query); } else if (!isYear && isAggregated) { dbAdapter.SelectCommand.CommandText = string.Format(ReportScripts.GetDeltaPerMonthTot, query); } else if (!isYear && !isAggregated) { dbAdapter.SelectCommand.CommandText = string.Format(ReportScripts.GetDeltaPerMonth, query); } dbAdapter.SelectCommand.Parameters.AddWithValue("Anno1", _selectedYears[0] > _selectedYears[1] ? _selectedYears[1] : _selectedYears[0]); dbAdapter.SelectCommand.Parameters.AddWithValue("Anno2", _selectedYears[1] < _selectedYears[0] ? _selectedYears[0] : _selectedYears[1]); dbAdapter.SelectCommand.Connection = new MySqlConnection(DAFconnection.GetConnectionType()); DataTable dataTable = new DataTable(); dbAdapter.Fill(dataTable); foreach (DataRow DR in dataTable.Rows) { GuadagnoPerPeriodo GPP = new GuadagnoPerPeriodo(); GPP.IdGestione = Convert.ToInt32(DR.ItemArray[0]); GPP.Gestione = DR.Field <string>("nome_gestione"); GPP.Valuta = DR.Field <string>("cod_valuta"); if (!isYear) { switch (DR.Field <int>("Mese")) { case 1: GPP.Mese = "Gennaio"; break; case 2: GPP.Mese = "Febbraio"; break; case 3: GPP.Mese = "Marzo"; break; case 4: GPP.Mese = "Aprile"; break; case 5: GPP.Mese = "Maggio"; break; case 6: GPP.Mese = "Giugno"; break; case 7: GPP.Mese = "Luglio"; break; case 8: GPP.Mese = "Agosto"; break; case 9: GPP.Mese = "Settembre"; break; case 10: GPP.Mese = "Ottobre"; break; case 11: GPP.Mese = "Novembre"; break; case 12: GPP.Mese = "Dicembre"; break; } } GPP.GuadagnoAnno1 = DR.Field <double>("GuadagniAnno1"); GPP.GuadagnoAnno2 = DR.Field <double>("GuadagniAnno2"); GPP.Differenza = DR.Field <double>("Differenza"); GPP.Delta = DR.ItemArray[!isYear? 7: 6] == System.DBNull.Value ? 0 : DR.Field <double>("Delta"); GPPL.Add(GPP); } } return(GPPL); } catch (MySqlException err) { throw new Exception(err.Message); } catch (Exception err) { throw new Exception(err.Message); } }
private void UpdateExportStatus(DataTable dt) { foreach (DataRow DR in dt.Rows) { OperationalControlRequest Request = _presenter.GetOperationalControlRequest(DR.Field <string>("RefNumber")); Request.ExportStatus = "Exported"; _presenter.UpdateOperationalRequestExportStatus(Request); } }