Translate

Monday, 27 May 2024

TASK 1A 2B 3C 4D 5E

 using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;


namespace ConsoleApplication1

{

    class Program

    {

        static void Main(string[] args)

        {

            List<string> numbers = new List<string> { "1", "2", "3", "4", "5" };

            List<string> chars = new List<string> { "A", "B", "C", "D", "E" };   


            for (int indexNumber = 0; indexNumber < numbers.Count; indexNumber++)

            {

                for (int indexChar = 0; indexChar < chars.Count; indexChar++)

                {

                    if (indexNumber == indexChar)

                    {

                        Console.WriteLine(numbers[indexNumber] + chars[indexChar]);

                    }

                }

            }

            Console.ReadLine();// OutPut 1A 2B 3C 4D 5E

        }

    }

}

Saturday, 11 November 2023

SQL server Capitalize First Letter

 ---Input String 'PABITRA MICROSOFT PabiTra miCroSoft'

declare @SQLColumnName nvarchar(max)

set @SQLColumnName = 'PABITRA MICROSOFT PabiTra miCroSoft'

declare @SpaceInWord char(1) = ' '

-- Upper case first letter and all others in lower case letters

select @SQLColumnName = STUFF(LOWER(@SQLColumnName), 1, 1, UPPER(LEFT(@SQLColumnName,1)) )

-- search for space character

declare @i int = CHARINDEX(@SpaceInWord, @SQLColumnName, 1)

while @i > 0

begin

 select @i = @i + 1

 -- replace character after space with its upper case letter

 select @SQLColumnName = STUFF(@SQLColumnName, @i, 1, UPPER( SUBSTRING(@SQLColumnName, @i, 1)) )

 -- search for next space character

 select @i = CHARINDEX(@SpaceInWord, @SQLColumnName, @i)

end

select @SQLColumnName

---Out Put : 'Pabitra Microsoft Pabitra Microsoft'






using cursor

----------

 

 

 declare @PrinterId int,@SQLColumnName varchar(1000)

declare _cursor cursor read_only for

select PrinterId,PAddress from PrinterDetails

open _cursor

fetch next from _cursor into @PrinterId,@SQLColumnName

while @@FETCH_STATUS=0

begin

-----------------------------Body

declare @SpaceInWord char(1) = ' '


-- Upper case first letter and all others in lower case letters

select @SQLColumnName = STUFF(LOWER(@SQLColumnName), 1, 1, UPPER(LEFT(@SQLColumnName,1)) )


-- search for space character

declare @i int = CHARINDEX(@SpaceInWord, @SQLColumnName, 1)


while @i > 0

begin

 select @i = @i + 1

 -- replace character after space with its upper case letter

 select @SQLColumnName = STUFF(@SQLColumnName, @i, 1, UPPER( SUBSTRING(@SQLColumnName, @i, 1)) )

 -- search for next space character

 select @i = CHARINDEX(@SpaceInWord, @SQLColumnName, @i)

end


--select @SQLColumnName

update PrinterDetails set PAddress=@SQLColumnName where PrinterId=@PrinterId

 -----------------------------Body end 

fetch next from _cursor into  @PrinterId,@SQLColumnName

end

close _cursor

deallocate _cursor



SQL queries to change the column datatype type

 Column with data type : AadhaarNumner int 

SQL queries to change the column datatype type

Alter table dbo.OrderPaperBooks alter column AadhaarNumner varchar(20)

SQL query for alter column name

 table name: dbo.OrderPaperBooks

old column name : PPNoOfCopy

assign new column name :NoOfCopy 


SQL query for alter column name 


 EXEC sp_rename 'dbo.OrderPaperBooks.PPNoOfCopy', 'NoOfCopy', 'COLUMN';

Friday, 3 November 2023

drop and create SQL Server procedure simple way

 IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'USP_BookTypes')

DROP PROCEDURE USP_BookTypes

GO

CREATE  PROC USP_BookTypes

(

   @action varchar(20)

  ,@BookTypeId int=null

  ,@BookType varchar(100)=null

)

AS BEGIN

  IF(@action='SELECTALL')

   BEGIN

    SELECT B.BookTypeId,B.BookType FROM BookTypes B WITH(NOLOCK)  

WHERE B.IsActive='Y'  order by B.BookTypeId; 

   END

   ELSE IF(@action='SELECTBYID')

   BEGIN

    SELECT B.BookTypeId,B.BookType FROM BookTypes B WITH(NOLOCK)  

WHERE B.BookTypeId=@BookTypeId and B.IsActive='Y' order by B.BookTypeId; 

   END

 END 

Thursday, 26 October 2023

singleton design pattern c#

 


 Calling the Singleton Design Pattern c# Class



namespace OrderProcessing.BusinessLayer

{

    public class BLLClass

    {

        public BLLClass()

        {

            //

            // TODO: Add constructor logic here

            //

        }

        public string bllAddClass(ClassModelAddUpdateRequst Requst)

        {


            string response = "error";

            response = Helper.Instance.ExecuteScalar(

                                        commandText: "USP_CLASS"

                                       , commandType: CommandType.StoredProcedure

                                       , sqlParameters:

                                        new SqlParameter[]{

                                                          new SqlParameter("@action", SqlDbType.Char, 20) { Value =Requst.action }

                                                         ,new SqlParameter("@ClassNameNumber", SqlDbType.Int) { Value =Requst.ClassNameNumber }

                                                         ,new SqlParameter("@ClassNameText", SqlDbType.VarChar, 20) { Value = Requst.ClassNameText }

                                                         ,new SqlParameter("@ClassNameRoman", SqlDbType.NVarChar, 20) { Value = Requst.ClassNameRoman }

                                                         ,new SqlParameter("@ClassNameOdia", SqlDbType.NVarChar, 20) { Value = Requst.ClassNameOdia }

                                                         ,new SqlParameter("@EntryBy", SqlDbType.VarChar, 20) { Value = Requst.userId }

                                                          }

                                   );


            return response;


        }

}


Singleton Design Pattern c# Class



public sealed class Helper

    {


        private Helper() { }

        private static Helper instance = null;

        public static Helper Instance

        {

            get

            {

                if (instance == null)

                {

                    instance = new Helper();

                }

                return instance;

            }

        }

        private string objCon;

        private SqlConnection Conn;

        public SqlConnection Connect()

        {

            objCon = ConfigurationManager.ConnectionStrings["sqlServerConn"].ConnectionString;

            Conn = new SqlConnection(objCon);

            if (Conn.State == ConnectionState.Open)

                Conn.Close();

            Conn.Open();

            return Conn;

        }

        public int ExecuteNonQuery(string commandText, CommandType commandType, SqlParameter[] sqlParameters)

        {

            int x = 0;

            try

            {

                Conn = Connect();

                SqlCommand cmd = new SqlCommand(commandText, Conn);

                cmd.CommandType = commandType;

                cmd.CommandTimeout = 0;

                if (sqlParameters != null && sqlParameters.Length != 0)

                {

                    cmd.Parameters.AddRange(sqlParameters);

                }

                x = cmd.ExecuteNonQuery();

                Conn.Close();

                Conn.Dispose();

                cmd.Dispose();

            }

            catch (Exception ex)

            { throw ex; }

            return x;

        }

}

Monday, 24 July 2023

Contact Form

 <!DOCTYPE html>

<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <title>Contact Form</title>
  <link href="https://netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
</head>
<body class="well well-sm">
<div class="container">
  <div class="row">
      <div class="col-md-12 col-md-offset-0.5">
       
          <form class="form-horizontal">

            <div class="col-md-12">
              <div class="col-md-4"></div>
            <div class="col-md-4">
            <h1>Contact Us</h1>
           
