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");
}
public ReserveOrders(DateTime reserveDate, DateTime reserveInterval, int n, string g, string status, Fruit f)
{
this.reserveDate = reserveDate;
this.reserveInterval = reserveInterval;
this.RItems = new ReserveItems(n, g, status, f);
}
public void insertReserveItem(int reserveID, int quantity, string fruitType, string fruitSeed, string grade)
{
ReserveItems ri = new ReserveItems(0, string.Empty, string.Empty, null);
ri.insertReserveItem(reserveID, quantity, fruitType, fruitSeed, grade);
}
