protected void btnSave_Click(object sender, EventArgs e)
{
dtgridList = (DataTable)ViewState["dtgridList"];
string users = Session["id"].ToString();
decimal totalamt = 0;
try
{
foreach (DataRow dr in dtgridList.Rows)
{
totalamt = totalamt + decimal.Parse(dr["Amount"].ToString());
}
FrameWork.PurchaseOrders PRO = new FrameWork.PurchaseOrders();
FrameWork.PurchaseOrderDetails PROsub = new PurchaseOrderDetails();
busPurchaseOrder busPRO = new busPurchaseOrder();
PRO.SupplierID = int.Parse(this.drpSupplier.SelectedValue);
PRO.CreatedById = int.Parse(users);
if (this.txtDateNeeded.Text.Trim() != string.Empty)
{
PRO.ExpectedDate = DateTime.Parse(this.txtDateNeeded.Text);
}
else
{
PRO.ExpectedDate = DateTime.Parse("01/01/1900");
}
PRO.PaymentAmount = totalamt;
string x = busPRO.insertPO(PRO);
foreach (DataRow dr in dtgridList.Rows)
{
PROsub.PurchaseOrderID = int.Parse(x);
PROsub.Quantity = Single.Parse(dr["Quantity"].ToString());
PROsub.UnitCost = decimal.Parse(dr["UnitPrice"].ToString());
PROsub.ProductID = int.Parse(dr["ProductID"].ToString());
busPRO.insertPurchaseOrderDetails(PROsub);
}
}
catch (Exception ex)
{
}
finally
{
this.txtQuantity.Text = string.Empty;
this.txtUOM.Text = string.Empty;
this.drpProduct.SelectedValue = "0";
this.lblDescription.Text = string.Empty;
this.txtUnitPrice.Text = string.Empty;
this.drpSupplier.SelectedValue = "0";
this.txtTerms.Text = string.Empty;
DataTable ds = new DataTable();
ds = null;
this.grdList.DataSource = ds;
grdList.DataBind();
}
}
protected void GridView_SelectedIndexChanged(object sender, EventArgs e)
{
string hello = "";
hello = GridView1.SelectedDataKey["id"].ToString();
busPurchaseOrder PurchaseOrder = new busPurchaseOrder();
FrameWork.PurchaseOrderDetails[] frmDRSI;
frmDRSI = PurchaseOrder.allPurchaseOrderDetails(hello);
GridView2.DataSource = frmDRSI;
GridView2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
busPurchaseOrder busPurchase = new busPurchaseOrder();
FrameWork.PurchaseOrders[] frmDRSI;
frmDRSI = busPurchase.allPO();
GridView1.DataSource = frmDRSI;
GridView1.DataBind();
}
}
protected void drpSupplier_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = (DataTable)ViewState["Supplier"];
DataRow[] foundRows;
string selectValue = "ID = " + this.drpSupplier.SelectedValue;
string sortOrder = "ID ASC";
foundRows = dt.Select(selectValue, sortOrder);
for (int i = 0; i < foundRows.Length; i++)
Console.WriteLine(foundRows[i][2]);
if (foundRows != null)
{
this.lblAddress.Text = foundRows[0]["Address"].ToString();
this.lblTin.Text = foundRows[0]["TIN"].ToString();
//this.lblEmail.Text = foundRows[0]["EmailAddress"].ToString();
this.lbltel.Text = foundRows[0]["BusinessPhone"].ToString();
FrameWork.PurchaseOrders[] dt1;
busPurchaseOrder buspurchase = new busPurchaseOrder();
this.drpPurchase.Items.Clear();
this.drpPurchase.Items.Add(new ListItem("select one", "0"));
dt1 = buspurchase.allPO();
var x = dt1.Where(a => a.SupplierID == int.Parse(this.drpSupplier.SelectedValue)).Select(a=> a.ID);
foreach (var dec in x)
{
this.drpPurchase.Items.Add(new ListItem(dec.ToString(), dec.ToString()));
}
}
}
protected void drpPurchase_SelectedIndexChanged(object sender, EventArgs e)
{
busPurchaseOrder ReceiveOrder = new busPurchaseOrder();
FrameWork.PurchaseOrderDetails[] frmDRSI;
frmDRSI = ReceiveOrder.allPurchaseOrderDetails(this.drpPurchase.SelectedValue);
BindStudent();
foreach(FrameWork.PurchaseOrderDetails x in frmDRSI)
{
DataRow dr;
dr = dtgridList.NewRow();
dr["Quantity"] = x.Quantity.ToString();
dr["UnitOfMeasure"] = string.Empty;
dr["ProductID"] =x.ProductID.ToString();
dr["ItemDescription"] = string.Empty;
//dr["UnitPrice"] = this.txtUnitPrice.Text;
//dr["Amount"] = total;
dr["CmdDelete"] = "Delete";
dtgridList.Rows.Add(dr);
ViewState["dtgridList"] = dtgridList;
grdList.DataSource = dtgridList;
grdList.DataBind();
}
}