            </div>
            <div class="col-md-4"></div>
          </div>
          <hr>
            <!-- Name input-->
            <div class="form-group">
              <label class="col-md-3 control-label" for="name">Name</label>
              <div class="col-md-9">
                <input id="txtName" name="name" tabindex="1" type="text" maxlength="100" title="Enter Your Name" placeholder="Your name" class="form-control">
              </div>
            </div>
            <!-- City input-->
            <div class="form-group">
              <label class="col-md-3 control-label" for="name">City</label>
              <div class="col-md-9">
                <input id="txtCity" name="city" tabindex="2"  type="text" maxlength="100"  title="Enter Your City"  placeholder="Your city" class="form-control">
              </div>
            </div>
            <!-- Email input-->
            <div class="form-group">
              <label class="col-md-3 control-label" for="email">Your E-mail</label>
              <div class="col-md-9">
                <input id="txtEmail" name="email"  tabindex="3"  type="text" maxlength="100"  title="Enter Your E-mail"  placeholder="Your email" class="form-control">
              </div>
            </div>
          <!-- DOB input-->
            <div class="form-group">
              <label class="col-md-3 control-label" for="email">Your Date Of Birth</label>
              <div class="col-md-9">
                <input id="txtDOB" name="dob"  tabindex="4"  type="date"  maxlength="10" title="Enter Your Date Of Birth" placeholder="Your Date Of Birth" class="form-control">
              </div>
            </div>
             <!-- Contact number input-->
            <div class="form-group">
              <label class="col-md-3 control-label" for="email">Your Contact number</label>
              <div class="col-md-9">
                <input id="txtContactNumber" name="contactnumber" title="Enter Your Contact number"  tabindex="5"  type="number"  maxlength="10"  placeholder="Your Contact number" class="form-control">
              </div>
            </div>
            <!-- Message body -->
            <div class="form-group">
              <label class="col-md-3 control-label" for="message">Your message</label>
              <div class="col-md-9">
                <textarea class="form-control" id="txtMessage" title="Enter Your message"  maxlength="150"   tabindex="6"  name="message" placeholder="Please enter your message here..." rows="5"></textarea>
              </div>
            </div>
   
            <!-- Form actions -->
            <div class="form-group">
              <div class="col-md-12 text-right">
                <button type="submit" class="btn btn-primary btn-lg"  title="Click here to submit the form "  tabindex="7" id="btnSubmit" >Submit</button>
              </div>
            </div>
          </form>
        </div>
      </div>
 
</div>
  <script src="https://netdna.bootstrapcdn.com/bootstrap/3.1.0/js/bootstrap.min.js"></script>
<script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>
  <script type="text/javascript">
  $(document).ready(function() {
   
      $('#btnSubmit').click(function () {
          if (validateForm()) {

              if (SubmitData()) {
                  alert('Data save succssfully !!!');
              }


          } else {
              return false;
          }
      });
     

  });



  function SubmitData() {
      alert('Server side code call ');
      var saveStatus = false;
      if (saveStatus)
          return true;
      else
      return false;
  }
  function validateForm()
  {
     
      var status =false;
      if ($('#txtName').val() == '')
      {
          $('#txtName').focus();
          alert('Name Field can not be blank');
      }else if($('#txtName').val().length>100)
      {
          $('#txtName').focus();
          alert('Name Field must not grater than 100');
      }
      else if ($('#txtCity').val() == '') {
          $('#txtCity').focus();
          alert('City Field can not be blank');
      } else if ($('#txtCity').val().length > 100) {
          $('#txtCity').focus();
          alert('City Field must not grater than 100');
      }
      else if ($('#txtEmail').val() == '') {
          $('#txtEmail').focus();
          alert('Email Field can not be blank');
      } else if ($('#txtEmail').val().length > 100) {
          $('#txtEmail').focus();
          alert('Email Field must not grater than 100');
      }
      else if ($('#txtDOB').val() == '') {
          $('#txtDOB').focus();
          alert('DOB Field can not be blank');
      } else if ($('#txtDOB').val().length > 10) {
          $('#txtDOB').focus();
          alert('DOB Field must not grater than 10');
      }
      else if ($('#txtContactNumber').val() == '') {
          $('#txtContactNumber').focus();
          alert('Contact number Field can not be blank');
      } else if ($('#txtContactNumber').val().length > 10) {
          $('#txtContactNumber').focus();
          alert('Enter 10 digit contact number ');
      } else if ($('#txtMessage').val() == '') {
          $('#txtMessage').focus();
          alert('message Field can not be blank');
      } else if ($('#txtMessage').val().length > 150) {
          $('#txtMessage').focus();
          alert('DOB Field must not grater than 150');
      }else {
          status = true;
      }
      return status;
  }

    </script>
 
 
</body>
</html>