public void setData(Member input_member)
{
this.member = input_member;
member = input_member;
rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable();
rayan_sportDataSetTableAdapters.membershipTableAdapter tableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
tableAdapter.FillBySelectById(membershipDataTable, input_member.member_id);
dgv_UcShowMemberContractInfoContracts.DataSource = membershipDataTable;
dgv_UcShowMemberContractInfoContracts.Columns["membership_memberId"].IsVisible = false;
dgv_UcShowMemberContractInfoContracts.Columns["membership_memberName"].IsVisible = false;
btn_UcShowMemberContractInfoDeleteContract.Enabled = false;
btn_UcShowMemberContractInfoDeleteContract.BackColor = Properties.Settings.Default.MediumGrey;
btn_UcShowMemberContractInfoExpireContract.Enabled = false;
btn_UcShowMemberContractInfoExpireContract.BackColor = Properties.Settings.Default.MediumGrey;
btn_UcShowMemberContractInfoAddContract.Enabled = true;
btn_UcShowMemberContractInfoAddContract.BackColor = Properties.Settings.Default.Blue;
foreach (var txb in tableLayoutPanel3.Controls)
{
if (txb is TextBox)
{
(txb as TextBox).Clear();
}
if (txb is ComboBox)
{
(txb as ComboBox).Text = "";
}
}
dts_UcShowMemberContractInfoStartDate.ResetText();
tableLayoutPanel3.Enabled = false;
btn_UcShowMemberContractInfoSave.BackColor = Properties.Settings.Default.MediumGrey;
btn_UcShowMemberContractInfoClear.BackColor = Properties.Settings.Default.MediumGrey;
}
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;
}
private void FillData()
{
//MessageBox.Show(member.member_id+"");
rayan_sportDataSet.membershipDataTable membershipDatatable = new rayan_sportDataSet.membershipDataTable();
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
membershipTableAdapter.FillBySelectById(membershipDatatable, member.member_id);
dgv_UcShowMemberContractInfoContracts.DataSource = membershipDatatable;
}
private void enterMember()
{
if (txb_UcCheckInInfoMemberId.Text.Equals(""))
{
//MessageBox.Show("کد عضویت ورزشکار را وارد نمایید");
Alert alert = new Alert("کد عضویت ورزشکار را وارد نمایید", "red");
txb_UcCheckInInfoMemberId.Focus();
}
else
{
int?commode;
if (txb_UcCheckInInfoCommodeNum.Text.Equals(""))
{
commode = null;
}
else
{
commode = Convert.ToInt32(txb_UcCheckInInfoCommodeNum.Text);
}
try
{
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
rayan_sportDataSet.memberCheckInDataTable memberCheckInDataTable = new rayan_sportDataSet.memberCheckInDataTable();
rayan_sportDataSetTableAdapters.memberCheckInTableAdapter memberCheckInTableAdapter = new rayan_sportDataSetTableAdapters.memberCheckInTableAdapter();
DateTime d = DateTime.Now;
PersianCalendar pc = new PersianCalendar();
String date = String.Format("{0}/{1:00}/{2:00} - {3:00}:{4:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d), pc.GetHour(d), pc.GetMinute(d));
string date1 = string.Format("{0}/{1:00}/{2:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d));
string time1 = string.Format("{0:00}:{1:00}", pc.GetHour(d), pc.GetMinute(d));
memberCheckInTableAdapter.Insert(membershipId, date, commode);
//MessageBox.Show(memberGender + " " + memberName + " " + "وارد شد.");
Alert alert = new Alert(memberGender + " " + memberName + " " + "وارد شد.", "green");
txb_UcCheckInInfoMemberId.Clear();
ClearTexts();
llb_UcCheckInInfoShowMemberDetail.Enabled = false;
pcb_UcCheckInInfoMemberRemainingSession.BackgroundImage = null;
pcb_UcCheckInInfoMembershipEndDate.BackgroundImage = null;
pcb_UcCheckInInfoMemberShipType.BackgroundImage = null;
pbx_UcCheckInInfoMemberPicture.Image = Properties.Resources.no_image;
rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable();
rayan_sportDataSetTableAdapters.membershipTableAdapter tableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
tableAdapter.IncreaseRemainingSession(remainingSession - 1, member_id, membershipId);
logTableAdapter.Insert("checked in member : " + memberName, "memberCheckIn", user_name, date1, time1);
}
catch (Exception ex)
{
Alert alert = new Alert(ex.Message, "red");
//throw;
}
}
}
private void btn_UcShowMemberContractInfoDeleteContract_Click(object sender, EventArgs e)
{
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int sucsses = membershipTableAdapter.DeleteById(currnet_membership_id);
if (sucsses == 1)
{
DateTime d = DateTime.Now;
PersianCalendar pc = new PersianCalendar();
string date1 = string.Format("{0}/{1:00}/{2:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d));
string time1 = string.Format("{0:00}:{1:00}", pc.GetHour(d), pc.GetMinute(d));
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
logTableAdapter.Insert("deleted membership num : " + currnet_membership_id, "membership", getUser_name(), date1, time1);
//MessageBox.Show("حذف با موفقیت انجام شد");
Alert alert = new Alert("حذف با موفقیت انجام شد", "green");
FillData();
}
}
private void btn_UcShowMemberMemberInfoChangeMember_Click(object sender, EventArgs e)
{
if (txb_UcShowMemberMemberInfoMemberName.Text == "")
{
Alert alert = new Alert("نام و نام خانوادگی ورزشکار را وارد کنید", "darkred");
txb_UcShowMemberMemberInfoMemberName.BackColor = Color.MistyRose;
}
else if (cmb_UcShowMemberMemberInfoMemberGender.Text == "")
{
Alert alert = new Alert("جنسیت ورزشکار را وارد کنید", "darkred");
cmb_UcShowMemberMemberInfoMemberGender.BackColor = Color.MistyRose;
}
else
{
try
{
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
memberTableAdapter.UpdateMember(txb_UcShowMemberMemberInfoMemberName.Text, txb_UcShowMemberMemberInfoMemberNationalCode.Text,
txb_UcShowMemberMemberInfoMemberTel.Text, cmb_UcShowMemberMemberInfoMemberGender.Text, cmb_UcShowMemberMemberInfoMemberBlood.Text,
txb_UcShowMemberMemberInfoMemberSick.Text, txb_UcShowMemberMemberInfoMemberAddress.Text, int.Parse(txb_UcShowMemberMemberInfoMemberId.Text));
membershipTableAdapter.UpdateMemberNameByMemberIdInMembership(txb_UcShowMemberMemberInfoMemberName.Text, int.Parse(txb_UcShowMemberMemberInfoMemberId.Text));
logTableAdapter.Insert("تغییر ورزشکار با نام " + txb_UcShowMemberMemberInfoMemberName.Text + "", "member", "admin", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString());
string path;
path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location) + @"\member_image\";
if (btn_UcShowMemberMemberInfoMemberAddPicture.Text != "افزودن عکس")
{
pbx_UcShowMemberMemberInfoMemberPicture.Image.Save(path + txb_UcShowMemberMemberInfoMemberId.Text + ".Jpeg", ImageFormat.Jpeg);
}
Alert alert = new Alert("اطلاعات ورزشکار با کد عضویت " + txb_UcShowMemberMemberInfoMemberId.Text + " تغییر یافت", "green");
}
catch (Exception)
{
Alert alert = new Alert("خطا در تغییر اطلاعات ورزشکار", "darkred");
}
}
}
private void btn_UcShowMemberContractInfoExpireContract_Click(object sender, EventArgs e)
{
try {
DateTime d = DateTime.Now;
PersianCalendar pc = new PersianCalendar();
string date1 = string.Format("{0}/{1:00}/{2:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d));
string time1 = string.Format("{0:00}:{1:00}", pc.GetHour(d), pc.GetMinute(d));
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
membershipTableAdapter.UpdateStatusById("غیر فعال", currnet_membership_id, currnet_membership_id);
//MessageBox.Show("قرارداد با موفقیت غیرفعال شد");
logTableAdapter.Insert("deactived membership number" + currnet_membership_id, "membership", getUser_name(), date1, time1);
Alert alert = new Alert("قرارداد با موفقیت غیرفعال شد ", "green");
FillData();
}
catch (Exception ex) {
//MessageBox.Show(ex.Message);
Alert alert = new Alert(ex.Message, "red");
}
}
public UC_Home()
{
InitializeComponent();
/*rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
* int count = (int)membershipTableAdapter.ScalarCountOfContract();
* lbl_UcHomeAllContractNum.Text = count.ToString();*/
activeContract = "فعال";
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter1 = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int activeCount = (int)membershipTableAdapter1.ScalarCountByActiveContract(activeContract);
lbl_UcHomeActiveContract.Text = activeCount.ToString();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
int numMember = (int)memberTableAdapter.ScalarCountByMemberNum();
lbl_UcHomeAllMember.Text = numMember.ToString();
String todeyDate1 = getDateShamsi(DateTime.Now.ToString("M/d/yyyy"));
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter2 = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int expiredContract = (int)membershipTableAdapter1.ScalarCountByTodayExpiredContract(todeyDate1);
lbl_UcHomeExoiredContract.Text = expiredContract.ToString();
rayan_sportDataSetTableAdapters.checkInTableAdapter checkInTableAdapter = new rayan_sportDataSetTableAdapters.checkInTableAdapter();
int notMember = (int)checkInTableAdapter.ScalarCountByNotMember(todeyDate1);
lbl_UcHomeDayliMemberNum.Text = notMember.ToString();
Iam = 0;
}
private void txb_UcCheckInInfoMemberId_TextChanged(object sender, EventArgs e)
{
if (!txb_UcCheckInInfoMemberId.Text.Equals(""))
{
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter membertableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
int rows = membertableAdapter.FillBySelectByMemberId(memberDataTable, Convert.ToInt32(txb_UcCheckInInfoMemberId.Text));
if (rows == 1)
{
llb_UcCheckInInfoShowMemberDetail.Enabled = true;
txb_UcCheckInInfoMemberName.Text = memberDataTable[0].member_name;
member_id = memberDataTable[0].member_id;
memberGender = memberDataTable[0].member_gender;
memberName = memberDataTable[0].member_name;
member = new Member(memberDataTable[0].member_id, memberDataTable[0].member_name, memberDataTable[0].member_nationalCode, memberDataTable[0].member_tel, memberDataTable[0].member_gender, memberDataTable[0].member_blood, memberDataTable[0].member_sick, memberDataTable[0].member_address, memberDataTable[0].member_charge);
rayan_sportDataSet.membershipDataTable membershipDataTable = new rayan_sportDataSet.membershipDataTable();
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int rows1 = membershipTableAdapter.FillBySelectMembersWithStatusAndId(membershipDataTable, Convert.ToInt32(txb_UcCheckInInfoMemberId.Text), "فعال");
try
{
string path;
path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location) + @"\member_image\";
pbx_UcCheckInInfoMemberPicture.Image = Image.FromFile(path + member_id + ".Jpeg");
pbx_UcCheckInInfoMemberPicture.SizeMode = PictureBoxSizeMode.Zoom;
}
catch (Exception ex) { }
if (rows1 == 1)
{
if (membershipDataTable[0].membership_remainingSession > 0)
{
membershipId = membershipDataTable[0].membership_id;
remainingSession = membershipDataTable[0].membership_remainingSession;
txb_UcCheckInInfoMemberShipType.Text = membershipDataTable[0].membership_type;
txb_UcCheckInInfoMemberRemainingSession.Text = membershipDataTable[0].membership_remainingSession + "";
txb_UcCheckInInfoMembershipEndDate.Text = membershipDataTable[0].membership_endDate;
pcb_UcCheckInInfoMemberRemainingSession.BackgroundImage = Properties.Resources._checked;
pcb_UcCheckInInfoMembershipEndDate.BackgroundImage = Properties.Resources._checked;
pcb_UcCheckInInfoMemberShipType.BackgroundImage = Properties.Resources._checked;
btn_UcCheckInInfoMemberCheck.Enabled = true;
btn_UcCheckInInfoMemberCheck.BackColor = Properties.Settings.Default.Blue;
}
else
{
txb_UcCheckInInfoMemberShipType.Text = "قرار داد فعال وجود ندارد";
txb_UcCheckInInfoMemberRemainingSession.Text = "قرار داد فعال وجود ندارد";
txb_UcCheckInInfoMembershipEndDate.Text = "قرار داد فعال وجود ندارد";
pcb_UcCheckInInfoMemberRemainingSession.BackgroundImage = Properties.Resources.cancel;
pcb_UcCheckInInfoMembershipEndDate.BackgroundImage = Properties.Resources.cancel;
pcb_UcCheckInInfoMemberShipType.BackgroundImage = Properties.Resources.cancel;
txb_UcCheckInInfoMemberShipType.ForeColor = Properties.Settings.Default.Red;
txb_UcCheckInInfoMemberRemainingSession.ForeColor = Properties.Settings.Default.Red;
txb_UcCheckInInfoMembershipEndDate.ForeColor = Properties.Settings.Default.Red;
btn_UcCheckInInfoMemberCheck.Enabled = false;
btn_UcCheckInInfoMemberCheck.BackColor = Properties.Settings.Default.MediumGrey;
}
}
else
{
txb_UcCheckInInfoMemberShipType.Text = "قرار داد فعال وجود ندارد";
txb_UcCheckInInfoMemberRemainingSession.Text = "قرار داد فعال وجود ندارد";
txb_UcCheckInInfoMembershipEndDate.Text = "قرار داد فعال وجود ندارد";
pcb_UcCheckInInfoMemberRemainingSession.BackgroundImage = Properties.Resources.cancel;
pcb_UcCheckInInfoMembershipEndDate.BackgroundImage = Properties.Resources.cancel;
pcb_UcCheckInInfoMemberShipType.BackgroundImage = Properties.Resources.cancel;
txb_UcCheckInInfoMemberShipType.ForeColor = Properties.Settings.Default.Red;
txb_UcCheckInInfoMemberRemainingSession.ForeColor = Properties.Settings.Default.Red;
txb_UcCheckInInfoMembershipEndDate.ForeColor = Properties.Settings.Default.Red;
btn_UcCheckInInfoMemberCheck.Enabled = false;
btn_UcCheckInInfoMemberCheck.BackColor = Properties.Settings.Default.MediumGrey;
}
}
else
{
ClearTexts();
llb_UcCheckInInfoShowMemberDetail.Enabled = false;
pcb_UcCheckInInfoMemberRemainingSession.BackgroundImage = null;
pcb_UcCheckInInfoMembershipEndDate.BackgroundImage = null;
pcb_UcCheckInInfoMemberShipType.BackgroundImage = null;
pbx_UcCheckInInfoMemberPicture.Image = Properties.Resources.no_image;
}
}
}
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;
}
}
}
private void btn_UcShowMemberContractInfoSave_Click(object sender, EventArgs e)
{
long?reciptnum;
if (cmb_UcShowMemberContractInfoExpireContractPaymentType.Text.Equals(""))
{
//MessageBox.Show("نوع پرداخت را وارد نمایید");
Alert alert = new Alert("نوع پرداخت را وارد نمایید ", "green");
cmb_UcShowMemberContractInfoExpireContractPaymentType.Focus();
}
else
{
try {
string startDate = dts_UcShowMemberContractInfoStartDate.Value.Value.ToString("M/d/yyyy");
startDate = getDateHijri(startDate);
if (cmb_UcShowMemberContractInfoExpireContractPaymentType.Text.Equals("نقد"))
{
reciptnum = null;
}
else
{
reciptnum = Convert.ToInt64(txb_UcShowMemberContractInfoReciptNum.Text);
}
rayan_sportDataSet.membershipDataTable memberShipDataTable = new rayan_sportDataSet.membershipDataTable();
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int sucsses = membershipTableAdapter.Insert(member.member_id, member.member_name, startDate, txb_UcShowMemberContractInfoEndDate.Text, cmb_UcShowMemberContractInfoContractType.Text, Convert.ToInt32(txb_UcShowMemberContractInfoRemainingSession.Text),
reciptnum, cmb_UcShowMemberContractInfoExpireContractPaymentType.Text, Convert.ToInt64(txb_UcShowMemberContractInfoExpireContractPrice.Text),
Convert.ToInt64(txb_UcShowMemberContractInfoPayment.Text), txb_UcShowMemberContractInfoDes.Text, "فعال"
);
if (sucsses == 1)
{
DateTime d = DateTime.Now;
PersianCalendar pc = new PersianCalendar();
string date1 = string.Format("{0}/{1:00}/{2:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d));
string time1 = string.Format("{0:00}:{1:00}", pc.GetHour(d), pc.GetMinute(d));
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
logTableAdapter.Insert("added membership for : " + member.member_name, "membership", getUser_name(), date1, time1);
//MessageBox.Show("قرارداد با موفقیت اضافه شد");
Alert alert = new Alert("قرارداد با موفقیت اضافه شد", "green");
FillData();
btn_UcShowMemberContractInfoDeleteContract.Enabled = false;
btn_UcShowMemberContractInfoDeleteContract.BackColor = Properties.Settings.Default.MediumGrey;
btn_UcShowMemberContractInfoExpireContract.Enabled = false;
btn_UcShowMemberContractInfoExpireContract.BackColor = Properties.Settings.Default.MediumGrey;
btn_UcShowMemberContractInfoAddContract.Enabled = true;
btn_UcShowMemberContractInfoAddContract.BackColor = Properties.Settings.Default.Blue;
foreach (var txb in tableLayoutPanel3.Controls)
{
if (txb is TextBox)
{
(txb as TextBox).Clear();
}
if (txb is ComboBox)
{
(txb as ComboBox).Text = "";
}
}
dts_UcShowMemberContractInfoStartDate.ResetText();
tableLayoutPanel3.Enabled = false;
btn_UcShowMemberContractInfoClear.BackColor = Properties.Settings.Default.MediumGrey;
btn_UcShowMemberContractInfoSave.BackColor = Properties.Settings.Default.MediumGrey;
}
}
catch (Exception ex) {
//MessageBox.Show(ex.Message);
Alert alert = new Alert("قرارداد با موفقیت اضافه شد", "green");
return;
}
}
}
