Asp.Net Designer Developer Architect in Mumbai - Arindam Chakraborty

How to use CustomValidator with dropdown list

2011-11-29T23:06:00.000-08:00

Here is an example of using CustomValidator with dropdown list in asp.net application

Step 1 : Write java script function
< script type="text/javascript" language="javascript" >

function CheckWorker(sender, args) {
var worker = $get('<%=ddlstWorkers.ClientID %>');
if (worker.selectedIndex == 0) {
args.IsValid = false;
return;
}
args.IsValid = true;
}

< / script>

Step 2: Define the asp:DropDownList and CustomValidator

< asp:DropDownList ID="ddlstWorkers" runat="server" CssClass="ddl" Style="width: 220px;">

< /asp:DropDownList >

< asp:CustomValidator ID="cvWorker" runat="server" ControlToValidate="ddlstWorkers" Display="None" ErrorMessage="Select a worker." ClientValidationFunction="CheckWorker" >< /asp:CustomValidator >

DateTime format problem in Csharp

2011-09-05T05:48:00.000-07:00

Often we face this problem, there are may example on google, but still i feel like sharing this with you, this is how you can play with any date format in any culture.

DateTime dob = DateTime.Now.AddYears(-18);

if (!string.IsNullOrEmpty(txtDOB.Text))
{
IFormatProvider culture = new CultureInfo("en-US", true); // this is how you can set any culture you want !
dob = DateTime.ParseExact(txtDOB.Text, "dd/MM/yyyy", culture);
}

profile.DOB = dob;

convert enum to list in csharp

2011-08-09T14:39:00.000-07:00

This function will convert any enum to a List object

public class EnumHelper

{

/// < summary >

/// Convert enum to a list object.

/// < /summary >

/// < typeparam name="T" >< /typeparam >

/// < returns >< /returns >

public static List< T > EnumToList< T >()

{

Type enumType = typeof(T);

// You can't use type constraints on value types, so have to check & throw error.

if (enumType.BaseType != typeof(Enum))

throw new ArgumentException("T must be of type System.Enum type");

Array enumValArray = Enum.GetValues(enumType);

List< T > enumValList = new List< T >(enumValArray.Length);

foreach (int val in enumValArray)

{

enumValList.Add((T)Enum.Parse(enumType, val.ToString()));

}

return enumValList;

}

// Now call the function with enum you want to conver into a list EnumHelper.EnumToList< EventState >()

public static List < EventState > GetEventStates()

{

List< EventState > eventStates = EnumHelper.EnumToList< EventState >();

//.FindAll(

//delegate(EventState x)

//{

// return x != EventState.Cancelled ;

//});

return eventStates;

}

WCF Service debuging technique from client

2011-04-26T13:59:00.000-07:00

While implementing any WCF service in any client application, you may find lots of issue, here i share some experience how you can get to know whats going wrong at service end!

You just need to turn on Tracing and Messging on WCF server

As a result you see the following set of tags has been added in your web config file.

< system.diagnostics >
< sources >
< source name="System.ServiceModel" switchValue="Warning, ActivityTracing"
propagateActivity="true" >
< listeners >
< add type="System.Diagnostics.DefaultTraceListener" name="Default" >
< filter type="" / >
< /add >
< add name="ServiceModelTraceListener" >
< filter type="" / >
< /add >
< /listeners >
< /source >
< source name="System.ServiceModel.MessageLogging" switchValue="Warning, ActivityTracing" >
< listeners >
< add type="System.Diagnostics.DefaultTraceListener" name="Default" >
< filter type="" / >
< /add >
< add name="ServiceModelMessageLoggingListener" >
< filter type="" / >
< /add >
< /listeners >
< /source >
< /sources >
< sharedListeners >
< add initializeData="F:\MyWCFFolder\Web_tracelog.svclog"
type="System.Diagnostics.XmlWriterTraceListener, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
name="ServiceModelTraceListener" traceOutputOptions="Timestamp" >
< filter type="" / >
< /add >
< add initializeData="F:\MyWCFFolder\Web_messages.svclog"
type="System.Diagnostics.XmlWriterTraceListener, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
name="ServiceModelMessageLoggingListener" traceOutputOptions="Timestamp" >
< filter type="" / >
< /add >
< /sharedListeners >
< /system.diagnostics >

Stop subsequent submit button clicks when a earlier request is being processed in ASP.NET

2011-04-26T06:40:00.000-07:00

How we can stop the subsequent click when a earlier request is still been processed.

here is the javascript code you need to place above your update panel.
< script type="text/javascript" language="javascript" >
var requestManager = Sys.WebForms.PageRequestManager.getInstance();
requestManager.add_initializeRequest(StopPostbackOnSubsequentSubmitClicks);

function StopPostbackOnSubsequentSubmitClicks(sender, args) {
if (requestManager.get_isInAsyncPostBack() &
args.get_postBackElement().id == '<%=btnSubmit.ClientID %>')
{
args.set_cancel(true);
alert('Please wait, earlier request is still being processed');
}
}
< /script >

Now write your update panel code
< asp:UpdatePanel runat="server" ID="upnlLogin" UpdateMode="Conditional" >
< ContentTemplate >

// do whatever you need

< asp:Button ID="btnSubmit" runat="server" Text="Sign in" CssClass="button" OnClick="btnSubmit_Click" />

< /ContentTemplate>

< /asp:UpdatePanel>
< asp:UpdateProgress AssociatedUpdatePanelID="upnlLogin" runat="server" >
< ProgressTemplate>
< img src="../Images/spinner.gif" / >
< /ProgressTemplate >
< /asp:UpdateProgress >

// Now see the code behind implementation

protected void btnSubmit_Click(object sender, EventArgs e)
{

Thread.Sleep(1000);
}

Sql paging example, paging in sql 2000

2011-04-25T17:25:00.000-07:00

Create PROCEDURE spPaggingExample
(
@ProductInfo varchar(100)=null,
@SearchBy varchar(50)=null,
@startRowIndex int,
@maximumRows int,
@totalRows int OUTPUT
)
AS

-- sample spPaggingExample '',null,1,10,0

DECLARE @first_id int, @startRow int

SET @startRowIndex = @startRowIndex * @maximumRows

IF @startRowIndex = 0 SET @startRowIndex = 1

SET ROWCOUNT @startRowIndex

SELECT @first_id = UniqueTableId FROM myProductTable where (Isnull(IsApproved,0)=1 and ProductName like '%'+@ProductInfo+'%' or ProductDescription like '%'+@ProductInfo+'%' ) ORDER BY UniqueTableId

--PRINT @first_id
SET ROWCOUNT @maximumRows
SELECT * FROM myProductTable WHERE Isnull(IsApproved,0)=1 and UniqueTableId >= @first_id and (ProductName like '%'+@ProductInfo+'%' or ProductDescription like '%'+@ProductInfo+'%' ) ORDER BY UniqueTableId

SET ROWCOUNT 0
-- GEt the total rows
SELECT @totalRows = COUNT(UniqueTableId) FROM myProductTable where (Isnull(IsApproved,0)=1 and ltrim(rtrim(ProductName)) like '%'+@ProductInfo+'%' or ProductDescription like '%'+@ProductInfo+'%' )

RETURN @totalRows

NHibernate configuration ProxyFactoryFactory exception

2011-04-03T13:13:00.000-07:00

This is how my configuration file look like.

< configSections >
< section name="hibernate-configuration"
type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" / >
< /configSections >

< hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
< session-factory name="EClinic" >
< property name="connection.provider" >NHibernate.Connection.DriverConnectionProvider< /property >
< property name="connection.driver_class" >NHibernate.Driver.SqlClientDriver< /property >
< property name="connection.connection_string" >Server=(arindam123);initial catalog=mydatabasename;userid=username;password=mypass;Integrated Security=SSPI; < /property >
< property name="dialect" >NHibernate.Dialect.MsSql2005Dialect< /property >
< property name="proxyfactory.factory_class" >NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle< /property >
< property name="show_sql" >true< /property >
< /session-factory >
< /hibernate-configuration >
< /configSections >

I am getting following error
The ProxyFactoryFactory was not configured.
Initialize 'proxyfactory.factory_class' property of the session-factory configuration section with one of the available NHibernate.ByteCode providers.
Example:
NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu
Example:
NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: NHibernate.Bytecode.ProxyFactoryFactoryNotConfiguredException: The ProxyFactoryFactory was not configured.
Initialize 'proxyfactory.factory_class' property of the session-factory configuration section with one of the available NHibernate.ByteCode providers.
Example:
NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu
Example:
NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle

Source Error:

Line 20: log4net.Config.XmlConfigurator.Configure();
Line 21: Configuration cfg = new Configuration();
Line 22: m_sessionFactory = cfg.BuildSessionFactory();
Line 23:
Line 24: }

