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); }