private void ViewMachineReport1(string shift, string unit, string mchn, string process, DateTime frmtm, DateTime totm)
    {
        DBServer db = new DBServer();

        ds = db.departmentreport(shift, unit, mchn, process, frmtm, totm);
        DataSet ds1 = new DataSet();

        ds1 = db.machinereport(shift, unit, mchn, process, frmtm, totm);
        lock (thisLock)
        {
            try{
                if (ds.Tables[0].Rows.Count > 0)
                {
                    grid_process.DataSource = ds.Tables[0];
                    grid_process.DataBind();
                    div_dept_error.Visible = false;
                    DIV_DEPART.Visible     = true;
                    div_exceldept.Visible  = true;
                }
                else
                {
                    div_dept_error.Visible = true;
                    DIV_DEPART.Visible     = false;
                    div_exceldept.Visible  = false;
                    lbl_dept.Text          = "Record Not Found";
                }
                if (ds1.Tables[0].Rows.Count > 0)
                {
                    GridView1.DataSource = ds1.Tables[0];
                    GridView1.DataBind();
                    div_mchn_error.Visible = false;
                    div_machine.Visible    = true;
                    div_excelmac.Visible   = true;
                }
                else
                {
                    div_mchn_error.Visible = true;
                    div_machine.Visible    = false;
                    div_excelmac.Visible   = false;

                    lbl_mchn.Text = "Record Not Found";
                }
            } catch (Exception ex)
            {
                ExceptionLogging.SendExcepToDB(ex);
            }
            finally
            {
            }
        }
    }