public bool CreateContent(Models.Data data)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CreateContent";
cmd.Parameters.Add(new SqlParameter("@FormId", data.FormId));
cmd.Parameters.Add(new SqlParameter("@FunctionalLocation", data.FunctionalLocation));
cmd.Parameters.Add(new SqlParameter("@Sequence", data.Sequence));
cmd.Parameters.Add(new SqlParameter("@Content", data.Content));
cmd.Parameters.Add(new SqlParameter("@Remarks", data.Remarks));
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
}
}
catch (Exception exp)
{
return(true);
}
}
public bool Update(Models.Data data)
{
if (data != null)
{
//Update data to DB
using (DataAccessComponent dac = new DataAccessComponent())
{
return(dac.UpdateContent(data));
}
}
else
{
return(false);
}
}