public bool CreateClientBasicDetails(Client clientObj) { bool retFlag = default(bool); StringBuilder insertQuery = new StringBuilder("INSERT INTO [dbo].[Client] ([ClientFirstName],[ClientLastName],[BusinessName],[ClientPrimaryAddress],[PrimaryContactNumber],[AlternateContactNumber],[PrimaryMailId],[FacebookId],[CreatedDate],[IsActive])"); insertQuery.Append("VALUES(@ClientFirstName,@ClientLastName,@BusinessName,@ClientPrimaryAddress,@PrimaryContactNumber,@AlternateContactNumber,@PrimaryMailId,@FacebookId,@CreatedDate,@IsActive)"); insertQuery.Append(";SELECT CAST(scope_identity() AS int);"); clientObj.ClientId = ClientDA.AddNewClient(clientObj, insertQuery.ToString()); retFlag = (clientObj.ClientId > 0) ? true : false; return(retFlag); }