public APIResult AddListGioiTinh(List <GioiTinh> listGioiTinh)
{
var db = new BCDHContext();
var result = new APIResult();
try
{
db.GioiTinh.AddRange(listGioiTinh);
db.SaveChanges();
result.error = new Error
{
code = "201",
internalMessage = "Success",
userMessage = "Thêm thành công"
};
}
catch (Exception ex)
{
result.error = new Error
{
code = "500",
internalMessage = ex.ToString(),
userMessage = "Lỗi khi thêm"
};
}
return(result);
}
public bool TruncateVanBan()
{
using (var db = new BCDHContext())
{
try
{
db.Database.ExecuteSqlCommand("truncate table [BCDH].[dbo].[VanBan]");
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool RandomOffice(int skip, int take)
{
Random rnd = new Random();
int officeRandom;
using (var db = new BCDHContext())
{
var vanBans = db.VanBan
.OrderBy(x => x.ID)
.Skip(skip)
.Take(take)
.ToList();
foreach (var item in vanBans)
{
officeRandom = rnd.Next(1, 4); // Random 1- 3
switch (officeRandom)
{
case 1:
item.DonViXuLyChinh = "000-00-12-H40";
break;
case 2:
item.DonViXuLyChinh = "000-00-19-H40";
break;
case 3:
item.DonViXuLyChinh = "000-00-20-H40";
break;
default:
break;
}
}
db.SaveChanges();
}
return(true);
}
public List <HoSo> HoSo()
{
var db = new BCDHContext();
return(db.HoSo.ToList());
}
public List <GiaoVien> GiaoVien()
{
var db = new BCDHContext();
return(db.GiaoVien.ToList());
}
public List <DonViGiaoDuc> DonViGiaoDuc()
{
var db = new BCDHContext();
return(db.DonViGiaoDuc.ToList());
}
public List <PhongHoc> PhongHoc()
{
var db = new BCDHContext();
return(db.PhongHoc.ToList());
}
public List <DonVi> DonVi()
{
var db = new BCDHContext();
return(db.DonVi.ToList());
}
public List <GioiTinh> GioiTinh()
{
var db = new BCDHContext();
return(db.GioiTinh.ToList());
}
public List <TruongHoc> TruongHoc()
{
var db = new BCDHContext();
return(db.TruongHoc.ToList());
}
public List <TonGiao> TonGiao()
{
var db = new BCDHContext();
return(db.TonGiao.ToList());
}
public List <PhuongXa> PhuongXa()
{
var db = new BCDHContext();
return(db.PhuongXa.ToList());
}
public List <VanBan> VanBan()
{
var db = new BCDHContext();
return(db.VanBan.ToList());
}
public ChartOutput Loc(ChartInput input)
{
var result = new ChartOutput();
var data = new List <ChartOutputItem>();
var fields = input.fields.Split(new string[] { "##" }, StringSplitOptions.None);
var fieldsLength = fields.Length;
var values = input.values.Split(new string[] { "##" }, StringSplitOptions.None);
string function = "";
var tuNgay = string.IsNullOrEmpty(input.tuNgay) ? DateTime.MinValue : DateTime.ParseExact(input.tuNgay, "dd/MM/yyyy", CultureInfo.InvariantCulture);
var denNgay = string.IsNullOrEmpty(input.denNgay) ? DateTime.MaxValue : DateTime.ParseExact(input.denNgay, "dd/MM/yyyy", CultureInfo.InvariantCulture);
var listVanBan = new List <VanBan>();
using (var db = new BCDHContext())
{
var vanBan = db.VanBan.
Where(x => x.PhanMem == input.maPhanMem &&
(x.DonViXuLyChinh == input.maDonVi ||
x.DonViXuLyChinh == input.maDonVi)
)
.ToList();
//vanBan = vanBan.Where(
// x => (DateTime.ParseExact(HttpUtility.UrlDecode(x.NgayGiao), "dd/MM/yyyy", CultureInfo.InvariantCulture) >= tuNgay)
// && (DateTime.ParseExact(HttpUtility.UrlDecode(x.NgayGiao), "dd/MM/yyyy", CultureInfo.InvariantCulture) <= denNgay))
// .ToList();
foreach (var item in vanBan)
{
string ngayGiao = HttpUtility.UrlDecode(item.NgayGiao);
if (string.IsNullOrEmpty(ngayGiao))
{
continue;
}
if (DateTime.ParseExact(ngayGiao, "dd/MM/yyyy", CultureInfo.InvariantCulture) >= tuNgay &&
DateTime.ParseExact(ngayGiao, "dd/MM/yyyy", CultureInfo.InvariantCulture) <= denNgay)
{
listVanBan.Add(item);
}
}
vanBan.Clear();
vanBan.AddRange(listVanBan);
for (int i = 0; i < fieldsLength; i++)
{
if (fields[i] == "TrangThaiChung")
{
if (i == fieldsLength - 1)
{
if (values[i] == "null")
{
var listTrangThaiChung = db.TrangThaiChung.ToList();
foreach (var item in listTrangThaiChung)
{
var value = vanBan.Where(x => x.MaTrangThaiChung == item.Ma).Count();
var chartOutputItem = new ChartOutputItem
{
title = item.Ten,
code = item.Ma,
value = value
};
data.Add(chartOutputItem);
}
result.type = "cot";
result.title = "Biểu đồ theo trạng thái";
result.function = function + "TrangThaiChung";
}
else
{
var maTrangThaiChung = values[i];
var trangThaiChung = db.TrangThaiChung.Where(x => x.Ma == maTrangThaiChung).FirstOrDefault();
var value = vanBan.Where(x => x.MaTrangThaiChung == maTrangThaiChung).ToList().Count();
var charOutputItem = new ChartOutputItem
{
title = trangThaiChung.Ten,
code = maTrangThaiChung,
value = value
};
data.Add(charOutputItem);
result.type = "cot";
result.title = "Biểu đồ theo trạng thái";
result.function = function + "TrangThaiChung";
}
}
else
{
var trangThai = values[i];
vanBan = vanBan.Where(x => x.MaTrangThaiChung == trangThai).ToList();
function += fields[i] + "##";
}
}
if (fields[i] == "TinhTrang")
{
if (i == fieldsLength - 1)
{
if (values[i] == "null")
{
var listTinhTrang = db.TinhTrang.ToList();
foreach (var item in listTinhTrang)
{
var value = vanBan.Where(x => x.MaTinhTrang == item.Ma).Count();
var chartOutputItem = new ChartOutputItem
{
title = item.Ten,
code = item.Ma,
value = value
};
data.Add(chartOutputItem);
}
result.type = "cot";
result.title = "Biểu đồ theo tình trạng xử lý";
result.function = function + "TinhTrang";
}
else
{
var maTinhTrang = values[i];
var tinhTrang = db.TinhTrang.Where(x => x.Ma == maTinhTrang).FirstOrDefault();
var value = vanBan.Where(x => x.MaTinhTrang == maTinhTrang).ToList().Count();
var charOutputItem = new ChartOutputItem
{
title = tinhTrang.Ten,
code = maTinhTrang,
value = value
};
data.Add(charOutputItem);
result.type = "cot";
result.title = "Biểu đồ theo tình trạng xử lý";
result.function = function + "TinhTrang";
}
}
else
{
var tinhTrang = values[i];
vanBan = vanBan.Where(x => x.MaTinhTrang == tinhTrang).ToList();
function += fields[i] + "##";
}
}
if (fields[i] == "TrangThaiPhanMem")
{
if (i == fieldsLength)
{
if (values[i] == "null")
{
var listTrangThaiPhanMem = db.TrangThaiPhanMem.ToList();
foreach (var item in listTrangThaiPhanMem)
{
var value = vanBan.Where(x => x.MaTrangThaiPhanMem == item.Ma).Count();
var chartOutputItem = new ChartOutputItem
{
title = item.Ten,
code = item.Ma,
value = value
};
data.Add(chartOutputItem);
}
result.type = "cot";
result.title = "Biểu đồ theo trạng thái phần mềm";
result.function = function + "TrangThaiPhanMem";
}
else
{
var maTrangThaiPhanMem = values[i];
var trangThaiPhanMem = db.TrangThaiPhanMem.Where(x => x.Ma == maTrangThaiPhanMem).FirstOrDefault();
var value = vanBan.Where(x => x.MaTrangThaiPhanMem == maTrangThaiPhanMem).ToList().Count();
var charOutputItem = new ChartOutputItem
{
title = trangThaiPhanMem.Ten,
code = maTrangThaiPhanMem,
value = value
};
data.Add(charOutputItem);
result.type = "cot";
result.title = "Biểu đồ theo trạng thái phần mềm";
result.function = function + "TrangThaiPhanMem";
}
}
else
{
var trangThaiPhanMem = values[i];
vanBan = vanBan.Where(x => x.MaTrangThaiPhanMem == trangThaiPhanMem).ToList();
function += fields[i] + "##";
}
}
}
var listAvailable = new List <string> {
"TrangThaiChung", "TinhTrang", "TrangThaiPhanMem"
};
var available = "";
foreach (var item in listAvailable)
{
if (!input.fields.Contains(item))
{
available += item + "##";
}
}
result.data = data;
result.available = available;
return(result);
}
}
public List <ThuTucHanhChinh> ThuTucHanhChinh()
{
var db = new BCDHContext();
return(db.ThuTucHanhChinh.ToList());
}
public List <LopHoc> LopHoc()
{
var db = new BCDHContext();
return(db.LopHoc.ToList());
}
public List <LinhVuc> LinhVuc()
{
var db = new BCDHContext();
return(db.LinhVuc.ToList());
}
public List <QuanHuyen> QuanHuyen()
{
var db = new BCDHContext();
return(db.QuanHuyen.ToList());
}
public List <HocSinh> HocSinh()
{
var db = new BCDHContext();
return(db.HocSinh.ToList());
}
public List <KhoiHoc> KhoiHoc()
{
var db = new BCDHContext();
return(db.KhoiHoc.ToList());
}
public List <DanToc> DanToc()
{
var db = new BCDHContext();
return(db.DanToc.ToList());
}
public List <CapHoc> CapHoc()
{
var db = new BCDHContext();
return(db.CapHoc.ToList());
}
public List <ChucVu> ChucVu()
{
var db = new BCDHContext();
return(db.ChucVu.ToList());
}
