/// <summary> /// Updates row in table. /// </summary> /// <param name="dbObject">Table name based on type name of object.</param> /// <returns></returns> public bool UpdateData(IDbObject dbObject, string condition = null) { GenericPropertyFinder <IDbObject> property = new GenericPropertyFinder <IDbObject>(); IEnumerable <List <string> > obj = property.PrintTModelPropertyAndValue(dbObject); string table = dbObject.GetType().ToString().Substring(dbObject.GetType().ToString().LastIndexOf('.') + 1); string query = new DbQueryBuilder(obj, table, condition).BuildQuery(QueryType.Update); if (condition != null) { if (query.EndsWith(';')) { query = query[0..^ 1];
/// <summary> /// Insert data in database. Name of table based on argument type. /// </summary> /// <param name="dbObject">Table name based on type name of object.</param> /// <returns>Boolean, True if operation successful</returns> public bool InsertData(IDbObject dbObject) { GenericPropertyFinder <IDbObject> property = new GenericPropertyFinder <IDbObject>(); IEnumerable <List <string> > obj = property.PrintTModelPropertyAndValue(dbObject); GetTableName(dbObject); string query = new DbQueryBuilder(obj, _table).BuildQuery(QueryType.Insert); try { using SqlConnection conn = new SqlConnection(ConnHelper.ConnStr(connection_name)); using SqlCommand command = new SqlCommand(query, conn); conn.Open(); command.ExecuteNonQuery(); command.Dispose(); conn.Close(); return(true); } catch (SqlException e) { MessageBox.Show( $"Provjerite vezu sa bazom podataka.\n {e.Message}", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } catch (Exception e) { MessageBox.Show( $"Nepoznata greška kod brisanja podataka, kontaktirajte podršku.\n {e.Message}", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }