protected void BtnAddQuotation_Click(object sender, EventArgs e) { if (ddlPurchaseOrder.SelectedValue == "0" || ddlSupplier.SelectedValue == "0" || txtCPU.Text == "" || txtQuotationDate.Text == "") { return; } Hashtable ht = new Hashtable(); string PrOrderNo = ddlPurchaseOrder.SelectedValue; try { ht.Add("QtNo", txtQuotationNo.Text); ht.Add("PrOrderNo", ddlPurchaseOrder.SelectedValue); ht.Add("SupplierCode", ddlSupplier.SelectedValue); ht.Add("BarCode", ddlProduct.SelectedValue); ht.Add("CPU", txtCPU.Text); ht.Add("QtDate", txtQuotationDate.Text); ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode); if (QuotationBll.AddQuotation(ht)) { LoadQuotations(PrOrderNo, ddlSupplier.SelectedValue); lblMessage.Text = "<font color='green'>Quotation added successfully!</font>"; ClearForQuotation(); } else { lblMessage.Text = "<font color='red'>Error in adding quotation!</font>"; } } catch { } }
public void FillSupplier(string PrOrderNo, string BarCode) { ddlSupplier.DataSource = QuotationBll.GetBidders(PrOrderNo, BarCode); ddlSupplier.DataValueField = "SupplierCode"; ddlSupplier.DataTextField = "SupplierName"; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, new ListItem("Select One", "0")); }
private void GenerateReport(string PrOrderNo) { Hashtable ht = new Hashtable(); ht.Add("PrOrderNo", PrOrderNo); DataTable dt = new DataTable(); dt = QuotationBll.QuotationReportReportData(ht); ReportViewer1.LocalReport.DataSources.Clear(); ReportDataSource reportDataset = new ReportDataSource("QuotationByPrOrder_DS", dt); ReportViewer1.LocalReport.DataSources.Add(reportDataset); ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports/QuotationByPrOrder.rdlc"); ReportViewer1.LocalReport.Refresh(); }
protected void btnWorkOrderDone_Click(object sender, EventArgs e) { if (QuotationBll.CompleteWorkOrder(ddlPurchaseOrder.SelectedValue, ddlSupplier.SelectedValue, ddlProduct.SelectedValue, txtRemarks.Text)) { btnWorkOrderDone.Visible = false; DataTable dt3 = PurchaseOrderBll.GetPurchaseOrderProducts(ddlPurchaseOrder.SelectedValue); if (PurchaseOrderBll.MailToSupplier(ddlSupplier.SelectedValue, ddlPurchaseOrder.SelectedValue, dt3)) { } lblWorkOrder.Text = "<font color='green'>Work order has been given to this supplier.</font>"; FillPurchaseOrder(); } else { lblWorkOrder.Text = "<font color='red'>Error in generating work order!.</font>"; } }
protected void btnOrderWork_Click(object sender, EventArgs e) { lblMessage.Text = "Please print this report before completing Work order."; DataTable dt = new DataTable(); string PrOrderNo = ddlPurchaseOrder.SelectedValue; Hashtable ht = new Hashtable(); ht.Add("PrOrderNo", PrOrderNo); ht.Add("SupCode", ddlSupplier.SelectedValue); ht.Add("BarCode", ddlProduct.SelectedValue); dt = QuotationBll.GetPurchaseOrder(ht); ReportViewer2.LocalReport.DataSources.Clear(); ReportDataSource reportDataset = new ReportDataSource("WorkOrder_RPT_DS", dt); ReportViewer2.LocalReport.DataSources.Add(reportDataset); ReportViewer2.LocalReport.ReportPath = Server.MapPath("Reports/WorkOrder_RPT.rdlc"); ReportViewer2.LocalReport.Refresh(); btnWorkOrderDone.Visible = true; }
private void LoadQuotations(string PrOrderNo, string BarCode) { grdQuotations.DataSource = QuotationBll.GetQuotationsByBarCode(PrOrderNo, BarCode); grdQuotations.DataBind(); }
private void LoadRequisitionMatrix() { //Table Matrix = new Table(); DataSet ds = new DataSet(); ds = QuotationBll.GetQuotationMatrixData(); DataTable pr = ds.Tables[0]; DataTable sup = ds.Tables[1]; DataTable mat = ds.Tables[2]; TableRow tr1 = new TableRow(); Hashtable ht = new Hashtable(); int i = 1; TableCell Ph = new TableCell(); Ph.Text = "Items"; Ph.Font.Bold = true; Ph.Width = 200; Ph.HorizontalAlign = HorizontalAlign.Center; Ph.BackColor = Color.DeepSkyBlue; tr1.Cells.Add(Ph); foreach (DataRow dr in sup.Rows) { //// Top head TableCell tc = new TableCell(); tc.Text = dr["SupplierName"].ToString(); tc.Font.Bold = true; tc.Width = 150; tc.HorizontalAlign = HorizontalAlign.Center; tc.BackColor = Color.DeepSkyBlue; tc.BorderColor = Color.DimGray; tc.Height = 40; //tc.Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter; ht.Add(i.ToString(), dr["SupplierCode"].ToString()); tr1.Cells.Add(tc); i++; } tr1.BorderWidth = 1; tr1.BorderColor = Color.Gray; Matrix.Rows.Add(tr1); string PrDrNo = string.Empty; //string LowestSupCode = string.Empty; decimal minCpu = 0; int x = 0; foreach (DataRow dr0 in pr.Rows) { minCpu = 0; TableRow tr = new TableRow(); for (int j = 0; j <= i - 1; j++) { if (j == 0) { // left head TableCell c1 = new TableCell(); c1.Text = pr.Rows[x]["ProductName"].ToString(); // +"<br/>"; +pr.Rows[x]["BarCode"].ToString(); PrDrNo = pr.Rows[x]["BarCode"].ToString(); minCpu = GetLowestBidder(PrDrNo, mat); c1.BorderColor = Color.Gray; c1.HorizontalAlign = HorizontalAlign.Center; tr.Cells.Add(c1); tr.BackColor = Color.LightGray; tr.BorderWidth = 1; tr.BorderColor = Color.Gray; } else { TableCell c = new TableCell(); string valueText = GetCPU(j, ht, PrDrNo, mat); c.Text = valueText; try { if (int.Parse(valueText) == minCpu) { c.BackColor = Color.LightGreen; } else { c.BackColor = Color.WhiteSmoke; } } catch { c.BackColor = Color.WhiteSmoke; } c.HorizontalAlign = HorizontalAlign.Center; tr.Cells.Add(c); tr.BorderWidth = 1; tr.BorderColor = Color.Gray; } } Matrix.Rows.Add(tr); x++; } //Matrix.DataBind(); // Panel1.Controls.Add(Matrix); }
private void SetQuotationNo(string PrOrderNo, string Barcode, string SupplierCode) { txtQuotationNo.Text = PrOrderNo + Barcode + SupplierCode + QuotationBll.GetCount(PrOrderNo, SupplierCode); }
private void LoadQuotations(string PrOrderNo, string SupCode) { grdQuotations.DataSource = QuotationBll.GetQuotationsByPrOrder(PrOrderNo, SupCode); grdQuotations.DataBind(); }