Surya Prayaga

Office 2010 Web Apps

2010-06-22T05:26:00Z

It Has been almost 1 and half year i have been out of blogging in asp.net due to ill health. So i missed my writings on visual studio 2008 though i worked on it. Now as i gained experience on Visual studio 2010 and had a research on it and done projects i'm thinking to post some of my research stuff on 2010 applications. Here it starts with Office 2010 Web Apps.

                  When the likes of Google Docs and Zoho were born and strutted the prowess of their very able online word processor and spreadsheet applications, some of us not only applauded but also began to scamper off in that direction. The newbie’s were free, offered collaborative working, and they got the job done. Period. Never mind, if page formatting went for a toss. Or, you had compatibility issues, very limited functionality, or took time to re-learn… Many people appreciated the new simplicity. Yet, many didn’t...
                 You couldn’t expect Microsoft to sit pretty and watch upstarts impinge on its home turf. So, turning adversity into opportunity, the world’s biggest software company has just fired its first salvo of online productivity applications in the cloud. Called Microsoft Office 2010 Web Apps (www.office2010. microsoft.com), this gives you free online versions of the very familiar Word, Excel, PowerPoint, and OneNote application. These web programmes allow you to create, view, edit or share your Office documents from virtually anywhere — whether you have Office on the computer that you are using at the time or not. All you need is a Windows Live ac-count, a supported browser and an Internet connection. For storage, you automatically get to use Windows Live SkyDrive, Microsoft’s 25GB free online storage space.
                But now don’t get greedy and expect all the plush, rich functionality that you see in the full-blown desktop versions of these programmes. The web versions offer sufficient features to satisfy the majority of us.
Issues like conflict resolution, when two or more users are working on a document together have also been dealt with. Therefore, instal-ling Silverlight (Microsoft’s web application framework that provides a rich media experience on the Web) en-hances the user experience and improves image rendering, but is not necessary to run Office 2010 Web Apps.
               Apart from several nifty new features, what is really nice is the fact that Micro-soft Office 2010 works very smoothly in tandem with SkyDrive, allowing you to save documents directly to this personal virtual drive in the cloud. (If you want to take it for a spin, go to http://is.gd/cucbJ.) In fact, if you want to save a file on SkyDrive, you don’t even have to save your file on to your PC first; you can save it directly to the SkyDrive.
               The giant from Redmond is also working hard and ambitiously to make your SkyDrive resident Office documents accessible (and editable) to your cell phone. While this works perfectly over WiFi and over 3G, what happens over an ordinary EDGE/GPRS connection can be anybody’s guess.
Overall, good going Microsoft… Your move, Google!

Simple search engine for your website

2007-12-13T03:33:00Z

I observed people implementing website search by using google API's or other third party dll's. This is a simple site search engine to search all the images , files ,... in a website without using any third party's like lucene , google. Previously I worked on lucene where i implemented both desktop and database search. But i thought depending on a third party doesn't gain much knowledge. So i've implemented a simple search using regular expressions.

Architecture of the search engine :

I'm using 5 classes here. Here is the class diagram

CleanHtml.cs : This is used to clean the file of HTML Tags
Page.cs : Page class to store data of individual files on the website
PageData.cs : Defines shared methods to create and add records to dataset
Site.cs : Properties of this class are used to store configurations and data of the entire site
Usersearch.cs : This class contains all the search function methods.

Design and Implementation :

Here the design interface is inspired by google where I'm using a simple textbox where I'll be giving the input i.e., my search keyword. There are 3 option where i will be searching through phrases, senteces and words.

The input which has been given will be passed as the input to the below method which is an instance of UserSearch inside the code.

private Searchs.UserSearch SearchSite(string strSearch)

{

Searchs.UserSearch srchSite;srchSite = new Searchs.UserSearch();

srchSite.SearchWords = strSearch;

..........

}

Now the search will be looped into all the folders and files in the project and returns the search results which I'm displaying in a list with the url of the file.

Webconfig :

In the webconfig I'm keeping restrictions for the search like what files to search , what files not to search etc,...Check below

<add key="BarredFiles" value="adminstation.htm,no_allowed.asp,AssemblyInfo.vb,Global.asax,Global.asax.vb,SiteSearch.aspx"/>

This is the basic functionality of my search.In this article I'm posting the complete project. If any comments they are welcome.

Regards,

Surya.

Encrypting URL

2007-11-14T03:44:00Z

The main idea of building a ASP.NET website is to provide security. Keeping this in mind i have written an encryption class where we can encrypt a particular url and hide the parameter value.

For ex : abc.aspx?id=2 will be encrypted to abc.aspx?id=[encrypted value].

Note:

To protect your site from errors or sql injections better pass the queries as stored procedures.

Here is the class for encryption :

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Specialized;

using System.Collections;
/// <summary>
/// Summary description for QueryStringEncDecryption
/// </summary>
public class QueryStringEncDecryption : NameValueCollection
{
private string document;

    public string Document
    {
        get
        {
            return document;
        }
    }
public QueryStringEncDecryption()
{
  //
  // TODO: Add constructor logic here
  //
}
    public QueryStringEncDecryption(NameValueCollection clone)
        : base(clone)

{

        }
    public static QueryStringEncDecryption FromCurrent()
    {
        return FromUrl(HttpContext.Current.Request.Url.AbsoluteUri);
    }
    public static QueryStringEncDecryption FromUrl(string url)
    {

string[] parts = url.Split("?".ToCharArray());

QueryStringEncDecryption qs = new QueryStringEncDecryption();

qs.document = parts[0];

if (parts.Length == 1)

return qs;

string[] keys = parts[1].Split("&".ToCharArray());

foreach (string key in keys)
{

string[] part = key.Split("=".ToCharArray());

if (part.Length == 1)

qs.Add(part[0], "");

qs.Add(part[0], part[1]);

}

return qs;

}

public void ClearAllExcept(string except)
{

ClearAllExcept(new string[] { except });

}

public void ClearAllExcept(string[] except)
{

ArrayList toRemove = new ArrayList();

foreach (string s in this.AllKeys)
{

foreach (string e in except)
{

if (s.ToLower() == e.ToLower())

if (!toRemove.Contains(s))

toRemove.Add(s);

}

foreach (string s in toRemove)

this.Remove(s);

}

public override void Add(string name, string value)
{

if (this[name] != null)

this[name] = value;

else

base.Add(name, value);

}

public override string ToString()
{

return ToString(false);

}

public string ToString(bool includeUrl)
{

string[] parts = new string[this.Count];

string[] keys = this.AllKeys;

for (int i = 0; i < keys.Length; i++)

parts[i] = keys[i] + "=" + HttpContext.Current.Server.UrlEncode(this[keys[i]]);

string url = String.Join("&", parts);

if ((url != null || url != String.Empty) && !url.StartsWith("?"))

url = "?" + url;

if (includeUrl)

url = this.document + url;

return url;

}
}

This is just the prieview of the encryption class. We will also be having an other class for Encryption which i'm posting as an attachment. Using these two classes you can encrypt ur URL.

Starting off my first blog entry by thanking asp.net developers team!

2007-10-13T03:21:00Z

I like to thank the complete asp.net developers team for giving me this oppurtunity to be a part of their blogging community.Its an amazing oppurtunity to express our ideas and share them with all the viewers.It took a while for me to start of this blog because of my busy schedule.I assure that I will give my best.