protected void DropDownList1_OnSelectedIndexChanged(object sender, EventArgs e) { QuotationLogic ql = new QuotationLogic(); TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString(); }
protected void Page_Load(object sender, EventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("DESIGNER") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE")) { if (!IsPostBack) { ProductLogic pl = new ProductLogic(); DropDownList1.DataSource = pl.SelectAll(); DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "ProductID"; DropDownList1.DataBind(); if (Convert.ToInt32(Request.QueryString["id"]) > 0) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(Request.QueryString["id"])); Product p1 = pl.SelectByProductID(o1.ProductID); DropDownList1.SelectedItem.Text = p1.Name; QuotationLogic ql = new QuotationLogic(); TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedValue)).QuotationID.ToString(); TextBox2.Text = o1.Quantity.ToString(); TextBox3.Text = o1.Rate.ToString(); TextBox4.Text = o1.PODate.ToString("dd/MM/yyyy"); TextBox5.Text = o1.PONumber.ToString(); TextBox6.Text = o1.CreateDate.ToString("dd/MM/yyyy"); DropDownList2.SelectedItem.Text = o1.Status; TextBox8.Text = o1.StatusRemarks; TextArea2.Text = o1.DeliveryAddress; TextBox9.Text = o1.DeliveryDate.ToString("dd/MM/yyyy"); String po = o1.AttachPO; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); FileUpload1.Visible = false; lnkImage1.Text = po.Substring(25); lnkImage1.NavigateUrl = po; } else { lnkImage1.Visible = false; LinkButton1.Visible = false; } } else { lnkImage1.Visible = false; LinkButton1.Visible = false; QuotationLogic ql = new QuotationLogic(); TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString(); TextBox6.Text = DateTime.Now.ToString("dd/MM/yyyy"); } } Label2.Visible = false; } else { Response.Redirect("Access.aspx"); } }