public frmCusOrder()
{
InitializeComponent();
bussinessclass bc = new bussinessclass();
DataSet ds = new DataSet();
ds = bc.Orders_GetList();
dgview.DataSource = ds;
dgview.DataMember = "Orders";
DataSet dscity = new DataSet();
dscity = bc.City_GetList();
cmbbeginning.DataSource = dscity.Tables["City"];
cmbbeginning.DisplayMember = "Name";
cmbbeginning.ValueMember = "Code";
cmbdestination.DataSource = dscity.Tables["City"];
cmbdestination.DisplayMember = "Name";
cmbdestination.ValueMember = "Code";
DataSet dsvehicle = new DataSet();
dsvehicle = bc.Vehicle_GetList();
cmbvehicle.DataSource = dsvehicle.Tables[0];
cmbvehicle.DisplayMember = "Title";
cmbvehicle.ValueMember = "ID";
}
private void btnadd_Click(object sender, EventArgs e)
{
bussinessclass bc = new bussinessclass();
bc.Orders_insert(Convert.ToInt32(txtId.Text), txttitle.Text, txtDesc.Text, Convert.ToInt32(cmbvehicle.SelectedValue), Convert.ToInt32(txtprice.Text), Convert.ToInt32(txtmaxnumber.Text), Convert.ToInt32(cmbbeginning.SelectedValue), Convert.ToInt32(cmbdestination.SelectedValue), txtdate.Text, txttime.Text, Convert.ToInt32(txtstatus.Text));
var q = bc.Orders_GetList();
dgview.DataSource = q;
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
bussinessclass bc = new bussinessclass();
// cmbvehicle.SelectedValue = 1;
bc.Orders_update(Convert.ToInt32(txtid1.Text), txttitle1.Text, txtdescription.Text, Convert.ToInt32(cmbvehicle.SelectedValue), Convert.ToInt32(txtprice.Text), Convert.ToInt32(txtmaxnumber.Text), Convert.ToInt32(cmbbeginning.SelectedValue), Convert.ToInt32(cmbdestination.SelectedValue), txtdate.Text, txttime.Text, Convert.ToInt32(txtstatus.Text));
var q = bc.Orders_GetList();
dgview.DataSource = q;
}
private void btndelete_Click(object sender, EventArgs e)
{
int indx = dgview.SelectedRows[0].Index;
bussinessclass bc = new bussinessclass();
bc.Orders_delete(Convert.ToInt32(dgview.SelectedRows[0].Cells[0].Value));
var q = bc.Orders_GetList();
dgview.DataSource = q;
}
