private void UC_ShowAllContractcs_Load(object sender, EventArgs e) { whoIsIt = 0; rayan_sportDataSet.membershipDataTable dataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter adapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); adapter.Fill(dataTable); dgv_UcShowAllContractShowContract.DataSource = dataTable; }
public UC_ShowAllContract(int caller) { InitializeComponent(); whoIsIt = caller; // dts_UcShowAllContractDateSelectorFrom.Value = DateTime.Now; // dts_UcShowAllContractDateSelectorUntil.Value = DateTime.Now; rdb_UcShowAllContractAllContarct.Enabled = false; rdb_UcShowAllContractEnded.Enabled = false; rdb_UcShowAllContractEnding.Enabled = false; rdb_UcShowAllContractTodayExpired.Enabled = false; rdb_UcShowAllContractActiveContract.Enabled = false; lbl_UcShowAllContractDateFrom.Enabled = true; dts_UcShowAllContractDateSelectorFrom.Enabled = true; lbl_UcShowAllContractDateUntil.Enabled = true; dts_UcShowAllContractDateSelectorUntil.Enabled = true; lbl_UcShowAllContractName.Enabled = true; txb_UcShowAllContractName.Enabled = true; ////////come from home to see allContracts////////// if (whoIsIt == 1) { rdb_UcShowAllContractEnded.IsChecked = false; rdb_UcShowAllContractEnding.IsChecked = false; rdb_UcShowAllContractTodayExpired.IsChecked = false; rdb_UcShowAllContractAllContarct.IsChecked = true; rdb_UcShowAllContractActiveContract.IsChecked = false; rdb_UcShowAllContractAllContarct.Enabled = true; rdb_UcShowAllContractEnded.Enabled = true; rdb_UcShowAllContractEnding.Enabled = true; rdb_UcShowAllContractTodayExpired.Enabled = true; rdb_UcShowAllContractActiveContract.Enabled = true; lbl_UcShowAllContractDateFrom.Enabled = true; dts_UcShowAllContractDateSelectorFrom.Enabled = false; lbl_UcShowAllContractDateUntil.Enabled = false; dts_UcShowAllContractDateSelectorUntil.Enabled = false; lbl_UcShowAllContractName.Enabled = false; txb_UcShowAllContractName.Enabled = false; rayan_sportDataSet.membershipDataTable dataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter adapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); adapter.Fill(dataTable); dgv_UcShowAllContractShowContract.DataSource = dataTable; } else if (whoIsIt == 3) { status = "فعال"; rdb_UcShowAllContractEnded.IsChecked = false; rdb_UcShowAllContractEnding.IsChecked = false; rdb_UcShowAllContractTodayExpired.IsChecked = false; rdb_UcShowAllContractAllContarct.IsChecked = false; rdb_UcShowAllContractActiveContract.IsChecked = true; rdb_UcShowAllContractAllContarct.Enabled = true; rdb_UcShowAllContractEnded.Enabled = true; rdb_UcShowAllContractEnding.Enabled = true; rdb_UcShowAllContractTodayExpired.Enabled = true; rdb_UcShowAllContractActiveContract.Enabled = true; lbl_UcShowAllContractDateFrom.Enabled = true; dts_UcShowAllContractDateSelectorFrom.Enabled = false; lbl_UcShowAllContractDateUntil.Enabled = false; dts_UcShowAllContractDateSelectorUntil.Enabled = false; lbl_UcShowAllContractName.Enabled = false; txb_UcShowAllContractName.Enabled = false; rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByActiveStatus(membershipDataTable, status); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } else if (whoIsIt == 5) { rdb_UcShowAllContractEnded.IsChecked = false; rdb_UcShowAllContractEnding.IsChecked = false; rdb_UcShowAllContractTodayExpired.IsChecked = true; rdb_UcShowAllContractAllContarct.IsChecked = false; rdb_UcShowAllContractActiveContract.IsChecked = false; rdb_UcShowAllContractAllContarct.Enabled = true; rdb_UcShowAllContractEnded.Enabled = true; rdb_UcShowAllContractEnding.Enabled = true; rdb_UcShowAllContractTodayExpired.Enabled = true; rdb_UcShowAllContractActiveContract.Enabled = true; lbl_UcShowAllContractDateFrom.Enabled = true; dts_UcShowAllContractDateSelectorFrom.Enabled = false; lbl_UcShowAllContractDateUntil.Enabled = false; dts_UcShowAllContractDateSelectorUntil.Enabled = false; lbl_UcShowAllContractName.Enabled = false; txb_UcShowAllContractName.Enabled = false; todeyDate = getDateShamsi(DateTime.Now.ToString("M/d/yyyy")); rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByTodayExpired(membershipDataTable, todeyDate); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } }
private void btn_UcShowAllContractFilter_Click(object sender, EventArgs e) { whoIsIt = 0; if (whoIsIt == 0) { if (endDate1 != "" && endDate2 != "" && Name != "") { rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectDateAndName(membershipDataTable, Name, endDate1, endDate2); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } Name = ""; if (endDate1 != "" && endDate2 != "" && Name == "") { rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByDate(membershipDataTable, endDate1, endDate2); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } endDate1 = ""; endDate2 = ""; if (endDate1 == "" && endDate2 == "" && Name != "") { rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByName(membershipDataTable, Name); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } if (rdb_UcShowAllContractEnded.IsChecked) { todeyDate = getDateShamsi(DateTime.Now.ToString("M/d/yyyy")); rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByEndedDate(membershipDataTable, todeyDate); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } if (rdb_UcShowAllContractAllContarct.IsChecked) { rayan_sportDataSet.membershipDataTable dataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter adapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); adapter.Fill(dataTable); dgv_UcShowAllContractShowContract.DataSource = dataTable; } if (rdb_UcShowAllContractTodayExpired.IsChecked) { todeyDate = getDateShamsi(DateTime.Now.ToString("M/d/yyyy")); rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByTodayExpired(membershipDataTable, todeyDate); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } if (rdb_UcShowAllContractEnding.IsChecked) { todeyDate = getDateShamsi(DateTime.Now.ToString("M/d/yyyy")); DateTime inSevenDays = DateTime.Today.AddDays(7); String sevenDay = getDateShamsi(inSevenDays.ToString()); rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByEndingContract(membershipDataTable, todeyDate, sevenDay); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } if (rdb_UcShowAllContractActiveContract.IsChecked) { rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable(); rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter(); membershipTableAdapter.FillBySelectByActiveStatus(membershipDataTable, status); dgv_UcShowAllContractShowContract.DataSource = membershipDataTable; } } }