dev-sankhadip’s gists

dev-sankhadip / firebase-crud.component.ts

Created November 28, 2021 10:15

	import { Component, OnInit } from '@angular/core';
	import { DocumentData, QuerySnapshot } from '@firebase/firestore';
	import { FirebaseService } from '../firebase.service';

	@Component({
	selector: 'app-firebase-crud',
	templateUrl: './firebase-crud.component.html',
	styleUrls: ['./firebase-crud.component.css']
	})
	export class FirebaseCrudComponent implements OnInit {

dev-sankhadip / firebase.service.ts

Created November 28, 2021 10:03

	import { Injectable } from '@angular/core';
	import { initializeApp } from 'firebase/app';
	import { Firestore, getFirestore, collection, addDoc, getDocs, deleteDoc, doc, updateDoc, DocumentData, CollectionReference, onSnapshot, QuerySnapshot } from 'firebase/firestore'
	import { Subject } from 'rxjs';
	import { environment } from '../environments/environment';


	@Injectable({
	providedIn: 'root'
	})

dev-sankhadip / environment.ts

Created November 28, 2021 05:17

	export const environment = {
	production: false,
	firebaseConfig: {
	apiKey: "-----",
	authDomain: "-----",
	projectId: "----",
	storageBucket: "----",
	messagingSenderId: "-----",
	appId: "-----"
	}

dev-sankhadip / firebase-crud.component.ts

Created November 28, 2021 05:01

	import { Component, OnInit } from '@angular/core';

	@Component({
	selector: 'app-firebase-crud',
	templateUrl: './firebase-crud.component.html',
	styleUrls: ['./firebase-crud.component.css']
	})
	export class FirebaseCrudComponent implements OnInit {

	studentDetails = {

dev-sankhadip / firebase-crud.component.html

Created November 28, 2021 05:00

	<h1>Add Student</h1>
	<form class="add">
	<label for="name">Name</label>
	<input type="text" name="name" required [(ngModel)]="studentDetails.name" />

	<label for="age">Age</label>
	<input type="text" name="age" required [(ngModel)]="studentDetails.age" />

	<button type="button" (click)="add()">Add</button>
	</form>

dev-sankhadip / imageView.ejs

Created May 13, 2021 04:02

	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Document</title>
	</head>
	<body>
	<img src="<%= name %>" />
	</body>
	</html>

dev-sankhadip / index.ejs

Created May 13, 2021 03:06

	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Document</title>
	</head>
	<body>
	<input type="file" id="file-input" accept="image/*" />
	<script>
	const inputFile = document.getElementById("file-input");

dev-sankhadip / server.js

Created May 13, 2021 02:29

	const express = require("express");
	const sql = require('mysql');

	const app = express();

	app.use(express.json({ limit: "50mb" }));
	app.use(express.urlencoded({ extended: true }));
	app.set("view engine", "ejs");

	const config = {

dev-sankhadip / create_table.sql

Created May 13, 2021 02:26

Create Table file(id Int AUTO_INCREMENT Not Null Primary Key, file_name Varchar(30), file_data LONGBLOB Not Null, created_by Varchar(20) Not Null, created_on Datetime Not Null);

dev-sankhadip / AESEncryption.cs

Created December 7, 2020 06:28

	//AES Encryption
	public static string EncryptString(string plainText, string keyToUse) {
	byte[] iv = new byte[16];
	byte[] array;

	using(Aes aes = Aes.Create()) {
	aes.Key = Encoding.UTF8.GetBytes(Get128BitString(keyToUse));
	aes.IV = iv;

	ICryptoTransform encryptor = aes.CreateEncryptor(aes.Key, aes.IV);

Sankhadip Samanta dev-sankhadip