Clarity important tables to connect project and task.

Clarity important tables to connect project and task.
They are three tables 

- odf_ca_project ( This will have the all the attributes created for project)
- odf_ca_task ( This will have the all the attributes created for tasks under project)
- prtask ( This is important table which will connect the project and tasks by using project id.)

Sample query to connect the task and project by using prtask table.

update odf_ca_task oct

set oct.wbso100 = 'Yes'

where oct.id in (select prt.prid from odf_ca_project odf,prtask prt

where prt.prprojectid = odf.id

and odf.wbso_subsidy = 'ws_yes');

Happy coding 

Bala

Clarity 13 Offline Time sheet Will not be avilable

Clarity 13 Offline Time sheet

Offline time sheet will not available any more in clarity 13 release.

Configuring Actuate Spread Sheet Report.

Step 1:

Install actuate spread sheet report from Actuate website. 

Step 1:

Mentioned below file require to do the modification.

Example: R175_Phi_Month_v0.1_qa.VTX design file you will get 

Step 2: 

Convert to the above file to zip file like this R175_Phi_Month_v0.1_qa.ZIP

Step 3: 

After converting extract the zip file and you will fine three files. 

- R175_Phi_Month_v0.1_qa.guid  (Guid File)

- R175_Phi_Month_v0.1_qa (Actuate parameter Template)

- R175_Phi_Month_v0.1_qa (Formula one file)

Click on the Actuate parameter template file, it will open in the spread sheet environment. 

some time if does not open, please reopen through actuate spread sheet. 

Step 4:

After opening go to Data file and then click "Data manager", you can find the connection and query, 

if you have any connection issue in the odbc. create connection through ODBC driver.

Happy coding 

Bala

Create ODBC connection using Windows 7

Step 1:

open this path in windows C:\Windows\SysWOW64

Step 2:

Please click on this file :odbcad32

Step 3:

After clicking the above mentioned file, it will open popup window with contains multiple tabs.

Step 4:
please open "System DSN" tab to select and add the ODBC connection to respective database servers

Happy coding
Bala

Clarity 13 Performance

Clarity 13 Partial load

When you make changes in the page only part of the page needs to be refreshed. instead of whole page like previous version of clarity.

You will notice that there is now a # sign in the URL. This is what allows clarity reload/redraw part of the page instead of whole page.

Actuate Chart Report

Dynamically changing the chart value by using the CustomizeCategoriesAndSeries event

Sub CustomizeCategoriesAndSeries( baseLayer As AcChartLayer, overlayLayer As AcChartLayer, studyLayers() As AcChartLayer )

Super::CustomizeCategoriesAndSeries( baseLayer, overlayLayer, studyLayers )

Dim checkMonth as integer

checkMonth=month(now)

if(checkMonth<>1) then

Dim numberOfSeries As Integer

numberOfSeries = baseLayer.GetNumberOfSeries( )

Dim seriesIndex As Integer

For seriesIndex =checkMonth To numberOfSeries

Dim series As AcChartSeries

Set series = baseLayer.GetSeries( seriesIndex )

Dim point As AcChartPoint

Dim pointIndex As Integer

Set point = series.GetPoint( 1 )

point.SetYValue(0)

Next seriesIndex

end if

End Sub

Full Text Search in SQL Server 2012

The Full Text Search in SQL Server 2012 has been enhanced by allowing you to search and index data stored in extended properties or metadata. Consider a PDF document that has "properties" filled in like Name, Type, Folder path, Size, Date Created, etc. In the newest release of SQL Server, this data could be indexes and searched along with the data in the document itself. The data does have to be exposed to work, but it's possible now

Ad-Hoc Query Paging in Sqlserver 2012

Ad-Hoc Query Paging:

Paging results in SQL Server has been discussed for years. The Order By option in the SQL SELECT statement has been enhanced in SQL Server 2012. Using a combination of OFFSET and FETCH along with ORDER BY gives you control of paging through a result set. Using this technique can really help performance by bring back only the results you want to show to your users when they are needed. The following TSQL code runs against the Person table in the AdventureWorks sample database (available from Microsoft). In the sample query below, SQL Server would return 10 records beginning with record 11. The OFFSET command provides a starting point for the SELECT statement in terms of paging, and the FETCH command provides how many records to return at a time.

SELECT BusinessEntityID, FirstName, LastName FROM Person.Person ORDER BY BusinessEntityID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

Drag & Drop Feture using HTML 5

I like personally this new interesting feature, two years back i was done  manually through javascript by using list in html and took time. Now in HTML 5 made very simple.

New Features in HTML 5

- New feaures should be based on HTML, DOM, CSS3 and Javascript
- Reduce the need of external plugins (like flash)
- Better error handling
- More markup to replace scripting
- HTML 5 should be device independent.

T-SQL Rediscovered with SQL Server 2012

SQL Server 2012 introduces a plethora of the new enhancements in T-SQL. With newly introduced syntax the code of the 100s lines can be reduced to merely few lines. By converting the old T-SQL syntax to new T-SQL syntax one can immediately get enormous performance improvement. This session will cover T-SQL tips and tricks which will make writing the code more fun!

Sync Fushion Grid Control

i have come across situation like to increase the performance Sync fusion
Grid control. for that have tried all our asp.net datasource. but we couln't able to
increase. finally found Sync fusion control itself having data source object (Grouppassdatasource).

Grouppassdatasource:

which will connect from datacontext.

Datacontext.

you have to create using link to sql data file (deml extension).

Sync fusion datasource name is GroupPassdatasource

Note: GroupPassdatasource should be with update panel

Motion Framework in Infragistics

Infragistics come up with the new technology called "motion frame work". which will give the full feature of visualization of the data in the impresive manner and animated experience.

It will be mainly used across the Silver light and wpf data visualization applications.

Running earlier version of Existing application in VS 2010.

Microsoft come with new option to build the existing application. I am really love to learn the new building option. It's really a simple step to complete the existing
lower version ( for example .net 2.0) application to building in the Visual studio 2010. Thanks to microsoft. The below element have to implement in the web.config file with the version details.

Element Name: in application configuration file.

URL Mapping in Visual studio 2010

visual studio come up with new feature called url mapping

There is method called "Response.RedirectPermanent()" will be used to map the url instead of using web.config method in the earlier version of Visual studio.

Visual Studio 2010 Part 1

I have been to VS 2010-ALM finals at Taj Residency in Bangalore. It’s really a very informative and fun session. I am just writing in my blog to share with you all. Let‘s talk about the speaker.
His name is Teju’s from Microsoft Bangalore. He is a great Man and great attitude and more over is active and young. He has shown many features with us about visual studio 2010. Let’s talk one by one.

My view of session it was great and very informative. Really visual studio 2010 will rock soon all your system. Now we have Beta. Try the nice feature and rock.Carrier perspective it’s going to create lot of opportunities. Really you will love it and do it.

Microsoft comes up with the different packages for Visual studio 2010.
Visual Studio 2010-Ultimate.
This is comprehensive suite of application life cycle management tools for teams to ensure quality results from design to development.

Visual Studio 2010- Premium.
A complete tool set for developer to deliver scalable high quality applications.

Visual Studio 2010- Professional.
This is essential tool set for doing basic development tasks to allow developers to implement their ideas easily.

Visual Studio Test Elements-2010
This is separate tool apart from vsts 2010. This is specifically for the tester.
VSTS 2010 had plenty of improvements and new features. Let’s talk about some coolest and hottest feature.

Debugging and diagnosis:
1) Intelli trace.
a. It’s one of the best feature ever never heard from any other development areas.
This is give you exact definition about the problem. When we have situation like in production environment user’s are having some issues but not having in the other environment. That time only our Intellin trace comes in to picture.

2) Static Code Analysis.
It’s one of the coolest features. Using this tool can define the best practices of the code.
If you not followed the best practices and build will fails.
3) Code Metrics.
User can see the chart level description about the code.
4) 64 Bit Support.
5) Break point Improvement.
a. Filtering
b. Label attachment for each break point.
Architectural Complaints:
1) Layer Diagram:
This is one of the nice features once you assign the layer for the solution. It should stick on that.
2) One shot all dependencies can show.
3) UML Added.
WPF Improvements:
1) Touch Input can possible now.
2) Added new controls like Data grid and Date Picker.
Deployment:
1) One click deployment as like as f5.
Silver light:
1) Siliverlight template added.
Chart Controls
Now in vs2010 added chart control no need to use other third party controls. it available.
Also supports 3D.
Cloud Application
It’s possible with Window Azure.
Share Point
Now we have the project template for share point. All the manipulation can be done through this.
Team Foundation Server:
1) Gated check in.
It’s really coolest feature and user friendly to do it. There is a situation like developer always breaks build. For that we have gated check in to restrict to check in.
2) Self test.
Data can be saved temporarily not in the server location.
3) TFS-Web
Now also can see who is working what like that information can trace from anywhere else.
4) Packages
Now we are able to create packages. Maintainability is good.
Now parent and child hierarchy are available
Branch creation and merging are available.
Database Development:
1) Import schemas.
2) Synchronization available with offline and online.
3) Refactoring database.
Testing
It support’s manual and automated. This is separate development environment.
1) Unit Test wizard.
2) Data driven test.
3) Code coverage.
4) Test impact analysis.
5) Coded UI test with record UI functionality as like mercury and more than.
This is just introduction part. Hope will see many articles about VS2010.

Webservices using Silverlight 2.0

