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