public CreatePurchaseRequest(PurchaseRequest pr, string staffNo, string restNo, string staffName, string restName)
{
cnn.Open();
InitializeComponent();
this.pr = pr;
StfId.Text = staffNo;
StfName.Text = staffName;
RestId.Text = restNo;
RestName.Text = restName;
this.restNo = restNo;
this.staffNo = staffNo;
//new
MySqlCommand getRestaurantHierarchy = new MySqlCommand("SELECT Hierarchy FROM Restaurant WHERE RestNo = '" + restNo + "';", cnn);
restHierarchy = (string)getRestaurantHierarchy.ExecuteScalar();
//
MySqlCommand getNextRequestNo = new MySqlCommand("SELECT MAX(RequestNo) FROM PurchaseRequest", cnn);
nowRequestNo = (string)getNextRequestNo.ExecuteScalar();
if (nowRequestNo == null)
{
nowRequestNo = "00000000";
}
else
{
nowRequestNo = Regex.Match(nowRequestNo, @"\d+").Value;
}
int num = Int32.Parse(nowRequestNo);
num++;
nowRequestNo = num.ToString().PadLeft(8, '0');
CreateDate.Text = today.ToString("yyyy-MM-dd");
//new
MySqlDataAdapter sda = new MySqlDataAdapter("SELECT i.ItemName FROM VItem v,Item i ,Category c WHERE v.category_id = c.category_id AND v.ItemID = i.ItemID AND c.name = '" + restHierarchy + "'; ", cnn);
DataTable dt = new DataTable();
sda.Fill(dt);
//itemList.DataSource = sda;
//itemList.DisplayMember = "ItemName";
foreach (DataRow dr in dt.Rows)
{
itemList.Items.Add(dr["ItemName"].ToString());
}
//
}
private void button1_Click(object sender, EventArgs e)
{
switch (deptCode)
{
case "AM":
this.Hide();
EditMenu em = new EditMenu(this, 0);
em.Show();
break;
case "RM":
this.Hide();
PurchaseRequest pr = new PurchaseRequest(this, restNo, StaffNo);
pr.Show();
break;
case "PM":
this.Hide();
TypeofAgreementMenu tam = new TypeofAgreementMenu(staffName, this);
tam.Show();
break;
case "CM":
this.Hide();
Category cat = new Category(this);
cat.Show();
break;
case "WC":
this.Hide();
WHViewDPI dpi = new WHViewDPI(this);
dpi.Show();
break;
case "AD":
this.Hide();
TypeofAgreementMenu adtam = new TypeofAgreementMenu(staffName, this);
adtam.Show();
break;
}
}
public ViewRequest(PurchaseRequest pr, string staffNo, string restNo, string staffName, string restName, string selectedRequest, string createDate, string status)
{
InitializeComponent();
cnn.Open();
StfId.Text = staffNo;
StfName.Text = staffName;
RestId.Text = restNo;
RestName.Text = restName;
CreateDate.Text = createDate.Substring(0, 10);
this.status.Text = status;
this.pr = pr;
this.restNo = restNo;
this.staffNo = staffNo;
title.Text = "Purchase Request " + selectedRequest;
MySqlDataAdapter showList = new MySqlDataAdapter("SELECT i.ItemName, pr.Quantity, v.VItemID, c.category_id FROM VItem v,Item i ,Category c,PurchaseRequest pr WHERE v.category_id = c.category_id AND v.ItemID = i.ItemID AND pr.VItemID = v.VItemID AND pr.category_id = v.category_id AND pr.RequestNo = '" + selectedRequest + "';", cnn);
DataTable dt = new DataTable();
showList.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
purchaseList2.Rows.Add(dr["itemName"].ToString(), dr["Quantity"].ToString(), dr["VItemID"].ToString(), dr["Category_id"].ToString());
}
}
public EditPurchaseRequest(PurchaseRequest pr, string staffNo, string restNo, string staffName, string restName, string selectedRequest, string createDate)
{
cnn.Open();
InitializeComponent();
StfId.Text = staffNo;
StfName.Text = staffName;
RestId.Text = restNo;
RestName.Text = restName;
CreateDate.Text = createDate.Substring(0, 10);
this.createDate = DateTime.Parse(createDate);
this.selectedRequest = selectedRequest;
this.restNo = restNo;
this.staffNo = staffNo;
title.Text = "Purchase Request " + selectedRequest;
MySqlDataAdapter showList = new MySqlDataAdapter("SELECT i.ItemName, pr.Quantity, v.VItemID, c.category_id FROM VItem v,Item i ,Category c,PurchaseRequest pr WHERE v.category_id = c.category_id AND v.ItemID = i.ItemID AND pr.VItemID = v.VItemID AND pr.category_id = v.category_id AND pr.RequestNo = '" + selectedRequest + "';", cnn);
DataTable dt = new DataTable();
showList.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
purchaseList2.Rows.Add(dr["itemName"].ToString(), dr["Quantity"].ToString(), dr["VItemID"].ToString(), dr["Category_id"].ToString());
}
MySqlCommand getRestaurantHierarchy = new MySqlCommand("SELECT Hierarchy FROM Restaurant WHERE RestNo = '" + restNo + "';", cnn);
restHierarchy = (string)getRestaurantHierarchy.ExecuteScalar();
MySqlDataAdapter sda = new MySqlDataAdapter("SELECT i.ItemName FROM VItem v,Item i ,Category c WHERE v.category_id = c.category_id AND v.ItemID = i.ItemID AND c.name = '" + restHierarchy + "'; ", cnn);
DataTable dt2 = new DataTable();
sda.Fill(dt2);
foreach (DataRow dr in dt2.Rows)
{
itemList.Items.Add(dr["ItemName"].ToString());
}
this.pr = pr;
}
