public async Task <ActionResult <IEnumerable <VB_QT_QuyTrinh> > > r1GetListDataBuoc(QuyTrinhVB options) { try { var buocLenhs = from b in _context.VB_QT_BuocLenhTuongTac where b != null join c in _context.VB_QT_LenhTuongTac on b.LenhTuongTacId equals c.Id select new { c.Name, c.Id, b.BuocId, }; RequestToken token = CommonData.GetDataFromToken(User); var tables = _context.VB_QT_Buoc.Where(x => x.QuyTrinhId == options.QuyTrinhId && x.CompanyId == options.CompanyId).Select(a => new { a.Name, a.Id, a.IsOrder, children = buocLenhs.Where(x => x.BuocId == a.Id).Select(a => new { a.Name, a.Id }).ToList() }).AsQueryable(); var qrs = await tables.OrderBy(x => x.IsOrder).ToListAsync(); return(new ObjectResult(new { error = 0, data = qrs })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_QuyTrinh> > > r1GetListDataLTT(QuyTrinhVB options) { try { var tables = _context.VB_QT_LenhTuongTac.Where(x => x.QuyTrinhId == options.QuyTrinhId).Select(a => new { a.Name, a.Id, a.Code, a.IsOrder, check = _context.VB_QT_BuocLenhTuongTac.Count(x => x.LenhTuongTacId == a.Id && x.BuocId == options.BuocId) > 0 ? true : false }).Where(x => x.check == false).AsQueryable(); var qrs = await tables.OrderBy(x => x.IsOrder).ToListAsync(); return(new ObjectResult(new { error = 0, data = qrs })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_QuyTrinh> > > r4DelListDataBuocLenh(QuyTrinhVB options) { try { var obj = _context.VB_QT_BuocLenhTuongTac.FirstOrDefault(x => x.LenhTuongTacId == options.LenhTuongTacId && x.BuocId == options.BuocId); _context.VB_QT_BuocLenhTuongTac.Remove(obj); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_QuyTrinh> > > r2AddListDataBuocLenh(QuyTrinhVB options) { try { if (_context.VB_QT_BuocLenhTuongTac.Count(x => x.LenhTuongTacId == options.LenhTuongTacId && x.BuocId == options.BuocId) > 0) { return(new ObjectResult(new { error = 2 })); } VB_QT_BuocLenhTuongTac obj = new VB_QT_BuocLenhTuongTac(); obj.BuocId = options.BuocId ?? 1; obj.LenhTuongTacId = options.LenhTuongTacId ?? 1; obj.IsOrder = _context.VB_QT_BuocLenhTuongTac.Count() + 1; _context.VB_QT_BuocLenhTuongTac.Add(obj); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_BuocLenhTuongTac> > > r1GetListDataLTTCHNguoiNhan(QuyTrinhVB options) { try { var tables = (from a in _context.VB_QT_BuocLenhTuongTac where a != null join b in _context.VB_QT_LenhTuongTac on a.LenhTuongTacId equals b.Id where a.BuocId == options.BuocId select new { BuoclenhTTID = a.Id, b.Name, LenhTuongTacId = b.Id, b.IsActive, b.Code, b.IsOrder }).AsQueryable(); var qrs = await tables.OrderBy(x => x.IsOrder).ToListAsync(); return(new ObjectResult(new { error = 0, data = qrs })); } catch (Exception ex) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_Buoc> > > r1GetListDataBuoc(QuyTrinhVB options) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var tables = _context.VB_QT_Buoc.Where(x => x.QuyTrinhId == options.QuyTrinhId && x.CompanyId == options.CompanyId).Select(a => new { a.Name, a.Id, a.IsOrder }).AsQueryable(); var qrs = await tables.OrderBy(x => x.IsOrder).ToListAsync(); return(new ObjectResult(new { error = 0, data = qrs })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_Buoc> > > r1GetListDataBuoc(QuyTrinhVB options) { try { RequestToken token = CommonData.GetDataFromToken(User); var tables = _context.VB_QT_Buoc.Where(x => x.QuyTrinhId == options.QuyTrinhId && x.CompanyId == options.CompanyId).Select(a => new { a.Name, a.Id, a.IsOrder }).AsQueryable(); var qrs = await tables.OrderBy(x => x.IsOrder).ToListAsync(); return(new ObjectResult(new { error = 0, data = qrs })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }