private void button1_Click(object sender, EventArgs e)
{
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
memberTableAdapter.FillBySelectMemberById(memberDataTable, Convert.ToInt32(textBox1.Text));
dataGridView1.DataSource = memberDataTable;
}
private void btn_UcShowAllMemberSearch_Click(object sender, EventArgs e)
{
if (txb_UcShowAllMemberMemberName.Text != "" && txb_UcShowAllMemberMemberId.Text != "")
{
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
memberTableAdapter.FillBySearchQueryWithNameCodeGender(memberDataTable, txb_UcShowAllMemberMemberName.Text, int.Parse(txb_UcShowAllMemberMemberId.Text), swb_UcShowAllMemberMemberGender.ValueObject.ToString());
dgv_UcShowAllMemberShowDgv.DataSource = memberDataTable;
dgv_UcShowAllMemberShowDgv.Columns["member_blood"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_sick"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_image"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_address"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_nationalCode"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_charge"].IsVisible = false;
}
else if (txb_UcShowAllMemberMemberName.Text != "")
{
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
memberTableAdapter.FillBySearchMemberNameGender(memberDataTable, txb_UcShowAllMemberMemberName.Text, swb_UcShowAllMemberMemberGender.ValueObject.ToString());
dgv_UcShowAllMemberShowDgv.DataSource = memberDataTable;
dgv_UcShowAllMemberShowDgv.Columns["member_blood"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_sick"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_image"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_address"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_nationalCode"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_charge"].IsVisible = false;
}
else if (txb_UcShowAllMemberMemberId.Text != "")
{
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
memberTableAdapter.FillBySearchMemberCodeGender(memberDataTable, int.Parse(txb_UcShowAllMemberMemberId.Text), swb_UcShowAllMemberMemberGender.ValueObject.ToString());
dgv_UcShowAllMemberShowDgv.DataSource = memberDataTable;
dgv_UcShowAllMemberShowDgv.Columns["member_blood"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_sick"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_image"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_address"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_nationalCode"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_charge"].IsVisible = false;
}
else
{
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
memberTableAdapter.FillBySearchMemberGender(memberDataTable, swb_UcShowAllMemberMemberGender.ValueObject.ToString());
dgv_UcShowAllMemberShowDgv.DataSource = memberDataTable;
dgv_UcShowAllMemberShowDgv.Columns["member_blood"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_sick"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_image"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_address"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_nationalCode"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_charge"].IsVisible = false;
}
}
public UC_ShowAllMember(string user_name)
{
InitializeComponent();
this.user_name = user_name;
rayan_sportDataSet.memberDataTable memberDataTable = new rayan_sportDataSet.memberDataTable();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
memberTableAdapter.Fill(memberDataTable);
dgv_UcShowAllMemberShowDgv.DataSource = memberDataTable;
dgv_UcShowAllMemberShowDgv.Columns["member_blood"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_sick"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_image"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_address"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_nationalCode"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_charge"].IsVisible = false;
dgv_UcShowAllMemberShowDgv.Columns["member_name"].HeaderText = "نام و نام خانوادگی";
dgv_UcShowAllMemberShowDgv.Columns["member_id"].HeaderText = "کد عضویت";
dgv_UcShowAllMemberShowDgv.Columns["member_gender"].HeaderText = "جنسیت";
dgv_UcShowAllMemberShowDgv.Columns["member_tel"].HeaderText = "تلفن";
}
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;
}
}
}
