public void bindGridView()
{
bt_addCustomer.Show();
BtupdateCustomer.Hide();
DGV_Customer.Rows.Clear();
store = new store();
var query = (from s in store.SalesRepresentatives
from m in store.employee
where (s.Employee_Id == m.ID && s.status == false)
select new { m, s }
).ToList();
if (query.Count != 0)
{
DGV_Customer.RowCount = query.Count;
int i = 0;
foreach (var item in query)
{
DGV_Customer.Rows[i].Cells[0].Value = item.s.ID.ToString();
DGV_Customer.Rows[i].Cells[1].Value = item.m.EmployeeName.ToString();
DGV_Customer.Rows[i].Cells[2].Value = item.m.Phone.ToString();
DGV_Customer.Rows[i].Cells[3].Value = item.m.Address;
i++;
}
}
DGV_Customer.Refresh();
DGV_Customer.Update();
}
private void bt_editCustomer_Click_1(object sender, EventArgs e)
{
if (DGV_Customer.SelectedRows.Count == 0)
{
MessageBoxIcon.Warning.ToString();
MessageBox.Show("يجب ان تختار المندوب من المندوبين");
bt_addCustomer.Show();
}
else
{
metroPanel1.Show();
BtupdateCustomer.Show();
bt_addCustomer.Hide();
CustomerAddressTxt.Visible = true;
CustomerPhoneTxt.Visible = true;
addressLabel.Visible = true;
phoneLabel.Visible = true;
p_id = int.Parse(DGV_Customer.SelectedRows[0].Cells[0].Value.ToString());
var query = store.SalesRepresentatives.FirstOrDefault(p => p.ID == p_id);
MandobNametextBox1.Text = query.Employee.EmployeeName;
CustomerPhoneTxt.Text = query.Employee.Phone;
CustomerAddressTxt.Text = query.Employee.Address;
}
}
//private void delCustomer_Click(object sender, EventArgs e)
//{
// store = new store();
// DGV_Customer.DataSource = null;
// DGV_Customer.Update();
// DGV_Customer.Refresh();
// var id = int.Parse(DGV_Customer.SelectedRows[0].Cells[0].Value.ToString());
// var query = store.customers.FirstOrDefault(p => p.ID == id);
// query.Status = true;
// store.SaveChanges();
// bindGridView();
//}
//private void bt_editCustomer_Click(object sender, EventArgs e)
//{
//}
//private void TXT_customerSearch_TextChanged(object sender, EventArgs e)
//{
//}
//private void CustomerForm1_Load(object sender, EventArgs e)
//{
// bindGridView();
//}
//private void BtupdateCustomer_Click(object sender, EventArgs e)
//{
// store = new store();
// p_id = int.Parse(DGV_Customer.SelectedRows[0].Cells[0].Value.ToString());
// var query = store.customers.FirstOrDefault(p => p.ID == p_id);
// query.Name = CustomerNameTxt.Text.ToString();
// query.addrees = CustomerAddressTxt.Text.ToString();
// query.Phone = CustomerPhoneTxt.Text.ToString();
// query.type = CustomerTypecomboBox.SelectedItem.ToString();
// store.SaveChanges();
// bindGridView();
//}
//private void bt_addCustomer_Click(object sender, EventArgs e)
//{
//}
private void showAddCustomerBtn_Click(object sender, EventArgs e)
{
bt_addCustomer.Show();
BtupdateCustomer.Hide();
CustomerNameTxt.Text = null;
CustomerPhoneTxt.Text = null;
CustomerAddressTxt.Text = null;
}
private void button1_Click_1(object sender, EventArgs e)
{
metroPanel1.Show();
BtupdateCustomer.Hide();
bt_addCustomer.Show();
CustomerAddressTxt.Visible = false;
CustomerPhoneTxt.Visible = false;
addressLabel.Visible = false;
phoneLabel.Visible = false;
}
private void bt_editCustomer_Click(object sender, EventArgs e)
{
//edit
BtupdateCustomer.Show();
bt_addCustomer.Hide();
if (DGV_Customer.SelectedRows.Count == 0)
{
MessageBoxIcon.Warning.ToString();
MessageBox.Show("يجب ان تختار منتج من المنتجات");
bt_addCustomer.Show();
}
else
{
p_id = int.Parse(DGV_Customer.SelectedRows[0].Cells[0].Value.ToString());
var query = store.customers.FirstOrDefault(p => p.ID == p_id);
CustomerNameTxt.Text = query.Name;
CustomerPhoneTxt.Text = query.Phone;
CustomerAddressTxt.Text = query.addrees;
CustomerTypecomboBox.SelectedValue = query.type.ToString();
}
}
