public static bool put_SYS_Var(AppEntities db, int ID, DTO_SYS_Var item, string Username)
{
bool result = false;
var dbitem = db.tbl_SYS_Var.Find(ID);
if (dbitem != null)
{
dbitem.Code = item.Code;
dbitem.ValueOfVar = item.ValueOfVar;
dbitem.TypeOfVar = item.TypeOfVar;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_SYS_Var", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_SYS_Var", e);
result = false;
}
}
return(result);
}
public IHttpActionResult Get(int id)
{
DTO_SYS_Var tbl_SYS_Var = BS_SYS_Var.get_SYS_Var(db, id);
if (tbl_SYS_Var == null)
{
return(NotFound());
}
return(Ok(tbl_SYS_Var));
}
public IHttpActionResult Post(DTO_SYS_Var tbl_SYS_Var)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_SYS_Var result = BS_SYS_Var.post_SYS_Var(db, tbl_SYS_Var, Username);
if (result != null)
{
return(CreatedAtRoute("get_SYS_Var", new { id = result.ID }, result));
}
return(Conflict());
}
public static DTO_SYS_Var post_SYS_Var(AppEntities db, DTO_SYS_Var item, string Username)
{
tbl_SYS_Var dbitem = new tbl_SYS_Var();
if (item != null)
{
dbitem.Code = item.Code;
dbitem.ValueOfVar = item.ValueOfVar;
dbitem.TypeOfVar = item.TypeOfVar;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.tbl_SYS_Var.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_SYS_Var", 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_SYS_Var", e);
item = null;
}
}
return(item);
}
public IHttpActionResult Put(int id, DTO_SYS_Var tbl_SYS_Var)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_SYS_Var.ID)
{
return(BadRequest());
}
bool result = BS_SYS_Var.put_SYS_Var(db, id, tbl_SYS_Var, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
