public bool UpdateOrderPlanModal(OrderPlanModal orderPlan)
        {
            try
            {
                var plan = VMSEntities.plan_quantities.Where(x => x.pqid == orderPlan.ID).FirstOrDefault();
                if (plan != null)
                {
                    plan.plan_quantity = orderPlan.Quantity;
                }
                else
                {
                    VMSEntities.plan_quantities.Add(new plan_quantities {
                        plan_quantity = orderPlan.Quantity, plan_datetime = DateTime.Now, mid = orderPlan.mid, loginid = orderPlan.loginid
                    });
                }


                VMSEntities.SaveChanges();
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }