Thursday, August 29, 2019

Google Apps Script For Developers

Google Apps Script Developers


Google Apps Script is nothing but Javascript. before start this article you should know the Javascript then you can easily understand the Google app script. The main moto of this article is to avoid the server side programming language to run the google product functionalities. for example if you want Google map, Youtube, API's, Drive and Gmail functionalities etc.

Once you creates the Javascript then you can run in google cloud without your own servers. so the maintenance burden reduces. you can develop your own code in local system. here i preferred the Visual Studio Code 2017 Editor. and i will write the code in ES6. i already developed some CRUD operation in Google App Script please check it. coming days. we will update the tutorials.

Please check Below App Script Projects
  1. Using Google spreadsheets as Database For Blog
  2. Sending Emails from Google Spreadsheet
Read More »

Monday, April 1, 2019

asp net mvc tutorial step by step for beginners with examples


asp.net mvc tutorials

Asp.net MVC tutorials sponsored by all tech geeks. this tutorial provides all articles in one container. it helps you like the index of the book. what is MVC ?. it is an architectural design pattern and stands for Model View and Controller. this container covers all topics of the asp.net MVC. it helps from freshers level to professional level. if you are starting level then you need basic knowledge of C#, Advanced OOPs, Visual Studio, and HTML.
it is an open source web development framework by Microsoft. it is alternate to asp.net and not the replacement of asp.net.

                                               Asp.Net MVC  - Get Started

  1. Asp.net MVC Tutorials- Get Started 
  2. Architecture
  3. First Application
  4. Folder Structure
  5. Controller
  6. Views
  7. Model
  8. Bundling
  9. View Bag
  10. Temp Data
  11. View Data
  12. Action Methods
  13. Action Selectors
  14. HTML Helpers
  15. Partial Views
  16. Layout View
  17. Filters
  18. Action Filters
  19. Validations
  20. Area
  21. What is Entity Framework and types  
  22. Creating Project in Database First Approach
  23. Creating Project in Code first approach
  24. Creating Project in Model Base First approach

Read More »

Tuesday, March 26, 2019

Sending Emails from Google Spreadsheet

google sheets are more popular nowadays. day by day the use of Apps script is increasing.
we can write the javascript to do anything like a NetSuite.Netsuite is a cloud ERP. it has only javascript development. same as google apps script also will use for all Google products (Apps) in the cloud.
google compute is the best IAAS cloud in the IT industry.

The main points in this article are to "send emails from google sheet". its very simple. and single step to do the above task.
Step 1: Login into Gmail.
Step 2: Go to google drive
Step 3: select the new button and select the spreadsheet
Step 4: type Email and name columns in the spreadsheet.
Step 5: go to tools and select the Script editor
Step 6: write the below script use where ever you want it

                                 MailApp.sendMail(to, subject, body) ;

Sending Emails from Google Spreadsheet

in the above image, you can find the function. the function name is myFunction(){}.

       myFunction()  
                   {
         MailApp.sendMail("alltechgeekz@gmail.com","Hello test mail","Hello from All Tech Geeks");
       
            }

But we need to pick email from the spreadsheet and send the mail from the sheet.

function Send Email() {

                  var sheet =SpreadsheetApp.getActiveSheet();
                  var r   = sheet.getRange("A1:B2");
                   var  customerdata=range.getValues();
for(j in customerdata)
      {
           var row=customerdata[i];
           var Email =row[0];
           MailApp.sendMail(row[1],"Email id is"+Email+,"this is test email");
      }
}

how to get data from the browser to the spreadsheet or how to use the google sheet as a database.
if we get the data from the website or anywhere. then we can do anything with that data.


Read More »

Wednesday, March 20, 2019

bind Dropdown list in asp.net

 public void bindcus()
    {
        ddlcustomer.Items.Clear();
        ddlcustomer.Items.Add(new ListItem("--SELECT--","0"));
        ddlcustomer.AppendDataBoundItems = true;
        dao.type = "CUSTOMER";
        DataTable dt= new DataTable();
        dt = bl.report(dao);
        if (dt.Rows.Count > 0)
        {
            ddlcustomer.DataSource = dt;
            ddlcustomer.DataTextField = "name";
            ddlcustomer.DataValueField = "code";
            ddlcustomer.DataBind();
        }

 
    }
Read More »

Using Google spreadsheets as Database For Blog


What is “Google spreadsheets as database”. nowadays every one using the website if they want a website then needs to buy the space for the website and for storing purpose need to buy the space so in both cases we need to buy the spaces from third parties like GoDaddy, Bluehost etc. So to avoid these type of problems you need to know some knowledge in “google apps script”.


Everyone has a Gmail account. Drive also free. Google drive has so many free applications like Docs, sheet, slides, forms, apps script, Jamboards, blog etc. By using these applications we can do amazing things without a database like My SQL, SQL Server, DB2 etc.

Here I will teach you how to use Google spreadsheets as a database for your web application. But I am not using web application. Instead of that, I am going to use google blog.
Pre-requirements

