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