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