public IHttpActionResult PostPreform(Preform preform)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Preform.Add(preform);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (PreformExists(preform.PreformNo))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = preform.PreformNo }, preform));
}
public IHttpActionResult PutPreform(int id, Preform preform)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != preform.PreformNo)
{
return(BadRequest());
}
db.Entry(preform).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PreformExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetPreform(int id)
{
Preform preform = db.Preform.Find(id);
if (preform == null)
{
return(NotFound());
}
return(Ok(preform));
}
public IHttpActionResult DeletePreform(int id)
{
Preform preform = db.Preform.Find(id);
if (preform == null)
{
return(NotFound());
}
db.Preform.Remove(preform);
db.SaveChanges();
return(Ok(preform));
}
public List <Preform> GetFormList()
{
string sql = "SELECT Seq, Subject, Explain FROM TB_APPROVAL_FORM WHERE Enabled = '1'";
List <Preform> preformList;
using (connection = new SqlConnection(SetConnString("mssql")))
{
connection.Open();
command = new SqlCommand(sql, connection);
reader = command.ExecuteReader();
Preform form;
preformList = new List <Preform>();
while (reader.Read())
{
form = new Preform();
form.Seq = reader["Seq"].ToString();
//form.FormId = reader["FormId"].ToString();
//form.FormGroup = reader["FormGroup"].ToString();
form.Subject = reader["Subject"].ToString();
form.Explain = reader["Explain"].ToString();
//form.Content = reader["Content"].ToString();
//form.Author = reader["Author"].ToString();
//form.Enabled = reader["Enabled"].ToString();
//form.Modified = reader["Modified"].ToString();
//form.Created = reader["Created"].ToString();
preformList.Add(form);
}
connection.Close();
}
return(preformList);
}
