//public BusinessLogicLayer() //{ // dataAccessLayer = new DataAccessLayer(); //} public string InsertValue(DataAccessObject objectDataAccesss) { try { return(dataAccessLayer.ToInsertValue(objectDataAccesss)); } catch (Exception ex) { throw ex; } finally { dataAccessLayer = null; } }
public string ToInsertValue(DataAccessObject objectDataAccess) { sqlConnection.Open(); string query = "INSERT INTO NumberValues(z) VALUES(@Z)"; SqlCommand cmd = new SqlCommand(query, sqlConnection); try { cmd.Parameters.AddWithValue("@Z", objectDataAccess.ValueOfZ); cmd.ExecuteNonQuery(); sqlConnection.Close(); } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); sqlConnection.Close(); } return(successMessage); }
public int UpdateTotal(DataAccessObject objectDataAccesss) { int totalValues = objectDataAccesss.ValueOfX + objectDataAccesss.ValueOfY + objectDataAccesss.TotalOfZ; return(totalValues); }