public static bool Insert(IzgubioModel dogModel)
{
int numOfColumns = 0;
try
{
mySqlConnection.Open();
string sql = string.Format(@"insert into dogfinderdb.dogs(name, weight, description,kind, slika1, slika2, grad)
values('{0}',{1},'{2}', '{3}', '{4}', '{5}', '{6}')", dogModel.ime, dogModel.tezina, dogModel.info,
dogModel.rasa, dogModel.slika1, dogModel.slika2, dogModel.grad);
MySqlCommand command = new MySqlCommand(sql, mySqlConnection);
numOfColumns = command.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
mySqlConnection.Close();
}
if (numOfColumns != 0)
{
RefreshCache();
}
return(numOfColumns != 0);
}
public HttpStatusCode Izgubio(IzgubioModel model)
{
bool isOk = DBComunicator.Insert(model);
if (isOk)
{
return(HttpStatusCode.OK);
}
return(HttpStatusCode.BadRequest);
}
