Date Format Based On Stored Procedure

Date

var newdate = DateTime.Now.AddDays(+16).ToString("dd/MM/yyyy hh:mm t\\M", new CultureInfo("en-US"));

var newdate = DateTime.Now.AddDays(+16).ToString("g", new CultureInfo("en-US"));

Based On Id paricular Record

context.Users.FirstOrDefault(x => x.Id == job.UserId);

select

context.users.take(10);

Date time format change

string input = "2012-06-28T08:26:57Z";

var dt = DateTime.Parse(input);

string output = dt.ToString(@"MM/dd/yyyy h:mm:ss tt", CultureInfo.InvariantCulture);=

create procedure JobAlertsBasedOnDateAfter5Days

as

begin

select * from dbo.[User] where CreatedDateTime=dateadd(day,datediff(day,5,CAST(CURRENT_TIMESTAMP AS DATE)),0) and (IsDeleted =0 or IsDeleted is null)

end

go

select * from dbo.[User] where id=3253

select dateadd(day,datediff(day,5,CAST(CURRENT_TIMESTAMP AS DATE)),0)

update dbo.[user] set CreatedDateTime='2014-10-25' where Id=3253

select * from Job where CreatedDateTime=dateadd(day,datediff(day,14,CAST(CURRENT_TIMESTAMP AS DATE)),0) and ((IsDeleted =0 or IsDeleted is null) and(IsRssJob=0 or IsRssJob is null))

create procedure JobAlertsBasedOnDateRememberEmail

as

begin

select * from dbo.[User] where (LastLoginTime=dateadd(day,datediff(day,29,CAST(CURRENT_TIMESTAMP AS DATE)),0) or LastLoginTime=dateadd(day,datediff(day,43,CAST(CURRENT_TIMESTAMP AS DATE)),0)) and IsCompany is null and IsAdmin is null

end

go

select dateadd(day,datediff(day,29,CAST(CURRENT_TIMESTAMP AS DATE)),0)

select * from dbo.[User] Where Id=3253

update dbo.[User] set LastLoginTime='2014-10-01' where Id=3253

difference between value type parameter and reference type parameter.

using System;

namespace Example1

{

    class Program

    {

        public static void value(int num)

        {

            num++;

        }

        public static void reference(ref int num)

        {

            num++;

        }

        static void Main(string[] args)

        {

            int num;

            Console.Write("Enter a number:\t");

            num = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("\n\n\tValue Type");

            Console.WriteLine("----------------");

            Console.Write("\nPrevious Value:\t{0}", num);

            Program.value(num);

            Console.Write("\nCurrent Value:\t{0}", num);

            Console.WriteLine("\n\n\n----------------");

            Console.WriteLine("\tReference Type");

            Console.WriteLine("--------------------");

            Console.Write("\nPrevious Value:\t{0}", num);

            Program.reference(ref num);

            Console.Write("\nCurrent Value:\t{0}", num);

            Console.ReadLine();

        }

    }

}

C# Function

using System;

namespace Example1

{

  class calculation

   {

     static int num1, num2, result;

     public static void add()

      {

        Console.Write("Enter number 1st.\t");

        num1 = Convert.ToInt32(Console.ReadLine());

        Console.Write("Enter number 2nd.\t");

        num2 = Convert.ToInt32(Console.ReadLine());

        result = num1 + num2;

        Console.Write("\nAdd = {0}", result);

        Console.ReadLine();

      }

   }

  class Program

   {

     static void Main(string[] args)

      {

        calculation.add();

      }

   }

}

Access Specifier and get set accessor.

using System;

namespace Example1

{

    class Program

    {

        private void add()

        {

            int num1, num2, result;

            Console.Write("Enter a number:\t");

            num1 = Convert.ToInt32(Console.ReadLine());

            Console.Write("\nEnter second number:\t");

            num2 = Convert.ToInt32(Console.ReadLine());

            result = num1 + num2;

            Console.WriteLine("{0} + {1} = {2}", num1, num2, result);

        }

        static void Main(string[] args)

        {

            Program p = new Program();

            p.add(); //It is valid, because private add() is           in same class

            Console.ReadLine();

        }

    }

}

using System;

namespace Example2

{

    class input

    {

        private static int num1, num2, result;

        public void add()

        {

            result = num1 + num2;

            Console.WriteLine("\n\nAdd = {0}", result);

            Console.ReadLine();

        }

        // Creating property for storing value in num1

        public int Number1

        {

            get

            {

                return num1;

            }

            set

            {

                num1 = value;

            }

        }

        // Creating property for storing value in num2

        public int Number2

        {

            get

            {

                return num2;

            }

            set

            {

                num2 = value;

            }

        }

    }

    class Program

    {

        static void Main(string[] args)

        {

            input inp = new input();

            Console.Write("Enter number 1st:\t");

            inp.Number1 = Convert.ToInt32(Console.ReadLine());

            Console.Write("Enter number 2nd:\t");

            inp.Number2 = Convert.ToInt32(Console.ReadLine());

            inp.add();

        }

    }

}

C# Programming Examples of Variables and Data types

using System;
 
namespace Examples
{
  class Program
   {
     static void Main(string[] args)
      {
        string name;
        string city;
        sbyte age;
        int pin;
 
        // \n is used for line-break
        Console.WriteLine("Enter your name\n");
        name = Console.ReadLine();
 
        Console.WriteLine("Enter Your City\n");
        city = Console.ReadLine();
 
        Console.WriteLine("Enter your age\n");
        age = sbyte.Parse(Console.ReadLine());
 
        Console.WriteLine("Enter your pin\n");
        pin = Int32.Parse(Console.ReadLine());
 
        // Printing message to console
        //formatting output
        Console.WriteLine("=============="); 
        Console.WriteLine("Your Complete Address:");
        Console.WriteLine("============\n");
 
        Console.WriteLine("Name = {0}", name);
        Console.WriteLine("City = {0}", city);
        Console.WriteLine("Age = {0}", age);
        Console.WriteLine("Pin = {0}", pin);
        Console.WriteLine("===============");
 
        Console.ReadLine();
      }
   }
}

O/P:

Enter your Name :Naresh

Enter Your City :Wgl

Enter Your age  :23

Enter Your Pin  :506164

=============================

Your Complete Address:

=============================

your Name :Naresh

Your City :Wgl

Your age  :23

Your Pin  :506164