public IHttpActionResult Refresh(DTO_PRO_BangKhaiNhanSu tbl_PRO_BangKhaiNhanSu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
BS_PRO_BangKhaiNhanSu.refresh_PRO_BangKhaiNhanSuByDeTai(db, tbl_PRO_BangKhaiNhanSu.IDDeTai, Username);
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Get(int id)
{
DTO_PRO_BangKhaiNhanSu tbl_PRO_BangKhaiNhanSu = BS_PRO_BangKhaiNhanSu.get_PRO_BangKhaiNhanSu(db, id);
if (tbl_PRO_BangKhaiNhanSu == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_BangKhaiNhanSu));
}
public IHttpActionResult Post(DTO_PRO_BangKhaiNhanSu tbl_PRO_BangKhaiNhanSu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_BangKhaiNhanSu result = BS_PRO_BangKhaiNhanSu.post_PRO_BangKhaiNhanSu(db, tbl_PRO_BangKhaiNhanSu, Username);
if (result != null)
{
return(CreatedAtRoute("get_PRO_BangKhaiNhanSu", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Put(int id, DTO_PRO_BangKhaiNhanSu tbl_PRO_BangKhaiNhanSu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_BangKhaiNhanSu.ID)
{
return(BadRequest());
}
bool result = BS_PRO_BangKhaiNhanSu.put_PRO_BangKhaiNhanSu(db, id, tbl_PRO_BangKhaiNhanSu, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
public IHttpActionResult GetCustom(int idDeTai, bool?isInput = false)
{
DTO_PRO_BangKhaiNhanSu tbl_PRO_BangKhaiNhanSu = BS_PRO_BangKhaiNhanSu.get_PRO_BangKhaiNhanSuByDeTai(db, idDeTai);
//if (tbl_PRO_LLKH.ID == 0)
//{
string html = "";
string htmlPrint = "";
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/BangKhaiNhanSu.html")))
{
htmlPrint = r.ReadToEnd();
}
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/BangKhaiNhanSu_Input.html")))
{
html = r.ReadToEnd();
}
tbl_PRO_BangKhaiNhanSu.HTML = html;
tbl_PRO_BangKhaiNhanSu.HTMLPrint = htmlPrint;
return(Ok(tbl_PRO_BangKhaiNhanSu));
}
public static DTO_PRO_BangKhaiNhanSu post_PRO_BangKhaiNhanSu(AppEntities db, DTO_PRO_BangKhaiNhanSu item, string Username)
{
tbl_PRO_BangKhaiNhanSu dbitem = new tbl_PRO_BangKhaiNhanSu();
if (item != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.YTuong_NguoiThucHien = item.YTuong_NguoiThucHien;
dbitem.YTuong_ChiPhi = item.YTuong_ChiPhi;
dbitem.PhuongPhap_NguoiThucHien = item.PhuongPhap_NguoiThucHien;
dbitem.PhuongPhap_ChiPhi = item.PhuongPhap_ChiPhi;
dbitem.QuyTrinhNhanMau_NguoiThucHien = item.QuyTrinhNhanMau_NguoiThucHien;
dbitem.QuyTrinhNhanMau_ChiPhi = item.QuyTrinhNhanMau_ChiPhi;
dbitem.ThucHienNhanMau_NguoiThucHien = item.ThucHienNhanMau_NguoiThucHien;
dbitem.ThucHienNhanMau_ChiPhi = item.ThucHienNhanMau_ChiPhi;
dbitem.NhapDuLieuVaoPM_NguoiThucHien = item.NhapDuLieuVaoPM_NguoiThucHien;
dbitem.NhapDuLieuVaoPM_ChiPhi = item.NhapDuLieuVaoPM_ChiPhi;
dbitem.VietBaiBaoCaoTiengViet_NguoiThucHien = item.VietBaiBaoCaoTiengViet_NguoiThucHien;
dbitem.VietBaiBaoCaoTiengViet_ChiPhi = item.VietBaiBaoCaoTiengViet_ChiPhi;
dbitem.VietBaiBaoCaoTiengAnh_NguoiThucHien = item.VietBaiBaoCaoTiengAnh_NguoiThucHien;
dbitem.VietBaiBaoCaoTiengAnh_ChiPhi = item.VietBaiBaoCaoTiengAnh_ChiPhi;
dbitem.ReviewTinhKhaThi_NguoiThucHien = item.ReviewTinhKhaThi_NguoiThucHien;
dbitem.ReviewTinhKhaThi_ChiPhi = item.ReviewTinhKhaThi_ChiPhi;
dbitem.XayDungPhanMem_NguoiThucHien = item.XayDungPhanMem_NguoiThucHien;
dbitem.XayDungPhanMem_ChiPhi = item.XayDungPhanMem_ChiPhi;
dbitem.XayDungKeHoachPhanTich_NguoiThucHien = item.XayDungKeHoachPhanTich_NguoiThucHien;
dbitem.XayDungKeHoachPhanTich_ChiPhi = item.XayDungKeHoachPhanTich_ChiPhi;
dbitem.LamSachSoLieu_NguoiThucHien = item.LamSachSoLieu_NguoiThucHien;
dbitem.LamSachSoLieu_ChiPhi = item.LamSachSoLieu_ChiPhi;
dbitem.PhanTichSoLieu_NguoiThucHien = item.PhanTichSoLieu_NguoiThucHien;
dbitem.PhanTichSoLieu_ChiPhi = item.PhanTichSoLieu_ChiPhi;
dbitem.XayDungKeHoachDieuPhoi_NguoiThucHien = item.XayDungKeHoachDieuPhoi_NguoiThucHien;
dbitem.XayDungKeHoachDieuPhoi_ChiPhi = item.XayDungKeHoachDieuPhoi_ChiPhi;
dbitem.ChuanBiHoSoGiayTo_NguoiThucHien = item.ChuanBiHoSoGiayTo_NguoiThucHien;
dbitem.ChuanBiHoSoGiayTo_ChiPhi = item.ChuanBiHoSoGiayTo_ChiPhi;
dbitem.DieuPhoiHoatDongNghienCuu_NguoiThucHien = item.DieuPhoiHoatDongNghienCuu_NguoiThucHien;
dbitem.DieuPhoiHoatDongNghienCuu_ChiPhi = item.DieuPhoiHoatDongNghienCuu_ChiPhi;
dbitem.QuanLyDieuHanhChung_NguoiThucHien = item.QuanLyDieuHanhChung_NguoiThucHien;
dbitem.QuanLyDieuHanhChung_ChiPhi = item.QuanLyDieuHanhChung_ChiPhi;
dbitem.FormConfig = item.FormConfig;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.tbl_PRO_BangKhaiNhanSu.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BangKhaiNhanSu", DateTime.Now, Username);
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("post_PRO_BangKhaiNhanSu", e);
item = null;
}
}
return(item);
}
public static DTO_PRO_BangKhaiNhanSu get_PRO_BangKhaiNhanSuByDeTai(AppEntities db, int deTaiId)
{
var query = db.tbl_PRO_BangKhaiNhanSu.Where(d => d.IDDeTai == deTaiId).Select(s => new DTO_PRO_BangKhaiNhanSu
{
ID = s.ID,
IDDeTai = s.IDDeTai,
YTuong_NguoiThucHien = s.YTuong_NguoiThucHien,
YTuong_ChiPhi = s.YTuong_ChiPhi,
PhuongPhap_NguoiThucHien = s.PhuongPhap_NguoiThucHien,
PhuongPhap_ChiPhi = s.PhuongPhap_ChiPhi,
QuyTrinhNhanMau_NguoiThucHien = s.QuyTrinhNhanMau_NguoiThucHien,
QuyTrinhNhanMau_ChiPhi = s.QuyTrinhNhanMau_ChiPhi,
ThucHienNhanMau_NguoiThucHien = s.ThucHienNhanMau_NguoiThucHien,
ThucHienNhanMau_ChiPhi = s.ThucHienNhanMau_ChiPhi,
NhapDuLieuVaoPM_NguoiThucHien = s.NhapDuLieuVaoPM_NguoiThucHien,
NhapDuLieuVaoPM_ChiPhi = s.NhapDuLieuVaoPM_ChiPhi,
VietBaiBaoCaoTiengViet_NguoiThucHien = s.VietBaiBaoCaoTiengViet_NguoiThucHien,
VietBaiBaoCaoTiengViet_ChiPhi = s.VietBaiBaoCaoTiengViet_ChiPhi,
VietBaiBaoCaoTiengAnh_NguoiThucHien = s.VietBaiBaoCaoTiengAnh_NguoiThucHien,
VietBaiBaoCaoTiengAnh_ChiPhi = s.VietBaiBaoCaoTiengAnh_ChiPhi,
ReviewTinhKhaThi_NguoiThucHien = s.ReviewTinhKhaThi_NguoiThucHien,
ReviewTinhKhaThi_ChiPhi = s.ReviewTinhKhaThi_ChiPhi,
XayDungPhanMem_NguoiThucHien = s.XayDungPhanMem_NguoiThucHien,
XayDungPhanMem_ChiPhi = s.XayDungPhanMem_ChiPhi,
XayDungKeHoachPhanTich_NguoiThucHien = s.XayDungKeHoachPhanTich_NguoiThucHien,
XayDungKeHoachPhanTich_ChiPhi = s.XayDungKeHoachPhanTich_ChiPhi,
LamSachSoLieu_NguoiThucHien = s.LamSachSoLieu_NguoiThucHien,
LamSachSoLieu_ChiPhi = s.LamSachSoLieu_ChiPhi,
PhanTichSoLieu_NguoiThucHien = s.PhanTichSoLieu_NguoiThucHien,
PhanTichSoLieu_ChiPhi = s.PhanTichSoLieu_ChiPhi,
XayDungKeHoachDieuPhoi_NguoiThucHien = s.XayDungKeHoachDieuPhoi_NguoiThucHien,
XayDungKeHoachDieuPhoi_ChiPhi = s.XayDungKeHoachDieuPhoi_ChiPhi,
ChuanBiHoSoGiayTo_NguoiThucHien = s.ChuanBiHoSoGiayTo_NguoiThucHien,
ChuanBiHoSoGiayTo_ChiPhi = s.ChuanBiHoSoGiayTo_ChiPhi,
DieuPhoiHoatDongNghienCuu_NguoiThucHien = s.DieuPhoiHoatDongNghienCuu_NguoiThucHien,
DieuPhoiHoatDongNghienCuu_ChiPhi = s.DieuPhoiHoatDongNghienCuu_ChiPhi,
QuanLyDieuHanhChung_NguoiThucHien = s.QuanLyDieuHanhChung_NguoiThucHien,
QuanLyDieuHanhChung_ChiPhi = s.QuanLyDieuHanhChung_ChiPhi,
CreatedDate = s.CreatedDate,
CreatedBy = s.CreatedBy,
ModifiedDate = s.ModifiedDate,
ModifiedBy = s.ModifiedBy,
FormConfig = s.FormConfig,
}).FirstOrDefault();
if (query == null)
{
query = new DTO_PRO_BangKhaiNhanSu
{
ID = 0,
IDDeTai = deTaiId
};
var thuyetminh = db.tbl_PRO_ThuyetMinhDeTai.FirstOrDefault(c => c.IDDeTai == deTaiId && c.IsDeleted == false);
if (thuyetminh != null && !string.IsNullOrEmpty(thuyetminh.B313_JSON_KeHoachThucHien))
{
try
{
List <DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien> lst = Newtonsoft.Json.JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien> >(thuyetminh.B313_JSON_KeHoachThucHien);
foreach (var item in lst)
{
if (item.NoiDung == DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.VietDeCuong)
{
query.YTuong_NguoiThucHien = item.NguoiThucHien;
query.PhuongPhap_NguoiThucHien = item.NguoiThucHien;
}
if (item.NoiDung == DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.ThuThapSoLieu)
{
query.QuyTrinhNhanMau_NguoiThucHien = item.NguoiThucHien;
query.ThucHienNhanMau_NguoiThucHien = item.NguoiThucHien;
query.NhapDuLieuVaoPM_NguoiThucHien = item.NguoiThucHien;
}
if (item.NoiDung == DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.VietBaiDangBaoTrongNuoc)
{
query.VietBaiBaoCaoTiengViet_NguoiThucHien = item.NguoiThucHien;
}
if (item.NoiDung == DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.VietBaiDangBaoQuocTe)
{
query.VietBaiBaoCaoTiengAnh_NguoiThucHien = item.NguoiThucHien;
}
if (item.NoiDung == DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.PhanTichSoLieuCuoiCung)
{
query.PhanTichSoLieu_NguoiThucHien = item.NguoiThucHien;
}
}
}
catch { }
}
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == deTaiId);
if (detai != null)
{
query.QuanLyDieuHanhChung_NguoiThucHien = detai.tbl_CUS_HRM_STAFF_NhanSu1.Name + "/" + detai.tbl_CUS_HRM_STAFF_NhanSu.Name;
}
}
return(query);
}
