Skip to content

Instantly share code, notes, and snippets.

View csaba-farkas's full-sized avatar

Csaba Farkas csaba-farkas

View GitHub Profile
@csaba-farkas
csaba-farkas / .htaccess
Created November 22, 2018 20:34
Apache .htaccess for Angular development
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.html$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.html [L]
</IfModule>
@csaba-farkas
csaba-farkas / Form.cs
Created October 17, 2018 09:46
[Highlight column on click - Devexpress GridControl]
private void gvSourceData_MouseDown(object sender, MouseEventArgs e) {
var gridView = sender as GridView;
GridHitInfo hi = hi = gridView.CalcHitInfo(gridControl.PointToClient(MousePosition));
if (!hi.InRowCell && !hi.InColumn) {
((DXMouseEventArgs)e).Handled = true;
return;
}
gridView.ClearSelection();
@csaba-farkas
csaba-farkas / nooooget.bat
Created September 19, 2018 14:02
[Reinstall all Nuget packages - version numbers unchanged]
Update-Package -Reinstall -Project YourProjectName
@csaba-farkas
csaba-farkas / app.component.html
Last active September 13, 2018 18:50
[Angular selector options] #Angular2Plus
<app-user></app-user>
<!-- <div app-user></div> -->
<!-- <div class="app-user"></div> -->
@csaba-farkas
csaba-farkas / import_from_csv.sql
Created September 13, 2018 08:58
[Import from CSV to SQL] #SQL
CREATE TABLE #users (
Name VARCHAR(500),
DOB DATETIME,
PPSNumber VARCHAR(30)
)
BULK INSERT #users
FROM 'D:\Users.csv'
WITH
(
@csaba-farkas
csaba-farkas / find_duplicates.sql
Created September 13, 2018 08:55
[Finding duplicate records in database] #SQL
SELECT
name, email, COUNT(*)
FROM
users
GROUP BY
name, email
HAVING
COUNT(*) > 1
@csaba-farkas
csaba-farkas / ListItemClickListener.java
Created September 7, 2018 14:10 — forked from csabafarkas/ListItemClickListener.java
RecyclerView with Adapter and OnClickListener implemented
public interface ListItemClickListener {
void onListItemClick(int clickedItemIndex);
}
@csaba-farkas
csaba-farkas / NetworkUtils.java
Created September 7, 2018 14:10 — forked from csabafarkas/NetworkUtils.java
Example NetworkUtils wit URL builder
public final class NetworUtils {
private static final String BASE_URL = "https://api.example.com";
private static final String FORMAT = "json";
private static final String QUERY_PARAM = "q";
private static final String SOME_OTHER_PARAM = "param";
public static URL buildUrl(String queryParam, String someOtherParam) {
Uri constructUri = Uri.parse(BASE_URL).buildUpon()
.appendQueryParameter(QUERY_PARAM, queryParam)
.appendQueryParameter(SOME_OTHER_PARAM, someOtherParam)
@csaba-farkas
csaba-farkas / ActivitySnippet.java
Created September 7, 2018 14:10 — forked from csabafarkas/ActivitySnippet.java
New implicit intent with Uri data
private void openAnAppThatCanHandleThisIntent(Uri mapUri) {
Intent intent = new Intent(Intent.ACTION_VIEW);
if (intent.resolveActivity(getPackageManager()) != null) {
startActivity(intent);
}
}
@csaba-farkas
csaba-farkas / CreateMapUri.java
Last active September 7, 2018 14:09 — forked from csabafarkas/CreateMapUri.java
Build Uri with maps data
public void onClickOpenAddressButton(View v) {
String address = "Cork Ireland";
Uri.Builder builder = new Uri.Builder();
builder.scheme("geo")
.path("0,0")
.appendQueryParameter("q", address);
Uri addressUri = builder.build();
showMap(addressUri);