In silverlight can't connect directly to the database. it can only connect through webservices.
Before connecting to webservices. we should aware of security, data integrity, binding, performance.
using silverlight user connect diferent services.the services are webservice, WCF service and REST.
hope know about webservice and wcf, so all are asking about REST. Rest means RePresentation of state transition.
through webclient and httpwebrequest can connect and get the response.
usually webservices can connect through http. while connecting you have to maintain the thread. it's should
run with in thread only. if you not connect through proxy. you should maintain the thread. other wise it would
be problem.
Method 1:
Calling ASMX webservices.
Step 1:
Create asmx webservice and in to silverlight application as a service reference.
Step 2:
ADD namespace in the using section.
Step 3:
Get path of asmx file through this method.
public string GetURLforResource(string resourcePage)
{
string webURL = HtmlPage.Document.DocumentUri.ToString();
string containerPage = webURL.Substring(webURL.LastIndexOf("/") + 1);
return webURL = webURL.Replace(containerPage, resourcePage);
}

Step 4:
Call webservice through this. string webServiceURL = GetURLforResource("WebserviceTest.asmx");
BasicHttpBinding binding = new BasicHttpBinding();
WebserviceTestSoapClient webSVC = new WebserviceTestSoapClient(binding,new EndpointAddress(webServiceURL));
webSVC.HelloWorldCompleted += new EventHandler(webSVC_HelloWorldCompleted);
webSVC.HelloWorldAsync();

also for the method has to create the eventhandler.
Step 5:
This is the event handler to display the result of the webservice method.
void webSVC_HelloWorldCompleted(object sender, HelloWorldCompletedEventArgs e)
{

HtmlPage.Window.Alert(e.Result);
}

Method 2:
Calling WCF service.
Everything same as like the above. one thing must to do in web.config.
while creating wcf it will add automatically binding as wsHttpBinding instead of that
have to modify basicHttpBinding.
Method 3:
Coming soon










-

Navigation between XAML Pages using Silverlight 2.0

Before going in to navigation one thing keep in mind there is no direct way for navigating the xaml files in Silverlight 2.0.
Ok fine let's start our navigation journey. I have two ways to navigate between the xaml files.
let me explain one by one.
# Method 1: Using App.XAML
Step 1:
There is a Application_startup event in App.XAML which will decide the initial load page.
Before that comment all the line in this method. (Example://this.RootVisual = new Page();)
Here in this have to do some little trick.
Step 2:
Declare one public Grid outside the event.
like this: public static Grid root;
and then write this code in the application Startup event.

private void Application_Startup(object sender, StartupEventArgs e)
{
root = new Grid();
root.Children.Add(new Login());
this.RootVisual = root;
}

here only we are adding Grid as a parent control. under that we have xaml page.
Step 3:
Create one more method for navigation.
public static void Navigate(UserControl newPage)
{
UserControl oldpage = root.Children[0] as UserControl;
root.Children.Add(newPage);
root.Children.Remove(oldpage);
}
This is the method will navigate one xaml to another xaml. Basically it's just removing the old page and adding new page.
The above all three steps only in the App.XAML file.
Step 4:
Now come to Login.Xaml, this is the inital page which will load from App.XAML.
After successing the login user has to navigate to productlist page.
The below code will navigate to product list page.
private void Login_Success_Click(object sender, RoutedEventArgs e)
{
App.Navigate(new Product());
}


#Method 2:
This is better approach compare to above.
In the silverlight application should have two files.
1) App.XAML2) Master.XAML
here in Master is the common file which will navigate the files through this.
let me go through step by step:
Step 1:
In the application_startup event load the Master.XAMl (Remove Automated code)
private void Application_Startup(object sender, StartupEventArgs e)
{
this.RootVisual = new Master();
}

Step 2:
In the master page clear all the content except usercontrol tag.
<UserControl x:Class="SilverlightThird.Master" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Width="400" Height="300"> </UserControl>
Step 3:
In the code behind of Master page write the below code.
public partial class Master : UserControl
{
public Master()
{

InitializeComponent();
if (this.Content == null)
{
this.Content = new Login();
}
}

public void Navigate(UserControl Nextpage)
{
this.Content = Nextpage;
}
}

Step 4:
Now come to Login.xaml file.
In the success method of login.xaml.cs file write this below it will navigate.

hope this will help.

Custom Fonts in Silverlight 2.0

Hi all today i have learned something called custom fonts in silverlight 2.0.
it's really surprising me, it's very good feature.
follow the below stpes to create custom fonts in silverlight 2.0

Step1:
Create one silverlight applicaton. mean while get ttf extension file name.
Note: ttf is the extension for font.
step2:
Add atleast one ttf file in to our project folder
Example:webdings.ttf
step3:
after adding in to our project. add the code like the below in example.
then you will get the custom fonts in your browser.
Syntax:
FontFamily="Font_File_Name#Font_Name”
Example:
<TextBlock FontFamily="webdings.ttf#webdings" Text="Test"> </TextBlock>

Note:font_file_name and font_name is different except few.
if you give correct font_name then only it will work.

Accesssing Client bin Images in XAML.

In the client can not only xap file also can contain images. Those images can acccess from silverlight application.


Client Bin
Bluehils.jpg
imageaccess.xap

the above two files are there in the client bin.


if you want to access that image have to simple thing.


<Image Source="/Bluehills.jpg"> </Image>


Note:"/"