private bool checkStock() { bool isPass; List <string> pass = new List <string>(); string reserveID = lblRI.Text; ReserveItems ri = new ReserveItems(0, string.Empty, string.Empty, null); DataTable dt = ri.getReserveItem(reserveID); foreach (DataRow item in dt.Rows) { string fruitType = item["fruitType"].ToString(); string fruitSeed = item["fruitSeed"].ToString(); string grade = item["grade"].ToString(); int amount = int.Parse(item["quantity"].ToString()); if (ri.checkStock(fruitType, fruitSeed, grade, amount)) //pass { pass.Add("pass"); } else // fail { pass.Add("fail"); } } if (pass.Contains("fail")) { isPass = false; } else { isPass = true; } pass.Clear(); return(isPass); }
protected void Page_Load(object sender, EventArgs e) { string reserveID = string.Empty; if (!IsPostBack) { ReserveData data = (ReserveData)Session["DATA"]; ReserveItems ri = new ReserveItems(0, string.Empty, string.Empty, null); //ri.ReserveID = "1"; reserveID = data.reserveID; lblRI.Text = data.reserveID; //string[] str = data.reserveDate.Split(' '); lblRD.Text = data.reserveDate; lblCus.Text = data.cusFullname; // str = data.receiveDate.Split(' ') ; lblRecieveDate.Text = data.receiveDate; showSale.DataSource = ri.getReserveItem(data.reserveID); showSale.DataBind(); if (checkStock()) { Button1.Enabled = true; } else { Button1.Enabled = false; Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('ผลไม้ใน stock มีไม่พอ')", true); } } }
protected void gvSellOrder_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string reserveID = gvSellOrder.DataKeys[e.Row.RowIndex].Value.ToString(); ReserveItems ri = new ReserveItems(0, string.Empty, string.Empty, null); GridView gvSellItem = e.Row.FindControl("gvSellItem") as GridView; //ri.ReserveID = reserveID; gvSellItem.DataSource = ri.getReserveItem(reserveID); gvSellItem.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { ReserveOrders ro = new ReserveOrders(DateTime.Now, DateTime.Now, 0, string.Empty, string.Empty, null); string reserveID = lblRI.Text; ReserveItems ri = new ReserveItems(0, string.Empty, string.Empty, null); DataTable dt = ri.getReserveItem(reserveID); foreach (DataRow item in dt.Rows) { string fruitType = item["fruitType"].ToString(); string fruitSeed = item["fruitSeed"].ToString(); string grade = item["grade"].ToString(); int amount = int.Parse(item["quantity"].ToString()); ri.updateStock(fruitType, fruitSeed, grade, amount); } ro.updateSellStatus(reserveID); Response.Redirect("Home.aspx"); }