public void saveListDetail(ref LND_ListNumberDetail pList) { using (var context = new SILOEntities()) { context.LND_ListNumberDetail.Add(pList); context.SaveChanges(); } }
public void saveList(ref LTL_LotteryList pList) { using (var context = new SILOEntities()) { context.LTL_LotteryList.Add(pList); context.SaveChanges(); } }
public LTD_LotteryDraw getById(long pId) { LTD_LotteryDraw draw = null; using (var context = new SILOEntities()) { draw = context.LTD_LotteryDraw.Find(pId); } return(draw); }
public List <LTD_LotteryDraw> getAll() { List <LTD_LotteryDraw> drawList = null; using (var context = new SILOEntities()) { drawList = context.LTD_LotteryDraw.ToList(); } return(drawList); }
public LNR_LotteryNumber getByNumberCode(string pNumberCode) { LNR_LotteryNumber findedNumber = null; using (var context = new SILOEntities()) { List <LNR_LotteryNumber> numberlist = context.LNR_LotteryNumber.Where(n => n.LNR_Number.Equals(pNumberCode)).ToList(); if (numberlist.Count > 0) { findedNumber = numberlist[0]; } } return(findedNumber); }
public void save(ref LTD_LotteryDraw pDraw) { using (var context = new SILOEntities()) { //LTD_LotteryDraw matchingDraw = context.LTD_LotteryDraw.Find(pDraw.LTD_Id); LTD_LotteryDraw matchingDraw = this.getByTypeAndDate(pDraw.LDT_LotteryDrawType, pDraw.LTD_CreateDate); if (matchingDraw != null) { matchingDraw = context.LTD_LotteryDraw.Find(matchingDraw.LTD_Id); matchingDraw.LDS_LotteryDrawStatus = pDraw.LDS_LotteryDrawStatus; context.SaveChanges(); pDraw = matchingDraw; } else { context.LTD_LotteryDraw.Add(pDraw); context.SaveChanges(); } } }
public void saveProhibitedNumbers(int[] pProhibitedArray) { LNR_LotteryNumber number = null; using (var context = new SILOEntities()) { // Determina cual es 1 y cual es 0 en el array de prohibidos y lo guarda en la tabla for (int i = 0; i < 100; i++) { int positionArray = (i == 0 ? 100 : i); number = context.LNR_LotteryNumber.Find(positionArray); // Actualizar número y estado de sincronización solo si varió el valor if (number.LNR_IsProhibited != pProhibitedArray[i]) { number.LNR_IsProhibited = pProhibitedArray[i]; number.SYS_SynchronyStatus = SystemConstants.SYNC_STATUS_PENDING_TO_SERVER; } } context.SaveChanges(); } }
public LTD_LotteryDraw getDrawRegister(LTD_LotteryDraw pDraw) { LTD_LotteryDraw findedDraw = null; using (var context = new SILOEntities()) { if (pDraw.LTD_Id != 0) { findedDraw = context.LTD_LotteryDraw.Find(pDraw.LTD_Id); } else { List <LTD_LotteryDraw> drawList = context.LTD_LotteryDraw .Where(list => list.LTD_CreateDate == pDraw.LTD_CreateDate) .Where(list => list.LDT_LotteryDrawType == pDraw.LDT_LotteryDrawType) .ToList(); if (drawList.Count > 0) { findedDraw = drawList[0]; } } } return(findedDraw); }