how to find application root dynamically

2011-03-26T00:23:00.000-07:00

sometimes you might have experienced some of the images are not appearing on your web page because of inappropriate path. so you need to know the root of the application dynically, because that keep chaning from development server to testing server, testing server to production server.

so you just need to do the following.

public static string ApplicationRoot
{
get
{
string root = null;
if (HttpContext.Current.Request.ApplicationPath != "/")
root = HttpContext.Current.Request.Url.GetLeftPart(System.UriPartial.Authority) + "/" + HttpContext.Current.Request.ApplicationPath;
else
root = HttpContext.Current.Request.Url.GetLeftPart(System.UriPartial.Authority) + "/";

if (!root.EndsWith("/"))
root += "/";

return root;
}
}

now whenever you are adding some image in any usercontrol, and you want to make sure the image is appearing allover the places then just use the following code

< img src='< %=ApplicationRoot +"Images/myImage.jpg"% >' >

JSON with extention method, Json Serialization

2011-03-25T23:47:00.000-07:00

Extension method allows you to add new method to the existing class without modifying the code, recompiling or modifying the original code.

public static class ExtensionsMethods
{

public static string Reverse(this string content)
{
char[] charArray = new char[content.Length];
int len = content.Length - 1;
for (int i = 0; i <= len; i++)
{
charArray[i] = content[len - i];
}
return new string(charArray);
}

/*Now suppose you want to have some functionality ToJason from all your custom object, you dont have to modify the source code, in the extention method class you just need to add the following line.*/

public static string ToJASON(this object myObject)
{

// you need reference of System.Web.Script.Serialization;
JavaScriptSerializer js = new JavaScriptSerializer();

return js.Serialize(myObject);
}
}

Now lets look at how to use the method

Suppose you have a object called Client

Client client = new Client();
client.Address = "Client's House";
client.ClientCode = "000C123";
client.ClientId = 98;
client.ClientName = "Client the God";
client.Email = "ac@gmail.com";

string jsonClient = client.ToJASON();
Response.Write(jsonClient);

the json out put will be :

{"ClientId":98,"ClientName":"Client the God","ClientCode":"000C123","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":null,"Email":"ac@gmail.com","Address":"Client\u0027s House"}

// now get a list of client. and make a jasonstring.
string jsonClients = MasterDTO.GetClients().ToJASON() ;
Response.Write(jsonClients);

the output will be
"}[{"ClientId":0,"ClientName":" Client - 0","ClientCode":"0010","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 0Client - 0","Email":" 0Client0@gmail.com","Address":null},{"ClientId":1,"ClientName":" Client - 1","ClientCode":"0011","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 1Client - 1","Email":" 1Client1@gmail.com","Address":null},{"ClientId":2,"ClientName":" Client - 2","ClientCode":"0012","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 2Client - 2","Email":" 2Client2@gmail.com","Address":null},{"ClientId":3,"ClientName":" Client - 3","ClientCode":"0013","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 3Client - 3","Email":" 3Client3@gmail.com","Address":null},{"ClientId":4,"ClientName":" Client - 4","ClientCode":"0014","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 4Client - 4","Email":" 4Client4@gmail.com","Address":null},{"ClientId":5,"ClientName":" Client - 5","ClientCode":"0015","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 5Client - 5","Email":" 5Client5@gmail.com","Address":null},{"ClientId":6,"ClientName":" Client - 6","ClientCode":"0016","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 6Client - 6","Email":" 6Client6@gmail.com","Address":null},{"ClientId":7,"ClientName":" Client - 7","ClientCode":"0017","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 7Client - 7","Email":" 7Client7@gmail.com","Address":null},{"ClientId":8,"ClientName":" Client - 8","ClientCode":"0018","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 8Client - 8","Email":" 8Client8@gmail.com","Address":null},{"ClientId":9,"ClientName":" Client - 9","ClientCode":"0019","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 9Client - 9","Email":" 9Client9@gmail.com","Address":null},{"ClientId":10,"ClientName":" Client - 10","ClientCode":"00110","ClientType":null,"Organization":null,"ContactPerson":null,"Phone":" 10Client - 10","Email":" 10Client10@gmail.com","Address":null}]

Similarly you also can convert the JSON string back to an object form by using the following extention method.

public static object JASONToObject(this string myObjectString)
{
JavaScriptSerializer js = new JavaScriptSerializer();

return js.DeserializeObject(myObjectString);
}

Server 2008 R2 Installation problem

2011-03-11T01:41:00.000-08:00

Installing Microsoft SQL Server 2008 R2 Management Studio Express is become really pain. while installing getting the following error.

Rule "Previous releases of Microsoft Visual Studio 2008" failed.

A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008. Visual Studio SP1 can be found at http://go.microsoft.com/fwlink/?LinkId=159627.

As many suggestion found on google , ihave installed sp1, and also changed the following key value in registry, then also it does not work.

Even if i change
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VNS\Servicing\9.0\EXP\1033]
"Install"=dword:00000001
"InstallerType"="MSI"
"SP"=dword:00000001
"SPIndex"=dword:00000001
"SPName"="SP1"

What would be the solution.?

Reduce image size in Asp.net

2011-02-07T16:08:00.000-08:00

You can reduce the image size while uploading, this would be helpul when we have some open interfece for end user, but you want to reducde the size of image uploaded by user.

//this path will be saved in database
string PathToBeUploaded = objDirInfo.CreateSubdirectory(this.CurrentUserFolder) + "\\" + strFilename;

// read the file in a stream.
System.IO.Stream strm = imgBigProduct.PostedFile.InputStream;

// Now form an image out of stream
System.Drawing.Image imageOriginal = System.Drawing.Image.FromStream(strm);

// get the thumbnail size as you need
System.Drawing.Image imageReduced = imageOriginal.GetThumbnailImage(350, 350, ThumbnailCallback, IntPtr.Zero);

// Save the reduced image.
imageReduced.Save(PathToBeUploaded);

// this you may need to call while calling the GetThumbnailImage method.
public bool ThumbnailCallback()
{
return false;
}

Web Farm and Web Garden

2011-01-18T03:14:00.000-08:00

Web garden in asp.net :
When an application is hosted by multiple processes on the same server it is said to be a web garden environment. An application pool with multiple worker process is called Web Garden, means single server and multiple CPUs.

