Wednesday, July 17, 2013

Birth Certificate ( Baby Birth Certificate )

Dear,

How to get Birth Certificate Mandatory Certificate

After Birth of your babies….

Please go to your Municipality/Panchayath
Give your details

Under Name: You can mention just baby of and later you can add/update your name;

Mandatory Docs;
Your Ids, If you want to mention your current address.. Please take your Bank Statement. So update your Current address now only in your Banks.


Monday, July 8, 2013

WCF Endpoint and Binding by coding.


namespace ORS.SAMPLE.Base.Repository
{
    public class SAMPLEFactory : ISAMPLEServiceFactoryIDisposable
    {
        private bool _disposed;
        private ChannelFactory<ISAMPLESubject> factory;
        /// <summary>
        /// Constructor to initialize factory
        /// </summary>
        public SAMPLESubjectServiceFactory()
        {
          

Binding binding = null;
           
Uri address = null;
           

ProcessConfig.ResolveEndpoint("SAMPLESubjectServiceProxy.ISAMPLESubject"out address, out binding);
           

factory = new ChannelFactory<ISAMPLESubject>(binding, address.ToString());
        
   // Based on http://stackoverflow.com/questions/4812668/how-to-add-maxitemsinobjectgraph-programmatically-without-using-configuration-fi
 foreach (OperationDescription op in factory.Endpoint.Contract.Operations)
            {
                var dataContractBehavior = op.Behaviors.Find<DataContractSerializerOperationBehavior>();
                if (dataContractBehavior != null)
                {
                    dataContractBehavior.MaxItemsInObjectGraph = int.MaxValue;
                }
            }
        }
       


        /// <summary>
        /// Factory class
        /// </summary>
        /// <returns></returns>
        public ChannelFactory<IFuseSubject> Create()
        {
            return factory;
        }
       


        /// <summary>
        /// Close the factory
        /// </summary>
        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }
        

        protected virtual void Dispose(bool disposing)
        {
            if (!_disposed)
           {
                if (disposing)
                {
                    if (factory != null) factory.Close();
                }
                factory = null;
                _disposed = true;
            }
        }
    }
}

----------------------------------
----------------------------------

using System;
using System.ServiceModel;
using System.ServiceModel.Channels;
using System.ServiceModel.Description;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.ServiceModel.Configuration;

namespace ABIM.BusinessService.Home
{
    public static class ProcessConfig
    {
        private static System.ServiceModel.Configuration.BindingsSection GetBindingSection()
        {
            return ConfigurationManager.GetSection("system.serviceModel/bindings") as System.ServiceModel.Configuration.BindingsSection;
        }

        public static Binding ResolveBinding(string name)
        {
            System.ServiceModel.Configuration.BindingsSection section = GetBindingSection();

            foreach (var bindingCollection in section.BindingCollections)
            {
                for (int i = 0; i < bindingCollection.ConfiguredBindings.Count; i++)
                {
                    if (name.Equals(bindingCollection.ConfiguredBindings[i].Name, StringComparison.CurrentCultureIgnoreCase))
                    {
                        var bindingElement = bindingCollection.ConfiguredBindings[i];
                        var binding = (Binding)Activator.CreateInstance(bindingCollection.BindingType);
                        binding.Name = bindingElement.Name;
                        bindingElement.ApplyConfiguration(binding);
                        return binding;
                    }
                }
            }
            return null;
        }

        private static ClientSection GetClientSection()
        {
            return ConfigurationManager.GetSection("system.serviceModel/client") as ClientSection;
        }

        public static void ResolveEndpoint(string contract, out Uri host, out Binding binding)
        {
            host = null;
            binding = null;
            ClientSection clientSection = GetClientSection();
            ChannelEndpointElementCollection endpointCollection = clientSection.ElementInformation.Properties[string.Empty].Value as ChannelEndpointElementCollection;
            foreach (ChannelEndpointElement endpointElement in endpointCollection)
            {
                if (contract.Equals(endpointElement.Contract, StringComparison.CurrentCultureIgnoreCase))
                {
                    host = endpointElement.Address;
                    binding = ResolveBinding(endpointElement.BindingConfiguration);
                    return;
                }
            }
        }
    }

}









Tuesday, February 19, 2013

Concatenate fields in item template GRID

Grid


Concatenate  fields in item template

Text='<%# string.Concat(DataBinder.Eval(Container.DataItem, "ID"), " ", DataBinder.Eval(Container.DataItem, "InstanceID")," ", DataBinder.Eval(Container.DataItem,"TypeCode") %>'


Monday, February 11, 2013

Linq - Delegates , Anonymous functions




delegate in where condition


An anonymous function is an "inline" statement or expression that can be used wherever a delegate type is expected. You can use it to initialize a named delegate or pass it instead of a named delegate type as a method parameter.

var fu = productMemberResponse.ProductList.Where(delegate(ProductMemberDetails pmd)
                {
                    if (pmd.Type == "SEP")
                        return sepProduction;
                    else if (pmd.Type == "PIM")
                        return pimProduction;
                    else return true;
                }
                ) ;



A lambda expression is an anonymous function that you can use to create delegates or expression tree types. By using lambda expressions, you can write local functions that can be passed as arguments or returned as the value of function calls. Lambda expressions are particularly helpful for writing LINQ query expressions.


(input parameters) => expression

(input parameters) => {statement;}

Func<bool, int> del = x => x ? 10 : 5; 
    new ShoppingCart().Process(del);


Friday, February 1, 2013

Interview Questions On SQL

Update


1) How update works internally ?
----------------------------
--
-- Oops! SQL column swap or SQL column clobber?
--
create table #temp (PK int identity, c1 int, c2 int);

insert into #temp values (1,2);
insert into #temp values (3,2);
insert into #temp values (2,1);
insert into #temp values (5,2);
insert into #temp values (5,3);

select * from #temp order by PK;
--
-- Swap columns c1 and c2 on a
-- row-by-row basis if c1 > c2
--

update #temp
 set c1 = c2, c2 = c1
 where c1 > c2;

--
-- Will column c2 clobber column c1
-- BEFORE column c1 can replace column c2?
-- Do we need a temporary column
-- or variable to correct this?
--
select * from #temp order by PK;
--

drop table #temp;


2) 
-- #1 Table
CREATE TABLE GenderUpdate
(
ID SMALLINT IDENTITY,
Gender CHAR(1)
);

-- #2 Data
INSERT INTO GenderUpdate (Gender) 
VALUES ('M'), ('M'),('M'),('M'),('M'),('M'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F')

-- #3 To check the data count gender wise
SELECT Gender, COUNT(gender) [COUNT] FROM GenderUpdate GROUP BY gender

-- #4 Final update with case statement
UPDATE GenderUpdate
 SET Gender = CASE WHEN GENDER = 'M' then 'F' ELSE 'M' END

 SELECT Gender, COUNT(gender) [COUNT] FROM GenderUpdate GROUP BY gender