public static DTO_PRO_Sysnopsis post_PRO_Sysnopsis(AppEntities db, DTO_PRO_Sysnopsis item, string Username)
{
tbl_PRO_Sysnopsis dbitem = new tbl_PRO_Sysnopsis();
if (item != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.StudyTitle = item.StudyTitle;
dbitem.Investigators = item.Investigators;
dbitem.BackgroundAims = item.BackgroundAims;
dbitem.Objectives = item.Objectives;
dbitem.StudyDesign = item.StudyDesign;
dbitem.StudyPopulation = item.StudyPopulation;
dbitem.Endpoint = item.Endpoint;
dbitem.PrimaryEndpoint = item.PrimaryEndpoint;
dbitem.SecondaryEndpoint = item.SecondaryEndpoint;
dbitem.MainEligibilityCriteria = item.MainEligibilityCriteria;
dbitem.InclusionCriteria = item.InclusionCriteria;
dbitem.ExclusionCriteria = item.ExclusionCriteria;
dbitem.DataAnalysis = item.DataAnalysis;
dbitem.References = item.References;
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_Sysnopsis.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_Sysnopsis", 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_Sysnopsis", e);
item = null;
}
}
return(item);
}
public IHttpActionResult Get(int id)
{
DTO_PRO_Sysnopsis tbl_PRO_Sysnopsis = BS_PRO_Sysnopsis.get_PRO_Sysnopsis(db, id);
if (tbl_PRO_Sysnopsis == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_Sysnopsis));
}
public IHttpActionResult Post(DTO_PRO_Sysnopsis tbl_PRO_Sysnopsis)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_Sysnopsis result = BS_PRO_Sysnopsis.post_PRO_Sysnopsis(db, tbl_PRO_Sysnopsis, Username);
if (result != null)
{
return(CreatedAtRoute("get_PRO_Sysnopsis", new { id = result.ID }, result));
}
return(Conflict());
}
public static DTO_PRO_Sysnopsis get_PRO_SysnopsisByDeTai(AppEntities db, int deTaiId)
{
var query = db.tbl_PRO_Sysnopsis.Where(d => d.IDDeTai == deTaiId && d.IsDeleted == false).Select(s => new DTO_PRO_Sysnopsis
{
ID = s.ID,
IDDeTai = s.IDDeTai,
StudyTitle = s.StudyTitle,
Investigators = s.Investigators,
BackgroundAims = s.BackgroundAims,
Objectives = s.Objectives,
StudyDesign = s.StudyDesign,
StudyPopulation = s.StudyPopulation,
Endpoint = s.Endpoint,
PrimaryEndpoint = s.PrimaryEndpoint,
SecondaryEndpoint = s.SecondaryEndpoint,
MainEligibilityCriteria = s.MainEligibilityCriteria,
InclusionCriteria = s.InclusionCriteria,
ExclusionCriteria = s.ExclusionCriteria,
DataAnalysis = s.DataAnalysis,
References = s.References,
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)
{
query = new DTO_PRO_Sysnopsis
{
IDDeTai = deTaiId
};
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == deTaiId);
if (detai != null)
{
query.IsDisabled = detai.IsDisabledHRCO ?? false;
}
}
return(query);
}
public IHttpActionResult GetCustom(int idDeTai, bool?isInput = false)
{
DTO_PRO_Sysnopsis tbl_PRO_Sysnopsis = BS_PRO_Sysnopsis.get_PRO_SysnopsisByDeTai(db, idDeTai);
string html = "";
string htmlPrint = "";
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/Sysnopsis.html")))
{
htmlPrint = r.ReadToEnd();
}
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/Sysnopsis_Input.html")))
{
html = r.ReadToEnd();
}
tbl_PRO_Sysnopsis.HTML = html;
tbl_PRO_Sysnopsis.HTMLPrint = htmlPrint;
return(Ok(tbl_PRO_Sysnopsis));
}
public IHttpActionResult Put(int id, DTO_PRO_Sysnopsis tbl_PRO_Sysnopsis)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_Sysnopsis.ID)
{
return(BadRequest());
}
bool result = BS_PRO_Sysnopsis.put_PRO_Sysnopsis(db, id, tbl_PRO_Sysnopsis, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