All IIS Request process by worker process ( w3wp.exe), In web garden scenario If we use Session Mode to "in proc", our application will not work correctly because session will be handled by different Worker Process. For Avoid this Type of problem we should have to use Session Mode "out proc" and we can use "Session State Server" or "SQL-Server Session State".

Web farm means running one asp.net application on multiple machine.

Events in HTTPApplication in Asp.net

2011-01-18T00:12:00.000-08:00

Here are the event occurred in life cycle of HTTPApplication

1. BeginRequest. The request processing starts.
2. AuthenticateRequest. The request is authenticated. IIS 7 and ASP.NET authentication modules subscribe to this stage to perform authentication.
3. PostAuthenticateRequest.
4. AuthorizeRequest. The request is authorized. IIS 7 and ASP.NET authorization modules check whether the authenticated user has access to the resource requested.
5. PostAuthorizeRequest.
6. ResolveRequestCache. Cache modules check whether the response to this request exists in the cache, and return it instead of proceeding with the rest of the execution path. Both ASP.NET Output Cache and IIS 7 Output Cache features execute.
7. PostResolveRequestCache.
8. MapRequestHandler. This stage is internal in ASP.NET and is used to determine the request handler.
9. PostMapRequestHandler.
10. AcquireRequestState. The state necessary for the request execution is retrieved. ASP.NET Session State and Profile modules obtain their data.
11. PostAcquireRequestState.
12. PreExecuteRequestHandler. Any tasks before the execution of the handler are performed.
13. ExecuteRequestHandler. The request handler executes. ASPX pages, ASP pages, CGI programs, and static files are served.
14. PostExecuteRequestHandler
15. ReleaseRequestState. The request state changes are saved, and the state is cleaned up here. ASP.NET Session State and Profile modules use this stage for cleanup.
16. PostReleaseRequestState.
17. UpdateRequestCache. The response is stored in the cache for future use. The ASP.NET Output Cache and IIS 7 Output Cache modules execute to save the response to their caches.
18. PostUpdateRequestCache.
19. LogRequest. This stage logs the results of the request, and is guaranteed to execute even if errors occur.
20. PostLogRequest.
21. EndRequest. This stage performs any final request cleanup, and is guaranteed to execute even if errors occur.

By using the familiar ASP.NET APIs, the ability to execute in the same stages as IIS 7 modules makes tasks that were only previously accessible in native ISAPI filters and extensions now possible in managed code.

Scrum Agile Methodology

2011-01-08T04:14:00.001-08:00

Scrum Agile Methodology is one of the most popular methodology in today’s software application development. We need to get familiar with few jargons while discussing about scrum.

1. Products Backlog : Product backlog will be created by Product Owner & scrum team. backlog are the piece of functionality of entire project.

2. Sprint backlog : Identifying the area will be developed in each mile stone.

3. Sprints : This is a small milestone. sprint can be of 7 to 15 days.

4. Scrum Master: who is monitoring the progress and updating prject plan day to day basis.

5. Burn down Charts :

6.Product Owner : Person who has the visualization of the product.

7. Scrum Team : Designer, Developer, Tester, Scrum master (project manager) & Project Owner.

8. Daily Scrum : Its a 30 minutes meeting with team members everyday in the morning to discuss the goal for the day.

9. Scrum Review : Once any sprint ends, everyone gets together in a meeting to share what he/she accomplished during the sprint, and what the problems come accross.

Now here i have found a great video, which can make you understand the scrum in just 10 minutes .

Update records row by row using cursor in sql

2011-01-07T04:45:00.000-08:00

How to loop through a table and update row by row using cursor in sql. ...basically looping through a table and updating record one by one in ms sql.

declare @cur1 cursor
declare @col1 varchar(10)
declare @col2 varchar(10)
declare @col3 varchar(10)
declare @col4 varchar(10)

set @cur1 = Cursor FOR SELECT column4,column1,column3 from myTable1

OPEN @cur1
FETCH NEXT FROM @cur1 into @col4, @col1, @col3
While @@FETCH_STATUS = 0
begin
select @col2=column2 from differentTable2 where someColumn=@col3

if @col2 is not null
begin
Update myTable1
set column2 = @col2
Where column4=@col4
end

FETCH NEXT FROM @cur1 into @col4, @col1, @col3
End
close cur1
deallocate cur1

Nhibernate Session Module Design

2011-01-05T04:17:00.000-08:00

Session Module is the heart & head of nhibernate framework, so here i am publishing the design of SessionModule

Reference required :
using System;
using System.Web;
using NHibernate;
using NHibernate.Cfg;

Session Module class :
public class SessionModule : System.Web.IHttpModule
{
private static readonly string SESSION_KEY = "CONTEXT_SESSION";
private const string TRANSACTION_KEY = "CONTEXT_TRANSACTION";

[ThreadStatic]
private static NHibernate.ISession m_session;

private static ISessionFactory m_sessionFactory;

public void Dispose()
{

}

public void Init(System.Web.HttpApplication context)
{
log4net.Config.XmlConfigurator.Configure();
context.BeginRequest += new EventHandler(BeginRequestHandlerExecute);
context.EndRequest += new EventHandler(EndRequestHandlerExecute);
// http://www.codeproject.com/KB/architecture/NHibernateBestPractices.aspx
Configuration cfg = new Configuration();
m_sessionFactory = cfg.BuildSessionFactory();

}

private void BeginRequestHandlerExecute(object sender, EventArgs e)
{
CurrentSession = m_sessionFactory.OpenSession() ;

}

private void EndRequestHandlerExecute(object sender, EventArgs e)
{
ISession currentSession = CurrentSession;
if (currentSession != null)
currentSession.Close();
}

public static ISession CurrentSession
{
get
{
ISession session = (ISession)HttpContext.Current.Items[SESSION_KEY];
return session;
}
set
{
HttpContext.Current.Items[SESSION_KEY] = value;
//SetCurrentSession(value);
}
}

public static ITransaction CurrentTransaction
{
get
{
ITransaction tran = (ITransaction)HttpContext.Current.Items[TRANSACTION_KEY];
return tran;
}
set
{
HttpContext.Current.Items[TRANSACTION_KEY] = value;
}
}
}

Nhibernate Quick Overview

2011-01-03T02:29:00.000-08:00

Download all required nhibernate from following url.

http://sourceforge.net/projects/nhibernate/

How to use ICriteria ?

ICriteria criteria = SessionManager.CurrentSession.CreateCriteria();
criteria = criteria.Add(NHibernate.Criterion.Expression.Eq("StudentId", 48));
Student stu= criteria.UniqueResult();

How to Map two or more database table from one object in nhibernate ?

Suppose thhe following school object does not have a property called Student ,

public class School
{
public virtual ISet Students { get; set; }
}

Now in hbm you can map like

< set name="Students" table="Students" schema="oneSchool" cascade="all-delete-orphan" lazy="true" where ="AdminDate() between StartDate And IsNull(EndDate,GetDate())">
< key column="SchooldId" / >
< many-to-many class="Student" column="StudentId"/ >
< /set>

how to use transaction in Nhibernate ?

use Nhibernate.Transaction namespace reference;
using (ITransaction tran = SessionManager.CurrentSession.BeginTransaction())
{
tran.commit();
}

How to implement transaction in WCF client

2010-11-18T23:02:00.000-08:00

Here we see how to consume two wcf service from wcf client !

Create a WCF Service :

using System.ServiceModel;
namespace ACWCF
{ [ServiceContract]
public interface ITranService
{

[TransactionFlow(TransactionFlowOption.Allowed)]
[OperationContract]
void UpdateData();
}
}

