private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
dbconnection.Open();
row1 = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex];
txtCode.Text = row1.Cells[0].Value.ToString();
string code = row1.Cells[0].Value.ToString();
double quantity = Convert.ToDouble(row1.Cells[1].Value);
if (int.TryParse(txtStoreID.Text, out storeId) && int.TryParse(txtBranchID.Text, out branchID) && int.TryParse(txtBillNumber.Text, out BranchBillNum))
{
string query = "select Store_Place from storage where Store_ID=" + storeId + " and Code='" + code + "' order by Storage_Date ";
MySqlDataAdapter da = new MySqlDataAdapter(query, dbconnection);
DataTable dt = new DataTable();
da.Fill(dt);
comStorePlace.DataSource = dt;
comStorePlace.DisplayMember = dt.Columns["Store_Place"].ToString();
comStorePlace.Text = "";
query = "select sum(Received_Quantity) from received_bill_store where Branch_ID=" + branchID + " and Branch_BillNumber=" + BranchBillNum + " and Code=" + code;
MySqlCommand com = new MySqlCommand(query, dbconnection);
if (com.ExecuteScalar().ToString() != "")
{
double recivedQuantity = Convert.ToDouble(com.ExecuteScalar());
txtRecivedQuantity.Text = (quantity - recivedQuantity).ToString();
}
else
{
txtRecivedQuantity.Text = quantity.ToString();
}
finish = false;
for (int i = 0; i < recordFinishedCount; i++)
{
if (recordFinishedCode[i].Split('*')[0] == code && recordFinishedCode[i].Split('*')[1] == BranchBillNum.ToString() && recordFinishedCode[i].Split('*')[2] == branchID.ToString())
{
finish = true;
}
}
groupBox3.Visible = true;
}
else
{
MessageBox.Show("insert correct value");
}
dbconnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtBillNumber_KeyDown(object sender, KeyEventArgs e)
{
try
{
dbconnection.Open();
if (e.KeyCode == Keys.Enter)
{
for (int i = 0; i < dgv2RowsCode.Length; i++)
{
dgv2RowsCode[i] = "";
}
dataGridView1.DataSource = null;
dataGridView2.DataSource = null;
bool flag2 = false;
int billNum = 0, customerID = 0, clientID = 0, delegateID = 0;
if (int.TryParse(txtBillNumber.Text, out BranchBillNum) && int.TryParse(txtBranchID.Text, out branchID) && int.TryParse(txtStoreID.Text, out storeId))
{
string query = "select * from requests where requests.BranchBillNumber=" + BranchBillNum + " and Branch_ID=" + branchID + " and Store_ID=" + storeId;
MySqlCommand com = new MySqlCommand(query, dbconnection);
MySqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
flag2 = true;
billNum = Convert.ToInt32(dr["Request_ID"]);
if (dr["Customer_ID"].ToString() != "")
{
customerID = Convert.ToInt32(dr["Customer_ID"]);
}
clientID = Convert.ToInt32(dr["Client_ID"]);
delegateID = Convert.ToInt32(dr["Delegate_ID"]);
dateTimePicker2.Value = Convert.ToDateTime(dr["Recive_Date"]);
}
dr.Close();
if (flag2 == true)
{
groupBox1.Visible = true;
//extract delgate info
if (delegateID > 0)
{
query = "select * from Delegate where Delegate_ID=" + delegateID;
com = new MySqlCommand(query, dbconnection);
dr = com.ExecuteReader();
while (dr.Read())
{
txtDelegateName.Text = dr["Delegate_Name"].ToString();
txtDelegateID.Text = dr["Delegate_ID"].ToString();
}
dr.Close();
}
else
{
dbconnection.Close();
flag2 = false;
MessageBox.Show("error..Must have delegate");
return;
}
//extract customer info
if (clientID > 0)
{
query = "select * from customer where Customer_ID=" + clientID + "";
com = new MySqlCommand(query, dbconnection);
dr = com.ExecuteReader();
while (dr.Read())
{
txtClientName.Text = dr["Customer_Name"].ToString();
txtClientID.Text = dr["Customer_ID"].ToString();
txtPhoneNumber.Text = dr["Customer_Phone"].ToString();
txtAddress.Text = dr["Customer_Address"].ToString();
}
dr.Close();
}
else
{
MessageBox.Show("error..No client");
dbconnection.Close();
return;
}
if (customerID > 0)
{
query = "select * from customer where Customer_ID=" + customerID + "";
com = new MySqlCommand(query, dbconnection);
dr = com.ExecuteReader();
while (dr.Read())
{
txtCustomerName.Text = dr["Customer_Name"].ToString();
txtCustomerID.Text = dr["Customer_ID"].ToString();
txtPhoneNumber.Text = dr["Customer_Phone"].ToString();
txtAddress.Text = dr["Customer_Address"].ToString();
}
dr.Close();
}
else
{
txtCustomerName.Visible = false;
labCustomer.Visible = false;
txtCustomerID.Visible = false;
}
flag2 = false;
// query= "select Storage_Date from storage inner join product_bill on storage.Code=product_bill.Code where product_bill.Dash_Bill_ID=" + billNum + " and storage.Store_ID=" + storeID + " order by Storage_Date limit 1"
query = "select distinct request_details.Code as 'كود',request_details.Quantity as ' الكمية',storage.Store_Place as 'مكان التخزين', type.Type_Name as 'النوع', factory.Factory_Name as 'المصنع' ,groupo.Group_Name as 'المجموعة', product.Product_Name as 'المنتج' ,data.Colour as 'اللون', data.Size as 'المقاس', data.Sort as 'الفرز',data.Classification as 'التصنيف', data.Description as 'الوصف' from request_details inner join data on data.Code=request_details.Code INNER JOIN requests on requests.Request_ID=request_details.Request_ID INNER JOIN type ON type.Type_ID = data.Type_ID INNER JOIN product ON product.Product_ID = data.Product_ID INNER JOIN factory ON data.Factory_ID = factory.Factory_ID INNER JOIN groupo ON data.Group_ID = groupo.Group_ID left join storage on storage.Code=request_details.Code where request_details.Request_ID=" + billNum + " and requests.Store_ID=" + storeId + " and storage.Storage_Date=(select Storage_Date from storage inner join request_details on storage.Code=request_details.Code where request_details.Request_ID=" + billNum + " and storage.Store_ID=" + storeId + " order by Storage_Date limit 1)";
MySqlDataAdapter da = new MySqlDataAdapter(query, dbconnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
/////////////////
for (int i = 0; i < recordRestCount; i++)
{
for (int j = 0; j < dataGridView1.Rows.Count - 1; j++)
{
if (addedRecordRestCode[i].Split('*')[0] == dataGridView1.Rows[j].Cells[0].Value.ToString() && addedRecordRestCode[i].Split('*')[1] == BranchBillNum.ToString() && addedRecordRestCode[i].Split('*')[2] == branchID.ToString())
{
dataGridView1.Rows[dataGridView1.Rows[j].Cells[0].RowIndex].DefaultCellStyle.BackColor = Color.Silver;
}
}
}
for (int i = 0; i < recordFinishedCount; i++)
{
for (int j = 0; j < dataGridView1.Rows.Count - 1; j++)
{
if (recordFinishedCode[i].Split('*')[0] == dataGridView1.Rows[j].Cells[0].Value.ToString() && recordFinishedCode[i].Split('*')[1] == BranchBillNum.ToString() && recordFinishedCode[i].Split('*')[2] == branchID.ToString())
{
dataGridView1.Rows[dataGridView1.Rows[j].Cells[0].RowIndex].DefaultCellStyle.BackColor = Color.Gray;
}
}
}
clear();
dataGridView2.Rows.Clear();
}
else
{
MessageBox.Show("error..this bill not exist");
}
}
else
{
MessageBox.Show("insert correct value");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dbconnection.Close();
}
