public async Task <ActionResult <IEnumerable <VB_QT_VanBanMoiSoHoa> > > r2AddQTChuyenChoPheDuyet(VB_QT_LuanChuyenVanBan vB_QT_LuanChuyenVanBan)
{
try
{
var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
var user = await _context.Sys_Dm_User.FindAsync(userId);
var userNN = await _context.Sys_Dm_User.FindAsync(vB_QT_LuanChuyenVanBan.NguoiNhanId);
var qtLuanChuyenVb = await _context.VB_QT_LuanChuyenVanBan.FindAsync(vB_QT_LuanChuyenVanBan.Id);
qtLuanChuyenVb.NgayDoc = DateTime.Now;
qtLuanChuyenVb.DaDoc = true;
qtLuanChuyenVb.NgayXuLy = DateTime.Now;
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
qtLuanChuyenVb.VbMoiSoHoaId, vB_QT_LuanChuyenVanBan.NguoiNhanId, vB_QT_LuanChuyenVanBan.TenNguoiNhan, userId, user.FullName,
vB_QT_LuanChuyenVanBan.TieuDe,
vB_QT_LuanChuyenVanBan.NoiDung, false,
vB_QT_LuanChuyenVanBan.HanXuLy, null,
vB_QT_LuanChuyenVanBan.TrangThaiXuLy,
vB_QT_LuanChuyenVanBan.MaLenh, null,
false, qtLuanChuyenVb.Id,
vB_QT_LuanChuyenVanBan.MenuGuiId,
vB_QT_LuanChuyenVanBan.MenuNhanId,
userNN.PositionName, user.PositionName, userNN.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
Sys_QT_ThongBao obj = new Sys_QT_ThongBao();
obj.MaLenh = vB_QT_LuanChuyenVanBan.MaLenh;
obj.QuyTrinhId = 1;
obj.TenNguoiGui = user.FullName;
obj.NguoiNhanId = vB_QT_LuanChuyenVanBan.NguoiNhanId ?? 0;
obj.NoiDung = vB_QT_LuanChuyenVanBan.NoiDung;
obj.NgayGui = DateTime.Now;
obj.DaDoc = false;
obj.NgayDoc = null;
obj.TrangThaiXuLy = vB_QT_LuanChuyenVanBan.TrangThaiXuLy;
obj.RouterLink = "/vanban/quytrinhvanban/vanbanchopheduyet";
_context.Sys_QT_ThongBao.Add(obj);
List <NguoiNhanThongBao> nhanThongBaos = new List <NguoiNhanThongBao>();
NguoiNhanThongBao nguoiNhan = new NguoiNhanThongBao();
nguoiNhan.NguoiNhanId = vB_QT_LuanChuyenVanBan.NguoiNhanId ?? 0;
nhanThongBaos.Add(nguoiNhan);
await _context.SaveChangesAsync();
return(new ObjectResult(new { error = 0, nguoiNhanTbs = nhanThongBaos }));
}
catch (Exception)
{
return(new ObjectResult(new { error = 1 }));
}
}
public async Task <ActionResult <IEnumerable <VB_QT_VanBanMoiSoHoa> > > r2AddQTPheDuyetTrinhKy(LuanChuyenVbDuyetTrinhKy luanChuyenVbXNHT)
{
try
{
List <NguoiNhanThongBao> nhanThongBaos = new List <NguoiNhanThongBao>();
var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
var user = await _context.Sys_Dm_User.FindAsync(userId);
var qtLuanChuyenVb = await _context.VB_QT_LuanChuyenVanBan.FindAsync(luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.Id);
qtLuanChuyenVb.NgayXuLy = DateTime.Now;
qtLuanChuyenVb.NgayDoc = DateTime.Now;
qtLuanChuyenVb.DaDoc = true;
var nguoiNhans = _context.VB_QT_LuanChuyenVanBan.Where(x => x.VbMoiSoHoaId == qtLuanChuyenVb.VbMoiSoHoaId).Select(a => new
{
a.TenNguoiGui,
a.NguoiGuiId,
a.MaLenh
}).Distinct().ToList();
if (luanChuyenVbXNHT.UserXNHT.isNguoiGui == true)
{
foreach (var item in nguoiNhans.Where(x => x.MaLenh == "VB_CHOTRINHKY" && x.NguoiGuiId != nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId))
{
var userNN = await _context.Sys_Dm_User.FindAsync(item.NguoiGuiId);
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
qtLuanChuyenVb.VbMoiSoHoaId, item.NguoiGuiId, item.TenNguoiGui, userId, user.FullName,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.TieuDe,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung, false,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.HanXuLy, null,
5,
"VB_NHANTHONGBAO", null, false,
qtLuanChuyenVb.Id,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuGuiId,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuNhanId,
userNN.PositionName, user.PositionName, userNN.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
// thêm vào thông báo
Sys_QT_ThongBao obj = new Sys_QT_ThongBao();
obj.MaLenh = "VB_NHANTHONGBAO";
obj.QuyTrinhId = 1;
obj.TenNguoiGui = user.FullName;
obj.NguoiNhanId = item.NguoiGuiId;
obj.NoiDung = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung;
obj.NgayGui = DateTime.Now;
obj.DaDoc = false;
obj.NgayDoc = null;
obj.TrangThaiXuLy = 5;
obj.RouterLink = "/vanban/quytrinhvanban/vanbandapheduyet";
NguoiNhanThongBao nguoiNhan = new NguoiNhanThongBao();
nguoiNhan.NguoiNhanId = item.NguoiGuiId;
nhanThongBaos.Add(nguoiNhan);
_context.Sys_QT_ThongBao.Add(obj);
}
}
var userNNN = await _context.Sys_Dm_User.FindAsync(nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId);
VB_QT_LuanChuyenVanBan lcvb1 = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
qtLuanChuyenVb.VbMoiSoHoaId, nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId, nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").TenNguoiGui, userId, user.FullName,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.TieuDe,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung, false,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.HanXuLy, null,
3,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MaLenh, null, false,
qtLuanChuyenVb.Id,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuGuiId,
luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuNhanId,
userNNN.PositionName, user.PositionName, userNNN.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb1);
NguoiNhanThongBao nguoiNhan1 = new NguoiNhanThongBao();
nguoiNhan1.NguoiNhanId = nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId;
nhanThongBaos.Add(nguoiNhan1);
// thêm vào thông báo
Sys_QT_ThongBao obj1 = new Sys_QT_ThongBao();
obj1.MaLenh = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MaLenh;
obj1.QuyTrinhId = 1;
obj1.TenNguoiGui = user.FullName;
obj1.NguoiNhanId = nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId;
obj1.NoiDung = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung;
obj1.NgayGui = DateTime.Now;
obj1.DaDoc = false;
obj1.NgayDoc = null;
obj1.TrangThaiXuLy = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.TrangThaiXuLy;
obj1.RouterLink = "/vanban/quytrinhvanban/vanbandapheduyet";
_context.Sys_QT_ThongBao.Add(obj1);
await _context.SaveChangesAsync();
return(new ObjectResult(new { error = 0, nguoiNhanTbs = nhanThongBaos }));
}
catch (Exception)
{
return(new ObjectResult(new { error = 1 }));
}
}
public async Task <IActionResult> r2addObjUnitCode()
{
try
{
var model = JsonConvert.DeserializeObject <VB_QT_VanBanMoiSoHoa>(Request.Form["model"]);
VB_QT_VanBanMoiSoHoa objvb = new VB_QT_VanBanMoiSoHoa();
var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
var user = await _context.Sys_Dm_User.FindAsync(userId);
var userNguoiKy = await _context.Sys_Dm_User.FirstOrDefaultAsync(x => x.Id == model.NguoiKyId);
if (model != null)
{
objvb.Id = Helper.GenKey();
objvb.CompanyId = user.CompanyId ?? 0;
objvb.DepartmentId = user.DepartmentId ?? 0;
objvb.TenNguoiKy = userNguoiKy.FullName;
objvb.LinhVucId = model.LinhVucId;
objvb.LoaiVanBanId = model.LoaiVanBanId;
objvb.SoKyHieu = model.SoKyHieu;
objvb.NoiBanHanh = model.NoiBanHanh;
objvb.NgayBanHanh = model.NgayBanHanh;
objvb.TuKhoa = model.TuKhoa;
objvb.SoTrang = model.SoTrang;
objvb.SoTrang = model.SoTrang;
objvb.TenNguoiTao = user.FullName;
objvb.CreateDate = DateTime.Now;
objvb.UserCreateId = userId;
objvb.TrichYeu = model.TrichYeu;
_context.VB_QT_VanBanMoiSoHoa.Add(objvb);
}
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(objvb.Id, userId, user.FullName, userId, user.FullName, "", "", false, null, null, 1, "VB_MOISOHOA", DateTime.Now, false, null, "VB0101", "VB0101", user.PositionName, user.PositionName, user.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
if (Request.Form.Files.Count != 0)
{
foreach (var item in Request.Form.Files)
{
VB_QT_FileVBMoiSoHoa obj = new VB_QT_FileVBMoiSoHoa();
var file = item;
var folderName = Path.Combine("Resources", "VanBan");
var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName);
if (!Directory.Exists(pathToSave))
{
Directory.CreateDirectory(pathToSave);
}
if (model != null)
{
if (file.Length > 0)
{
var fileName = long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss")).ToString() + ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
var fullPath = Path.Combine(pathToSave, fileName);
var dbPath = Path.Combine(folderName, fileName);
obj.Path = dbPath;
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
}
}
}
obj.Name = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
obj.VbMoiSoHoaId = objvb.Id;
obj.Size = file.Length;
obj.Type = 1;
_context.VB_QT_FileVBMoiSoHoa.Add(obj);
}
}
await _context.SaveChangesAsync();
return(new ObjectResult(new { error = 0, ms = "" }));;
}
catch (Exception ex)
{
var result = new OkObjectResult(new { error = 1, ms = "Lỗi khi thêm mới UnitCode, vui lòng kiểm tra lại!" });
return(result);
}
}
public async Task <ActionResult <IEnumerable <VB_QT_VanBanMoiSoHoa> > > r2AddQTChuyenXuLy(LuanChuyenVbUser luanChuyenVbUser)
{
try
{
var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
var user = await _context.Sys_Dm_User.FindAsync(userId);
var userNCD = await _context.Sys_Dm_User.FindAsync(luanChuyenVbUser.UserNhan.NguoiChiDaoId);
var userNXL = await _context.Sys_Dm_User.FindAsync(luanChuyenVbUser.UserNhan.NguoiXuLyId);
var userNDXL = await _context.Sys_Dm_User.FindAsync(luanChuyenVbUser.UserNhan.NguoiDXuLyId);
var userNNDB = await _context.Sys_Dm_User.FindAsync(luanChuyenVbUser.UserNhan.NguoiNDBId);
var qtLuanChuyenVb = _context.VB_QT_LuanChuyenVanBan.Where(x => x.VbMoiSoHoaId == luanChuyenVbUser.VB_QT_LuanChuyenVanBan.VbMoiSoHoaId &&
x.NguoiNhanId == luanChuyenVbUser.VB_QT_LuanChuyenVanBan.NguoiGuiId &&
x.MenuNhanId == luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuGuiId).OrderByDescending(x => x.ThoiGianGui).Take(1);
if (luanChuyenVbUser.UserNhan.NguoiChiDaoId != null)
{
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.VbMoiSoHoaId, luanChuyenVbUser.UserNhan.NguoiChiDaoId, luanChuyenVbUser.UserNhan.TenNguoiChiDao, userId, user.FullName,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.TieuDe,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.NoiDung, false,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.HanXuLy, null,
5,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MaLenh, null, false,
qtLuanChuyenVb.FirstOrDefault().Id,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuGuiId,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuNhanId,
userNCD.PositionName, user.PositionName, userNCD.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
}
if (luanChuyenVbUser.UserNhan.NguoiXuLyId != null)
{
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.VbMoiSoHoaId, luanChuyenVbUser.UserNhan.NguoiXuLyId, luanChuyenVbUser.UserNhan.TenNguoiXuLy, userId, user.FullName,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.TieuDe,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.NoiDung, false,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.HanXuLy, null,
6,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MaLenh, null, false,
qtLuanChuyenVb.FirstOrDefault().Id,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuGuiId,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuNhanId,
userNXL.PositionName, user.PositionName, userNXL.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
}
if (luanChuyenVbUser.UserNhan.NguoiDXuLyId != null)
{
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.VbMoiSoHoaId, luanChuyenVbUser.UserNhan.NguoiDXuLyId, luanChuyenVbUser.UserNhan.TenNguoiDXuLy, userId, user.FullName,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.TieuDe,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.NoiDung, false,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.HanXuLy, null,
7,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MaLenh, null, false,
qtLuanChuyenVb.FirstOrDefault().Id,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuGuiId,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuNhanId,
userNXL.PositionName, user.PositionName, userNXL.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
}
if (luanChuyenVbUser.UserNhan.NguoiDXuLyId != null)
{
VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.VbMoiSoHoaId, luanChuyenVbUser.UserNhan.NguoiNDBId, luanChuyenVbUser.UserNhan.TenNguoiNDB, userId, user.FullName,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.TieuDe,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.NoiDung, false,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.HanXuLy, null,
8,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MaLenh, null, false,
qtLuanChuyenVb.FirstOrDefault().Id,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuGuiId,
luanChuyenVbUser.VB_QT_LuanChuyenVanBan.MenuNhanId,
userNNDB.PositionName, user.PositionName, userNNDB.DepartmentName, user.DepartmentName);
_context.VB_QT_LuanChuyenVanBan.Add(lcvb);
}
await _context.SaveChangesAsync();
return(new ObjectResult(new { error = 0 }));
}
catch (Exception ex)
{
return(new ObjectResult(new { error = 1 }));
}
}