// Implement the interface
public class TranService : ITranService
{
[OperationBehavior(TransactionScopeRequired = true)]
public void UpdateData()
{
SqlConnection objConnection = new SqlConnection("MyConnectionString");
objConnection.Open();
SqlCommand objCommand = new SqlCommand("insert into Customer(CustomerName,CustomerCode) values('sss','sss')", objConnection);
objCommand.ExecuteNonQuery();
objConnection.Close();
}

// Assuming we are aware of hosting the service on IIS .. so i am not talking about the web.config part of it .

Now lets create a client to consume multiple wcf service

// this is how wcf client can consume multiple wcf service.
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
try
{
//ServiceReference1.Service1Client obj = new ServiceReference1.Service1Client();
//obj.UpdateData();
//ServiceReference2.Service1Client obj1 = new ServiceReference2.Service1Client();
//obj1.UpdateData();

ts.Complete();
}
catch (Exception ex)
{
ts.Dispose();
}
}

A great article can be seen on
http://www.c-sharpcorner.com/UploadFile/shivprasadk/436456754708092009145905PM/4364567547.aspx

another good wcf clip can be seen at:

Entity Framework Sample

2010-11-13T10:26:00.001-08:00

You need to install sp1 before you can start with entity framework

If you can't see the framework template, do the following step
Click on Tools => Option => Projects & Solutions ..then
Click on "User item template location" browse button and set the right path
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\
do same for project templets
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ProjectTemplates\
Now click on "ok"
then close the studio and re-open again ..now you will be able to see the entity framework template

some more guide step - by step can be seen on http://www.installationwiki.org/Installing_ADO.NET_Entity_Framework

Getting problem in Connectionstring in Entity framework ?

< add name="HRRPMSContext" providerName="System.Data.EntityClient" connectionString="metadata=res://ETG.Base.Applications.EntityFramework,Culture=neutral,PublicKeyToken=null/HRRPMSContext.csdl|res://ETG.Base.Applications.EntityFramework,Culture=neutral,PublicKeyToken=null/HRRPMSContext.ssdl|res://ETG.Base.Applications.EntityFramework,Culture=neutral,PublicKeyToken=null/HRRPMSContext.msl;provider=System.Data.SqlClient;provider connection string='Data Source=ETG1\SQLEXPRESS;;Initial Catalog=ACSampleDB;User ID=HRRPMS;Password=pass;Integrated Security=True;multipleactiveresultsets=true'"/ >

In the above string ETG.Base.Applications.EntityFramework is my assembly name ETG.Base.Applications.EntityFramework.dll

Fetching a collection using entity framework.
public static List< tbCandidate> GetAllCandidates()
{
List< tbCandidate > candidates = new List< tbCandidate>(); ;

using (var hrEntities = new HRRPMSContext())
{
foreach (var candidate in hrEntities.tbCandidate)
{
candidates.Add(candidate);
}
}

return candidates;

}

Adding data example :
public static void SetData()
{
tbCandidate candidate = new tbCandidate();
candidate.Name = "Arindam Chakraborty";
candidate.Phone = "11545645656";
candidate.Qualification = "B.Sc";
candidate.Street = "New Golden Nest";
Add(candidate);

}

public static void Add(tbCandidate obj)
{
using (var hrEntities = new HRRPMSContext())
{
hrEntities.AddTotbCandidate(obj);
hrEntities.SaveChanges();
}
}

Find a candidate by name from database
public static tbCandidate FindCndidateByName(string name)
{
tbCandidate candidate = null;

using (var hrEntities = new HRRPMSContext())
{
candidate = hrEntities.tbCandidate.FirstOrDefault(c => c.Name == name);
}

return candidate;

}

Update a candidate information

public static void Update(tbCandidate updatedCandidate)
{

using (var hrEntities = new HRRPMSContext())
{
tbCandidate candidate = hrEntities.tbCandidate.FirstOrDefault(c => c.CandidateID == updatedCandidate.CandidateID);
candidate = updatedCandidate;
hrEntities.tbCandidate.Context.ApplyPropertyChanges("tbCandidate", candidate);
hrEntities.tbCandidate.Context.SaveChanges();
}
}

Add Data in many tables with transaction scope
public static void AddMultipleRecord(tbInterview interview, tbRequirement requirement)
{

using (TransactionScope scope = new TransactionScope())
{
using (var hrEntities = new HRRPMSContext())
{

hrEntities.AddTotbInterview(interview);
hrEntities.AddTotbRequirement(requirement);

hrEntities.SaveChanges();
scope.Complete();
}
}
}

How to write join and where clause using lambada expression
using (var entities = new MyEntities())
{
var userProfile = from user in entities.UserProfile
join pro in entities.ProductInfo
on user.UserInfoID equals pro.UserInfoID
where pro.ProductInfoId == ProductId
select user;

profile = userProfile.FirstOrDefault();

}

UML basic overview

2010-10-30T16:17:00.001-07:00

Few important keywords in UML.

Generalization:
A generalization is used when two classes or actor are similar, but have some differences, one class shares its structure and/or behavior with one or more other classes. Its more like inheritance.

Dependency :
When behavior of one class/object depends on behavior of another class/object then dependency relation ship applied.

Association, Aggregation, and Composition:

Realization:

Include:
Extends:

Some good UML tool can be seen on http://www.uml-forum.com/tools.htm

Can a class diagram show the dynamic behavior of a system?
No, Class Diagram is static diagram, cant show the dynamic behavior of the system.

What is class diagram ?
The class diagram is used to refine the use case diagram and define a detailed design of the system. The class diagram classifies the actors defined in the use case diagram into a set of interrelated classes. The relationship or association between the classes can be either an "is-a" or "has-a" relationship. Each class in the class diagram may be capable of providing certain functionality. These functionality provided by the class are termed "methods" of the class. Apart from this, each class may have certain "attributes" that uniquely identify the class.

What is association ends ? or role of association ?
Association ends specify the role of the association end, its multiplicity, visibility, navigability, and constraints

Can deployment diagram be used for forward and reverse engineering?

Content of Enterprise Architecting

2010-10-30T12:28:00.000-07:00

What is the are of understing one should have while talking about Enterprise Architecting, Yes, that was always a question in my mind. and after going through many defination onweb i am able to come up with the following bullet points. but yes "The TOGAF 9 Training Session" added some value.

• Architecture Frameworks
• Architecture Development Process
• Modeling specification such as UML 2.0, BPMN etc.
• Component Programming Model such as standard .NET
• Pattern and Reusable Assets
• Business Process Management
• Model Driven Architecture
• Service Oriented Architecture
• Legacy transformation, EAI
• Architecture Realization & Assessment Governance capability

Key elements of TOGAF 9
Boundaryless Information Flow is the key driver of "TOGAF 9", and open group has come up with some defination for "Architecture Development Methodology"

How to implement security in WCF service

2010-10-08T16:29:00.000-07:00

There are three type of security in WCF
1. Message level Security
2. Transport level Security
3. TransportWithMessageCredential

Here we see how to implement Message Level securtiy in WCF service :

Setp 1 :
Create a class with name "CustomUserNameValidator" and the class should inherit from "System.IdentityModel.Selectors.UserNamePasswordValidator" in wcf service project.

namespace WcfService1
{
public class CustomUserNameValidator :System.IdentityModel.Selectors.UserNamePasswordValidator
{

public override void Validate(string userName, string password)
{
if ((userName != "arindam") && (password != "acpass"))
throw new FaultException("Invalid credentials");
}
}
}