Step 1: Open Gmail account
Step 2: create a blog after login into your Gmail account and name it.
Step 3: go to google drive click on the new button and create a new google spreadsheet.
Step 4: Give the name for google spreadsheets
Step 5: Go to blog create a new blog account
Step 6: create a page insert_values.
Step 7: publish the blog test it you will surprise.


google spreadsheets as database for your blog


Now open Google spreadsheets and name it as "insert values"  and given 5 column names as shown below image
 Time_stamp, Id, Name, State, City, Country.

google spreadsheet as database 
Now click on tools click on script editor. In script editor you can write the code in javascript

google spreadsheet as database

The name is as insert values  and the extension is “.gs” means google script it is nothing but javascript.
In the editor, you can write the script.

google spreadsheet as database


Next, go to google spreadsheets and copy the link and paste in as shown below image.
It is a “SpreadsheetApp.openByUrl”. it means while running the program it opens the URL works as per requirement.

google sheet as database for blog


Finally, publish the script for anyone and save the script_url. It will consume it anywhere.
Click Deploy à deploy as Web app à select “who has access to the app as anyone”.
Save the script URL.
google sheet as database for your website

Select the Anyone as shown above image and Click on deploy button.
After the click, it asks to need permission to click on it. Select your Gmail account and go to advance click on insert value(unsafe).  Finally, click on allow button copy the URL.
below is the script.
Now goto blog. Create a new blog  and create a new page in the blog
google sheets api


Now go to notepad++ write javascript and paste the URL as shown below.
And create the required fields in the body tag
google sheets api

 Finally, copy all the above script  and paste in blogger page publish it
Open in the browser then it looks like below image. these all values will insert into google spreadsheets after the button click
google sheets api for your website

Click on insert button then the data goes and sits in insert_values google spreadsheets as shown below image. After insert button, it shows as successfully inserted.
google sheets api for your website

Now go and check the google spreadsheets. All value you can find in google spreadsheets.
google sheets api for your website


the above article only for insert values into google spreadsheets. in next article, you can find the Update, delete and view the values from "google spreadsheets as database"




Read More »

Sunday, December 30, 2018

Samsung Galaxy j7 (2018)


samsung galaxy j7 (2018)

  1. Samsung Galaxy j7 was launched in June 2018.
  2. The size of the phone is 5.5 inches touchscreen
  3.  resolution of the Samsung j7 (2018) phone is 720 X 1080 pixels
  4.  OS operating system is Android
  5. Front Cames is 13 MP megapixels
  6. The rare camera is 13 MP megapixels
  7. it released in black color
  8. the aspect ratio is 16:9
  9. the processor is Dual Core
  10. it supports the 3G / 4G / LTE
  11. The accelerometer is enabled: yes
  12. Sim type is Nano Sim
  13. number of sims are 2
  14. Headphones are 3.5 mm
  15. expandable storage is up to 256 GB
Read More »

Bundling in Asp.net MVC Tutorials

Asp.net MVC Tutorials explains the Bundling and minification is a technique to improve the request load time and introduced in asp.net MVC 4. bundlings has some following bundle classes in System.Web.Optimization namespace.

  1. ScriptBundle
  2. StyleBundle
  3. DynamicFolderBundle

the above bundles are included in MVC 5 and the namespace is System.Web.Optimization.Bundle.
it is a process of grouping the CSS/javascript files.
the most important of bundling is to reduce the number of request from the browsers to the server, while minification reduces the size of requested assets.
Minification reduces the unnecessary white spaces and comments

Without Minification :

 allTechGeeks =function(city){
                                                   //this is comment
                                                   var test = "Hello World" + city ;
                                                   alert(test) ;
                                                }
After Minification :
  allTechGeeks =function(city){var test = "Hello World" + city ;alert(test) ;}

in without minification, the javascript file has spaces and comments but after minification, we can't find the spaces and comments. So automatically the size of the file reduces but for development needs the without minification. in production minification file is good.



                                               Asp.Net MVC  - Get Started

  1. Asp.net MVC Tutorials- Get Started 
  2. Architecture
  3. First Application
  4. Folder Structure
  5. Controller
  6. Views
  7. Model
  8. Bundling
  9. View Bag
  10. Temp Data
  11. View Data
  12. Action Methods
  13. Action Selectors
  14. HTML Helpers
  15. Partial Views
  16. Layout View
  17. Filters
  18. Action Filters
  19. Validations
  20. Area
  21. What is Entity Framework and types  
  22. Creating Project in Database First Approach
  23. Creating Project in Code first approach
  24. Creating Project in Model Base First approach


Read More »

Wednesday, December 26, 2018

State Management Techniques in asp.net mvc

we can find the 5 types of state management techniques in asp.net mvc.
1) View bag
2) View data
3) Temp data
4) Cookies
5) query string
Read More »

Monday, November 12, 2018

C programming Tutorials for beginners

C programming Tutorials for beginners. below are the 10 programs for practice. 

1. Program to convert from Fahrenheit to Celcius

#include<stdio.h>

