public List <MenuViewModel> GetMenu()
{
try
{
List <MenuViewModel> result = new List <MenuViewModel>();
using (var db = new QuanLyCongVanContext())
{
//Get Data
var Data = db.Menu.Where(c => c.ParentId == 0 && c.TrangThai == true).Select(x => new MenuViewModel
{
Id = x.Id,
Name = x.Name,
ParentId = x.ParentId,
TrangThai = x.TrangThai,
CSS = x.CSS,
LinkView = x.LinkView,
SubMenu = GetSubMenu(x.Id)
}).ToList();
// Sap xep lai Data
result = Data;
}
return(result);
}
catch (Exception ex)
{
return(null);
}
}
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;
}
}
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/CQBH.xlsx");
Workbook wb = new Workbook();
//Cell Cells = char.Parse(new Cell["A3"].ToString());
Worksheet ws = wb.Worksheets[0];
dt.Columns.Add("Mã");
dt.Columns.Add("Tên");
dt.Columns.Add("Địa chỉ");
dt.Columns.Add("Điện thoại");
dt.Columns.Add("Fax");
dt.Columns.Add("Email");
dt.Columns.Add("Ghi chú");
dt.Columns.Add("Tên viết tắt");
dt.Columns.Add("Mã cấp CQBH");
List <Cqbh> listcqbh = new List <Cqbh>();
listcqbh = db.Cqbh.ToList();
string listcqbhs = "";
if (listcqbh.Count > 0)
{
listcqbhs = String.Join(",", listcqbh.Select(x => x.ToString()).ToArray());
}
var ob = new CqbhRepository();
var data = ob.GetAll();
foreach (Cqbh item in data)
{
dt.Rows.Add(item.MaCqbh, item.TenCqbh, item.DiaChi, item.DienThoai, item.Fax, item.Email, item.GhiChu, item.TenVietTat, item.MaCapCqbh);
}
string filename = "DanhSachCQBH" + 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;
}
}
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/NhanSu.xlsx");
Workbook wb = new Workbook();
//Cell Cells = char.Parse(new Cell["A3"].ToString());
Worksheet ws = wb.Worksheets[0];
dt.Columns.Add("Mã nhân sự");
dt.Columns.Add("Tên");
dt.Columns.Add("Giới tính");
dt.Columns.Add("ngày sinh");
dt.Columns.Add("Địa chỉ nhà");
dt.Columns.Add("Địa chỉ cơ quan");
dt.Columns.Add("Điện thoại");
dt.Columns.Add("Mã phòng");
List <NhanSu> listns = new List <NhanSu>();
listns = db.NhanSu.ToList();
string listnss = "";
if (listns.Count > 0)
{
listnss = String.Join(",", listns.Select(x => x.ToString()).ToArray());
}
var ob = new NhanSuRepository();
var data = ob.GetAll();
foreach (NhanSu item in data)
{
dt.Rows.Add(item.MaNhanSu, item.Ten, item.GioiTinh, Convert.ToDateTime(item.NgaySinh), item.DiaChiNR, item.DiaChiCQ, item.DienThoai, item.MaPhong);
}
string filename = "DanhSachNhanSu" + 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;
}
}
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/PhongBan.xlsx");
Workbook wb = new Workbook();
//Cell Cells = char.Parse(new Cell["A3"].ToString());
Worksheet ws = wb.Worksheets[0];
dt.Columns.Add("Mã phòng");
dt.Columns.Add("Tên");;
dt.Columns.Add("Điện thoại");
dt.Columns.Add("Fax");
dt.Columns.Add("Mã nhân sự");
List <PhongBan> listpb = new List <PhongBan>();
listpb = db.PhongBan.ToList();
string listpbs = "";
if (listpb.Count > 0)
{
listpbs = String.Join(",", listpb.Select(x => x.ToString()).ToArray());
}
var ob = new PhongBanRepository();
var data = ob.GetAll();
foreach (PhongBan item in data)
{
dt.Rows.Add(item.MaPhong, item.TenPhong, item.DienThoai, item.Fax, item.MaNhanSu);
}
string filename = "DanhSachPhongBan" + 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;
}
}
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/NguoiDung.xlsx");
Workbook wb = new Workbook();
//Cell Cells = char.Parse(new Cell["A3"].ToString());
Worksheet ws = wb.Worksheets[0];
dt.Columns.Add("Tên tài khoản");
dt.Columns.Add("Mật khẩu");
dt.Columns.Add("kích hoạt");
dt.Columns.Add("Mã nhân sự");
List <NguoiDung> listnd = new List <NguoiDung>();
listnd = db.NguoiDung.ToList();
string listnds = "";
if (listnd.Count > 0)
{
listnds = String.Join(",", listnd.Select(x => x.ToString()).ToArray());
}
var ob = new NguoiDungRepository();
var data = ob.GetAll();
foreach (NguoiDung item in data)
{
dt.Rows.Add(item.TenTaiKhoan, item.MatKhau, item.KichHoat, item.MaNhanSu);
}
string filename = "DanhSachNguoiDung" + 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 List <MenuViewModel> GetSubMenu(int ParrentId)
{
List <MenuViewModel> submenu = new List <MenuViewModel>();
using (var db = new QuanLyCongVanContext())
{
submenu = db.Menu.Where(x => x.ParentId == ParrentId && x.TrangThai == true)
.Select(x => new MenuViewModel
{
Id = x.Id,
Name = x.Name,
ParentId = x.ParentId,
TrangThai = x.TrangThai,
CSS = x.CSS,
LinkView = x.LinkView,
SubMenu = GetSubMenu(x.Id)
}).ToList();
}
return(submenu);
}
public GenericRepository(QuanLyCongVanContext db)
{
this.db = db;
table = db.Set <T>();
}
public GenericRepository()
{
db = new QuanLyCongVanContext();
table = db.Set <T>();
}