Setp 2 :
Add the folowing tag in your host webconfig file
================================================
< services >
< service behaviorConfiguration="ETG.Base.Applications.EClinic.Services.DoctorServiceBehavior"
name="ETG.Base.Applications.EClinic.Services.DoctorService" >
< endpoint address="http://localhost:50219/DoctorService.svc" binding="wsHttpBinding" contract="ETG.Base.Applications.EClinic.Services.ServiceDefination.IDoctorService" >
< identity >
< dns value="localhost" / >
< /identity >
< /endpoint >
< endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" / >
< /service >
< / services >
< behaviors >
< serviceBehaviors >
< behavior name="WCFSampleServiceBehaviors" >
< serviceMetadata httpGetEnabled="true" / >
< !-- The tag below allow to get the exception details from client -- >
< serviceDebug includeExceptionDetailInFaults="true"/ >

< !-- The tag below allow service to implement securty -- >
< serviceCredentials >
< userNameAuthentication userNamePasswordValidationMode="Custom" customUserNamePasswordValidatorType="WcfService1.CustomUserNameValidator,WcfService1"/ >
< /serviceCredentials >
< /behavior >

< /serviceBehaviors >
< /behaviors >

< bindings >
< wsHttpBinding >
< binding name ="WCFSampleServiceBinding" >
< security mode="Message" >
< message clientCredentialType ="UserName" / >
< /security >
< /binding >
< /wsHttpBinding >
< /bindings >

now we are done with service seide implementation of message level security. just run the service, make sure it runs properly.

The next step is to see how we can access the wcf service with right credential. also we see if the credential is wrong then what error message we get ?

Open your existing asp.net project or create a new project, add the service reference, open the web config file, now you should see that service reference has been added in < system.serviceModel > section.

we are just one step away from testing .

Setp 3 :

Now set the credential to service client class this way ..
DoctorServiceClient dClient dClient = new DoctorServiceClient();
dClient.ClientCredentials.UserName.UserName = "arindam";
dClient.ClientCredentials.UserName.Password = "acpass";

dClient.CallMyMethod();
this should work fine, to test the credential just change the username/password, you should get error message thrown by service.

MUST READ
========
How to create certificate on local machine
http://msdn.microsoft.com/en-us/library/ff648498.aspx

How to configure certificate on IIS 7
http://weblogs.asp.net/scottgu/archive/2007/04/06/tip-trick-enabling-ssl-on-iis7-using-self-signed-certificates.aspx

How to allow wcf client to get WCF service exception details

2010-09-29T12:17:00.000-07:00

There are two ways to allow client to get the wcf exption details

IncludeExceptionDetailInFaults

one is by adding the "includeExceptionDetailInFaults" in serviceDebug tag

< behaviors >
< serviceBehaviors >
< behavior name="WCFSampleServiceBehaviors" >
< serviceMetadata httpGetEnabled="true" / >
< !-- The tag below allow to get the exception details from client -- >
< serviceDebug includeExceptionDetailInFaults="true"/ >
< serviceCredentials >
< userNameAuthentication userNamePasswordValidationMode="Custom" customUserNamePasswordValidatorType="WcfService1.CustomUserNameValidator,WcfService1"/ >
< /serviceCredentials >
< /behavior >
< behavior name="ServiceBehavior" >
< serviceSecurityAudit auditLogLocation="Application" serviceAuthorizationAuditLevel="SuccessOrFailure"
messageAuthenticationAuditLevel="SuccessOrFailure" / >
< /behavior >
< /serviceBehaviors >
< /behaviors >

Second option is adding service behavior "IncludeExceptionDetailInFaults=true"
[ServiceBehavior(IncludeExceptionDetailInFaults = true)]
public class WCFSampleService : IWCFSampleService
{

}

WCF question answer

2010-09-18T21:27:00.000-07:00

What is ABC of WCF ?

A : Address (Where is the service?)
B : Binding (How do i talk to service?)
C : Contracts (What service can do/perform ?)

Address : Specifies the location of the service which will be like http://Myserver/MyService.Clients will use this location to communicate with our service.

Binding : Specifies how the two paries will communicate in term of transport and encoding and protocols

Contract : Specifies the interface between client and the server.It's a simple interface with some attribute.

there are three types of contract in WCF.
1. DataContract
2. OperationContract
3. ServiceContract

What is endpoint ?
End point is the address where Service resides.

What is the difference between web service and wcf ?
1. Asp.net web services can use only HTTP channel, when WCF support Tcp, Http & msmq
2. Web service can hosted on IIS only, when WCF can be hosted on IIS, Was, self hosting
3. With WCF you can use SSL to encrypt the communication (to do that in ASMX you need to use WSE - Web Services Enhancements), you can send big files and securely (to do that in ASMX you need to use MTOM - Message Transmission Optimization Mechanism)

WCF Security related question & answer
http://msdn.microsoft.com/en-us/library/ff649839.aspx

Wcf Security implementation
http://www.codeguru.com/csharp/.net/net_general/netmyservices/article.php/c13313

LINQ to SQL implementation step by step

2010-09-16T12:13:00.000-07:00

LINQ to SQL implementation step by step

Right click on project solution => Add New Item =>
Select DBML class, give some appropriate name and add in project.

now open your server explorer and add some database. => drag some table on the dbml file.

// this is the class generated by hr.dbml
HRDataContext hr = new HRDataContext();

// get any one table
var q = from a in hr.GetTable()
select a;

// bind the table in datagrid
GridView1.DataSource = q;
GridView1.DataBind();

Data LINQ examples

2010-09-16T11:07:00.001-07:00

To use LINQ (Language Integrated Query) you just need to have the following 2 namespace reference
using System.Collections.Generic;
using System.Linq;

// using where clasue within the collection.
List allCities = Common.GetAllCities().Where(c => c.DewPoint> 1).ToList() ;

// using where clasue & some property contain value search.
List allCities1 = Common.GetAllCities().Where(c => c.StationName.Contains("a")).ToList() ;

// pick the default value collection
Climate climate = Common.GetAllCities().SingleOrDefault();

// pick the First/default value collection
Climate climate1 = Common.GetAllCities().FirstOrDefault();

// sort the list
Common.GetAllCities().Sort();

Read xml data using Xml.Linq to generic list

2010-09-16T03:25:00.000-07:00

using Xml.Linq.XDocument is very easy. now lets see how to pick the following xml file into xdocument and query with in the filedata using XML.Linq

< ?xml version="1.0" encoding="utf-8" ? >
< Cities >
< City StationName="Mumbai" >
< WeatherCondition >Not Extreem< /WeatherCondition >
< WindDirection >North-to-South< /WindDirection >
< Temperature >30 degree C< /Temperature >
< DewPoint >16< /DewPoint >
< Humidity >14.05< /Humidity >
< WindSpeed >Mild< /WindSpeed >
< /City >
< City StationName="Kolkata" >
< WeatherCondition >Dry< /WeatherCondition >
< WindDirection >East-to-South< /WindDirection >
< Temperature >32 degree C< /Temperature >
< DewPoint >11< /DewPoint >
< Humidity >12.35< /Humidity >
< WindSpeed >Strong< /WindSpeed >
< /City >
< City StationName="Delhi" >
< WeatherCondition >Hot< /WeatherCondition >
< WindDirection >East-to-North< /WindDirection >
< Temperature >42 degree C< /Temperature >
< DewPoint >7< /DewPoint >
< Humidity >11.35< /Humidity >
< WindSpeed >Strong< /WindSpeed >
< /City >
< /Cities >

Now read the above xml data using Xml.Linq.XDocument

