public frmRentFurniture(DataSet Dataset_employee, DataSet DT, List <String> items)
{
Dataset_customer = DT;
this.Dataset_employee = Dataset_employee;
cart = items;
InitializeComponent();
TxtRentDate.Text = DateTime.Now.ToShortDateString();
TxtEmployee_id.Text = Dataset_employee.Tables[0].Rows[0][0].ToString();
TxtCustomer_id.Text = Dataset_customer.Tables[0].Rows[0][0].ToString();
int price = 0;
foreach (String id in cart)
{
price = price + int.Parse(new DB_Access().furniture(id).Tables[0].Rows[0][5].ToString());
Dataset_furniture = new DB_Access().furniture(id);
grid_selected_item.Rows.Add(Dataset_furniture.Tables[0].Rows[0][0].ToString(), Dataset_furniture.Tables[0].Rows[0][1].ToString(), Dataset_furniture.Tables[0].Rows[0][2].ToString(), Dataset_furniture.Tables[0].Rows[0][3].ToString(), Dataset_furniture.Tables[0].Rows[0][4].ToString(), Dataset_furniture.Tables[0].Rows[0][5].ToString());
}
TxtTotal_price.Text = price.ToString();
}
private void sortby(object senDataSetEmployeer, EventArgs e)
{
Cobox_selectItem.Items.Clear();
DataSet DataSet = null;
if (Cobox_sortby.Text == "By Item Number")
{
DataSet = new DB_Access().furnitureTypes("item_num");
field = "item_num";
procedure = "FurnitureByItem";
}
else if (Cobox_sortby.Text == "By Category")
{
DataSet = new DB_Access().furnitureTypes("category");
field = "category";
procedure = "FurnitureByCategory";
}
else if (Cobox_sortby.Text == "By Style")
{
DataSet = new DB_Access().furnitureTypes("Style");
field = "Style";
procedure = "FurnitureByStyle";
}
else if (Cobox_sortby.Text == "By Furniture ID")
{
DataSet = new DB_Access().furnitureTypes("F_id");
field = "F_id";
procedure = "FurnitureByFid";
}
if (DataSet != null)
{
foreach (DataRow row in DataSet.Tables[0].Rows)
{
Cobox_selectItem.Items.Add(row[0].ToString());
}
}
}
private void selectItems(object senDataSetEmployeer, EventArgs e)
{
DataSet = new DB_Access().Searchfurniture(field, Cobox_selectItem.Text, procedure);
grid_ShowItem.DataSource = DataSet.Tables[0].DefaultView;
}