protected void txtQtyBox_TextChanged(object sender, EventArgs e) //This for calculate Qty value,Crate and Ltr for sale Line { try { GridViewRow gvrow = (GridViewRow)(((TextBox)sender)).NamingContainer; TextBox txtBox = (TextBox)gvrow.FindControl("txtBox"); TextBox txtPCS = (TextBox)gvrow.FindControl("txtPCS"); TextBox txtQty = (TextBox)gvrow.FindControl("txtqty"); //total Qty conv TextBox txtBoxPcs = (TextBox)gvrow.FindControl("txtBoxPcs"); //total Qty conv HiddenField productPack = (HiddenField)gvrow.FindControl("HiddenField2"); if (txtBox.Text == "") { txtBox.Text = "0"; } if (txtPCS.Text == "") { txtPCS.Text = "0"; } if (Convert.ToDecimal(txtPCS.Text) > Convert.ToDecimal(productPack.Value)) { int pcs = Convert.ToInt32(Convert.ToDecimal(txtPCS.Text)); int pac = Convert.ToInt32(Convert.ToDecimal(productPack.Value)); int addbox = pcs / pac; int remainder = pcs % pac; if (remainder == 0) { txtPCS.Text = "0"; } else { txtPCS.Text = Convert.ToString(remainder); } txtBox.Text = Convert.ToString(Convert.ToInt32(Convert.ToDouble(txtBox.Text)) + addbox); } if (txtBox.Text != "" && txtPCS.Text != "") { string str = (Convert.ToInt32(txtBox.Text) + (Convert.ToDecimal(txtPCS.Text) / Convert.ToDecimal(productPack.Value))).ToString("N6"); txtQty.Text = str; } DataTable dt = new DataTable(); dt = baseObj.GetData("SELECT BOXPRINT FROM [dbo].[udf_GetPCSDetails](" + App_Code.Global.ConvertToDecimal(txtQty.Text).ToString() + "," + Convert.ToDecimal(productPack.Value) + ")"); if (dt.Rows.Count > 0) { txtBoxPcs.Text = dt.Rows[0][0].ToString(); } string[] calValue = baseObj.CalculatePrice1(gvrow.Cells[1].Text, string.Empty, decimal.Parse(txtQty.Text), "Box"); if (calValue.Length > 0) { gvrow.Cells[3].Text = calValue[0]; //Crate gvrow.Cells[8].Text = calValue[1]; //ltr } if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(gvrow.Cells[9].Text)) { gvrow.BackColor = System.Drawing.Color.Red; this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please check stock Qty for ITEM:" + gvrow.Cells[1].Text + " !');", true); txtQty.Text = "0"; gvrow.Cells[3].Text = "0"; gvrow.Cells[8].Text = "0"; } else { gvrow.BackColor = System.Drawing.Color.White; } ltr = 0; Crates = 0; BoxQty = 0; TotalQtyConv = 0; PcsQty = 0; foreach (GridViewRow grv in GridView2.Rows) { string str = grv.Cells[3].Text; Crates += Convert.ToDecimal(grv.Cells[3].Text); TextBox txtQtyConv = (TextBox)grv.Cells[6].FindControl("txtqty"); TotalQtyConv += Convert.ToDecimal(txtQtyConv.Text); TextBox txtBoxQty = (TextBox)grv.Cells[4].FindControl("txtBox"); BoxQty += Convert.ToDecimal(txtBoxQty.Text); TextBox txtPcsQty = (TextBox)grv.Cells[5].FindControl("txtPCS"); PcsQty += Convert.ToDecimal(txtPcsQty.Text); ltr += Convert.ToDecimal(grv.Cells[8].Text); } GridView2.FooterRow.Cells[2].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[2].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[2].Text = "TOTAL : "; GridView2.FooterRow.Cells[2].Font.Bold = true; GridView2.FooterRow.Cells[3].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[3].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[3].Text = Crates.ToString(); GridView2.FooterRow.Cells[3].Font.Bold = true; GridView2.FooterRow.Cells[4].Text = BoxQty.ToString(); GridView2.FooterRow.Cells[4].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[4].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[4].Font.Bold = true; GridView2.FooterRow.Cells[5].Text = PcsQty.ToString(); GridView2.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[5].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[5].Font.Bold = true; GridView2.FooterRow.Cells[6].Text = TotalQtyConv.ToString(); GridView2.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[6].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[6].Font.Bold = true; GridView2.FooterRow.Cells[8].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[8].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[8].Text = ltr.ToString(); GridView2.FooterRow.Cells[8].Font.Bold = true; } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Input String was not in Correct format !');", true); } //UppnalegridDetails.Update(); }