public static List GetAllCities()
{
// Load a Xml File into XDocument class
XDocument xmlDoc = XDocument.Load(@"App_Data/CitiesClimate.xml");

// Read the Xml data into a
var cities = from xmlData in xmlDoc.Elements("Cities").Elements("City")
select xmlData;

Climate climate = null;
List climateList = new List();

//Now loop through all the cities in resultset
foreach (var city in cities)
{
climate = new Climate();
climate.StationName = city.Attribute("StationName").Value;
climate.WeatherCondition = city.Element("WeatherCondition").Value;
climate.WindDirection = city.Element("WindDirection").Value;
climate.Temperature = city.Element("Temperature").Value;
climate.DewPoint = Convert.ToDecimal(city.Element("DewPoint").Value) ;
climate.Humidity =Convert.ToDecimal(city.Element("Humidity").Value);
climate.WindSpeed = city.Element("WindSpeed").Value;
climateList.Add(climate);
}

return climateList;
}

Now see how to search some records
// Here we can perform search
var cities1 = from xmlData in xmlDoc.Elements("Cities").Elements("City")
where Convert.ToInt32(xmlData.Elements("DewPoint")) > 11
select xmlData;

Journey was always tough, but I got something on my way

2010-09-09T11:58:00.000-07:00

Journey was always tough, but I got something on my way everytime i have been through! Yes, that has happen with me many times ...and repeated again. I don't know how! what force does work behind it, whatever may be the logic i enjoy the result.

Yes, i always wanted to be satisfied (as everyone wants) with whatever i do, but sometimes that become very tough because of many reasons. and i get stumbled over again and again. Specially in last few months it went to a farthest point, somehow i kept myself cool.. during the time i also felt that there are many who might be in more tougher situation.. and question popup what can be done....that's probably the point when i could visualise the idea..

http://arindamchakraborty.wordpress.com/2010/09/01/firstcoder-a-utility-for-c-developer

FirstCoder, a utility for C# developer

2010-09-06T11:03:00.000-07:00

Introdcuing an Utility that can reduce your work load specially if you are working in asp.net C#, Just connect your database ..and a few clicks all your business objects are ready to be used.

I have seen at least 40% of our time we spend in doing few standard functions for all the application we develop in our lifetime, sometimes I feel tired doing same monotonous task, i don’t believe in doing any job which can be automated, let the utility do all task for you….just relax!

I am sure many of you might have experienced the same.

Here I have identified few tasks for the same reason, and automated for all the following task for you.

Java Script Objects: The utility writes java script for all your business objects with few standard methods in it, like addToList(), removeFromList(), getById(id), getAll(),

JSON: The utility writes Json structure for all your business objects with few standard methods in it. Like Save, Get. I keep the JSON structure ready, you just need to set the value from your page control and you are done! JSON can make call to web service or WCF service.

WCF / Web Service: The utility creates wcf service for your entire object with a hosting plan on IIS and one page for service registration.

HBM: The utility gets your entire basic HBM ready within in a minute; I take care of id, composite key, one to many, one to one etc.

Business Entity: Write all business entity with custom attribute like wcf compatible, n-hibernate compatible.

Data Objects Structure: You must have seen often we change our database object structure during the development, but never update our technical specification, so here I create a document for all tables, views & procedures.

Once you standardize the definition, I produce exactly the same, you don’t have to spend time in object creation & to review them, and thus I also save some time, so more quickly you can concentrate on core business area.

Here is the link to download the utility

Upcoming Features :
1. Format all projects code at one click.
2. Identify all areas where function definition has not been written
3. Generate a report all of all function details, so we can identify if any duplicate function written or naming convention are incorrect, that may help to save the review time.

Whats new in .net framework 4

2010-06-16T10:09:00.000-07:00

Before i can show implementation of framework .net 4.0, i request you to go through http://msdn.microsoft.com/en-us/library/ms171868(VS.100).aspx

DLR (Dynamic Language Runtime)

Infopath 2010 development with C# .Net

2010-04-20T10:35:00.000-07:00

Well, I started with InfoPath with "ZERO" idea, But today i am feeling like sharing my journey with community, Because everything i got know from community.

Can we write .net code to develope Infopath form?

Yes, and here is how! step by step.

You need to install "VSTA" at the time of Office Infopath 2010. if VSTA not installed on your machine, run the office installer again, select custom mode => go under InfoPath node => Select VSTA => Select run from my computer.

Once VSTA Installed on your machine, open a Infopath form place a button on the form => right click on button => go to properties => click on edit code to open VSTA application.

edit data in dataset using gridview

2010-03-16T08:23:00.000-07:00

I was just thinking of sharing the this peice of code, nothing much simply editing data in dataset and finally submitting in data in database, also addressing the concurrency problem inmy next article .. direct implementation ..take a look at url below.

http://etgconsultancy.com/AspNetControls/Edit-gridview-save-dataset-to-database.aspx

Freelance asp.net jquery developer in mumbai, Ajax developer in mumbai

2009-10-12T14:02:00.000-07:00

Do you need to hire a Freelance Asp.net Programmer? Working remotely, I’m available when you need to hire a asp.net programmer on a freelance basis. I have 10 years of designing development experience & last 6 years i have been working on asp.net

Nowdays many small companies, web start ups and web designers that dont have any Asp.net programming experience, most of these people need to hire a full time programmer. They need some programming done, for a short amount of time.

ETG Consultancy help them to achive their goal.

We have a team of experienced, reliable and professional asp.net developer, We work remotely on your project until it is completed to your specifications. We are always available for ongoing support after a project is finished. You can count on us to get your project completed.

Whatever Asp.net programming you need, I can accomodate you. Contact me to discuss your project. Build your business site or personal website in Asp.net Ajax SQL .

Conatct me for your quick solution
Arindam Chakraborty
arindam.tech@yahoo.co.in
Asp.net developer in mumbai,

Freelance web developer in mumbai, Asp.net ajax website development.

Freelance Php Mysql programmer developer in Mumbai

2009-10-11T16:43:00.000-07:00

Do you need to hire a Freelance PHP Programmer? Working remotely, I’m available when you need to hire a php programmer on a freelance basis.

Nowdays many small companies, web start ups and web designers that dont have any PHP programming experience, most of these people need to hire a full time programmer. They need some programming done, for a short amount of time.

ETG Consultancy help them to achive their goal.

We have a team of experienced, reliable and professional php developer, We work remotely on your project until it is completed to your specifications. We are always available for ongoing support after a project is finished. You can count on us to get your project completed.

Whatever PHP programming you need, I can accomodate you. Contact me to discuss your project. Build your business site or personal website in PHP MySQL

Conatct me for your quick solution
Arindam Chakraborty
arindam.tech@yahoo.co.in

php developer in mumbai, Freelance web developer, mumbai freelancer, website optimization seo, php website development, (PHP-MySQL script installation)

I have come back to you, i just can't stop myself ..Php

2009-10-05T03:55:00.000-07:00

I did php development for only a few months, 6 years back. After that i never got a chance to look at php further, during that small development experience i realised that i can make a long & healthy journey with php. But somewhow that didn’t happen, rather i have made my journey with .net framework.. so far journey was not bad.

But now i have got the chance to taste the old essence again, this time I really don't want to miss the opportunity. I wish to look at php more passionately. I will keep posting my php journey on http://etgconsultancy.com/Php .

Very soon i write on php jquery, php ajax, php oops, how to deal with customobject in php, php with xml ...any many more to talk about.

Keep in touch .. LAMP

.Net 3.5 Framework & LINQ

2009-09-30T18:27:00.000-07:00

When we talk about .net 3.5 framework, LINQ is a major thing, In simple word linq is a orm.

1. LINQ to Object
Queries performed against the in-memory data
2. LINQ to ADO.Net [Example]
2.1 LINQ to SQL (formerly DLinq) {Queries performed against the relation database only Microsoft SQL Server Supported}
2.2 LINQ to DataSet {Supports queries by using ADO.NET data sets and data tables}
2.3 LINQ to Entities {Microsoft ORM solution}

