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