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; } }
public OrderPlanModal GetOrderPlanModal(int mid) { try { OrderPlanModal planModal = (from m in VMSEntities.modal_details join p in VMSEntities.plan_quantities on m.mid equals p.mid where m.mid == mid select new { ID = m.mid, ModalName = m.modal_name, ModalColor = m.modal_color, Quantity = p.plan_quantity }).Cast <OrderPlanModal>().FirstOrDefault(); return(planModal); } catch (Exception ex) { throw; } }