3. LINQ to XML (formerly XLinq)
{ Queries performed against the XML source}

In my site i have put all examples of linq and its use.

http://etgconsultancy.com/DotNetFrameWork/Framework3p5/LINQ-Implementation.aspx

A Complete implementation of LINQ to SQL can be found here :

http://etgconsultancy.com/DotNetFrameWork/Framework3p5/Linq-to-Sql.aspx

How to implement Microsoft EnterpriseLibrary 4.0 Data Access Application Block

2009-09-20T10:44:00.000-07:00

Hi Guys here is a very common topic i want to share with you, I am sure you guys using microsoft application block for long time, But when i started using Microsoft EnterpriseLibrary 4.0 Data Access Application Block i found it little tricky to figure out the database connection part.

After spending few hours I finally got the solution, here i am sharing the step by step implementation process, http://etgconsultancy.com/Architecture/EnterpriseLibrary4/

Hope tis will help, incase you have any question just drop me a line.

Implement google map, how to get coordinates

2009-09-06T11:35:00.000-07:00

Here are the very simple steps to implement google map in your application..

I assume you have a gmail account, and you have created your mark on http://maps.google.com

So first make your google location.

Now generate your key for google map, if you dont have click on following url to generate key http://code.google.com/apis/maps/signup.html

once you get your key, replace the key in following script.

< script src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=yourkey" type="text/javascript" >< / script >
< script type="text/javascript" >

function initialize() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById("divMap"));
map.setCenter(new GLatLng(37.4419, -122.1419), 13);
map.setUIToDefault();
}
}

< / script >

Now place a div where you want to display the google map.

< div id="divMap" style="margin-top:12px;width:500px;height:400px;" >
< / div >

finally initialise the key

< script language="javascript" type="text/javascript" >
window.load= initialize();
< / script >

Google ma getting dipalyed on your site, but you might be wondering why your location not gettting displayed. For that you need to change the coorodinates.

How to get the coordinates ? Simply open your location in google map and copy paste the following javascript code on browser. youe get your location, replace the code in map.setCenter(new GLatLng(37.4419, -122.1419), 13); method in above script.

javascript:void(prompt('',gApplication.getMap().getCenter()));

Or

click on the right top "send" you get the following code

Hi, I'd like to share a Google Maps link with you.
Link: < http://maps.google.com/maps/ms?ie=UTF8&hl=en&msa=0&msid=103425934348104227970.000472c4205e6efea558c&ll=19.298314,72.861425&spn=0.007281,0.009624&z=17 >

Enjoy google map in your application.

Arindam
http://etgconsultancy.com

Web Designing & Development Mega Offer

2009-09-03T11:34:00.000-07:00

Hello Firend, I am offering a wel-design seo compitable website with minimum cost.

Take a look at my offer below.

1. Beautiful Graphic layout (match your business type)
2. Five web pages.
3. Asp.net, Ajax & Jquery development.
4. Seo compitable structure.
5. Free search engine submission.
6. One year domain registration & hosting plan.
7. pop3 & smtp support with 3 e-mail ids.

for Just $300 USD

Write me at arindam.tech@yahoo.co.in

HR Recruitment process management System

2009-08-15T00:04:00.000-07:00

HR Software, HR Recruitment software

ETG Consultancy introducing a most useful efficient software for HR recruiter, the name of the software is "HR Recruitment process management System"

It has all the features that a any hr recruitment firm may require.

1. Add / Edit Client
2. Add new requirement, any client can have multiple requirement.
3. Add / Edit / Search Candidate
4. Maintain Candidate history
4. Schedule Interview / Follow-up interview
5. Send bulk mail for new opening
6. Add note / reminders
7. Create / edit templates
8. Search Interview by date / status

Admin part
==========
1. Add / Edit Consultant
2. Manage consultant’s profile
3. Track consultant’s activity reports
4. Business reports
5. Case history by Company.
6. Case history by Consultant.
7. Data transfer from excel to SQL database.

Open Area
=========
1. Candidate can submit their profile to your database.
2. Companies can send you their requirement

All reports are downloadable in excel format.

We understantd that requiremnt may differ from company to company based on their business practice, we can provide customized solution for any specific requirement.

the application is built in .net 2.0 & sql backend, can be deployed over internet & intranet environment, any client need a winform UI or oneclick installer also can contact me at, if required we can make it WCF compitable. now contact arindam.tech@yahoo.co.in.

Anybody wants to see a demo please conatct me.

we soon publish the HR Software product on our website http://etgconsultancy.com/products/HRRPMSystem.aspx

Simple thing is not so simple, simple mistake can cost a lot

2009-08-09T13:49:00.000-07:00

We often heard "we / you are not organised" or "we / you should get organised" … from top management to junior level executives. It’s very simple sentence, very easy to say, but very difficult to feel it.

I have just felt that twice in last three years with two different companies, and also seen the horrible result, which I took as a learning lesson from process & I would like to share the flavour with you all. In the recent recession many companies have reduced the head count in the name of cost cutting. But is that really a solution? I doubt! I strongly feel we are still not able to pin point the leakage.

If I take both the cases (I have been with) as "case study", I found one thing common…is "communication gap" between "business manager" & "project manager", and as a result repeated unplanned work cost huge time. I am not getting into who was right and who was wrong. What I feel is missing is a well defined process.

I also have experienced that in the name of doing something quicker (most of the time that happen because of unorganised pressure from management), we do same job again and again, and most of our allotted time get consumed, as a result things gets delayed.

Many small and middle size (including CMM level 3/4) companies lose huge amount of man days (finally money) in this way. Where I feel we / they are not able to use the techniques (technology), they are being used by process. Or I would say this side is often overlooked.

Now let me tell you that I was very lucky to be a part of a "well defined process" three and half years ago, which now gives me a clear idea about how a simple thing can make a huge difference. All small and middle size companies can save good amount of time by paying attention to that "simple" things.

Arindam Chakraborty
http://etgconsultancy.com

Why SEO? And where is the Competition??

2009-08-06T10:31:00.000-07:00

SEO is the most discussed topic in today’s web business, every site owner is aware of SEO and doing their best to optimize the site for search engine. Many companies claim to be the master of search engine optimization.

People who think SEO plays 100% in success of web business, I have some different word for them, I would call SEO as a regular process, it plays a major role in web business, holding customer back in site is more important & tough job. Which actually create the permanent traffic to the site?

User friendliness is very important in success of a web business. It may take time to create traffic in your site, but if the site has a well analysis in content decoration user must come back again and again, as they will enjoy surfing your site, http://e-tigers.netis a new upcoming business platform for manufacturers in India, importers exporters in China & India, Where you can feel the user friendly presentation, so the site will keep generating traffic slowly, but the user will comeback again and again.

So my recommendation is don't spend too much money for SEO, first you try to do it yourself, as I said SEO is just a simple process, so you just need to follow a few steps, take a look at http://www.seocompany.ca/seo/seo-techniques.html , which explains each step in detail. You also can consult with any consultant.

I can help you to create a user friendly high end database driven website, we believe the same approach in our business, we want our customer to come back again and again, and we deliver quality.

Contact me if you have any query.

Arindam Chakraborty
http://etgconsultancy.com

Tough time is the right time to plan big game !

2009-07-31T03:39:00.000-07:00

Though we have experienced a very tough time in last 6 months, many people have lost their job, many have shutdown their business, But this is the right time to start a new venture ! that we must learn from history.

