public void TextSubItem_Changed(object sender, EventArgs e) { TextItemWeight.Focus(); TextItemWeight.Text = ""; alert_box.Visible = false; }
public void TextItemWeight_TextChanged(object sender, EventArgs e) { int ItemID = Convert.ToInt32(DropDownItemID.Text); if (ItemID != 0) { int SubItemID = Convert.ToInt32(DropDownSubItemID.Text); string ItemWeightCheck = TextItemWeight.Text; string MatchPattern = "([0-9.]+)"; if (ItemWeightCheck != null) { if (Regex.IsMatch(ItemWeightCheck, MatchPattern)) { alert_box.Visible = false; OracleConnection conn = new OracleConnection(strConnString); conn.Open(); string makeSQL = " select nvl(sum(ITEM_WEIGHT),0) AS ITEM_WEIGHT from PF_PURCHASE_JW where ITEM_ID = '" + ItemID + "' AND SUB_ITEM_ID = '" + SubItemID + "' "; cmdl = new OracleCommand(makeSQL); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount = dt.Rows.Count; double FinalStock = 0.00; double ItemWeight = Convert.ToDouble(TextItemWeight.Text); for (int i = 0; i < RowCount; i++) { FinalStock = Convert.ToDouble(dt.Rows[i]["ITEM_WEIGHT"].ToString()); } if (ItemWeight <= FinalStock) { CheckItemWeight.Text = "<label class='control-label'><i class='fa fa fa-check'></i> This Material is available</label>"; CheckItemWeight.ForeColor = System.Drawing.Color.Green; EntryDate.Focus(); BtnAdd.Attributes.Add("aria-disabled", "true"); BtnAdd.Attributes.Add("class", "btn btn-primary active"); } else { CheckItemWeight.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> This Material is not available. Available Material is <span class='badge bg-yellow'>" + FinalStock + "</span> metric ton (MT)</label>"; CheckItemWeight.ForeColor = System.Drawing.Color.Red; TextItemWeight.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } } else { CheckItemWeight.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Enter Material Weight</label>"; CheckItemWeight.ForeColor = System.Drawing.Color.Red; TextItemWeight.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } } } else { alert_box.Visible = false; TextItemWeight.Text = ""; CheckItemWeight.Text = ""; DropDownItemID.Focus(); } }
public void TextItemRate_Changed(object sender, EventArgs e) { if (TextItemRate.Text != "" && TextItemWeight.Text != "") { int ItemID = Convert.ToInt32(DropDownItemID.Text); if (ItemID != 0) { int SubItemID = Convert.ToInt32(DropDownSubItemID.Text); string ItemWeightCheck = TextItemWeight.Text; string MatchPattern = "([0-9.]+)"; if (ItemWeightCheck != null) { if (Regex.IsMatch(ItemWeightCheck, MatchPattern)) { alert_box.Visible = false; OracleConnection conn = new OracleConnection(strConnString); conn.Open(); string makeSQL = " select nvl(sum(ITEM_WEIGHT),0) AS FINAL_STOCK_WT from PF_PRODUCTION_JW where ITEM_ID = '" + ItemID + "' "; cmdl = new OracleCommand(makeSQL); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount = dt.Rows.Count; double FinalStock = 0.00; double ItemWeightF = Convert.ToDouble(TextItemWeight.Text); for (int i = 0; i < RowCount; i++) { FinalStock = Convert.ToDouble(dt.Rows[i]["FINAL_STOCK_WT"].ToString()); } if (ItemWeightF <= FinalStock) { CheckItemWeight.Text = "<label class='control-label'><i class='fa fa fa-check'></i> This Material is available</label>"; CheckItemWeight.ForeColor = System.Drawing.Color.Green; TextItemRate.Focus(); BtnAdd.Attributes.Add("aria-disabled", "true"); BtnAdd.Attributes.Add("class", "btn btn-primary active"); BtnUpdate.Attributes.Add("aria-disabled", "true"); BtnUpdate.Attributes.Add("class", "btn btn-success active"); } else { CheckItemWeight.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> This Material is not available for Sale from Job Work (Purchase). Available Material is <span class='badge bg-yellow'>" + FinalStock + "</span> metric ton (MT)</label>"; CheckItemWeight.ForeColor = System.Drawing.Color.Red; TextItemWeight.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); BtnUpdate.Attributes.Add("aria-disabled", "false"); BtnUpdate.Attributes.Add("class", "btn btn-success disabled"); } } else { CheckItemWeight.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Enter Material Weight</label>"; CheckItemWeight.ForeColor = System.Drawing.Color.Red; TextItemWeight.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } } } else { alert_box.Visible = false; CheckItemWeight.Text = ""; DropDownItemID.Focus(); } double ItemRate = Convert.ToDouble(TextItemRate.Text); double ItemWeight = Convert.ToDouble(TextItemWeight.Text); double ItemAmount = ItemRate * ItemWeight; string ItemAmountNew = Math.Round(decimal.Parse(ItemAmount.ToString()), 0).ToString(); double ItemAmountNewD = Convert.ToDouble(ItemAmountNew); TextItemAmount.Text = ItemAmountNewD.ToString("0.00"); double VatPercent = Convert.ToDouble(DropDownVatID.SelectedItem.Text); double VatPercentAmt = (ItemAmount * VatPercent) / 100; TextVatAmount.Text = VatPercentAmt.ToString("0.00"); EntryDate.Focus(); } }