public static List <string> GetMonths()
{
UmAlQuraCalendar um = new UmAlQuraCalendar();
var dt = new DataTable();
var GetDateFromDatabase = new OrcDataAcess();
GetDateFromDatabase.show3(dt);
var Result = new List <string>();
var MonthList = new List <string>();
var WholeDate = new List <string>();
foreach (DataRow item in dt.Rows)
{
WholeDate.Add((DateTime.Parse(item.Field <string>("DAT")).Year.ToString()).Contains("143") || DateTime.Parse(item.Field <string>("DAT")).Year.ToString().Contains("144") ?
DateTime.Parse(item.Field <string>("DAT")).Month.ToString() :
um.GetMonth(DateTime.Parse(item.Field <string>("DAT"))).ToString());
}
return(WholeDate);
}
/// <summary>
/// ForFiltring Days And Months and years
/// </summary>
/// <param name="Typesearch"></param>
/// <returns></returns>
public void FieldDataTables(TypeSearch Typesearch, DataTable data)
{
List <string> Name = new List <string>();
List <string> NUMF = new List <string>();
List <string> Price = new List <string>();
List <string> Price_a = new List <string>();
List <string> DOW = new List <string>();
List <string> Barcode = new List <string>();
List <string> DAT = new List <string>();
//-=-=-
List <string> Name_ = new List <string>();
List <string> NUMF_ = new List <string>();
List <string> Price_ = new List <string>();
List <string> Price_a_ = new List <string>();
List <string> DOW_ = new List <string>();
List <string> Barcode_ = new List <string>();
List <string> DAT_ = new List <string>();
BindingSource Bind = new BindingSource();
if (Typesearch == TypeSearch.Day)
{
DataTable dt = new DataTable();
var GetTables = new OrcDataAcess();
GetTables.show3(dt);
foreach (DataRow item in dt.Rows)
{
Name.Add(item.Field <string>("NAME"));
NUMF.Add(item.Field <string>("NUMF"));
Price.Add(item.Field <string>("PRICE"));
Price_a.Add(item.Field <string>("PRICE_A"));
DOW.Add(item.Field <string>("DOW"));
Barcode.Add(item.Field <string>("BARCODE"));
DAT.Add(item.Field <string>("DAT"));
}
var DayList = new List <string>();
foreach (var item in SealsFunction.GetDays())
{
DayList.Add(item);//Add Days For Compairing.
}
for (int i = 0; i < DayList.Count; i++)
{
if (SealsFunction.ExtractDaysFromDate() == DayList[i])
{
Name_.Add(Name[i]);
Barcode_.Add(Barcode[i]);
Price_.Add(Price[i]);
Price_a_.Add(Price_a[i]);
DOW_.Add(DOW[i]);
DAT_.Add(DAT[i]);
NUMF_.Add(NUMF[i]);
}
}
data.Columns.Add("NAME");
data.Columns.Add("NUMF");
data.Columns.Add("PRICE");
data.Columns.Add("PRICE_A");
data.Columns.Add("DOW");
data.Columns.Add("BARCODE");
data.Columns.Add("DAT");
for (int ii = 0; ii < Name_.Count; ii++)
{
DataRow datarow = data.NewRow();
datarow["NAME"] = Name_[ii];
datarow["NUMF"] = NUMF_[ii];
datarow["PRICE"] = Price_[ii];
datarow["PRICE_A"] = Price_a_[ii];
datarow["DOW"] = DOW_[ii];
datarow["BARCODE"] = Barcode_[ii];
datarow["DAT"] = DAT_[ii];
data.Rows.Add(datarow);
}
PrintHelper.Print.Datatable_ = data;
PrintHelper.Print.IsDay_ = true;
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsYear_ = false;
}
else if (Typesearch == TypeSearch.Month)
{
DataTable dt = new DataTable();
var GetTables = new OrcDataAcess();
GetTables.show3(dt);
foreach (DataRow item in dt.Rows)
{
Name.Add(item.Field <string>("NAME"));
NUMF.Add(item.Field <string>("NUMF"));
Price.Add(item.Field <string>("PRICE"));
Price_a.Add(item.Field <string>("PRICE_A"));
DOW.Add(item.Field <string>("DOW"));
Barcode.Add(item.Field <string>("BARCODE"));
DAT.Add(item.Field <string>("DAT"));
}
var Monthlist = new List <string>();
foreach (var item in SealsFunction.GetMonths())
{
Monthlist.Add(item);//Add Days For Compairing.
}
for (int i = 0; i < Monthlist.Count; i++)
{
if (SealsFunction.ExtractmonthsFromDate() == Monthlist[i])
{
Name_.Add(Name[i]);
Barcode_.Add(Barcode[i]);
Price_.Add(Price[i]);
Price_a_.Add(Price_a[i]);
DOW_.Add(DOW[i]);
DAT_.Add(DAT[i]);
NUMF_.Add(NUMF[i]);
}
}
data.Columns.Add("NAME");
data.Columns.Add("NUMF");
data.Columns.Add("PRICE");
data.Columns.Add("PRICE_A");
data.Columns.Add("DOW");
data.Columns.Add("BARCODE");
data.Columns.Add("DAT");
for (int ii = 0; ii < Name_.Count; ii++)
{
DataRow datarow = data.NewRow();
datarow["NAME"] = Name_[ii];
datarow["NUMF"] = NUMF_[ii];
datarow["PRICE"] = Price_[ii];
datarow["PRICE_A"] = Price_a_[ii];
datarow["DOW"] = DOW_[ii];
datarow["BARCODE"] = Barcode_[ii];
datarow["DAT"] = DAT_[ii];
data.Rows.Add(datarow);
}
PrintHelper.Print.Datatable_ = data;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsMounth_ = true;
PrintHelper.Print.IsYear_ = false;
}
else if (Typesearch == TypeSearch.SquareYear)
{
DataTable dt = new DataTable();
var GetTables = new OrcDataAcess();
GetTables.show3(dt);
foreach (DataRow item in dt.Rows)
{
Name.Add(item.Field <string>("NAME"));
NUMF.Add(item.Field <string>("NUMF"));
Price.Add(item.Field <string>("PRICE"));
Price_a.Add(item.Field <string>("PRICE_A"));
DOW.Add(item.Field <string>("DOW"));
Barcode.Add(item.Field <string>("BARCODE"));
DAT.Add(item.Field <string>("DAT"));
}
var MonthList = new List <string>();
foreach (var item in SealsFunction.GetMonths())
{
MonthList.Add(item);//Add Days For Compairing.
}
for (int i = 0; i < MonthList.Count; i++)
{
if (DateTime.Now.Day.ToString() == MonthList[i])
{
Name_.Add(Name[i]);
Barcode_.Add(Barcode[i]);
Price_.Add(Price[i]);
Price_a_.Add(Price_a[i]);
DOW_.Add(DOW[i]);
DAT_.Add(DAT[i]);
NUMF_.Add(NUMF[i]);
}
}
data.Columns.Add("NAME");
data.Columns.Add("NUMF");
data.Columns.Add("PRICE");
data.Columns.Add("PRICE_A");
data.Columns.Add("DOW");
data.Columns.Add("BARCODE");
data.Columns.Add("DAT");
for (int ii = 0; ii < Name_.Count; ii++)
{
DataRow datarow = data.NewRow();
datarow["NAME"] = Name_[ii];
datarow["NUMF"] = NUMF_[ii];
datarow["PRICE"] = Price_[ii];
datarow["PRICE_A"] = Price_a_[ii];
datarow["DOW"] = DOW_[ii];
datarow["BARCODE"] = Barcode_[ii];
datarow["DAT"] = DAT_[ii];
data.Rows.Add(datarow);
}
}
else if (Typesearch == TypeSearch.Year)
{
DataTable dt = new DataTable();
var GetTables = new OrcDataAcess();
GetTables.show3(dt);
foreach (DataRow item in dt.Rows)
{
Name.Add(item.Field <string>("NAME"));
NUMF.Add(item.Field <string>("NUMF"));
Price.Add(item.Field <string>("PRICE"));
Price_a.Add(item.Field <string>("PRICE_A"));
DOW.Add(item.Field <string>("DOW"));
Barcode.Add(item.Field <string>("BARCODE"));
DAT.Add(item.Field <string>("DAT"));
}
var yearlist = new List <string>();
foreach (var item in SealsFunction.GetYears())
{
yearlist.Add(item);//Add Days For Compairing.
}
for (int i = 0; i < yearlist.Count; i++)
{
if (SealsFunction.ExtractyearsFromDate() == yearlist[i])
{
Name_.Add(Name[i]);
Barcode_.Add(Barcode[i]);
Price_.Add(Price[i]);
Price_a_.Add(Price_a[i]);
DOW_.Add(DOW[i]);
DAT_.Add(DAT[i]);
NUMF_.Add(NUMF[i]);
}
}
data.Columns.Add("NAME");
data.Columns.Add("NUMF");
data.Columns.Add("PRICE");
data.Columns.Add("PRICE_A");
data.Columns.Add("DOW");
data.Columns.Add("BARCODE");
data.Columns.Add("DAT");
for (int ii = 0; ii < Name_.Count; ii++)
{
DataRow datarow = data.NewRow();
datarow["NAME"] = Name_[ii];
datarow["NUMF"] = NUMF_[ii];
datarow["PRICE"] = Price_[ii];
datarow["PRICE_A"] = Price_a_[ii];
datarow["DOW"] = DOW_[ii];
datarow["BARCODE"] = Barcode_[ii];
datarow["DAT"] = DAT_[ii];
data.Rows.Add(datarow);
}
PrintHelper.Print.Datatable_ = data;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsYear_ = true;
}
}
public func(bool Lo_Max, bool Lo_Ma = false)
{
this.Lo_EDIT_MAX = Lo_Max;
InitializeComponent();
#region Imp1
if (Lo_Ma == false)
{
if (Lo_EDIT_MAX == true)
{
System.Windows.Forms.BindingSource bindS = new System.Windows.Forms.BindingSource();
var Acc_dataACCess = new OrcDataAcess();
var datatable = new System.Data.DataTable();
Acc_dataACCess.Show(datatable);
bindS.DataSource = datatable;
DD.ItemsSource = bindS;
TX.Visibility = Visibility.Visible;
TX_Copy.Visibility = Visibility.Visible;
L.Visibility = Visibility.Hidden;
textBlock.Visibility = Visibility.Visible;
textBlock_Copy3.Visibility = Visibility.Hidden;
textBlock_Copy.Visibility = Visibility.Visible;
textBlock_Copy2.Visibility = Visibility.Visible;
DD.Visibility = Visibility.Visible;
Dis_add.Visibility = Visibility.Hidden;
Tx_Add.Visibility = Visibility.Hidden;
Tx_Edit.Visibility = Visibility.Visible;
Dis_edit.Visibility = Visibility.Visible;
DDD.Visibility = Visibility.Hidden;
B.Visibility = Visibility.Hidden;
S2.Visibility = Visibility.Visible;
btnMA.Visibility = Visibility.Hidden;
maBar.Visibility = Visibility.Hidden;
maName.Visibility = Visibility.Hidden;
name_Copy.Visibility = Visibility.Visible;
pri_Copy.Visibility = Visibility.Visible;
pri_a_Copy.Visibility = Visibility.Visible;
qua_Copy.Visibility = Visibility.Visible;
bar_Copy.Visibility = Visibility.Visible;
name.Visibility = Visibility.Hidden;
pri.Visibility = Visibility.Hidden;
pri_a.Visibility = Visibility.Hidden;
qua.Visibility = Visibility.Hidden;
bar.Visibility = Visibility.Hidden;
btn_add.Visibility = Visibility.Hidden;
btn_add_Copy.Visibility = Visibility.Visible;
}
else
{
ADD_LOA_MAX();
textBlock.Visibility = Visibility.Visible;
textBlock_Copy3.Visibility = Visibility.Hidden;
TX.Visibility = Visibility.Visible;
TX_Copy.Visibility = Visibility.Visible;
textBlock_Copy.Visibility = Visibility.Visible;
textBlock_Copy2.Visibility = Visibility.Visible;
L.Visibility = Visibility.Hidden;
B.Visibility = Visibility.Hidden;
S2.Visibility = Visibility.Visible;
Dis_add.Visibility = Visibility.Visible;
Tx_Add.Visibility = Visibility.Visible;
Tx_Edit.Visibility = Visibility.Hidden;
Dis_edit.Visibility = Visibility.Hidden;
DD.Visibility = Visibility.Visible;
DDD.Visibility = Visibility.Hidden;
btnMA.Visibility = Visibility.Hidden;
maBar.Visibility = Visibility.Hidden;
maName.Visibility = Visibility.Hidden;
btn_add.Visibility = Visibility.Visible;
btn_add_Copy.Visibility = Visibility.Hidden;
name_Copy.Visibility = Visibility.Hidden;
pri_Copy.Visibility = Visibility.Hidden;
qua_Copy.Visibility = Visibility.Hidden;
pri_a_Copy.Visibility = Visibility.Hidden;
bar_Copy.Visibility = Visibility.Hidden;
name.Visibility = Visibility.Visible;
pri.Visibility = Visibility.Visible;
pri_a.Visibility = Visibility.Visible;
qua.Visibility = Visibility.Visible;
bar.Visibility = Visibility.Visible;
}
}
else
{
if (Lo_EDIT_MAX == true)
{
System.Windows.Forms.BindingSource bindS = new System.Windows.Forms.BindingSource();
var Acc_dataACCess = new OrcDataAcess2();
var datatable = new System.Data.DataTable();
Acc_dataACCess.Show(datatable);
bindS.DataSource = datatable;
DDD.ItemsSource = bindS;
btnMA.Visibility = Visibility.Hidden;
btnMAEd.Visibility = Visibility.Visible;
L.Visibility = Visibility.Visible;
TX.Visibility = Visibility.Hidden;
TX_Copy.Visibility = Visibility.Hidden;
textBlock_Copy3.Visibility = Visibility.Visible;
textBlock_Copy.Visibility = Visibility.Hidden;
textBlock_Copy2.Visibility = Visibility.Hidden;
B.Visibility = Visibility.Visible;
S2.Visibility = Visibility.Hidden;
DD.Visibility = Visibility.Hidden;
DDD.Visibility = Visibility.Visible;
btnMA.Visibility = Visibility.Hidden;
maBar.Visibility = Visibility.Hidden;
maName.Visibility = Visibility.Hidden;
maName_Copy.Visibility = Visibility.Visible;
maBar_Copy.Visibility = Visibility.Visible;
name_Copy.Visibility = Visibility.Hidden;
pri_Copy.Visibility = Visibility.Hidden;
pri_a_Copy.Visibility = Visibility.Hidden;
Dis_add.Visibility = Visibility.Hidden;
Tx_Add.Visibility = Visibility.Hidden;
Tx_Edit.Visibility = Visibility.Hidden;
Dis_edit.Visibility = Visibility.Hidden;
qua_Copy.Visibility = Visibility.Hidden;
bar_Copy.Visibility = Visibility.Hidden;
name.Visibility = Visibility.Hidden;
pri.Visibility = Visibility.Hidden;
pri_a.Visibility = Visibility.Hidden;
qua.Visibility = Visibility.Hidden;
bar.Visibility = Visibility.Hidden;
btn_add.Visibility = Visibility.Hidden;
btn_add_Copy.Visibility = Visibility.Hidden;
}
else
{
ADD_LOA_MAX();
L.Visibility = Visibility.Visible;
TX.Visibility = Visibility.Hidden;
TX_Copy.Visibility = Visibility.Hidden;
btnMA.Visibility = Visibility.Visible;
btnMAEd.Visibility = Visibility.Hidden;
textBlock_Copy.Visibility = Visibility.Hidden;
textBlock_Copy2.Visibility = Visibility.Hidden;
B.Visibility = Visibility.Visible;
maName_Copy.Visibility = Visibility.Hidden;
maBar_Copy.Visibility = Visibility.Hidden;
S2.Visibility = Visibility.Hidden;
textBlock_Copy3.Visibility = Visibility.Visible;
DD.Visibility = Visibility.Hidden;
DDD.Visibility = Visibility.Visible;
btnMA.Visibility = Visibility.Visible;
maBar.Visibility = Visibility.Visible;
maName.Visibility = Visibility.Visible;
btn_add.Visibility = Visibility.Hidden;
btn_add_Copy.Visibility = Visibility.Hidden;
name_Copy.Visibility = Visibility.Hidden;
pri_Copy.Visibility = Visibility.Hidden;
Dis_add.Visibility = Visibility.Hidden;
Tx_Add.Visibility = Visibility.Hidden;
Tx_Edit.Visibility = Visibility.Hidden;
Dis_edit.Visibility = Visibility.Hidden;
pri_a_Copy.Visibility = Visibility.Hidden;
qua_Copy.Visibility = Visibility.Hidden;
bar_Copy.Visibility = Visibility.Hidden;
name.Visibility = Visibility.Hidden;
pri.Visibility = Visibility.Hidden;
pri_a.Visibility = Visibility.Hidden;
qua.Visibility = Visibility.Hidden;
bar.Visibility = Visibility.Hidden;
}
}
#endregion
}
private void search_P()
{
try {
var name = new List <string>();
var bar = new List <string>();
var pri = new List <string>();
var qua = new List <string>();
var data_acc = new OrcDataAcess();
var dt = new DataTable();
data_acc.Show(dt);
foreach (DataRow Dr in dt.Rows)
{
name.Add(Dr.Field <string>("NAME"));
bar.Add(Dr.Field <string>("BARCODE"));
pri.Add(Dr.Field <string>("PRICE"));
qua.Add(Dr.Field <string>("QUANTITY"));
}
int MAX = 0;
for (int i = 0; i < name.Count; i++)
{
if (Regex.IsMatch(search.Text, "^[0-9]*$"))
{
if (search.Text == bar[i])
{
this.AA.IsChecked = false;
this.bar.Text = bar[i];
this.qua.Text = qua[i];
this.pri.Text = pri[i];
Name.Text = name[i];
}
else
{
MAX++;
}
}
else
{
if (search.Text != name[i])
{
MAX++;
}
else
{
this.AA.IsChecked = false;
this.bar.Text = bar[i];
this.qua.Text = qua[i];
this.pri.Text = pri[i];
Name.Text = name[i];
}
}
}
if (MAX == name.Count)
{
this.AA.IsChecked = false;
this.AA.IsChecked = true;
this.bar.Text = "";
this.qua.Text = "";
this.pri.Text = "";
Name.Text = "";
}
bar.Clear();
qua.Clear();
pri.Clear();
name.Clear();
}
catch (Exception ex) { }
}
