public void BindingGrid()
        {
            DataTable dt   = new DataTable();
            MCDelObj  objI = new MCDelObj();

            objI.DelDate = txtSelectDate.Text.Trim();
            objI.DelType = ddlDeliveryType.SelectedValue.Trim();
            objI.KDLot   = "";

            dt = SQLManager.GridItemDetail(objI);

            gdvDaily.DataSource = dt;
            gdvDaily.DataBind();
        }
        protected void btnGenerate_Click(object sender, EventArgs e)
        {
            try
            {
                MCDelObj objI = new MCDelObj();
                objI.DelDate = txtSelectDate.Text.Trim();

                if (ddlDeliveryType.SelectedValue == "CKD")
                {
                    SQLManager.Insert_MCDailyDelivery_CKD(objI);
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('" + ex.Message + "')", true);
            }
        }