public SignIntValueChoosingModel(IRepository repository, int idorder, int idsign) { this._Repository = repository; this.Sign = _Repository.Signs.First(s => s.idsign == idsign); this.Order = _Repository.Orders.First(o => o.idorder == idorder); this.OrderSign = _Repository.OrdersSigns.SingleOrDefault(os => os.idsign == idsign && os.idorder == idorder); }
public bool CreateOrderSign(ordersign instance) { if (instance.idordersign == 0) { instance.idordersign = dbconn.GetGenId("gen_ordersign"); dbContext.ordersigns.InsertOnSubmit(instance); dbContext.SubmitChanges(); } return(false); }
public bool UpdateOrderSign(ordersign instance) { ordersign cache = dbContext.ordersigns.FirstOrDefault(os => os.idordersign == instance.idordersign); if (cache != null) { dbContext.SubmitChanges(); return(true); } return(false); }
public bool RemoveOrderSign(int idordersign) { ordersign instance = dbContext.ordersigns.FirstOrDefault(os => os.idordersign == idordersign); if (instance != null) { dbContext.ordersigns.DeleteOnSubmit(instance); dbContext.SubmitChanges(); return(true); } return(false); }