protected void ddl_ProcessStatus_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataTable dt  = new DataTable();
            var       obj = new DAL_PurchaseOrder();

            dt = obj.filter_ProcessStatus(ddl_ProcessStatus.SelectedItem.Text);
            gv_PurchaseOrder.DataSource = dt;
            gv_PurchaseOrder.DataBind();
        }
        //protected void btn_Descending_Click(object sender, EventArgs e)
        //{
        //    DataSet ds = new DataSet();
        //    ds = obj.filterDescending();

        //    gv_PurchaseOrder.DataSource = ds;
        //    gv_PurchaseOrder.DataBind();
        //}

        protected void ddl_Descending_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataSet ds  = new DataSet();
            var     obj = new DAL_PurchaseOrder();

            string getValue = ddl_Descending.SelectedItem.Value;

            if (getValue == "Latest")
            {
                ds = obj.filterDescending();
                gv_PurchaseOrder.DataSource = ds;
                gv_PurchaseOrder.DataBind();
            }
        }
        public int insertOrderItems(string date)
        {
            DAL_PurchaseOrder obj = new DAL_PurchaseOrder();

            return(obj.insertOrderItems(date));
        }
        public int insertPurchaseOrder(string name, string email, string contact, string address, string date)
        {
            DAL_PurchaseOrder obj = new DAL_PurchaseOrder();

            return(obj.insertPurchaseOrder(name, email, contact, address, date));
        }