protected void LoadSchedule(Object Sender, EventArgs e)
 {
     if (drpScheduleType.SelectedValue != "")
     {
         GetSchedule(drpScheduleType, drpSchedule, lblplantcode.Text);
         txtGramStart.Text = String.Empty;
         GetGrammage();
         drpSchedule.Enabled = true;
     }
     else
     {
         drpSchedule.Enabled = false;
     }
     MPActiveSchedule.Show();
 }
        protected void btnActivate_Click(Object Sender, EventArgs e)
        {
            lblStartMessage.Text = string.Empty;
            if (drpScheduleType.SelectedValue == "0")
            {
                lblStartMessage.Text      = "Schedule Type Empty !";
                lblStartMessage.ForeColor = Color.Red;
                MPActiveSchedule.Show();
            }
            else if (drpSchedule.SelectedValue == "0")
            {
                lblStartMessage.Text      = "Schedule Empty !";
                lblStartMessage.ForeColor = Color.Red;
                MPActiveSchedule.Show();
            }
            else if (txtStartDate.Text == "")
            {
                lblStartMessage.Text      = "Start Date empty !";
                lblStartMessage.ForeColor = Color.Red;
                MPActiveSchedule.Show();
            }


            else
            {
                object         result;
                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@OPR", 15),
                    new SqlParameter("@ScheduleTypeId", drpScheduleType.SelectedValue),
                    new SqlParameter("@ScheduleId", drpSchedule.SelectedValue),
                    new SqlParameter("@StartDate", txtStartDate.Text.Trim()),
                    new SqlParameter("@StartTime", Convert.ToString(drpTimeStartSchedule.SelectedValue)),
                    new SqlParameter("@StartedBy", Convert.ToString(Session["username"])),
                    new SqlParameter("@Status", 1),
                    new SqlParameter("@Gram", txtGramStart.Text.Trim()),
                };


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

                if (Convert.ToInt64(result) > 0)
                {
                    lblStartMessage.Text      = "Schedule Activate Success";
                    lblStartMessage.ForeColor = Color.Green;
                    ClearActivateSchedule();
                    BindScheduleStatusGrid();
                    MPActiveSchedule.Hide();
                }
                else if (Convert.ToInt16(result) == -1)
                {
                    lblStartMessage.Text      = "Please Stop the current Active Schedule and then Start Activate new Schedule";
                    lblStartMessage.ForeColor = Color.Red;
                    MPActiveSchedule.Show();
                }
                else
                {
                    lblStartMessage.Text      = "Error, Something went wrong!";
                    lblStartMessage.ForeColor = Color.Red;
                    MPActiveSchedule.Show();
                }
            }
        }
 protected void btnActivateSchedule_Click(Object Sender, EventArgs e)
 {
     GetScheduleType(drpScheduleType);
     BindTimeControl(drpTimeStartSchedule);
     MPActiveSchedule.Show();
 }