protected void GetInvoiceDetails() { #region getHeaderDetails query = "Select A.[DOCUMENT_NO],CONVERT(VARCHAR(11),A.[DOCUMENT_DATE] ,106) as [DOCUMENT_DATE], A.PURCH_INDENTNO, CONVERT(VARCHAR(11),A.[PURCH_INDENTDATE],106) AS PURCH_INDENTDATE, " + "A.MATERIAL_VALUE, A.PURCH_RECIEPTNO, A.TRANSPORTER_CODE,A.VEHICAL_NO, A.VEHICAL_TYPE, A.[SALE_INVOICENO] AS INVOICENO, " + " CONVERT(VARCHAR(11), A.[SALE_INVOICEDATE],106) AS INVOICEDATE from [ax].[ACXPURCHINVRECIEPTHEADER] A where A.[SITE_Code]='" + Session["SiteCode"].ToString() + "' " + "and A.[DATAAREAID]='" + Session["DATAAREAID"].ToString() + "' and A.PURCH_RECIEPTNO='" + drpRecieptNo.SelectedItem.Text + "' "; dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { txtReceiptDate.Text = dt.Rows[0]["DOCUMENT_DATE"].ToString(); txtInvoiceDate.Text = dt.Rows[0]["INVOICEDATE"].ToString(); // decimal materialValue = Convert.ToDecimal(dt.Rows[0]["MATERIAL_VALUE"].ToString()); txtReceiptValue.Text = "0.00"; } #endregion #region Product Details query = "exec ACX_GET_NONSALABLEINVOICEDETAIL '" + Session["SiteCode"].ToString() + "','" + Session["DATAAREAID"].ToString() + "','" + drpRecieptNo.SelectedItem.Text + "',0"; dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { DDLMaterialCode.DataSource = dt; DDLMaterialCode.DataTextField = "PRODUCTDESC"; DDLMaterialCode.DataValueField = "PRODUCT_CODE"; DDLMaterialCode.DataBind(); DDLMaterialCode.Items.Insert(0, new ListItem("--Select--", "0")); } #endregion }
protected void GetProduct() { #region Product Details dt = (DataTable)Session["MarketVRSDetails"]; if (dt != null) { DDLMaterialCode.DataSource = dt; DDLMaterialCode.DataTextField = "PRODUCT_NAME"; DDLMaterialCode.DataValueField = "PRODUCTCODE"; DDLMaterialCode.DataBind(); DDLMaterialCode.Items.Insert(0, new ListItem("--Select--", "0")); } #endregion }
protected void GetProduct() { #region Product Details string bucode; if (ddlBusinessUnit.SelectedIndex == 0) { bucode = ""; } else { bucode = ddlBusinessUnit.SelectedValue; } dt = new DataTable(); if (rdoColdRoomDistruction.Checked == true) { query = "exec ACX_GETDISTRUCTIONPRODUCTDETAILS '" + Session["SiteCode"].ToString() + "',0,'" + bucode + "'"; dt = obj.GetData(query); } else if (rdoMarketReturnDistruction.Checked == true) { // query = "exec ACX_GETDISTRUCTIONPRODUCTDETAILS '" + Session["SiteCode"].ToString() + "',1"; dt = (DataTable)Session["MarketDistructionDetails"]; if (dt != null) { var Value = dt.Select("Cust_Group ='" + ddlCustomerGroup.Text.Trim() + "' AND CUSTOMER_CODE ='" + ddlCustomer.Text.Trim() + "'"); dt = Value.CopyToDataTable(); var distValue = dt.DefaultView.ToTable(true, "PRODUCT_NAME", "PRODUCTCODE"); DataTable dtCust = new DataTable(); dtCust = (DataTable)distValue; dt = dtCust; } } if (dt != null) { DDLMaterialCode.DataSource = dt; DDLMaterialCode.DataTextField = "PRODUCT_NAME"; DDLMaterialCode.DataValueField = "PRODUCTCODE"; DDLMaterialCode.DataBind(); DDLMaterialCode.Items.Insert(0, new ListItem("--Select--", "0")); } #endregion }
private bool ValidateLineItemAdd() { bool b = true; if (DDLMaterialCode.Text == string.Empty || DDLMaterialCode.Text == "--Select--") { string message = "alert('Select Product First !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); DDLMaterialCode.Focus(); b = false; return(b); } if (txtValue.Text == string.Empty) { txtValue.Text = "0"; } if (txtBoxQty.Text == string.Empty || txtBoxQty.Text == "0") { b = false; string message = "alert('Qty cannot be left blank !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtBoxQty.Focus(); return(b); } if (txtPcsQty.Text == string.Empty) { txtPcsQty.Text = "0"; } if (txtBatch.Text == string.Empty) { string message = "alert('Please Provide Batch No !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtBatch.Focus(); b = false; return(b); } if (txtMDF.Text == string.Empty) { string message = "alert('Please Provide MDF !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtMDF.Focus(); b = false; return(b); } foreach (GridViewRow grv in gvDetails.Rows) { DataTable dt = new DataTable(); if (Session["ProductDetails"] != null) { dt = (DataTable)Session["ProductDetails"]; if (dt.Rows.Count > 0) { string sqty = Convert.ToString(dt.Compute("Sum(QtyBox)", "ProductCode ='" + DDLMaterialCode.SelectedItem.Value + "'")); if (sqty == "") { sqty = "0"; } decimal sumQty = Convert.ToDecimal(sqty) + Convert.ToDecimal(txtBoxQty.Text); if (sumQty > Convert.ToDecimal(txtStockQty.Text)) { string message = "alert('Distruction Qty cannot be more than quantity available to move.!!');"; ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", message, true); b = false; return(b); } } } } if (Convert.ToDecimal(txtValue.Text) <= 0) { string message = "alert('Claim value should be more than zero.!!');"; ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", message, true); b = false; return(b); } return(b); }
private bool ValidateLineItemAdd() { bool b = true; if (DDLMaterialCode.Text == string.Empty || DDLMaterialCode.Text == "--Select--") { string message = "alert('Select Product First !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); DDLMaterialCode.Focus(); b = false; return(b); } if (txtBatch.Text == string.Empty) { string message = "alert('Please Provide Batch No !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtBatch.Focus(); b = false; return(b); } if (txtMDF.Text == string.Empty) { string message = "alert('Please Provide MDF !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtMDF.Focus(); b = false; return(b); } decimal totalBox = Convert.ToDecimal(txtBoxQty.Text) + (Convert.ToDecimal(txtPcsQty.Text) / Convert.ToDecimal(txtPackSize.Text)); if (totalBox == 0) { b = false; string message = "alert('Qty cannot be left blank !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtBoxQty.Focus(); return(b); } if (txtPcsQty.Text == string.Empty) { txtPcsQty.Text = "0"; } if (txtPackSize.Text == "" || txtPackSize.Text == "0") { txtPackSize.Text = "1"; } if (Convert.ToDecimal(txtBoxQty.Text) < 0) { b = false; string message = "alert('Distruction qty box cannot be less than zero!');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtBoxQty.Focus(); return(b); } if (Convert.ToDecimal(txtPcsQty.Text) < 0) { b = false; string message = "alert('Distruction qty pcs cannot be less than zero!');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtPcsQty.Focus(); return(b); } if (txtMDF.Text == string.Empty) { txtMDF.Text = System.DateTime.Today.ToString("dd-MMM-yyyy"); } if (Convert.ToDecimal(txtActualClaim.Text) <= 0) { string message = "alert('Claim amount should be more than zero.!!');"; ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", message, true); b = false; return(b); } ////=====Same product cant add-=================== //foreach (GridViewRow grv in gvDetails.Rows) //{ // string product = grv.Cells[1].Text; // if (DDLMaterialCode.SelectedItem.Value == product) // { // string message = "alert('" + DDLMaterialCode.SelectedItem.Text + " is already exists in the list .Please Select Another Product !!');"; // ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", message, true); // b = false; // return b; // } //} return(b); }