What's new management thought. What changes have been made during the period in operation. Yes that's going to be a new chapter in MBA school.

So what expert says ? What do you think ?

ETG Consultancy is one of such initiative taken by a group of professionals in Mumbai. In a very short period of time they have published their first product http://e-tigers.net , A great platform to promote business.

Share your view, let the world know your idea, Show them the new way of approaching business

Jquery in web development

2009-06-24T09:23:00.000-07:00

I have been designing & developing a web based application for last 10 years, In first 2 years of my career i was completely into page designing using photoshop, corel, html, css and little bit javascript, I designed many pages, many website for different companies & individuals, later i got into programming asp, php, openscript..then asp.net for last 5 years, now I dont get a chance to play with webapge designing, most of the time go for middle tier development.

I always used think of a web page that will behave like a win form application, very stable, first response and a smooth interface. After knowing about jquery i just can't stop my self from page designing, So whenever i get a chance i try to make something using jquery.

But its not that easy always, Here i will share my short journey with jquery, hiding and showing any div or object with some effect was just fun, but when trying to use jquery method from a repeater, grid or datalist i was not finding any example, that really took some time to figure out the way, so i wish if this code helps some one like me. i have published all code in my site tep by step http://etgconsultancy.com/JQuery/Jquery-Repeater-Gridview.aspx
Hope you guys will ejoy!
Arindam

CLR, CTS and CLS JIT, MSIL Code

2009-05-03T12:53:00.000-07:00

Common Language Runtime :
CLR is the core engine of .Net framework.

CLR provide the following services :
1. Memory management
2. Thread management
3. Exception handling
4. Garbage collection
5. Security

What is JIT ?

The Common Language Runtime (CLR) provides various Just In Time compilers (JIT) and each works on a different architecture depending on Operating System. That is why the same Microsoft Intermediate Language (MSIL) can be executed on different Operating Systems without rewrite the source code. Just In Time (JIT) compilation preserves memory and save time during application initialization. Just In Time (JIT) compilation is used to run at high speed, after an initial phase of slow interpretation. Just In Time Compiler (JIT) code generally offers far better performance than interpreters.

CLS (Common Language Specification):
CLS is a standard for .net . cls is small set of specification to make all languages as a .net compliant languages. cls make a use of cts and clr. if my languages (c#,vb.net,j#,vc++) wants to be compliant language it has to follow cls standard.

CTS (Common Type System):
Common Type System is also a standard like cls. If two languages (c# or vb.net or j# or vc++) wants to communicate with each other, they have to convert into some common type (i.e in clr common language runtime). In c# we use int which is converted to Int32 of CLR to communicate with vb.net which uses Integer or vice versa

Big manufacturers are focusing on rural market

2009-04-28T14:31:00.000-07:00

As India has a great marketplace, many big companies like LG are also focusing on rural indian market, now we must understand as a marketer, one need to be innovative in communication strategy and have to offer spectrum of products to attract the customer.

So now all small and midlle size manufacturers should also think of expanding their market in different verticals, more & more visibity in the market will help manufacturers in india & china to promotoe their brands, which will be the future resource for new demands.

An appropriate strategy followed by accurate execution ensures the accomplishment of goals and vision of an organisation.

Arindam Chakraborty

Why Internet is the best media to promote products?

2009-04-14T22:15:00.000-07:00

Now more people using internet media to read news and exchange information. Web sites are used as a replacement of traditional print media, as an effect some of the newspapers have been dying off.

Now all bloging sites are doing well by providing and criticizing information, as result reader getting better quality information, that’s how the bogging sites are gaining popularity and making readers coming back again.

Now if we compare the cost factor, internet media is less expensive than any other media and gives benefit for a long time. So in future every one has to promote their products on web, they will not have any choice.

So sooner we realise, its better.

Arindam Chakraborty
http://e-tigers.net

Manufacturers Importers Exporters in India, China, UK and USA

2009-04-13T17:23:00.000-07:00

Importers, Exporters and Manufacturers in India, China, UK and USA promote your products now http://e-tigers.net/eshop/Index.aspx

Promoting products in UK is easier and cheaper, we have introduced a new section in our e-tigers.net, one can easily highlight their products in UK http://e-tigers.net/Uk , we specially encourage hotelier, travel agent, property dealer to highlight their business in following segment.
http://e-tigers.net/UK/UKHotels.aspx
http://e-tigers.net/UK/TravelTourism.aspx
http://e-tigers.net/UK/Realestate.aspx

Its just a beginning, we come with lot more soon.. keep checking
manufacturer and business owner please let us know if we can help you in any way.

Role Based Security Implementation in AspNet

2009-04-02T05:48:00.000-07:00

http://www.asp.net/security/tutorials/role-based-authorization-cs
http://www.codeguru.com/csharp/.net/net_security/authentication/article.php/c7415 [zip file at the end of the file.]

Setting in web.config
=====================
< connectionStrings>
< add name="myDbConnection" connectionString ="Server=43.455.565.67;database=mydatabasename;uid=arindam;pwd=passmenow;" />
< /connectionStrings>

< roleManager enabled="true" defaultProvider="SqlRoleManager" >
< providers>
< add name="SqlRoleManager" type="System.Web.Security.SqlRoleProvider" connectionStringName="myDbConnection" applicationName="MyApplication" />
< /providers>
< /roleManager>

Create the following set of tables to support the role based authorization and security system.

Ceate table User
(
UserID - pk
Username varchar(20),
Password varchar(20)
)

Ceate table SecurityGroupAssigns
(
AssignID - pk
UserID - fk
SecurityGroupId - fk
)

Ceate table SecurityGroup
(
SecurityGroupId - pk
Name
DisplayName
)

Create Table SecurityRightAssign
(
AssignID - PK
SecurityGroupId - fk
SecurityRightID - fk
)

Create Table SecurityRight
(
SecurityRightID - PK
SecurityRight - varchar
)

Success in small business.

2009-03-10T11:51:00.000-07:00

Everyone wish to own a small business and want it to succeed. You may know that there are many competitors and all are well established. So the question is - "How do you make a difference"? How do you make sure that your services or products are viewed by your customer?

Never wait for a right time to start, Because today is the right time ! so just get started !

Success never comes easily. Start sharing your business information with maximum number of people through some presentable channel. NEVER SPEND LOT OF MONEY TO MARKET YOUR PRODUCT, USE CHEAPER OR FREE CHANNEL, because at beginning you may not have idea where the results will come from!

Try to keep your business details short, provide only basic information before your customer start asking you.

Try to improve the content and relation everytime you deal with your clients, treat him/her special.

Never force or try to finalise any deal, patient, everything will happen with time. just follow the regular process.

Don't forget to follow up your clients (most of the time people give up at this point.)

Remember there is no magic for success, so keep doing the cycle for 90 days and see the result.

Keep doing well
Arindam Chakraborty

Asp.net IIS 5 relation

2009-03-07T13:42:00.000-08:00

1. aspnet_isapi.dll : this dll made for receiving request from browser. the dll normally accepts request from all the following mapping files.

.asax ASP.NET application files. Usually global.asax.
.ascx ASP.NET user control files.
.ashx HTTP handlers, the managed counterpart of ISAPI extensions.
.asmx ASP.NET web services.
.aspx ASP.NET web pages.
.axd ASP.NET internal HTTP handlers.
.svc WCF service

2. inetinfo.exe : In IIS 5.0 there is only worker process to deal with asp.net based request. the file may be located at C:\WINDOWS\system32\inetsrv\

3. aspnet_wp.dll : this is the worker process of asp.net pages, this is basically http runtime environment which process the page and send the response back to browser in the form of html.