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 }));
}
}
