Friday, 27 March 2020

Answer : NIELIT IT Tools and Business Systems (July 2018)

Solved :  NIELIT IT Tools and Business Systems (July 2018)

1 : Multiple Choice


1.1 :  D
1.2 : B
1.3 : D
1.4 : C
1.5 : B
1.6 : C

Thursday, 26 March 2020

Compare date in dd/mm/yyyy format C#



Some programmer needs to compare date in the format of dd/mm/yyyy. C# sharp has reach features of handling date but too complicated. So I made this post which helps you to compare date in dd/mm/yyyy format in simple way.

using System.Globalization;

string strFromDate =  "16/03/2020";
           
string strToDate = "20/03/2020";

Wednesday, 25 March 2020

NIELIT IT Tools and Business Systems (July 2018)

Solved NIELIT  IT Tools and Business Systems (July 2018)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein.

1.1 : statement for MS-Word?
A) It can be used to prepare annual report.
B) It can be used to generate same document to send multiple persons.
C) It has autocorrect facility and dictionary facility.
D) It can create a graph from given data.
Answer 

Thursday, 27 February 2020

Spilit comma seprated string using SQL Server 2012

Create a function that will separate the comma-separated string and extract each word in using SQL Server 2012.

declare @str varchar(50),@l int,@i int,@p int,@slen int
select @str='o,222,333,kl,4444,555,88pol'
select @l=LEN(@str)
set @i=1
set @p=0
set @slen=1

Saturday, 8 February 2020

Post data over with API using PHP

This post will help you to understand. How can you call an API created from ASP.NET MVC and calling from PHP?  API was created for the notification purpose for school.API Database is SQL server and server-side language is C#. You will see in this post how can you consume a post API created from other language and consume by PHP

Data Model

Field
Description
ID
Row ID (Auto Increment)
NotesText
Text of notification
NotesType
Attachment Type (Text,Link,File)
Path
Location of Attachemntq
ClassID
Class Name
NewGIF
Description: http://ankuram.probuzzmedia.com/Image/Page/new.gif
CreateDate
Created Date

API Code (C#)

Thursday, 6 February 2020

Horizontal Image Slider


Head Section

<link rel="stylesheet" href="lightslider.css" />

   
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
    <script src="lightslider.js"></script>


CSS

<style>

        ul {
            list-style: none outside none;
            padding-left: 0;
            margin: 0;
        }

        .demo .item {
            margin-bottom: 60px;
        }

Friday, 31 January 2020

ASP.NET MVC 3 and the @helper syntax within Razor

When you make a website then sometimes you need to make a reusable HTML component, for example, you want to show testimonial on the various page. For doing this you need to copy-paste testimonial HTML on pages where it is required. The problem arises when any modification is done on Testimonial, You will have to update testimonial manually on every page which is time taking and prone to error.

Consume Get API

Consume get API from ASP.Net using PHP


This post will help you to know how can you consume a get Api. Api in this post is made through ASP.Net C# which will be consumed by core PHP.

Data Model


Field
Description
ID
Row ID (Auto Increment)
NotesText
Text of notification
NotesType
Attachment Type (Text,Link,File)
Path
Location of Attachemntq
ClassID
Class Name
NewGIF
Description: http://ankuram.probuzzmedia.com/Image/Page/new.gif
CreateDate
Created Date


<table border="1" cellpadding="3" cellspacing="0">
                <tr>
                                <th>Sr No.</th>
                                <th>Notes Text</th>

Tuesday, 28 January 2020

News Ticker


Ticker using HTML and CSS



Latest News

Lorem
ipsum
datom


CSS


.g-news {
            border: solid 1px #ffb600;
            height: 300px;
            width:300px;
        }

Thursday, 23 January 2020

POST API ASP.Net

POST API ASP.Net C# (MVC)

API Controller


public class MyapiController : ApiController
    {
        // GET api/myapi
        public MyapiController() { }
     
        // POST api/myapi
      
        public IHttpActionResult Postdata([FromBody] NotificationModel data)
        {
            UserRepository obj = new UserRepository();
            string ErrMsg="";
            obj.AddNotesDB(data, ref ErrMsg);
            return Ok();
        }

    }

Monday, 20 January 2020

Return JSON Object from API Controller

Return JSON Object from API Controller ASP.Net C# (MVC)


public IHttpActionResult GetNotification()
        {
            UserRepository ob = new UserRepository();
            List<NotificationAPIModel> data = new List<NotificationAPIModel>();
            data = ob.GetNotificationAPI("0", "2");

Sunday, 19 January 2020

Answer : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018

Answer  : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018

1. Multiple Choice


1.1 : A
1.2 : A
1.3 : C
1.4 : A

Saturday, 18 January 2020

Solved : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018

Solved : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018


1. Each question below gives a multiple choice of answers. Choose the most appropriate  one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 : Binary equivalent of (53.625)10 is .
A)  (110101.101)2 B)  (111101.001)2
C)  (110111.100)2 D)  (100101.101)2
1.2 : FAT stands for________
A) File Allocation Table
B) Folder Allocation Table
C) Folder Allocation Transition
D) File Allocation Transition
1.3 : ____ operation of file or folder is required to move location of file or folder.
A) Copy followed by Paste
B) Cut followed by Paste
C) Move followed by Paste
D) Change location

Thursday, 9 January 2020

Delete File C# ASP.Net

JS



function DeleteImage(path)
{
    if (confirm('Are you sure to delete this Image')) {

        var Userobj =
           {

           }

        $.ajax({

            url: '/WebsiteAdmin/DeleteAssociateImage?path=' + path,
            type: "POST",
            contentType: false, // Not to set any content header 
            processData: false, // Not to process data 
            data: JSON.stringify(Userobj),

            success: function (result) {
                //Update Extension
                if (result.sMessage == "1") {
                    alert("Image deleted Successfully");
                    location.reload();

Monday, 6 January 2020

Select specified file from input type file using HTML

Select specified file from input type file using HTML


Input type file enables you to select any type of file by default but you can specify which file type will be selected. Following HTML input type file enable you to select image (JPG,PNG),Word and PDF file. 

Saturday, 4 January 2020

Image file preview before upload using css

Image file preview before upload using css


Uploading Image file to the webserver is very common. We use HTML file type input for file upload, by default HTML file upload control doesn’t preview file. But if you want to show selected image file preview before upload and select only image file. Then this post is a complete solution for this. So enjoy coding with Girfa Student Help blog.


<html>
<head>
    <title>Preview file before upload</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
    <style>
        .fileUpload {
            position: relative;
            overflow: hidden;
            margin: 10px;
            margin-top: 0px;
        }

            .fileUpload input.upload {
                position: absolute;
                top: 0;
                right: 0;
                margin: 0;
                padding: 0;
                font-size: 20px;
                cursor: pointer;
                opacity: 0;
                filter: alpha(opacity=0);
            }
    </style>
    <script>