public ActionResult ExportExcel()
{
try
{
var webRoot = _env.WebRootPath;
DataTable dt = new DataTable();
QuanLyCongVanContext db = new QuanLyCongVanContext();
var paht = System.IO.Path.Combine(webRoot, "Content/TempExcel/VanBan.xlsx");
Workbook wb = new Workbook();
//Cell Cells = char.Parse(new Cell["A3"].ToString());
Worksheet ws = wb.Worksheets[0];
dt.Columns.Add("Văn bản đi đến");
dt.Columns.Add("Mã loại VB");;
dt.Columns.Add("Mã CQBH");
dt.Columns.Add("Số VB");
dt.Columns.Add("Số đến");
dt.Columns.Add("Ngày đến");
dt.Columns.Add("Độ mật");
dt.Columns.Add("Độ khẩn");
dt.Columns.Add("Số đến");
dt.Columns.Add("Trích yếu");
dt.Columns.Add("Nơi nhận");
dt.Columns.Add("Ngày ký");
dt.Columns.Add("Người ký");
dt.Columns.Add("Kết quả xử lý");
dt.Columns.Add("File đính kèm");
List <VanBan> listvb = new List <VanBan>();
listvb = db.VanBan.ToList();
string listvbs = "";
if (listvb.Count > 0)
{
listvbs = String.Join(",", listvb.Select(x => x.ToString()).ToArray());
}
var ob = new VanBanRepository();
var data = ob.GetAll();
foreach (VanBan item in data)
{
dt.Rows.Add(item.VbdiDen, item.MaLoaiVb, item.MaCqbh, item.SoVb, item.SoDen, Convert.ToDateTime(item.NgayDen),
item.DoMat, item.DoKhan, item.TrichYeu, item.NoiNhan, Convert.ToDateTime(item.NgayKy), item.NguoiKy, item.KetQuaXuLy, item.FileDinhKem);
}
string filename = "DanhSachVanBan" + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + ".xlsx";
string folderName = "/assets/Excel/";
var file = System.IO.Path.Combine(webRoot + folderName + filename);
if (!System.IO.Directory.Exists(folderName))
{
System.IO.Directory.CreateDirectory(folderName);
}
ws.Cells.ImportDataTable(dt, false, 2, 0);
wb.Save(file);
return(Json(folderName + filename));
}
catch (Exception ex)
{
throw ex;
}
}
private IPagedList <VanBanResult> Find(ValueSearchViewModel model)
{
var seachAll = VanBanRepository.GetAll();
//if (model.CoQuanBanHanhVanBanId.HasValue)
// seachAll = seachAll.Where(x => x.CoQuanBanHanhId == model.CoQuanBanHanhVanBanId);
//if (model.LoaiVanBanId.HasValue)
// seachAll = seachAll.Where(x => x.LoaiVanBanId == model.LoaiVanBanId);
//if (model.LinhVucVanBanId.HasValue)
// seachAll = seachAll.Where(x => x.LinhVucVanBanId == model.LinhVucVanBanId);
//if (model.NamBanHanhId.HasValue)
// seachAll = seachAll.Where(x => x.NgayBanHanh.Year == model.NamBanHanhId);
if (model.CoQuanBanHanhVanBanIds != null && model.CoQuanBanHanhVanBanIds.Any())
{
seachAll = seachAll.Where(x => model.CoQuanBanHanhVanBanIds.Any(y => y == x.CoQuanBanHanhId));
}
if (model.LoaiVanBanIds != null && model.LoaiVanBanIds.Any())
{
seachAll = seachAll.Where(x => model.LoaiVanBanIds.Any(y => y == x.LoaiVanBanId));
}
if (model.LinhVucVanBanIds != null && model.LinhVucVanBanIds.Any())
{
seachAll = seachAll.Where(x => model.LinhVucVanBanIds.Any(y => y == x.LinhVucVanBanId));
}
if (model.NamBanHanhIds != null && model.NamBanHanhIds.Any())
{
seachAll = seachAll.Where(x => model.NamBanHanhIds.Any(y => y == x.NgayBanHanh.Year));
}
if (!string.IsNullOrEmpty(model.TenVanBan))
{
if (model.TimTrongNoiDung)
{
seachAll = seachAll.Where(x => x.NoiDung.Contains(model.TenVanBan));
}
if (model.TimTrongSoHieu)
{
seachAll = seachAll.Where(x => x.SoVanBan.Contains(model.TenVanBan));
}
if (model.TimTrongTrichYeu)
{
seachAll = seachAll.Where(x => x.TrichYeu.Contains(model.TenVanBan));
}
}
return(seachAll.ToPagedList(model.Page, TechOfficeConfig.PAGESIZE));
}
public async Task <JsonResult> DeleteConfirmed(int id)
{
return(await ExecuteWithErrorHandling(async() =>
{
if (id == 0)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return Json("Bad Request", JsonRequestBehavior.AllowGet);
}
return await ExecuteResultAsync(async() => await VanBanRepository.DeleteByAsync(id));
}));
}
//private readonly bool _readOnly;
public UnitOfWork(ISBEntities dbContext /*, bool readOnly = false*/)
{
_dbContext = dbContext;
//_readOnly = readOnly;
UserRepository = new UserRepository(_dbContext);
DonViRepository = new DonviRepository(_dbContext);
LoaiVanBanRepository = new LoaiVanBanRepository(_dbContext);
VanBanRepository = new VanBanRepository(_dbContext);
LoaiTaiLieuRepository = new LoaiTaiLieuRepository(_dbContext);
TaiLieuRepository = new TaiLieuRepository(_dbContext);
BanHanhVbRepository = new BanHanhVbRepository(_dbContext);
TheLoaiRepository = new TheLoaiRepository(_dbContext);
LoaiTinRepository = new LoaiTinRepository(_dbContext);
}
public ActionResult Edit(int id, EditVanBanViewModel model)
{
var data = VanBanRepository.Single(id);
data.LinhVucVanBanId = model.LinhVucVanBanId;
data.CoQuanBanHanhId = model.CoQuanBanhHanhVanBanId;
data.LoaiVanBanId = model.LoaiVanBanId;
data.NgayBanHanh = model.NgayBanHanh;
data.NoiDung = model.NoiDungVanBan;
data.SoVanBan = model.SoVanBan;
data.TrichYeu = model.TrichYeuVanBan;
data.LastUpdatedBy = UserName;
var result = VanBanRepository.Update(data);
if (result == Services.SaveResult.SUCCESS)
{
SaveFiles(id, model.Files);
}
return(RedirectToRoute(UrlLink.VANBAN));
}
public ActionResult Edit(int id)
{
return(ExecuteWithErrorHandling(() =>
{
var data = VanBanRepository.Single(id);
var init = InitViewModel();
var model = new EditVanBanViewModel
{
CoQuanBanHanhVanBanInfos = init.CoQuanBanHanhVanBanInfos,
LoaiVanBanInfos = init.LoaiVanBanInfos,
LinhVucVanBanInfos = init.LinhVucVanBanInfos,
LinhVucVanBanId = data.LinhVucVanBanId,
CoQuanBanhHanhVanBanId = data.CoQuanBanHanhId,
LoaiVanBanId = data.LoaiVanBanId,
NgayBanHanh = data.NgayBanHanh,
NoiDungVanBan = data.NoiDung,
SoVanBan = data.SoVanBan,
TrichYeuVanBan = data.TrichYeu,
TapTinVanBanResults = data.Files,
};
return View(model);
}));
}
public ActionResult Add(AddVanBanViewModel model)
{
var dataSave = new VanBanResult
{
TenVanBan = model.SoVanBan,
NoiDung = model.NoiDungVanBan,
TrichYeu = model.TrichYeuVanBan,
LinhVucVanBanId = model.LinhVucVanBanId,
LoaiVanBanId = model.LoaiVanBanId,
CoQuanBanHanhId = model.CoQuanBanhHanhVanBanId,
NgayBanHanh = model.NgayBanHanh,
SoVanBan = model.SoVanBan,
CreatedBy = UserName,
};
var result = VanBanRepository.Add(dataSave);
if (result == Services.SaveResult.SUCCESS && dataSave.Id > 0)
{
SaveFiles(dataSave.Id, model.Files);
}
return(RedirectToRoute(UrlLink.VANBAN_EDIT, new { sovanban = dataSave.SoVanBan.RejectMarks(), id = dataSave.Id }));
}
public PartialViewResult Detail(int id)
{
var model = VanBanRepository.Single(id);
return(PartialView("_PartialPageDetail", model));
}
