public IHttpActionResult Put(int id, DTO_PRO_MauPhanTichDuLieu tbl_PRO_MauPhanTichDuLieu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_MauPhanTichDuLieu.ID)
{
return(BadRequest());
}
tbl_PRO_MauPhanTichDuLieu.JSON_BienSoKhac = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.BienSoKhac);
tbl_PRO_MauPhanTichDuLieu.JSON_ChuKyChuyenPhoi = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.ChuKyChuyenPhoi);
tbl_PRO_MauPhanTichDuLieu.JSON_DacDiemNen = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.DacDiemNen);
tbl_PRO_MauPhanTichDuLieu.JSON_KetQuaThai = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.KetQuaThai);
tbl_PRO_MauPhanTichDuLieu.JSON_KichThichBuongTrung = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.KichThichBuongTrung);
tbl_PRO_MauPhanTichDuLieu.JSON_LaBo = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.LaBo);
bool result = BS_PRO_MauPhanTichDuLieu.put_PRO_MauPhanTichDuLieu(db, id, tbl_PRO_MauPhanTichDuLieu, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
public IHttpActionResult Get(int id)
{
DTO_PRO_MauPhanTichDuLieu tbl_PRO_MauPhanTichDuLieu = BS_PRO_MauPhanTichDuLieu.get_PRO_MauPhanTichDuLieu(db, id);
if (tbl_PRO_MauPhanTichDuLieu == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_MauPhanTichDuLieu));
}
public IHttpActionResult GetCustom(int idDeTai, bool?isInput = false)
{
DTO_PRO_MauPhanTichDuLieu tbl_PRO_MauPhanTichDuLieu = BS_PRO_MauPhanTichDuLieu.get_PRO_MauPhanTichDuLieuByDeTai(db, idDeTai);
string html = "";
string htmlPrint = "";
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/MauPhanTichDuLieu.html")))
{
htmlPrint = r.ReadToEnd();
}
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/MauPhanTichDuLieu_Input.html")))
{
html = r.ReadToEnd();
}
tbl_PRO_MauPhanTichDuLieu.HTML = html;
tbl_PRO_MauPhanTichDuLieu.HTMLPrint = htmlPrint;
return(Ok(tbl_PRO_MauPhanTichDuLieu));
}
public IHttpActionResult Post(DTO_PRO_MauPhanTichDuLieu tbl_PRO_MauPhanTichDuLieu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
tbl_PRO_MauPhanTichDuLieu.JSON_BienSoKhac = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.BienSoKhac);
tbl_PRO_MauPhanTichDuLieu.JSON_ChuKyChuyenPhoi = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.ChuKyChuyenPhoi);
tbl_PRO_MauPhanTichDuLieu.JSON_DacDiemNen = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.DacDiemNen);
tbl_PRO_MauPhanTichDuLieu.JSON_KetQuaThai = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.KetQuaThai);
tbl_PRO_MauPhanTichDuLieu.JSON_KichThichBuongTrung = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.KichThichBuongTrung);
tbl_PRO_MauPhanTichDuLieu.JSON_LaBo = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_MauPhanTichDuLieu.LaBo);
DTO_PRO_MauPhanTichDuLieu result = BS_PRO_MauPhanTichDuLieu.post_PRO_MauPhanTichDuLieu(db, tbl_PRO_MauPhanTichDuLieu, Username);
if (result != null)
{
return(CreatedAtRoute("get_PRO_MauPhanTichDuLieu", new { id = result.ID }, result));
}
return(Conflict());
}
public static bool put_PRO_MauPhanTichDuLieu(AppEntities db, int ID, DTO_PRO_MauPhanTichDuLieu item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_MauPhanTichDuLieu.Find(ID);
if (dbitem != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.JSON_DacDiemNen = item.JSON_DacDiemNen;
dbitem.JSON_KichThichBuongTrung = item.JSON_KichThichBuongTrung;
dbitem.JSON_LaBo = item.JSON_LaBo;
dbitem.JSON_ChuKyChuyenPhoi = item.JSON_ChuKyChuyenPhoi;
dbitem.JSON_KetQuaThai = item.JSON_KetQuaThai;
dbitem.JSON_BienSoKhac = item.JSON_BienSoKhac;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.FormConfig = item.FormConfig;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_MauPhanTichDuLieu", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_MauPhanTichDuLieu", e);
result = false;
}
}
return(result);
}
public static DTO_PRO_MauPhanTichDuLieu post_PRO_MauPhanTichDuLieu(AppEntities db, DTO_PRO_MauPhanTichDuLieu item, string Username)
{
tbl_PRO_MauPhanTichDuLieu dbitem = new tbl_PRO_MauPhanTichDuLieu();
if (item != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.JSON_DacDiemNen = item.JSON_DacDiemNen;
dbitem.JSON_KichThichBuongTrung = item.JSON_KichThichBuongTrung;
dbitem.JSON_LaBo = item.JSON_LaBo;
dbitem.JSON_ChuKyChuyenPhoi = item.JSON_ChuKyChuyenPhoi;
dbitem.JSON_KetQuaThai = item.JSON_KetQuaThai;
dbitem.JSON_BienSoKhac = item.JSON_BienSoKhac;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.FormConfig = item.FormConfig;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.tbl_PRO_MauPhanTichDuLieu.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_MauPhanTichDuLieu", 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_MauPhanTichDuLieu", e);
item = null;
}
}
return(item);
}
public static DTO_PRO_MauPhanTichDuLieu get_PRO_MauPhanTichDuLieuByDeTai(AppEntities db, int deTaiId)
{
var query = db.tbl_PRO_MauPhanTichDuLieu.Where(d => d.IDDeTai == deTaiId && d.IsDeleted == false).Select(s => new
{
ID = s.ID,
IDDeTai = s.IDDeTai,
JSON_DacDiemNen = s.JSON_DacDiemNen,
s.JSON_ChuKyChuyenPhoi,
s.JSON_KetQuaThai,
s.JSON_KichThichBuongTrung,
s.JSON_LaBo,
s.JSON_BienSoKhac,
HTML = s.HTML,
FormConfig = s.FormConfig,
IsDisabled = s.tbl_PRO_DeTai.IsDisabledHRCO ?? false,
IsDeleted = s.IsDeleted,
CreatedDate = s.CreatedDate,
CreatedBy = s.CreatedBy,
ModifiedDate = s.ModifiedDate,
ModifiedBy = s.ModifiedBy,
}).FirstOrDefault();
if (query != null)
{
DTO_PRO_MauPhanTichDuLieu item = new DTO_PRO_MauPhanTichDuLieu
{
ID = query.ID,
IDDeTai = query.IDDeTai,
JSON_BienSoKhac = query.JSON_BienSoKhac,
BienSoKhac = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_MauPhanTichDuLieu_BienSoKhac>(query.JSON_BienSoKhac),
JSON_DacDiemNen = query.JSON_DacDiemNen,
DacDiemNen = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_MauPhanTichDuLieu_DacDiemNen>(query.JSON_DacDiemNen),
JSON_ChuKyChuyenPhoi = query.JSON_ChuKyChuyenPhoi,
ChuKyChuyenPhoi = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_MauPhanTichDuLieu_ChuKyChuyenPhoi>(query.JSON_ChuKyChuyenPhoi),
JSON_KetQuaThai = query.JSON_KetQuaThai,
KetQuaThai = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_MauPhanTichDuLieu_KetQuaThai>(query.JSON_KetQuaThai),
JSON_KichThichBuongTrung = query.JSON_KichThichBuongTrung,
KichThichBuongTrung = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_MauPhanTichDuLieu_KichThichBuongTrung>(query.JSON_KichThichBuongTrung),
JSON_LaBo = query.JSON_LaBo,
LaBo = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_MauPhanTichDuLieu_LaBo>(query.JSON_LaBo),
HTML = query.HTML,
FormConfig = query.FormConfig,
IsDisabled = query.IsDisabled,
IsDeleted = query.IsDeleted,
CreatedDate = query.CreatedDate,
CreatedBy = query.CreatedBy,
ModifiedDate = query.ModifiedDate,
ModifiedBy = query.ModifiedBy,
};
return(item);
}
else
{
DTO_PRO_MauPhanTichDuLieu item = new DTO_PRO_MauPhanTichDuLieu
{
IDDeTai = deTaiId,
KetQuaThai = new DTO_PRO_MauPhanTichDuLieu_KetQuaThai(),
DacDiemNen = new DTO_PRO_MauPhanTichDuLieu_DacDiemNen(),
KichThichBuongTrung = new DTO_PRO_MauPhanTichDuLieu_KichThichBuongTrung(),
LaBo = new DTO_PRO_MauPhanTichDuLieu_LaBo(),
ChuKyChuyenPhoi = new DTO_PRO_MauPhanTichDuLieu_ChuKyChuyenPhoi(),
BienSoKhac = new DTO_PRO_MauPhanTichDuLieu_BienSoKhac()
};
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == deTaiId);
if (detai != null)
{
item.IsDisabled = detai.IsDisabledHRCO ?? false;
}
return(item);
}
return(null);
}
