private void FillCombo() { client = new MyClient(); ds = new DataSet(); ds = client.GetDataSet("Select Id,Name From TableGroup; Select Distinct Number From Tables"); cmbxTableGroup.DataSource = ds.Tables[0].DefaultView; cmbxTableGroup.ValueMember = "Id"; cmbxTableGroup.DisplayMember = "Name"; cmbxTableGroup.SelectedIndex = 0; for (int i = 1; i <= 100; i++) { int k = 0; foreach (DataRow dr in ds.Tables[1].Rows) { if (i.ToString() != dr["Number"].ToString()) { k++; } } if (k == ds.Tables[1].Rows.Count) { cmbxTableNumber.Items.Add(i.ToString()); } } string[] installs = new string[] { "Məbləğ", "Faiz" }; cmbxAdditiontype.Items.AddRange(installs); cmbxTableNumber.SelectedIndex = 0; }
private void EditData(int id) { client = new MyClient(); ds = new DataSet(); ds = client.GetDataSet("Select a.Id,a.SurName,a.Name,a.UserName,a.Address,a.PhoneNumber,b.Name As OfficeName,a.Email,a.Img,b.Id As OfficeId" + " From Users As a INNER JOIN Office As b ON a.OfficeId = b.Id Where a.Id =" + id + ";Select Id,Name From Office"); cboOfficeName.DataSource = ds.Tables[1].DefaultView; cboOfficeName.DisplayMember = "Name"; cboOfficeName.ValueMember = "Id"; foreach (DataRow dr in ds.Tables[0].Rows) { txtName.Text = (dr["Name"].ToString()); txtSurname.Text = (dr["SurName"].ToString()); txtUser.Text = (dr["UserName"].ToString()); txtAddress.Text = (dr["Address"].ToString()); txtEmail.Text = (dr["Email"].ToString()); txtPhone.Text = (dr["PhoneNumber"].ToString()); imgBox.Image = (dr["Img"] == DBNull.Value ? myImage : Image.FromStream(new MemoryStream((byte[])dr["Img"]))); cboOfficeName.SelectedValue = (int)dr["OfficeId"]; } ds.Dispose(); }
private void ShowTable() { client = new MyClient(); ds = new DataSet(); ds = client.GetDataSet("Select a.Id,b.Name As GroupName,a.Name,a.Number,IIf(a.Type=0, 'Mebleg','Faiz') As Type,a.Amount,a.Status" + " From Tables As a INNER JOIN TableGroup As b ON a.GroupId = b.Id Order by a.Status DESC"); dgvTables.DataSource = ds.Tables[0].DefaultView; }
private void EditData(int id) { string[] installs = new string[] { "Məbləğ", "Faiz" }; cmbxAdditiontype.Items.AddRange(installs); client = new MyClient(); ds = new DataSet(); ds = client.GetDataSet("Select a.Id,a.Name,a.Number,b.Name As GroupName,a.Type,a.Amount,a.GroupId, a.Status" + " From Tables As a INNER JOIN TableGroup As b ON a.Id = b.Id Where a.Id =" + id + "; Select Id, Name From TableGroup; Select Distinct Number From Tables"); cmbxTableGroup.DataSource = ds.Tables[1].DefaultView; cmbxTableGroup.DisplayMember = "Name"; cmbxTableGroup.ValueMember = "Id"; foreach (DataRow dr in ds.Tables[0].Rows) { txtName.Text = (dr["Name"].ToString()); tablename = (dr["Name"].ToString()); cmbxTableNumber.SelectedValue = (int)dr["Number"]; defnum = (dr["Number"].ToString()); cmbxTableGroup.SelectedValue = (int)dr["GroupId"]; cmbxAdditiontype.SelectedIndex = (int)dr["Type"]; txtAdditionAmount.Text = (dr["Amount"].ToString()); chbxStatus.Checked = Convert.ToBoolean(dr["Status"]); } ds.Dispose(); chbxStatus.Enabled = false; cmbxTableNumber.Items.Add(defnum); cmbxTableNumber.SelectedIndex = 0; for (int i = 1; i <= 100; i++) { int k = 0; foreach (DataRow dr in ds.Tables[2].Rows) { if (i.ToString() != dr["Number"].ToString()) { k++; } } if (k == ds.Tables[2].Rows.Count) { cmbxTableNumber.Items.Add(i.ToString()); } } }
private void FillData(int id) { client = new MyClient(); ds = new DataSet(); ds = client.GetDataSet("Select a.Id,a.SurName,a.Name,a.UserName,a.Address,a.PhoneNumber,b.Name As OfficeName,a.Email,a.Img,a.ClosedDate,b.Id As OfficeId" + " From Users As a INNER JOIN Office As b ON a.OfficeId = b.Id Where a.Id =" + id + ";Select Id,Name From Office"); cboOfficeName.DataSource = ds.Tables[1].DefaultView; cboOfficeName.DisplayMember = "Name"; cboOfficeName.ValueMember = "Id"; foreach (DataRow dr in ds.Tables[0].Rows) { txtName.Text = (dr["Name"].ToString()); txtSurname.Text = (dr["SurName"].ToString()); txtUser.Text = (dr["UserName"].ToString()); txtAddress.Text = (dr["Address"].ToString()); txtEmail.Text = (dr["Email"].ToString()); txtPhone.Text = (dr["PhoneNumber"].ToString()); cboOfficeName.SelectedValue = (int)dr["OfficeId"]; txtDate.Text = (dr["ClosedDate"].ToString()); } if (txtDate.Text.ToString() == "") { btnActive.Enabled = false; btnDeactive.Enabled = true; btnPassZero.Enabled = true; } else { btnActive.Enabled = true; btnDeactive.Enabled = false; btnPassZero.Enabled = false; } ds.Dispose(); }