public void GetMachineComplaintsAndRectifiedDetails()
        {
            bmcr = new BMachineComplaintsAndRectifiedRecord();
            DataSet DS = new DataSet();

            DS = bmcr.GetMachineComplaintsAndRectifiedDetails();
            if (!Comman.Comman.IsDataSetEmpty(DS))
            {
                rpMachineComplaintsReport.DataSource = DS;
                rpMachineComplaintsReport.DataBind();
            }
        }
        public void GetMachineComplaintsAndRectifiedDetails(int MachineComplaintsAndRectifiedRecordId)
        {
            DataSet DS = new DataSet();

            bmcr = new BMachineComplaintsAndRectifiedRecord();
            DS   = bmcr.GetMachineComplaintsAndRectifiedDetailsById(MachineComplaintsAndRectifiedRecordId);
            if (!Comman.Comman.IsDataSetEmpty(DS))
            {
                string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordDate"].ToString();
                if (DATE == "")
                {
                    txtComplaintsDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd"));
                }
                else
                {
                    DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
                    txtComplaintsDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
                }
                dpShiftDetails.ClearSelection();
                if (dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordShiftId"]).ToString()) != null)
                {
                    dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordShiftId"]).ToString()).Selected = true;
                }
                txtMachineName.Text  = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MachineName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MachineName"].ToString();
                txtIdentifiedBy.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["IdentifiedBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["IdentifiedBy"].ToString();
                txtRectifiedBy.Text  = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RectifiedBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RectifiedBy"].ToString();
                string DATE2 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RectifiedDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RectifiedDate"].ToString();
                if (DATE2 == "")
                {
                    txtRectifiedDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd"));
                }
                else
                {
                    DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
                    txtRectifiedDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd"));
                }

                dpStatusDetails.ClearSelection();
                if (dpStatusDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineRectifiedStatus"]).ToString()) != null)
                {
                    dpStatusDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineRectifiedStatus"]).ToString()).Selected = true;
                }
            }
        }
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            {
                mmcr = new MMachineComplaintsAndRectifiedRecord();
                bmcr = new BMachineComplaintsAndRectifiedRecord();
                int Result = 0;
                mmcr.MachineComplaintsAndRectifiedRecordId      = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
                mmcr.MachineComplaintsAndRectifiedRecordDate    = Convert.ToDateTime(txtComplaintsDate.Text.ToString());
                mmcr.MachineComplaintsAndRectifiedRecordShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
                mmcr.MachineName            = txtMachineName.Text;
                mmcr.IdentifiedBy           = txtIdentifiedBy.Text;
                mmcr.RectifiedBy            = txtRectifiedBy.Text;
                mmcr.RectifiedDate          = Convert.ToDateTime(txtRectifiedDate.Text.ToString());
                mmcr.MachineRectifiedStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value);
                mmcr.flag = "Update";
                Result    = bmcr.machinereportdata(mmcr);
                if (Result > 0)
                {
                    divDanger.Visible  = false;
                    divwarning.Visible = false;

                    divSusccess.Visible = true;
                    lblSuccess.Text     = "Machine Complaints And Rectified  Data Update  Successfully";
                    pnlError.Update();
                    // GetPastDetails();
                }
                else
                {
                    divDanger.Visible   = false;
                    divwarning.Visible  = true;
                    divSusccess.Visible = false;
                    lblSuccess.Text     = "Something went wrong plz contact site admin";
                    pnlError.Update();
                }

                //return Result;
            }
        }
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            {
                mmcr = new MMachineComplaintsAndRectifiedRecord();
                bmcr = new BMachineComplaintsAndRectifiedRecord();
                int Result = 0;
                mmcr.MachineComplaintsAndRectifiedRecordId      = 0;
                mmcr.MachineComplaintsAndRectifiedRecordDate    = Convert.ToDateTime(txtComplaintsDate.Text.ToString());
                mmcr.MachineComplaintsAndRectifiedRecordShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
                mmcr.MachineName            = txtMachineName.Text;
                mmcr.IdentifiedBy           = txtIdentifiedBy.Text;
                mmcr.RectifiedBy            = txtRectifiedBy.Text;
                mmcr.RectifiedDate          = Convert.ToDateTime(txtRectifiedDate.Text.ToString());
                mmcr.MachineRectifiedStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value);
                mmcr.flag = "Insert";
                Result    = bmcr.machinereportdata(mmcr);
                if (Result > 0)
                {
                    divDanger.Visible  = false;
                    divwarning.Visible = false;

                    divSusccess.Visible = true;
                    lblSuccess.Text     = "Machine Complaints And Rectified  Data Add  Successfully";
                    pnlError.Update();
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').removeClass('collapsed-box');", true);
                }
                else
                {
                    divDanger.Visible   = false;
                    divwarning.Visible  = true;
                    divSusccess.Visible = false;
                    lblSuccess.Text     = "Something went wrong plz contact site admin";
                    pnlError.Update();
                }

                //return Result;
            }
        }