Example #1
0
        protected void drpStartPO_SelectedIndexChanged(object sender, EventArgs e)
        {
            lblStartMessage.Text = string.Empty;
            if (drpStartPO.SelectedValue != "" && Session["DtStartPO"] != null)
            {
                DataTable DtProcessOrders = (DataTable)(Session["DtStartPO"]);

                DataRow[] results = DtProcessOrders.Select("ProcessOrder =" + drpStartPO.SelectedValue);

                if (results != null && results.Count() > 0)
                {
                    txtMaterialStartPO.Text = Convert.ToString(results[0]["MaterialCode"]);
                    txtGramStart.Text       = Convert.ToString(results[0]["Gram"]);
                    txtCaseSizeStart.Text   = Convert.ToString(results[0]["CaseSize"]);
                }
                else
                {
                    txtMaterialStartPO.Text = string.Empty;
                    txtGramStart.Text       = string.Empty;
                    txtCaseSizeStart.Text   = string.Empty;
                }
            }
            else
            {
                txtMaterialStartPO.Text = string.Empty;
                txtGramStart.Text       = string.Empty;
                txtCaseSizeStart.Text   = string.Empty;
            }

            MPStartPO.Show();
        }
Example #2
0
        protected void btnStartRun_Click(object sender, EventArgs e)
        {
            lblStartMessage.Text = string.Empty;
            btnStartPO.Enabled   = true;
            if (ViewState["Active"] != null)
            {
                lblStartMessage.Text      = "Please Stop Run the current Active PO and then Start Run new PO.";
                lblStartMessage.ForeColor = Color.Red;
                btnStartPO.Enabled        = false;
            }
            BindStartPo();
            txtMaterialStartPO.Text = string.Empty;
            txtGramStart.Text       = string.Empty;
            txtCaseSizeStart.Text   = string.Empty;
            txtStartDate.Text       = lbldate.Text;
            txtStartDate.Attributes.Add("readonly", "true");
            BindTimeControl(drpTimeStartPO);

            MPStartPO.Show();
        }
Example #3
0
        protected void btnStartPO_Click(object sender, EventArgs e)
        {
            lblStartMessage.Text = string.Empty;

            if (ViewState["Active"] != null)
            {
                lblStartMessage.Text      = "Please Stop Run the current Active PO and then Start Run new PO.";
                lblStartMessage.ForeColor = Color.Red;
                MPStartPO.Show();
            }
            else if (drpStartPO.SelectedValue == "")
            {
                lblStartMessage.Text      = "Process Order Empty !";
                lblStartMessage.ForeColor = Color.Red;
                MPStartPO.Show();
            }
            else if (txtStartDate.Text == "")
            {
                lblStartMessage.Text      = "Start Date empty !";
                lblStartMessage.ForeColor = Color.Red;
                MPStartPO.Show();
            }
            else if (drpTimeStartPO.SelectedValue == "")
            {
                lblStartMessage.Text      = "Start Time empty !";
                lblStartMessage.ForeColor = Color.Red;
                MPStartPO.Show();
            }
            else
            {
                object         result;
                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@OPR", 2),
                    new SqlParameter("@PlantCode", lblplantcode.Text),
                    new SqlParameter("@Line", lblline.Text),
                    new SqlParameter("@ShiftCode", lblshift.Text),
                    new SqlParameter("@Date", lbldate.Text),
                    new SqlParameter("@PONumber", Convert.ToString(drpStartPO.SelectedValue)),
                    new SqlParameter("@StartDate", txtStartDate.Text.Trim()),
                    new SqlParameter("@StartTime", Convert.ToString(drpTimeStartPO.SelectedValue)),
                    new SqlParameter("@StartedBy", Convert.ToString(Session["username"])),
                    new SqlParameter("@CurrentStatus", "Active"),
                    new SqlParameter("@Gram", txtGramStart.Text.Trim()),
                    new SqlParameter("@CaseSize", txtCaseSizeStart.Text.Trim())
                };

                result = DBClass.ExecuteScalar_WithParam(param, "DM_SP_DML_DATA");

                if (Convert.ToInt64(result) > 0)
                {
                    lblStartMessage.Text      = "PO Start Run Success";
                    lblStartMessage.ForeColor = Color.Green;
                    CheckandAssignPo(drpStartPO.SelectedValue);
                    ClearStartPO();
                    BindActiveAndScheduledGrid();
                    MPStartPO.Hide();
                }
                else
                {
                    lblStartMessage.Text      = "Error, Something went wrong!";
                    lblStartMessage.ForeColor = Color.Red;
                    MPStartPO.Show();
                }
            }
        }