// Create
public int CreateOrUpdate(GadgetModel gadgetModel)
{
// Acesso ao banco de dados
// Using abra e fecha automaticamente o banco de dados
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "";
if (gadgetModel.Id <= 0)
{
sqlQuery = "INSERT INTO dbo.Gadgets Values(@Name, @Description, @AppearsIn, @WithThisActor)";
}
else
{
//update
sqlQuery = "UPDATE dbo.Gadgets SET Name = @Name, Description = @Description, AppearsIn = @AppearsIn, WithThisActor = @WithThisActor WHERE Id = @Id";
}
// associar @id com o parâmetro Id
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@Id", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.Id;
command.Parameters.Add("@Name", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.Name;
command.Parameters.Add("@Description", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.Description;
command.Parameters.Add("@AppearsIn", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.AppearsIn;
command.Parameters.Add("@WithThisActor", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.WithThisActor;
connection.Open();
int newID = command.ExecuteNonQuery();
return(newID);
}
}
public GadgetModel FetchOne(int Id)
{
// Acesso ao banco de dados
// Using abra e fecha automaticamente o banco de dados
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from dbo.Gadgets WHERE Id = @id";
// associar @id com o parâmetro Id
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = Id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
GadgetModel gadget = new GadgetModel();
if (reader.HasRows)
{
while (reader.Read())
{
//Criando um novo objeto Gadget e adicionando na lista de retorno.
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
}
}
return(gadget);
}
}
// Fará todas as operações relacionadas ao banco de dados
public List <GadgetModel> FetchAll()
{
List <GadgetModel> returnList = new List <GadgetModel>();
// Acesso ao banco de dados
// Using abra e fecha automaticamente o banco de dados
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from dbo.Gadgets";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//Criando um novo objeto Gadget e adicionando na lista de retorno.
GadgetModel gadget = new GadgetModel();
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
returnList.Add(gadget);
}
}
}
return(returnList);
}
public GadgetModel FetchOne(int id)
{
// access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from dbo.Gadgets WHERE Id = @id";
// associate @id with Id parameter
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
GadgetModel gadget = new GadgetModel();
if (reader.HasRows)
{
while (reader.Read())
{
// create a new gadget object. Add it to the list to return.
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
}
}
return(gadget);
}
}
internal List <GadgetModel> SearchForName(string searchPhrase)
{
List <GadgetModel> returnList = new List <GadgetModel>();
// access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM dbo.Gadgets WHERE NAME LIKE @searchForMe";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@searchForMe", System.Data.SqlDbType.NVarChar).Value = "%" + searchPhrase + "%";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
// create a new gadget object. Add it to the list to return.
GadgetModel gadget = new GadgetModel();
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
returnList.Add(gadget);
}
}
return(returnList);
}
}
public string ValidateWidget(string widgetXml)
{
GadgetModel model = new GadgetModel();
bool validationResult = true;
List <string> messages = new List <string>();
try
{
validationResult = GadgetModel.Validate(widgetXml, messages);
if (validationResult)
{
model = HttpHelpers.XmlDeserialize <GadgetModel>(widgetXml);
}
}
catch (Exception ex)
{
validationResult = false;
messages.Add(ex.Message);
}
return(string.Format(
@"<body><script>
var message=JSON.stringify({0});
top.postMessage('BinaryApiCall' + message, '*');
</script></body>" ,
new JavaScriptSerializer().Serialize(new
{
ID = Guid.NewGuid(),
widget = model,
manifest = widgetXml,
validationResult = validationResult,
messages = messages
})));
}
// performs all operations on the database. Get all, create, delete, get one, search etc.
public List <GadgetModel> FetchAll()
{
List <GadgetModel> returnList = new List <GadgetModel>();
// access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from [dbo].[Gadgets]";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
// create a new gadget object. Add it to the list to return.
GadgetModel gadget = new GadgetModel();
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
returnList.Add(gadget);
}
}
return(returnList);
}
}
//Create a single item in the database
public int CreateOrUpdateGadget(GadgetModel gadgetModel)
{
//Access the database
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
string sqlQuery = "";
if (gadgetModel.Id <= 0)
{
sqlQuery = "INSERT INTO dbo.Gadgets Values(@Name, @Description, @AppearsIn, @WithThisActor) ";
}
else
{
//Update
sqlQuery = "UPDATE dbo.Gadgets SET Name = @Name, Description = @Description, AppearsIn = @AppearsIn, WithThisActor = @WithThisActor WHERE Id = @Id";
}
//Associate @id with Id parameter
SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = gadgetModel.Id;
sqlCommand.Parameters.Add("@Name", System.Data.SqlDbType.VarChar, 100).Value = gadgetModel.Name;
sqlCommand.Parameters.Add("@Description", System.Data.SqlDbType.VarChar, 100).Value = gadgetModel.Description;
sqlCommand.Parameters.Add("@AppearsIn", System.Data.SqlDbType.VarChar, 100).Value = gadgetModel.AppearsIn;
sqlCommand.Parameters.Add("@WithThisActor", System.Data.SqlDbType.VarChar, 100).Value = gadgetModel.WithThisActor;
sqlConnection.Open();
int newId = sqlCommand.ExecuteNonQuery();
return(newId);
}
}
//Performs all operations on the database.
//Get all items in the database
public List <GadgetModel> GetAll()
{
List <GadgetModel> returnList = new List <GadgetModel>();
//Access the database
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM dbo.Gadgets";
SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
//Create a new gadget object. Add it to the list to return.
GadgetModel gadget = new GadgetModel();
gadget.Id = sqlDataReader.GetInt32(0);
gadget.Name = sqlDataReader.GetString(1);
gadget.Description = sqlDataReader.GetString(2);
gadget.AppearsIn = sqlDataReader.GetString(3);
gadget.WithThisActor = sqlDataReader.GetString(4);
returnList.Add(gadget);
}
}
}
return(returnList);
}
public GadgetModel fetchById(int id)
{
GadgetModel gadget = new GadgetModel();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string SqlQuery = "SELECT * FROM [dbo].[GADGETS] where Id = @Id";
SqlCommand command = new SqlCommand(SqlQuery, connection);
command.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
}
}
}
return(gadget);
}
internal List <GadgetModel> SearchForName(string searchPhrase)
{
List <GadgetModel> returnList = new List <GadgetModel>();
// Acesso ao banco de dados
// Using abra e fecha automaticamente o banco de dados
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from dbo.Gadgets WHERE NAME LIKE @searchForMe";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@searchForMe", System.Data.SqlDbType.NVarChar).Value = "%" + searchPhrase + "%";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//Criando um novo objeto Gadget e adicionando na lista de retorno.
GadgetModel gadget = new GadgetModel();
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
returnList.Add(gadget);
}
}
return(returnList);
}
}
internal List <GadgetModel> SearchForName(string searchPhrase)
{
List <GadgetModel> returnList = new List <GadgetModel>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQurey = "SELECT * from dbo.Gadgets WHERE NAME LIKE @searchForME";
SqlCommand command = new SqlCommand(sqlQurey, connection);
command.Parameters.Add("@searchForME", System.Data.SqlDbType.VarChar).Value = "%" + searchPhrase + "%";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
GadgetModel gadget = new GadgetModel()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Description = reader.GetString(2),
AppearsIn = reader.GetString(3),
WithThisActor = reader.GetString(4)
};
returnList.Add(gadget);
}
}
return(returnList);
}
}
//perform all operations related to DB
public List <GadgetModel> fetchAll()
{
List <GadgetModel> returnList = new List <GadgetModel>();
//opens connection, closes connection after using is done
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM [dbo].[GADGETS]";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//create new Gadget Object and add to the list
GadgetModel gadget = new GadgetModel();
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
returnList.Add(gadget);
}
}
}
return(returnList);
}
public ActionResult Edit(int id)
{
GadgetDAO gadgetDAO = new GadgetDAO();
GadgetModel gadgets = gadgetDAO.FetchOne(id);
return(View("GadgetForm", gadgets));
}
internal void Cleanup()
{
GadgetModel.CopyFrom(GadgetReport.CreateDefault);
ComponentControlModel = TComponentControlModel.CreateDefault;
BusyVisibility = Visibility.Hidden;
}
//Cria um item no banco
public ActionResult ProcessCreate(GadgetModel gadgetModel)
{
//Salvando no banco de dados.Para Updates e Criar
GadgetModel gadget = context.Gadgets.SingleOrDefault(g => g.Id == gadgetModel.Id);
//edit
if (gadget != null)
{
gadget.Name = gadgetModel.Name;
gadget.Description = gadgetModel.Description;
gadget.AppearsIn = gadgetModel.AppearsIn;
gadget.WithThisActor = gadgetModel.WithThisActor;
context.SaveChanges();
}
else
{
context.Gadgets.Add(gadgetModel);
}
context.SaveChanges();
return(View("Details", gadgetModel));
}
public ActionResult Details(int id)
{
GadgetDAO gadgetDAO = new GadgetDAO();
GadgetModel gadget = gadgetDAO.FetchOne(id);
return(View("Details", gadget));
}
public List <GadgetModel> FetchAll()
{
List <GadgetModel> returnList = new List <GadgetModel>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQurey = "SELECT * from dbo.Gadgets";
SqlCommand command = new SqlCommand(sqlQurey, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
GadgetModel gadget = new GadgetModel()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Description = reader.GetString(2),
AppearsIn = reader.GetString(3),
WithThisActor = reader.GetString(4)
};
returnList.Add(gadget);
}
}
}
return(returnList);
}
public IActionResult Create(GadgetModel newModel)
{
GadgetDAO gadgetDAO = new GadgetDAO();
gadgetDAO.Create(newModel);
return(View("Details", newModel));
}
public ActionResult Edit(int id)
{
GadgetDAO gadgetDAO = new GadgetDAO();
GadgetModel gadget = gadgetDAO.GetGadget(id);
return(View("GadgetForm", gadget));
}
public int CreateOrUpdate(GadgetModel gadgetModel)
{
// ha a gadgetmodel.id <= 1 akkor create
// ha a gadgetmodel.id > 1 akkor update
GadgetModel gadget = new GadgetModel();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQurey = "";
if (gadgetModel.Id <= 0)
{
sqlQurey = "INSERT INTO dbo.Gadgets Values(@Name, @Description, @AppearsIn, @WithThisActor)";
}
else
{
sqlQurey = "UPDATE dbo.Gadgets SET Name = @Name, Description = @Description, AppearsIn = @AppearsIn, WithThisActor = @WithThisActor WHERE Id = @id";
}
SqlCommand command = new SqlCommand(sqlQurey, connection);
command.Parameters.Add("@Id", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.Id;
command.Parameters.Add("@Name", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.Name;
command.Parameters.Add("@Description", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.Description;
command.Parameters.Add("@AppearsIn", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.AppearsIn;
command.Parameters.Add("@WithThisActor", System.Data.SqlDbType.VarChar, 1000).Value = gadgetModel.WithThisActor;
connection.Open();
int newId = command.ExecuteNonQuery();
return(newId);
}
}
public List <GadgetModel> SearchDescription(string Description)
{
List <GadgetModel> gadgets = new List <GadgetModel>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = $"SELECT * FROM [dbo].[GADGETS] where Description LIKE @Description";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@Description", System.Data.SqlDbType.VarChar, 1000).Value = $"%{Description}%";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//create new Gadget Object and add to the list
GadgetModel gadget = new GadgetModel();
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
gadgets.Add(gadget);
}
}
}
return(gadgets);
}
public GadgetModel FetchOne(int Id)
{
GadgetModel gadget = new GadgetModel();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQurey = "SELECT * from dbo.Gadgets WHERE Id=@id";
//@id == a paraméter Id-val
SqlCommand command = new SqlCommand(sqlQurey, connection);
command.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = Id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
gadget.Id = reader.GetInt32(0);
gadget.Name = reader.GetString(1);
gadget.Description = reader.GetString(2);
gadget.AppearsIn = reader.GetString(3);
gadget.WithThisActor = reader.GetString(4);
}
}
}
return(gadget);
}
public ActionResult Details(int id)
{
GadgetModel gadget = context.Gadgets.SingleOrDefault(g => g.Id == id);
return(View("Details", gadget));
}
public ActionResult ProcessCreate(GadgetModel gadgetModel)
{
GadgetDAO gadgetDAO = new GadgetDAO();
gadgetDAO.CreateOrUpdate(gadgetModel);
return(View("Details", gadgetModel));
}
public IActionResult Update(GadgetModel updateModel)
{
//GadgetModel gadget = new GadgetModel();
GadgetDAO gadgetDAO = new GadgetDAO();
gadgetDAO.Update(updateModel);
return(View("Details", updateModel));
}
public IActionResult Edit(int id)
{
GadgetModel gadget = new GadgetModel();
GadgetDAO gadgetDAO = new GadgetDAO();
gadget = gadgetDAO.fetchById(id);
return(View("Edit", gadget));
}
public ActionResult ProcessCreate(GadgetModel gadgetModel)
{
//Save to the database
GadgetDAO gadgetDAO = new GadgetDAO();
gadgetDAO.CreateOrUpdateGadget(gadgetModel);
return(View("Details", gadgetModel));
}
public ActionResult Delete(int id)
{
GadgetModel gadget = context.Gadgets.SingleOrDefault(g => g.Id == id);
context.Entry(gadget).State = EntityState.Deleted;
context.SaveChanges();
return(Redirect("/Gadgets"));
}
//Cria um item no banco
public ActionResult ProcessCreate(GadgetModel gadgetModel)
{
//Salvando no banco de dados
GadgetDAO gadgetDAO = new GadgetDAO();
gadgetDAO.CreateOrUpdate(gadgetModel);
return(View("Details", gadgetModel));
}
