public int Add(User entity) { var queryString = String.Format("INSERT INTO {0} (Name) VALUES ('{1}');", c_usersDatabaseName, entity.Name); DataBaseHelper.ExecuteCommand(queryString); return(m_userMapper.GetLastCreatedId(queryString)); }
public int Add(Catalog entity) { var queryString = String.Format("INSERT INTO {0} (Name) VALUES ('{1}');", c_catalogsDatabaseName, entity.Name ); return(m_catalogMapper.GetLastCreatedId(queryString)); }
public int Add(Order entity) { var queryString = String.Format("INSERT INTO {0} (UserId) VALUES ({1});", c_ordersDatabaseName, entity.UserId ); return(m_orderMapper.GetLastCreatedId(queryString)); }
public int Add(Product entity) { var queryString = ""; if (entity.CatalogId == 0) { queryString = String.Format("INSERT INTO {0} (Name, Description) VALUES ('{1}', '{2}'); SELECT IDENT_CURRENT('{0}') AS Id;", c_productsDatabaseName, entity.Name, entity.Description ); } else { queryString = String.Format("INSERT INTO {0} (Name, Description, CatalogId) VALUES ('{1}', '{2}', {3}); SELECT IDENT_CURRENT('{0}') AS Id;", c_productsDatabaseName, entity.Name, entity.Description, entity.CatalogId); } return(m_productMapper.GetLastCreatedId(queryString)); }