void main()
{

float f,c;
clrscr();

printf("\nEnter  a value for Farenheit:\t");
scanf("%f",&f);

c=(f-32)/1.8;

printf("\nThe Converted Celcius Value is:\t%f",c); getch();

}

2. Find the area of the circle using symbolic constants

#include<stdio.h>
#define PI 3.14

void main()
{

float r,area;
clrscr();

printf("\nEnter the radius:\t");
scanf("%f",&r);

area=PI*r*r;
printf("\nThe area is:\t%f",area);

getch();
}

3. To calculate the average of three numbers

#include<stdio.h>

void main()
{

float x1,x2;
clrscr();

printf("Enter the two numbers:\t");
scanf("%f%f",&x1,&x2);

if(x1>x2)
printf("\nFirst number is greater\n");

else
printf("\nSecond number is greater");

getch();
}




4. find greatest of two numbers using If-Else

#include<stdio.h>
void main()

{
float x1,x2,x3;

float avg;
clrscr();

printf("Enter the three numbers:\t");
scanf("%f%f%f",&x1,&x2,&x3);

avg=(x1+x2+x3)/3;
printf("The average is:\t%f",avg);

getch();
}


5. program to find whether the points lie in /on /outside the circle

#include<stdio.h>

#include<conio.h>
#include<math.h>

void main()
{

int x,x1,y,y1,r,d;
clrscr();

printf("Enter the Circle Coordinates : ");
scanf("%d%d",&x,&y);

printf("Enter the Radius : ");
scanf("%d",&r);

printf("Enter The Coefficients : ");
scanf("%d%d",&x1,&y1);

d=sqrt(((x-x1)*(x-x1))+((y-y1)*(y-y1)));
if(d<r)

printf("Points Lies Inside the Circle");
if(d>r)

printf("Points Lies Outside the Circle");
if(d==r)

printf("Ponit Lies On The Circle");
getch();

}



 6. The rectangle is greater than the perimeter


#include<stdio.h>
void main()

{
float l,b,area,per;

clrscr();
printf("\nEnter the length of the rectangle:\t");

scanf("%f",&l);
printf("\nEnter the breadth of the rectangle:\t");

scanf("%f",&b);
area=l*b;

per=2*(l+b);
if(area>per)

printf("\nArea is greater than the perimeter");
else

printf("\nPerimeter is greater than the area");
getch();

}



7. Calculation

#include<stdio.h>

void main()
{

float amt,b;
char g;

clrscr();
printf("\nEnter the amount: ");

scanf("%f",&amt);
fflush(stdin);

printf("\nEnter hte gender: ");
scanf("%c",&g);

if(g=='f')
{

if(amt>=5000)
b=amt*0.05;

else
b=amt*0.02;

}
else

b=amt*0.02;
amt+=b;

printf("\nThe amount is %f",amt);
getch();

}

8. Roots of the quadratic equation

#include<stdio.h>
#include<math.h>

void main()
{

float a,b,c,r1,r2,d,d1,real,img;
clrscr();

printf("Enter the coefficients a,b,c:\n");
scanf("%f%f%f",&a,&b,&c);

d=b*b-4*a*c;
if(d== 0)

{
printf("\nThe roots are real and equal");

r1=(-b)/(2*a);
printf("\nRoots are %f,%f",r1,r1);

}
else

if(d>0)
{

printf("Roots are real and distinct");
d1=sqrt(d);

r1=(-b+d1)/(2*a);
r2=(-b-d1)/(2*a);

printf("\nRoots are %f,%f",r1,r2);
}

else
{

printf("\nThe Roots are imaginary");
d=-d;

d1=sqrt(d);
real=-b/(2*a);

img=d1/(2*a);
printf("\nThe roots are %f+i%f,%f-i%f",real,img);

}
getch();

}



9.Greatest amount 4 numbers using simple if

#include<stdio.h>
void main()

{
int a,b,c,d,max;

clrscr();
printf("\nEnter 4 numbers:\n");

scanf("%d%d%d%d",&a,&b,&c,&d);
max=a;

if(b>max)
max=b;

if(c>max)
max=c;

if(d>max)
max=d;

printf("\nThe Maximum number is:\t%d",max);
getch();

}


10 Program to find the point lies in 1/2/3/4 Quadrant

#include<stdio.h>
void main()

{
int x,y;

clrscr();
printf("\nEnter the coordinate point\n");

scanf("%d%d",&x,&y);
if(x>0)

if(y>0)
printf("\nPoint in the I Quadrant");

else
printf("\nPoint lies in IV Quadrant");

else
if(y>0)

printf("\nPoint lies in II Quadrant");
else

printf("\nPoint lies in III Quadrant");
getch();

}

Read More »

Saturday, October 13, 2018

WebRTC Uses and Benefits

WebRTC is a free open source project for real time communication API's. the main moto of this project is to enable the rich and RTC application to be developed for browser, IOT and mobile platform. it allows them all via CSP protocol (Common Set Protocol). initially released in 2011 and written in c++ , javascript under BSD licence.
Read More »