Codeanswer

Covid - 19 (Coronavirus) - live Update -

2020-03-19T04:57:00.002-07:00

Action Method in Mvc

2016-10-18T03:25:00.001-07:00

In this section, you will learn about the action method of controller class.

All the public methods of a Controller class are called Action methods. They are like any other normal methods with the following restrictions:

Action method must be public. It cannot be private or protected
Action method cannot be overloaded
Action method cannot be a static method.
The following is an example of Index action method of StudentController

Action Method in ASP.NET MVC
Action Method
As you can see in the above figure, Index method is a public method and it returns ActionResult using the View() method. The View() method is defined in the Controller base class, which returns the appropriate ActionResult.

Default Action method:

Every controller can have default action method as per configured route in RouteConfig class. By default, Index is a default action method for any controller, as per configured default root as shown below.

Default Route:

routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}/{name}",
defaults: new { controller = "Home",
action = "Index",
id = UrlParameter.Optional
});

However, you can change the default action name as per your requirement in RouteConfig class.

ActionResult:

MVC framework includes various result classes, which can be return from an action methods. There result classes represent different types of responses such as html, file, string, json, javascript etc. The following table lists all the result classes available in ASP.NET MVC.

Result Class	Description
ViewResult	Represents HTML and markup.
EmptyResult	Represents No response.
ContentResult	Represents string literal.
FileContentResult/ FilePathResult/ FileStreamResult	Represents the content of a file
JavaScriptResult	Represent a JavaScript script.
JsonResult	Represent JSON that can be used in AJAX
RedirectResult	Represents a redirection to a new URL
RedirectToRouteResult	Represent another action of same or other controller
PartialViewResult	Returns HTML from Partial view
HttpUnauthorizedResult	Returns HTTP 403 status

The Index() method of StudentController in the above figure uses View() method to return ViewResult (which is derived from ActionResult). The View() method is defined in base Controller class. It also contains different methods, which automatically returns particular type of result as shown in the below table.

Result Class	Description	Base Controller method
ViewResult	Represents HTML and markup.	View()
EmptyResult	Represents No response.
ContentResult	Represents string literal.	Content()
FileContentResult, FilePathResult, FileStreamResult	Represents the content of a file	File()
JavaScriptResult	Represent a JavaScript script.	JavaScript()
JsonResult	Represent JSON that can be used in AJAX	Json()
RedirectResult	Represents a redirection to a new URL	Redirect()
RedirectToRouteResult	Represent another action of same or other controller	RedirectToRoute()
PartialViewResult	Returns HTML	PartialView()
HttpUnauthorizedResult	Returns HTTP 403 status

Action method Parameters:

Every action methods can have input parameters as normal methods. It can be primitive data type or complex type parameters as shown in the below example.

Example: Action method parameters

[HttpPost]
public ActionResult Edit(Student std)
{
// update student to the database

return RedirectToAction("Index");
}

[HttpDelete]
public ActionResult Delete(int id)
{
// delete student from the database whose id matches with specified id

return RedirectToAction("Index");
}

Action method parameters can be Nullable type.

By default, the values for action method parameters are retrieved from the request's data collection. The data collection includes name/values pairs for form data or query string values or cookie values. Model binding in ASP.NET MVC automatically maps the URL query string or form data collection to the action method parameters if both names are matching. Visit model binding section for more information on it.

ASP.NET MVC Version History

2016-10-18T03:19:00.001-07:00

Microsoft had introduced ASP.NET MVC in .Net 3.5, since then lots of new features have been added.

The following table list brief history of ASP.NET MVC.

MVC Version	Visual Studio	.Net Version	Release date	Features
MVC 1.0	VS2008	.Net 3.5	13-Mar-2009	MVC architecture with webform engine Routing HTML Helpers Ajax Helpers Auto binding
MVC 2.0	VS 2008,	.Net 3.5/4.0	10-Mar-2010	Area Asynchronous controller Html helper methods with lambda expression DataAnnotations attributes Client side validation Custom template Scaffolding
MVC 3.0	VS 2010	.Net 4.0	13-Jan-2011	Unobtrusive javascript validation Razor view engine Global filters Remote validation Dependency resolver for IoC ViewBag
MVC 4.0	VS 2010 SP1, VS 2012	.NET 4.0/4.5	15-Aug-2012	Mobile project template Bundling and minification Support for Windows Azure SDK
MVC 5.0	VS 2013	.NET 4.5	17-oct-2013	Authentication filters Bootstrap support New scaffolding items ASP.Net Identity
MVC 5.2 - Current	VS 2013	.NET 4.5	28-Aug-2014	Attribute based routing bug fixes and minor features upate

Angular Tutorial - Part 1: Introduction to Angular.js

2016-10-13T08:14:00.003-07:00

In this article we will look at the basics of Angular.Js. This is the first part of an article series. The main objective of this series is to learn about Angular and see how Angular helps us in developing more flexible, maintainable and testable client side web applications and that too without compromising with the productivity.

Link to complete series

Angular Tutorial - Part 1: Introduction to Angular.js
Angular Tutorial - Part 2: Understanding Modules and Controllers
Angular Tutorial - Part 3: Understanding and using Directives
Angular Tutorial - Part 4: Understanding and implementing Filters
Angular Tutorial - Part 5: Understanding and implementing Services
Angular Tutorial - Part 6: Building and Validating Data Entry Forms
Angular Tutorial - Part 7: Understanding Single page applications and Angular routing
Background
If we take a look back in time and see how our software applications have evolved then we can clearly see how the application development and development model has evolved. Almost two decade ago most software applications were getting built as standalone applications. These applications were targeted at a single user and ran on their operating systems.

Then came the need to share data across multiple users and a need to store data at a central location. This need gave birth to distributed applications. Distributed applications ran as standalone applications on the user’s machine giving him a rich user interface (les call it desktop like experience) to work with, and behind the scenes, these applications sent data to a server.

Read More

Introduction to Angular

2016-10-13T08:13:00.000-07:00

Introduction to Angular
So what is Angular, and why would you want to use it? The simplest answer to that question is that Angular is a JavaScript library, but it's so much more than that. It's probably more accurate to categorize it as an MV* framework. Angular isn't just an MV* framework, it's an opinionated MV* framework. What is opinionated software? Well, opinionated software guides you into certain ways of doing things. Opinionated software has a vision. It may limit itself to solving fewer problems, but generally, software with opinions solves those problems with less fuss. That doesn't mean that there isn't more than one way to solve a problem with Angular. For example, take DOM manipulation. Angular wants you to only manipulate your DOM inside of directives, but with Angular, inside of a directive you can use jQuery, Zepto, any other library, or even just raw JavaScript to manipulate your DOM. That doesn't mean that you can't manipulate the DOM from within any other piece of an Angular application, but Angular definitely has an opinion about whether or not you should, and it gently guides you into doing things a certain way.

Let’s make sure that we understand exactly what an MV* framework is.

Read More

TaskTimer, Reducing Your Exposure To The Internet

2016-10-13T08:11:00.002-07:00

Introduction
Internet is a great tool, but it often distracts us. This can be said of computer clutter in general--all the icons and files in close proximity make it too easy for us to dart off into an unexpected adventure. TaskTimer is a tool to limit our exposure to the distractions by tempering our access to the internet and by periodically reminding us to focus on a chosen task. It appears as a tray icon and is completely configured in one step by setting a desired nag message, the approximate frequency with which you'd like to see the nag message, and, finally, the target internet adapter (e.g. Wi-Fi) you'd like for the program to turn on and off, based on your needs.

Turning on TaskTimer will block all access to your immediate network, including your internet connection. Then, until you close the application, you will only be able to access the internet for the limited amount of time that you request for your internet goal. Likewise, there is additional functionality to encourage staying focused on non-internet goals as well. Exiting TaskTimer will re-enable your internet access.

Background
It is well known that webpages and advertisements are designed to maximize our exposure to marketing material. Users may not even notice how much time they engage with content they never planned to consume. The result is hours upon hours of wasted time every day--hours that could have been spent productively enhancing one's skill set or one's social connections. The first step in making changes for the better is to understand and accept this potential challenge.

Currently, there is no stand-alone solution to the problem of internet overindulgence. There are multiple websites that offer to keep track of your time online--even services that store a log of tasks you worked on--but these are still services, interested in keeping you online and not offline. TaskTimer takes the alternative approach that only freeware could take in that it asks for no contribution at all from the user. It respects the users decision about being offline, and enforces the user's intended goal of being online for only a limited amount of time, after which the internet gets shut off, prompting a re-examination of whether it's worth it for the user to continue browsing.

Using the code
Written in C# .NET Framework 4.0, the code for TaskTimer is attached as a Visual Studio project. Although currently fully-functional, it's highly likely that one may desire some additional feature(s), in which case they should feel free to change / enhance TaskTimer.

The core functionality uses System.Timers.Timer to monitor for changes every 15 seconds. Upon launching the application, ApplicationContext.cs stores the user's current internet configuration (IP address, etc.) into container class InternetDetails.cs. The user interface, Form.cs, displays the list of internet adapters in your computer that could be controlled by the program. The user is encouraged to store their settings before closing the initial popup window, although it is possible to close the UI and the program by selecting "Close Program" from the icon created in the task-bar. Pressing the "Save and Turn Off Internet" button will, indeed, turn off internet access.

By Reference

Using .NET libraries from JAVA

2016-10-13T08:05:00.002-07:00

Recent popularization of net offerings seems to resolve virtually any interoperability issue between JAVA and .Web programs because of platform independence and universal transport channel. And that is actual, the pliability and universality of internet offerings founded options in mixture with good-defined requisites makes this technology a winner in virtually eighty% might be even ninety% of cases. However fairly there are no cons?

Of direction there are and circumstances unresolvable with internet carrier come out on occasion in many crucial initiatives. The major purpose why internet offerings does no longer slot in each case is regularly performance, protection and development costs. The determination the right way to clear up these disorders mostly relies on system architects and it might be probably the most essential choice in challenge entailing quite a lot of specific consequences.

How you can identify in case your case will have to be solved with net offerings?

If you are the one to make a decision you must recollect as a minimum following aspects. Let’s say we now have .Web library with some legacy business common sense or relevant encryption/buying and selling algorithm or .Net simplest API to corporate CRM, here is how we could analyse this:

examine in case your requirement is worth constructing dedicated customer-server infrastructure. Will you ought to run go desktop executions? Don't forget that net provider is consumer server. In our case we might must construct web provider on .Internet side and wrap selected approaches in our WCF SVC or ASMX interface. If it’s just one approach and dll located on the identical laptop as our JAVA software is it worth to host internet server and consume it on neighborhood host? Obviously not.
Examine if you could have enough money it. Each web provider name has rather colossal overhead on each request message if we use xml protocol every easy approach is wrapped in xml envelope and handed in http request ingesting internet server resources, and together with all different delays of transport channel, serialization/deserialization and internet request processing correctly if it is trading algorithm that locations transactions on currency trading or inventory market we must restrict it… identical in all other circumstances have been we make various requests in short time or we just rely on speed we must now not add that so much of buzz into our communication.
Investigate if it’s no longer too simple. If the library that we use comprises single system for encrypting or calculating anything, must we make: web provider, consumer, host web server, permit http conversation, build .Web net mission simply to load one approach from one dll and get in touch with it as soon as in lifetime of our JAVA challenge? No.
Investigate if it’s now not too elaborate. Regularly the amount of code that we need to reuse in JAVA could be oppositely too massive. Wrapping countless numbers of methods in web carrier and passing hundreds of execution places by way of web provider customer would rate us rather a lot in progress and additional maintenance. Simple illustration would be the case were we want to construct JAVA software with WPF interface, i will be able to’t assume exposing all WPF framework classes by way of internet offerings enforcing call-backs and constructing out of it responsive UI.

We could anticipate that up to now we have now determined if our solution must and would be implemented with net offerings interoperability technique, but what must we do if it does now not fit in there? Most of builders most often don't meet such problems but as a result if they do it’s rough to find a excellent solution. It is not that effortless to get JAVA and .Web work collectively by way of our possess, with out spending for it extra time than entire our undertaking is deliberate for. And of course we must remember that it isn't a excellent apply to reinvent the wheel.

What are the possible choices to make use of .Internet libraries from JAVA application?

Most of us does no longer comprehend that there are some native JAVA to .Web bridges to be had in the marketplace whereas these solutions does exactly this what web carrier does not so they fill our gap of 20% circumstances perfectly.

Native JAVA to .Net Bridge leverages JAVA native methods invocation capabilities with native platform exact verbal exchange channels and direct invocations on .Web objects. In this approach we get .Net procedure being hosted natively for our JAVA utility giving us entry to any .Internet library directly from JAVA code like they were native JAVA objects. When you consider that of direct invocation passing between tactics we get instant execution with out delays, overhead and further infrastructure.

Moreover we get a few additional advantages, these are: efficient call-backs mechanism if you want to with no trouble subscribe cross platform movements, entry to any .Net library without any wrappers and implementation on .Web side, lifecycle of objects and methods bound into one runtime and no client server solutions accordingly no additional side merchandise to keep and display.
JAVA to .Internet interop market is not large. There are simplest few carriers who managed to supply efficient and flexible adequate solutions that could be nontoxic for initiatives of any measurement.

Picking out proper bridge will have to be pushed by using simplicity of usage, performance and flexibility. This year there used to be new answer launched called Javonet. It appears to be very appealing because of a number of causes. The mission was once firstly born as tutorial study for object database techniques at Polish-jap Institute of information science. From very beginnig it was aimed on high efficiency.

For the duration of commercialization it was improved with very programmer-pleasant API and many valuable aspects. Javonet offers access to any .Net library nonetheless it's customized, part of .Net framework or delivered by using 1/3 celebration firms. There aren't any changes in .Net code required and libraries can be loaded from neighborhood directories or GAC. And it supports both x86 and x64.

Having entry to any library instantly we are able to just reference them from our JAVA code and work on objects and courses from such library like they have been native JAVA objects. Javonet API exposes specified NObject variable for JAVA which works as manage to .Net object. For the reason that all invocations and references are performed in runtime we will initialize and make use of any object, process, property or discipline making use of reflection-type syntax by way of supplying names in steady strings.

JAVA to .Web bridge like Javonet handles internally rubbish collector moves and exceptions with a purpose to seize .Internet exceptions on JAVA side and if our NObject control is collected on JAVA aspect corresponding object will get disposed on .Net aspect as good. All these points makes such bridging resolution a huge leading edge technological know-how that gives you us all-in-one framework for making use of .Net code from JAVA.

The possibilities of these options are worth exploring as high efficiency and easy utilization results in new strategies of how we would apply this in our tasks. In tutorial and samples we will read step by step publications make full JAVA software with WinForms or WPFinterface or how you can lengthen .Internet category in JAVA, typically even for tremendously experienced builders these sort of solutions looks like magic.

I totally encourage all JAVA builders to become aware of and test these solutions to preserve in intellect new choices how CLR and JVM interoperability issues would be resolved in state-of-the-art world.

SOLVING EQUATIONS WITH EXCEL

2016-10-12T05:47:00.002-07:00

Excel and Lotus software are equipped with functions that allow the user to identify the root of an equation. By root, we mean the values of x such that a given equation cancels itself out.

Let us consider the case where we wish to obtain the root of the function

			2		3	4,
i.e., solve the equation					. You will see in the following illustration,
that the first step of all	Excel solutions is to correctly define the function we want to find
that the first step of all	2	3	4	0

the root of, and to assign the variable to one specific cell.

We assigned the cell B1 to contain the value of variable x. In cell B2, we define the function. Note that B1 plays the part of in the formula. By inserting values in cell B1, you will notice that the result of the function will change. Therefore, finding the root of a function implies finding the value of such that the function is zero. Our goal is to have cell B1 vary (the value of x) until the cell B2 (that contains the value of the function) is 0.

It would be too long to find an answer by trial and error. Select in Excel the function Solver (Tools menu). The following dialog box will appear.

Set Target Cell: we ask you to identify the position of the function you wish to carry out an operation on. In our example, the function was placed in cell B2.

Equal to: To identify the operation you wish to carry out with the function located at B2 (max ? min ? value ?). We want the function to take on the value 0.

By Changing Cells: To identify cells that contain the variables of the function. In our example, B1 is the cell containing the value of x.

By clicking on Solve, Excel will execute the operation you asked it to and will give you the solution x = 0,85078105.

One of the limits of the Excel Solver is that it will only give one root even though we know there is a second one. For now, we use the discriminant

	√	4
	√	4
That gives the second root (	2	).
	2,35078108

Unfortunately, the discriminant will be of no use with other types of functions and we will not be able to count on it to help us.

Exponential and logarithmic equations using Excel

Besides for finding the root of polynomial equations, the Excel Solver can solve equations containing exponential or logarithmic functions. The software will be all the more useful in this case since solving this type of algebraic equations is often impossible. For example, there are no solution methods that will find the value of such that the equation 4 is solved. The method to follow will be identical to the one presented in the case of roots, except for the following detail : the equation must be rewritten so that all terms are regrouped on the left side of the equality. For example, instead of resolving the equation 4 , we want the solution of 4 0.

Example

Solve the following equation with the help of the solver:

4 .

Solution

Firstly, we need to rewrite the equality so that the terms are regrouped on the left side :

4 0. Then, it is important to correctly define the equation we want to resolve, as well as attributing the variable to a specific cell.

Once again, we have designated the cell B1 to contain the value of the variable . The cell B2 contains the expression equal to 0. It is defined in function to B1, which substitutes the variable .

Select in Excel the function Solver (Tools menu). A dialog box will appear in which you need to fill in information.

Equal to: To identify the operation you wish to carry out with (max ? min ? value ?).

Variable cells: To identify cells that contain the variables of the function. In our example, B1 is the cell containing the value of x.

Target cell to define: the function was placed in cell B2.

Equal to: We want the function located in B2 to take on the value 0.

Variable cells: B1 is the cell that will contain the value of .

By clicking on Solve, Excel will execute the operation you asked it to and will give you the following answer:

The value of		makes the equations			true. Let us recall though
that Excel only	gives one solution to any given equation, even though it may have more
that Excel only	0,35740306			4
than one. A second solution		exists when			, as is indicated in the
following image:			2,15329217

The techniques allowing us to find these other solutions will be the subject of future discussions.

Exercise

With the help of Excel, find at least one value of x such that the following equations are satisfied.

a)	ln	2
b)
c)	ln 1
		2
d)	√
	ln	3

Solution

a. 1,68957994

b. 0,76822112

c. 0,44754188

d. 0,82461277

OepnRowSet Example

2016-03-17T03:03:00.001-07:00

DECLARE @WorkingTempTbl Varchar(20)
SET @WorkingTempTbl = 'FL_HUM_Census';

DECLARE @SourceFileName Varchar(200)
SET @SourceFileName = 'D:\JSAOBDSL_2015-06-01'

DECLARE @SqlTempTbl varchar(MAX)

SET @SqlTempTbl = '
Insert into ' + @WorkingTempTbl + '(
RECORDTYPE)
Select RECORDTYPE from OPENROWSET( BULK ''' + @SourceFileName + ''' ,FORMATFILE = ''D:\GetRowCount.xml'')'

Exec @SqlTempTbl

BULK INSERT FL_HUM_Census
select * FROM 'D:\JSAOBDSL_2015-06-01.csv'
WITH (FORMATFILE = 'D:\JSAOBDSL_19cols.xml');
GO
SELECT * FROM FL_HUM_Census;
truncate Table FL_HUM_Census
GO

INSERT into FL_HUM_Census
SELECT * FROM OPENROWSET
( BULK 'D:\Sample_OpenRowSet\JSAOBDSL_2015-06-18.csv',
FORMATFILE = 'D:\JSAOBDSL_19cols.xml',FIRSTROW = 2)t;

Select * from ETLTableMetaData
Select * from ETLTables

SQL Server db_executor role to grant execute permission

2016-03-17T02:37:00.002-07:00

Recently I was answering to a question on a SQL Server public forum, 
that how to grant only execute permission on a database for some users? 
Yes, It’s very easy to grant execute permission to a user but somehow I 
feel there should have some built-in roles like db_datareader or 
db_datawriter for the same? Anyway it’s not that difficult to create 
one. Let’s create a role and name it db_execproc, then add role-members.

USE [DBA] --Change the database name

GO

--It will drop the role if it is already exists.

DECLARE @RoleName sysname

set @RoleName = N'db_execproc'

IF @RoleName <> N'public' and (select is_fixed_role from sys.database_principals where name = @RoleName) = 0

BEGIN

    DECLARE @RoleMemberName sysname

    DECLARE Member_Cursor CURSOR FOR

    select [name]

    from sys.database_principals 

    where principal_id in ( 

        select member_principal_id

        from sys.database_role_members

        where role_principal_id in (

            select principal_id

            FROM sys.database_principals where [name] = @RoleName AND type = 'R'))

    OPEN Member_Cursor;

    FETCH NEXT FROM Member_Cursor

    into @RoleMemberName

    DECLARE @SQL NVARCHAR(4000)

    WHILE @@FETCH_STATUS = 0

    BEGIN

        SET @SQL = 'ALTER ROLE '+ QUOTENAME(@RoleName,'[') +' DROP MEMBER '+ QUOTENAME(@RoleMemberName,'[')

        EXEC(@SQL)

        FETCH NEXT FROM Member_Cursor

        into @RoleMemberName

    END;

    CLOSE Member_Cursor;

    DEALLOCATE Member_Cursor;

END

/****** Object:  DatabaseRole [db_execproc]    Script Date: 3/5/2016 8:40:20 PM ******/

DROP ROLE [db_execproc]

GO

/****** Object:  DatabaseRole [db_execproc]    Script Date: 3/5/2016 8:40:20 PM ******/

CREATE ROLE [db_execproc]

GO

--Grant EXECUTE permission at the schema level to the role.

GRANT EXECUTE ON SCHEMA::dbo TO db_execproc;

GO

--EXEC sp_addrolemember N'db_execproc', N'TestUser'; -- Add user here

GO

Correlated or Derived JOIN in SQL Server

2016-03-17T02:31:00.001-07:00

You must be wondering what is this correlated join in SQL Server? Let me clarify it’s not a type of join like INNER or OUTER, it is a kind of usage or play around with joins. Some call it derived join too. Anyway it really does not matter what it is called. The concept is important to understand here. Different types of JOINs in SQL Server

Couple of months ago, I was interviewing a guy. My first question was, find the top 3 business by Amount from Business table, he was kind of happy because he thought it’s a very silly and common question. I saw that happiness and tweaked the question a little bit, I asked him to get me the same out put but by doing a LEFT JOIN with Employee then INNER JOIN between Employee and Location tables.

Let’s do the practical. We have 3 tables, named Employee, Location and Business. In Business table, we have the business data. Let’s find the top 3 businesses by Amount made so far by our employees using the joins mentioned above.

Business:

BusinessID	BusinessName	EmpID	Amount
1	92 Per-cents %% team	7	4750
2	K-Land fund trust	2	16750
3	Robert@BigStarBank.com	7	18100
5	BIG 6’s Foundation%	4	22090
6	TALTA_Kishan International	3	18100
7	Ben@MoreTechnology.com	10	41000
8	www.@-Last-U-Can-Help.com	7	25000
9	Thank you @.com	11	21500
10	Just Mom	5	9900
11	Big Giver Tom	7	19000
12	Mega Mercy	9	55000
13	Hope Reaches	7	29000
14	Everyone Wins	4	12500

Employee:

EmpID	LastName	FirstName	LocationID	ManagerID
2	Brown	Barry	1	11
3	Osako	Lee	2	11
4	Kinnison	Dave	1	11
5	Bender	Eric	1	11
7	Lonning	David	NULL	11
9	Newton	James	2	3
10	O’Haire	Terry	2	3
11	Smith	Sally	1	NULL

Location

LocationID	street	city	state
1	545 Pike	Seattle	WA
2	222 Second AVE	Boston	MA
4	444 Ruby ST	Spokane	WA
5	1595 Main	Philadelphia	PA
6	915 Wallaby Drive	Sydney	NULL

TOP 3 Business by Amount, our desired output:

BusinessName	Amount	EmpID
Mega Mercy	55000	9
Ben@MoreTechnology.com	41000	10
Hope Reaches	29000	7

To get the above result, we can simply write a SELECT TOP(3) statement on Business table and then ORDER BY Amount DESC like shown below.

SELECT TOP (3) BusinessName, Amount from [dbo].[Business]
ORDER BY Amount DESC

Remember, I had tweaked the question and asked him to write the query by doing LEFT JOIN between Business and Employee tables then INNER JOIN between Employee and Location tables. Usually someone will write a query like below.

--Wrong
SELECT TOP (3) b.BusinessName, b.Amount FROM Business b

LEFT JOIN Employee e
ON e.EmpID = b.EmpID

INNER JOIN Location l
ON l.LocationID = e.LocationID

ORDER BY b.Amount DESC

Output: (Wrong)

BusinessName	Amount	EmpID
Mega Mercy	55000	9
Ben@MoreTechnology.com	41000	10
BIG 6’s Foundation%	22090	4

We know BIG 6’s Foundation% (22090) is not our 3rd highest business. The reason Hope Reaches(29000) did not come in the result set because EmpID 7 owns that business and EmpID 7 has no relative data in the location table, LocationID is NULL for EmpID 7 in the Employee table.

Note: In the above query we are fine up to LEFT JOIN between Business and Employee tables but the INNER JOIN with Location phrased out the whole result set at the end with only matching records between Employee and Location tables. Our EmpID 7 is the owner of the 3rd highest business unfortunately he works from home so his business is filtered out and the next highest business is displayed.

Now answering the question.. There are number of ways to get the desired result set but probably the most natural is to use an interesting capability of joins.

--Right
SELECT TOP (3) b.BusinessName, b.Amount, b.EmpID FROM Business b

LEFT JOIN (
Employee e

INNER JOIN Location l
ON l.LocationID = e.LocationID

)
ON e.EmpID = b.EmpID

ORDER BY b.Amount DESC

Output: (Right)

BusinessName	Amount	EmpID
Mega Mercy	55000	9
Ben@MoreTechnology.com	41000	10
Hope Reaches	29000	7

In the above query, we isolated the EMPLOYEE and LOCATION join within parenthesis to their own pendent logical phase. Which is why the LEFT JOIN is not filtered out by the location anymore.

J query Datatable in asp.net c#, Optimoze Gridview with datatable J query

2012-04-01T23:57:00.003-07:00

Controller

HomeController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using JQueryDataTables.Models;
using JQueryDataTables.Models.Repository;

namespace JQueryDataTables.Controllers
{
    public class HomeController : Controller
    {
        /// <summary>
        /// Action that handles initiall request and returns empty view
        /// </summary>
        /// <returns>Home/Index view</returns>
        public ActionResult Index()
        {
            return View();
        }

        /// <summary>
        /// Returns data by the criterion
        /// </summary>
        /// <param name="param">Request sent by DataTables plugin</param>
        /// <returns>JSON text used to display data
        /// <list type="">
        /// <item>sEcho - same value as in the input parameter</item>
        /// <item>iTotalRecords - Total number of unfiltered data. This value is used in the message:
        /// "Showing *start* to *end* of *iTotalDisplayRecords* entries (filtered from *iTotalDisplayRecords* total entries)
        /// </item>
        /// <item>iTotalDisplayRecords - Total number of filtered data. This value is used in the message:
        /// "Showing *start* to *end* of *iTotalDisplayRecords* entries (filtered from *iTotalDisplayRecords* total entries)
        /// </item>
        /// <item>aoData - Twodimensional array of values that will be displayed in table.
        /// Number of columns must match the number of columns in table and number of rows is equal to the number of records that should be displayed in the table</item>
        /// </list>
        /// </returns>
        public ActionResult AjaxHandler(JQueryDataTableParamModel param)
        {
            var allCompanies = DataRepository.GetCompanies();
            IEnumerable<Company> filteredCompanies;
            //Check whether the companies should be filtered by keyword
            if (!string.IsNullOrEmpty(param.sSearch))
            {
                //Used if particulare columns are filtered
                var nameFilter = Convert.ToString(Request["sSearch_1"]);
                var addressFilter = Convert.ToString(Request["sSearch_2"]);
                var townFilter = Convert.ToString(Request["sSearch_3"]);

                //Optionally check whether the columns are searchable at all
                var isNameSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
                var isAddressSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
                var isTownSearchable = Convert.ToBoolean(Request["bSearchable_3"]);

                filteredCompanies = DataRepository.GetCompanies()
                   .Where(c => isNameSearchable && c.Name.ToLower().Contains(param.sSearch.ToLower())
                               ||
                               isAddressSearchable && c.Address.ToLower().Contains(param.sSearch.ToLower())
                               ||
                               isTownSearchable && c.Town.ToLower().Contains(param.sSearch.ToLower()));
            }
            else
            {
                filteredCompanies = allCompanies;
            }

            var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]);
            var isAddressSortable = Convert.ToBoolean(Request["bSortable_2"]);
            var isTownSortable = Convert.ToBoolean(Request["bSortable_3"]);
            var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
            Func<Company, string> orderingFunction = (c => sortColumnIndex == 1 && isNameSortable ? c.Name :
                                                           sortColumnIndex == 2 && isAddressSortable ? c.Address :
                                                           sortColumnIndex == 3 && isTownSortable ? c.Town :
                                                           "");

            var sortDirection = Request["sSortDir_0"]; // asc or desc
            if (sortDirection == "asc")
                filteredCompanies = filteredCompanies.OrderBy(orderingFunction);
            else
                filteredCompanies = filteredCompanies.OrderByDescending(orderingFunction);

            var displayedCompanies = filteredCompanies.Skip(param.iDisplayStart).Take(param.iDisplayLength);
            var result = from c in displayedCompanies select new[] { Convert.ToString(c.ID), c.Name, c.Address, c.Town };
            return Json(new
                            {
                                sEcho = param.sEcho,
                                iTotalRecords = allCompanies.Count(),
                                iTotalDisplayRecords = filteredCompanies.Count(),
                                aaData = result
                            },
                        JsonRequestBehavior.AllowGet);
        }

    }
}

Models

Company.cs

namespace JQueryDataTables.Models
{
    /// <summary>
    /// Company class contains information that shoudl be shown in table
    /// </summary>
    public class Company
    {
        static int nextID = 17;

        public Company()
        {
            ID = nextID++;
        }
        public int ID { get; set; }
        public string Name { get; set; }
        public string Address { get; set; }
        public string Town { get; set; }
    }

}

JQueryDataTableParamModel.cs

namespace JQueryDataTables.Models
{
    /// <summary>
    /// Class that encapsulates most common parameters sent by DataTables plugin
    /// </summary>
    public class JQueryDataTableParamModel
    {
        /// <summary>
        /// Request sequence number sent by DataTable, same value must be returned in response
        /// </summary>
        public string sEcho{ get; set; }

        /// <summary>
        /// Text used for filtering
        /// </summary>
        public string sSearch{ get; set; }

        /// <summary>
        /// Number of records that should be shown in table
        /// </summary>
        public int iDisplayLength{ get; set; }

        /// <summary>
        /// First record that should be shown(used for paging)
        /// </summary>
        public int iDisplayStart{ get; set; }

        /// <summary>
        /// Number of columns in table
        /// </summary>
        public int iColumns{ get; set; }

        /// <summary>
        /// Number of columns that are used in sorting
        /// </summary>
        public int iSortingCols{ get; set; }

        /// <summary>
        /// Comma separated list of column names
        /// </summary>
        public string sColumns{ get; set; }

    }
}

View

Inde.chtml

@{
    Layout = null;
}

<!DOCTYPE html>
<html>
    <head>
        <title>JQuery DataTables/ASP.NET MVC Integration</title>
        <link href="@Url.Content("~/Content/dataTables/demo_table.css")" rel="stylesheet" type="text/css" />
        <script src="@Url.Content("~/Scripts/jquery-1.4.4.min.js")" type="text/javascript"></script>
        <script src="@Url.Content("~/Scripts/jquery.dataTables.min.js")" type="text/javascript"></script>
        <script src="@Url.Content("~/Scripts/index.js")" type="text/javascript"></script>
    </head>

    <body>
        <div id="container">
            <div id="demo">
                <h2>Index</h2>
                <table id="myDataTable" class="display">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Company name</th>
                            <th>Address</th>
                            <th>Town</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    </bod

Use JQueryDataTables.dll library

Dynamically generating thumbnail images in ASP.NET with C#

2012-04-01T23:52:00.001-07:00

<img src="CreateThumbnail.aspx?image=upload/product/<%# Eval("image") %>&width=50" />

CreateThumbnail.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Drawing;
using System.Drawing.Imaging;

public partial class CreateThumbnail : System.Web.UI.Page
{
    private void Page_Load(object sender, System.EventArgs e)
    {
        string Image = Request.QueryString["Image"];
        if (Image == null)
        {
            this.ErrorResult();
            return;
        }
        string sSize = Request["Size"];
        int Size = 120;
        if (sSize != null)

            Size = Int32.Parse(sSize);

        string Path = Server.MapPath(Request.ApplicationPath) + "\\" + Image;
        Bitmap bmp = Thumbnail(Path, Size, Size);

        if (bmp == null)
        {
            this.ErrorResult();
            return;
        }
        string OutputFilename = null;
        OutputFilename = Request.QueryString["OutputFilename"];
        if (OutputFilename != null)
        {

            if (this.User.Identity.Name == "")
            {

                bmp.Dispose();
                this.ErrorResult();

            }
            try
            {

                bmp.Save(OutputFilename);

            }

            catch (Exception ex)
            {
                bmp.Dispose();
                this.ErrorResult();
                return;
            }

        }
        Response.ContentType = "image/jpeg";
        bmp.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
        bmp.Dispose();

    }
    private void ErrorResult()
    {
        Response.Clear();
        Response.StatusCode = 404;
        Response.End();
    }
    public static Bitmap Thumbnail(string lcFilename, int lnWidth, int lnHeight)
    {
        System.Drawing.Bitmap bmpOut = null;
        try
        {
            Bitmap loBMP = new Bitmap(lcFilename);
            ImageFormat loFormat = loBMP.RawFormat;
            decimal lnRatio;
            int lnNewWidth = 0;
            int lnNewHeight = 0;
            if (loBMP.Width < lnWidth && loBMP.Height < lnHeight)

                return loBMP;
            if (loBMP.Width > loBMP.Height)
            {

                lnRatio = (decimal)lnWidth / loBMP.Width;

                lnNewWidth = lnWidth;

                decimal lnTemp = loBMP.Height * lnRatio;

                lnNewHeight = (int)lnTemp;

            }

            else
            {

                lnRatio = (decimal)lnHeight / loBMP.Height;

                lnNewHeight = lnHeight;

                decimal lnTemp = loBMP.Width * lnRatio;

                lnNewWidth = (int)lnTemp;

            }

            bmpOut = new Bitmap(lnNewWidth, lnNewHeight);

            Graphics g = Graphics.FromImage(bmpOut);

            g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;

            g.FillRectangle(Brushes.White, 0, 0, lnNewWidth, lnNewHeight);

            g.DrawImage(loBMP, 0, 0, lnNewWidth, lnNewHeight);

            loBMP.Dispose();

        }

        catch
        {

            return null;

        }

        return bmpOut;

    }

}

Product Catelog App class in asp.net c# -7

2012-04-01T23:48:00.003-07:00

view_product.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="view_product.aspx.cs" Inherits="view_product" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <table>
        <tr>
            <td width="63%" align="right" valign="top">
                <table width="90%" border="0" align="right" cellpadding="0" cellspacing="0" style="padding: 40px 0 0 0;
                    margin-top: 10px;">
                    <tr>
                        <td width="90%" align="right" valign="top">
                            <table width="90%" border="0" align="right" cellpadding="0" cellspacing="0" style="margin-bottom: 25px;">
                                <tr>
                                    <td align="left">
                                        <table width="98%" align="left" cellpadding="0" cellspacing="0" style="margin: 25px 0 0 0;">
                                            <tr>
                                                <td align="left" valign="top" class="style13">
                                                    VIEW PRODUCT
                                                </td>
                                                <td width="198" height="35" align="right" valign="middle" class="style4">
                                                </td>
                                            </tr>
                                            </TBODY>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="left">
                                        <table width="535" border="0" align="center" cellpadding="0" cellspacing="0">
                                            <tr>
                                                <td height="10">
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    <table align="center" border="0" cellpadding="0" cellspacing="0" width="535">
                                                        <tr>
                                                            <td height="10">
                                                                <table style="width: 100%">
                                                                    <tr>
                                                                        <td align="left" style="width: 50%">
                                                                            <asp:TextBox ID="txtsearch" Text="Search by ProductName" runat="server" OnClick="this.value = ''; this.style.color = 'black'" OnBlur="javascript:changeText(this.id)"></asp:TextBox>
                                                                            <asp:Button ID="Submit" runat="server" Text="Button" OnClick="Submit_Click" />
                                                                        </td>
                                                                        <td align="right" style="width: 50%">
                                                                            <asp:DropDownList ID="drpcategory" runat="server" OnSelectedIndexChanged="drpcategory_SelectedIndexChanged">
                                                                            </asp:DropDownList>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="top" width="520">
                                                                <table border="0" cellpadding="0" cellspacing="0" width="90%">
                                                                    <tr>
                                                                        <td align="center" colspan="3" height="15" valign="middle">
                                                                            <h1>
                                                                                <asp:GridView ID="gvcategory" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                                                                    CellPadding="5" DataKeyNames="CategoryId" OnPageIndexChanging="gvcategory_PageIndexChanging"
                                                                                    OnRowDeleting="gvcategory_RowDeleting" OnRowEditing="gvcategory_RowEditing" Width="80%">
                                                                                    <HeaderStyle CssClass="Head" />
                                                                                    <RowStyle CssClass="rowtext" />
                                                                                    <Columns>
                                                                                        <asp:TemplateField HeaderText="ID" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="7%">
                                                                                            <ItemTemplate>
                                                                                                <%#Container.DataItemIndex+1 %>
                                                                                            </ItemTemplate>
                                                                                            <ItemStyle HorizontalAlign="Center" Width="7%" />
                                                                                        </asp:TemplateField>
                                                                                        <asp:BoundField DataField="CategoryName" HeaderText="CategoryName" ItemStyle-HorizontalAlign="Left">
                                                                                            <ItemStyle HorizontalAlign="Left" />
                                                                                        </asp:BoundField>
                                                                                        <asp:BoundField DataField="productname" HeaderText="ProductName" ItemStyle-HorizontalAlign="Left">
                                                                                            <ItemStyle HorizontalAlign="Left" />
                                                                                        </asp:BoundField>
                                                                                        <asp:BoundField DataField="productcode" HeaderText="ProductCode" ItemStyle-HorizontalAlign="Left">
                                                                                            <ItemStyle HorizontalAlign="Left" />
                                                                                        </asp:BoundField>
                                                                                        <asp:TemplateField HeaderText="ProductImage">
                                                                                            <ItemTemplate>
                                                                                                <img src="CreateThumbnail.aspx?image=upload/product/<%# Eval("image") %>&width=50" />
                                                                                            </ItemTemplate>
                                                                                        </asp:TemplateField>
                                                                                        <asp:CommandField ControlStyle-CssClass="link" ItemStyle-HorizontalAlign="Center"
                                                                                            ShowEditButton="True">
                                                                                            <ControlStyle CssClass="link" />
                                                                                            <ItemStyle HorizontalAlign="Center" />
                                                                                        </asp:CommandField>
                                                                                        <asp:CommandField ControlStyle-CssClass="link" ItemStyle-HorizontalAlign="Center"
                                                                                            ShowDeleteButton="True">
                                                                                            <ControlStyle CssClass="link" />
                                                                                            <ItemStyle HorizontalAlign="Center" />
                                                                                        </asp:CommandField>
                                                                                    </Columns>
                                                                                </asp:GridView>
                                                                            </h1>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="center" colspan="3" valign="middle">
                                                                            <table border="0" cellpadding="0" cellspacing="0" width="82%">
                                                                                <tr>
                                                                                    <td width="60">
                                                                                         
                                                                                    </td>
                                                                                </tr>
                                                                            </table>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="left" colspan="3" height="60" valign="middle">
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="left" valign="middle">
                                                                             
                                                                        </td>
                                                                        <td>
                                                                             
                                                                        </td>
                                                                        <td align="left" valign="middle">
                                                                            <a class="thickbox" style="border: none;"> </a>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="top">
                                                                 
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="left" valign="top">
                                                     
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

view_product.aspx.cs

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

public partial class view_product : System.Web.UI.Page
{
    BALProductMaster bal = new BALProductMaster();
    DALProductMaster dal = new DALProductMaster();
    BALCategoryMaster catbal = new BALCategoryMaster();
    DALCategoryMaster catdal = new DALCategoryMaster();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            drpcategory.DataSource = catdal.SelectCategory();
            drpcategory.DataBind();
            drpcategory.SelectedItem.Text = "category";
            drpcategory.SelectedValue = "id";
            gvbind();
        }
    }
    public void gvbind()
    {
        DataTable dt = dal.Select_ProductMaster();
        gvcategory.DataSource = dt;
        gvcategory.DataBind();
        ViewState["dtpro"] = dt;
    }
    protected void gvcategory_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string productid = gvcategory.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Redirect("Add_product.aspx?id=" + productid);
    }
    protected void gvcategory_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int productid = int.Parse(gvcategory.DataKeys[e.RowIndex].Value.ToString());
        bal.ProductID = productid;
        dal.delete_ProductMaster(bal);
        gvbind();
    }
    protected void gvcategory_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvcategory.PageIndex = e.NewPageIndex;
        gvcategory.DataSource = (DataTable)ViewState["dtpro"];
        gvcategory.DataBind();
    }
    protected void drpcategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        catbal.CategoryId = int.Parse(drpcategory.SelectedValue.ToString());
        DataTable dt = dal.selectR_ProductMasterByCategoryId(catbal);
        gvcategory.DataSource = dt;
        gvcategory.DataBind();
        ViewState["dtpro"] = dt;
    }
    protected void Submit_Click(object sender, EventArgs e)
    {
        string search = txtsearch.Text.ToString();
        DataTable dt = dal.Select_ProductMasterSearch(search);
        gvcategory.DataSource = dt;
        gvcategory.DataBind();
        ViewState["dtcat"] = dt;
    }
}

Product Catelog App class in asp.net c# -6

2012-04-01T23:46:00.003-07:00

add_product.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="add_product.aspx.cs" Inherits="add_product" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <table>
        <tr>
            <td width="63%" align="right" valign="top">
                <table width="90%" border="0" align="right" cellpadding="0" cellspacing="0" style="padding: 40px 0 0 0;
                    margin-top: 10px;">
                    <tr>
                        <td width="90%" align="right" valign="top">
                            <table width="90%" border="0" align="right" cellpadding="0" cellspacing="0" style="margin-bottom: 25px;">
                                <tr>
                                    <td align="left">
                                        <table width="98%" align="left" cellpadding="0" cellspacing="0" style="margin: 25px 0 0 0;">
                                            <tr>
                                                <td align="left" valign="top" class="style13">
                                                    ADD PRODUCT
                                                </td>
                                                <td width="198" height="35" align="right" valign="middle" class="style4">
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="left">
                                        <table width="535" border="0" align="center" cellpadding="0" cellspacing="0">
                                            <tr>
                                                <td height="10">
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="520" align="left" valign="top">
                                                    <table width="90%" border="0" cellspacing="5" cellpadding="5">
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                SELECT CATEGORY
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                <asp:DropDownList ID="drpcategory" runat="server" Height="16px"
                                                                    style="width: 77px" Width="130px">
                                                                </asp:DropDownList>
                                                            </td>
                                                            <td width="142">
                                                                <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="drpcategory"
                                                                    ErrorMessage="*" ValidationGroup="ok"></asp:RequiredFieldValidator>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                PRODUCT NAME:
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                <asp:TextBox ID="txtproduct" runat="server" Width="147" class="fields"></asp:TextBox>
                                                            </td>
                                                            <td width="142">
                                                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtcategory"
                                                                    ErrorMessage="*" ValidationGroup="ok"></asp:RequiredFieldValidator>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                PRODUCT CODE
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                <asp:TextBox ID="txtproductcode" runat="server" Width="147" class="fields"></asp:TextBox>
                                                            </td>
                                                            <td width="142">
                                                                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtproductcode"
                                                                    ErrorMessage="*" ValidationGroup="ok"></asp:RequiredFieldValidator>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                PRODUCT DETAIL
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                <asp:TextBox TextMode="MultiLine" ID="txtdetail" runat="server" Width="169px" class="fields"
                                                                    Height="69px"></asp:TextBox>
                                                            </td>
                                                            <td width="142">
                                                                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtdetail"
                                                                    ErrorMessage="*" ValidationGroup="ok"></asp:RequiredFieldValidator>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                IMAGE
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                <asp:FileUpload ID="fileupload" runat="server" />
                                                            </td>
                                                            <td width="142">
                                                              <asp:Image ID="imgcon" runat="server" BorderStyle="None" Visible="false" />
                         <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click"
                            Visible="false">Remove Image</asp:LinkButton></td>
                                                        </tr>
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                 
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                 
                                                            </td>
                                                            <td width="142">
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td height="15" colspan="3" align="left" valign="middle" class="fields">
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="3" align="center" valign="middle">
                                                                <table width="82%" border="0" cellspacing="0" cellpadding="0">
                                                                    <tr>
                                                                        <td align="left" valign="middle">
                                                                             
                                                                        </td>
                                                                        <td width="60">
                                                                            <asp:Button ID="btnsubmit" runat="server" Text="Submit" OnClick="btnsubmit_Click"
                                                                                Style="height: 26px" />
                                                                        </td>
                                                                        <td align="right" valign="middle">
                                                                             
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td height="60" colspan="3" align="left" valign="middle">
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="middle">
                                                                 
                                                            </td>
                                                            <td>
                                                                 
                                                            </td>
                                                            <td align="left" valign="middle">
                                                                <a style="border: none;" class="thickbox"> </a>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    <table align="center" border="0" cellpadding="0" cellspacing="0" width="535">
                                                        <tr>
                                                            <td height="10">
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="top" width="520">
                                                                <table border="0" cellpadding="0" cellspacing="0" width="90%">
                                                                    <tr>
                                                                        <td align="center" colspan="3" height="15" valign="middle">
                                                                             
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="center" colspan="3" valign="middle">
                                                                             
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="left" colspan="3" height="60" valign="middle">
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="left" valign="middle">
                                                                             
                                                                        </td>
                                                                        <td>
                                                                             
                                                                        </td>
                                                                        <td align="left" valign="middle">
                                                                             
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="top">
                                                                 
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="left" valign="top">
                                                     
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

add_product.aspx.cs

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

public partial class add_product : System.Web.UI.Page
{
    BALProductMaster bal = new BALProductMaster();
    DALProductMaster dal = new DALProductMaster();
    BALCategoryMaster catbal = new BALCategoryMaster();
    DALCategoryMaster catdal = new DALCategoryMaster();

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {

            drpcategory.DataSource = catdal.SelectCategory();
            drpcategory.DataBind();
            drpcategory.SelectedItem.Text = "category";
            drpcategory.SelectedValue = "id";

            if (Request.QueryString["id"] != null)
            {
                int ProductID = int.Parse(Request.QueryString["id"].ToString());
                bal.ProductID = ProductID;
                DataTable dt = dal.select_ProductMasterByProductId(bal);
                if (dt.Rows.Count != 0)
                {
                    drpcategory.SelectedValue = dt.Rows[0]["cate_id"].ToString();
                    txtproduct.Text = dt.Rows[0]["ProductName"].ToString();
                    txtproductcode.Text = dt.Rows[0]["Productcode"].ToString();
                    txtdetail.Text = dt.Rows[0]["detail"].ToString();
                    imgcon.Visible = true;
                    imgcon.ImageUrl = "CreateThumbnail.aspx?image=upload/product/" + dt.Rows[0]["image"] + "&width=100";
                }
            }

        }
    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        string strimage, path;
        strimage = fileupload.FileName;
        path = Server.MapPath("upload/product/");
        if (!fileupload.FileName.Equals(""))
        {
            Session["image"] = strimage;
        }
        else
        {

        }

        if (Request.QueryString["id"] != null)
        {
            bal.ProductName = txtproduct.Text.Trim().ToString().ToUpper();
            bal.ProductCode = txtproductcode.Text.Trim().ToString();
            bal.CategoryId = int.Parse(drpcategory.SelectedValue.ToString());
            bal.Image = Session["image"].ToString();
            bal.ProductID = int.Parse(Request.QueryString["id"].ToString());
            bal.Detail = txtdetail.Text.ToString();
            dal.updateR_ProductMaster(bal);
            Response.Redirect("view_product.aspx");
        }
        else
        {

            bal.ProductName = txtproduct.Text.Trim().ToString().ToUpper();
            bal.ProductCode = txtproductcode.Text.Trim().ToString();
            bal.CategoryId = int.Parse(drpcategory.SelectedValue.ToString());
            bal.Image = Session["image"].ToString();
            bal.Detail = txtdetail.Text.ToString();
            dal.insert_ProductMaster(bal);
            Response.Redirect("view_product.aspx");
        }
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        bal.ProductID = int.Parse(Request.QueryString["id"].ToString());
        dal.Image_remove(bal);
    }
}

Product Catelog App class in asp.net c# -5

2012-04-01T23:38:00.000-07:00

Add_view_category.aspx.cs

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

public partial class Add_view_category : System.Web.UI.Page
{
    BALCategoryMaster bal = new BALCategoryMaster();
    DALCategoryMaster dal = new DALCategoryMaster();
    DALProductMaster prodal = new DALProductMaster();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["id"] != null)
            {
                int CategoryId = int.Parse(Request.QueryString["id"].ToString());
                bal.CategoryId = CategoryId;
                DataTable dt = dal.select_CategoryMasterByCategoryId(bal);
                if (dt.Rows.Count != 0)
                {
                    txtcategory.Text = dt.Rows[0]["CategoryName"].ToString();
                }
            }
            gvbind();
        }

    }
    public void gvbind()
    {
        DataTable dt = dal.Select_CategoryMaster();
        gvcategory.DataSource = dt;
        gvcategory.DataBind();
        ViewState["dtcat"] = dt;
    }

    protected void gvcategory_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string categoryid = gvcategory.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Redirect("Add_view_category.aspx?id=" + categoryid);

    }
    protected void gvcategory_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int categoryid = int.Parse(gvcategory.DataKeys[e.RowIndex].Value.ToString());
        bal.CategoryId = categoryid;
        dal.delete_CategoryMaster(bal);
        gvbind();
    }

    protected void gvcategory_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvcategory.PageIndex = e.NewPageIndex;
        gvcategory.DataSource = (DataTable)ViewState["dtcat"];
        gvcategory.DataBind();

    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        if (Request.QueryString["id"] != null)
        {
            bal.CategoryName = txtcategory.Text.Trim().ToString().ToUpper();
            bal.CategoryId = int.Parse(Request.QueryString["id"].ToString());
            dal.update_CategoryMaster(bal);
            Response.Redirect("Add_view_category.aspx");
        }
        else
        {

            bal.CategoryName = txtcategory.Text.Trim().ToString().ToUpper();
            dal.insert_CategoryMaster(bal);
            Response.Redirect("Add_view_category.aspx");

        }
    }
    protected void Submit_Click(object sender, EventArgs e)
    {
        string search = txtsearch.Text.ToString();
        DataTable dt = dal.Select_CategoryMasterSearch(search);
        gvcategory.DataSource = dt;
        gvcategory.DataBind();
        ViewState["dtcat"] = dt;
    }
}

Add_view_category.aspx

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="Add_view_category.aspx.cs" Inherits="Add_view_category" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <table>
        <tr>
            <td width="63%" align="right" valign="top">
                <table width="90%" border="0" align="right" cellpadding="0" cellspacing="0" style="padding: 40px 0 0 0;
                    margin-top: 10px;">
                    <tr>
                        <td width="90%" align="right" valign="top">
                            <table width="90%" border="0" align="right" cellpadding="0" cellspacing="0" style="margin-bottom: 25px;">
                                <tr>
                                    <td align="left">
                                        <table width="98%" align="left" cellpadding="0" cellspacing="0" style="margin: 25px 0 0 0;">
                                            <tr>
                                                <td align="left" valign="top" class="style13">
                                                    CREATE CATEGORY
                                                </td>
                                                <td width="198" height="35" align="right" valign="middle" class="style4">
                                                </td>
                                            </tr>
                                            </TBODY>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="left">
                                        <table width="535" border="0" align="center" cellpadding="0" cellspacing="0">
                                            <tr>
                                                <td height="10">
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="520" align="left" valign="top">
                                                    <table width="90%" border="0" cellspacing="0" cellpadding="0">
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                CATEGORY NAME:
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                <asp:TextBox ID="txtcategory" runat="server" Width="147" class="fields"></asp:TextBox>
                                                            </td>
                                                            <td width="142">
                                                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtcategory"
                                                                    ErrorMessage="*" ValidationGroup="ok"></asp:RequiredFieldValidator>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td width="225" align="left" valign="middle" class="fields">
                                                                 
                                                            </td>
                                                            <td width="147" align="left" valign="middle">
                                                                 
                                                            </td>
                                                            <td width="142">
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td height="15" colspan="3" align="left" valign="middle" class="fields">
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="3" align="center" valign="middle">
                                                                <table width="82%" border="0" cellspacing="0" cellpadding="0">
                                                                    <tr>
                                                                        <td align="left" valign="middle">
                                                                             
                                                                        </td>
                                                                        <td width="60">
                                                                            <asp:Button ID="btnsubmit" runat="server" Text="Submit" OnClick="btnsubmit_Click" />
                                                                        </td>
                                                                        <td align="right" valign="middle">
                                                                             
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td height="60" colspan="3" align="left" valign="middle">
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="middle">
                                                                 
                                                            </td>
                                                            <td>
                                                                 
                                                            </td>
                                                            <td align="left" valign="middle">
                                                                <a style="border: none;" class="thickbox"> </a>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    <table align="center" border="0" cellpadding="0" cellspacing="0" width="535">
                                                        <tr>
                                                            <td height="10">
                                                                <asp:TextBox ID="txtsearch" runat="server"></asp:TextBox>
                                                                <asp:Button ID="Submit" runat="server" Text="Button" />
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="top" width="520">
                                                                <table border="0" cellpadding="0" cellspacing="0" width="90%">
                                                                    <tr>
                                                                        <td align="center" colspan="3" height="15" valign="middle">
                                                                            <h1>
                                                                                <asp:GridView ID="gvcategory" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                                                                    CellPadding="5" DataKeyNames="CategoryId" OnPageIndexChanging="gvcategory_PageIndexChanging"
                                                                                    OnRowDeleting="gvcategory_RowDeleting" OnRowEditing="gvcategory_RowEditing" Width="80%">
                                                                                    <HeaderStyle CssClass="Head" />
                                                                                    <RowStyle CssClass="rowtext" />
                                                                                    <Columns>
                                                                                        <asp:TemplateField HeaderText="ID" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="7%">
                                                                                            <ItemTemplate>
                                                                                                <%#Container.DataItemIndex+1 %>
                                                                                            </ItemTemplate>
                                                                                            <ItemStyle HorizontalAlign="Center" Width="7%" />
                                                                                        </asp:TemplateField>
                                                                                        <asp:BoundField DataField="CategoryName" HeaderText="CategoryName" ItemStyle-HorizontalAlign="Left">
                                                                                            <ItemStyle HorizontalAlign="Left" />
                                                                                        </asp:BoundField>
                                                                                        <asp:CommandField ControlStyle-CssClass="link" ItemStyle-HorizontalAlign="Center"
                                                                                            ShowEditButton="True">
                                                                                            <ControlStyle CssClass="link" />
                                                                                            <ItemStyle HorizontalAlign="Center" />
                                                                                        </asp:CommandField>
                                                                                        <asp:CommandField ControlStyle-CssClass="link" ItemStyle-HorizontalAlign="Center"
                                                                                            ShowDeleteButton="True">
                                                                                            <ControlStyle CssClass="link" />
                                                                                            <ItemStyle HorizontalAlign="Center" />
                                                                                        </asp:CommandField>
                                                                                    </Columns>
                                                                                </asp:GridView>
                                                                            </h1>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="center" colspan="3" valign="middle">
                                                                            <table border="0" cellpadding="0" cellspacing="0" width="82%">
                                                                                <tr>
                                                                                    <td width="60">
                                                                                         
                                                                                    </td>
                                                                                </tr>
                                                                            </table>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="left" colspan="3" height="60" valign="middle">
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td align="left" valign="middle">
                                                                             
                                                                        </td>
                                                                        <td>
                                                                             
                                                                        </td>
                                                                        <td align="left" valign="middle">

                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td>
                                                                 
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="left" valign="top">
                                                                 
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="left" valign="top">
                                                     
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

Product Catelog App class in asp.net c# -3

2012-04-01T23:35:00.003-07:00

Abstract Connection Class

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

/// <summary>
/// Summary description for Connection
/// </summary>
public class Connection
{
    SqlConnection sqlcon = new SqlConnection();
    string sqlConnect;

    public Connection()
    {
        sqlConnect = ConfigurationManager.ConnectionStrings["connsql"].ConnectionString;
    }

    protected SqlConnection FetchConnection()
    {
        sqlcon = new SqlConnection(sqlConnect);
        return sqlcon;

    }
}

Product Catelog App class in asp.net c# -2

2012-04-01T23:33:00.002-07:00

DALCategoryMaster.cs

using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DALCategoryMaster
/// </summary>
public class DALCategoryMaster : Connection
{

    SqlConnection sqlcon = new SqlConnection();

    public DALCategoryMaster()
    {
        sqlcon = FetchConnection();
    }

    public DataTable SelectCategory()
    {
        sqlcon = FetchConnection();
        DataTable dt = new DataTable();
        string cate = "select * from tbl_category";
        SqlDataAdapter da = new SqlDataAdapter(cate, sqlcon);
        da.SelectCommand.CommandType = CommandType.Text;
        da.Fill(dt);
        return dt;
    }
    public void insert_CategoryMaster(BALCategoryMaster bal)
    {
        string insert = "insert into tbl_category (category) values (@category)";
        SqlCommand sqlCmd = new SqlCommand(insert, sqlcon);
        sqlCmd.CommandType = CommandType.Text;

        SqlParameter paraCategoryName = new SqlParameter("@Category", SqlDbType.VarChar);
        paraCategoryName.Value = bal.CategoryName;
        sqlCmd.Parameters.Add(paraCategoryName);

        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }

        sqlCmd.ExecuteNonQuery();
        sqlcon.Close();
    }
    public DataTable Select_CategoryMaster()
    {
        string str = "select * from tbl_category order by id asc";
        SqlCommand sqlCmd = new SqlCommand(str, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataSet ds = new DataSet();
        SqlDataAdapter adp = new SqlDataAdapter(str, sqlcon);
        adp.Fill(ds);
        sqlcon.Close();
        return ds.Tables[0];
    }
    public DataTable Select_CategoryMasterSearch(string search)
    {
        string str = "select * from tbl_category where category like '%[" + search + "]%' order by id asc";
        SqlCommand sqlCmd = new SqlCommand(str, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataSet ds = new DataSet();
        SqlDataAdapter adp = new SqlDataAdapter(str, sqlcon);
        adp.Fill(ds);
        sqlcon.Close();
        return ds.Tables[0];
    }
    public void delete_CategoryMaster(BALCategoryMaster bal)
    {
        string delete = "delete from tbl_category where id=@CategoryId";
        SqlCommand sqlCmd = new SqlCommand(delete, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter CategoryId = new SqlParameter("@CategoryId", SqlDbType.Int);
        CategoryId.Value = bal.CategoryId;
        sqlCmd.Parameters.Add(CategoryId);
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        sqlCmd.ExecuteNonQuery();
        sqlcon.Close();
    }
    public void update_CategoryMaster(BALCategoryMaster bal)
    {
        string str = "update tbl_category set category=@CategoryName where id=@CategoryId";
        SqlCommand sqlCmd = new SqlCommand(str, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter paraCategoryName = new SqlParameter("@CategoryName", SqlDbType.VarChar);
        paraCategoryName.Value = bal.CategoryName;
        sqlCmd.Parameters.Add(paraCategoryName);
        SqlParameter paraCategoryId = new SqlParameter("@CategoryId", SqlDbType.Int);
        paraCategoryId.Value = bal.CategoryId;
        sqlCmd.Parameters.Add(paraCategoryId);
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        try
        {
            sqlCmd.ExecuteNonQuery();
        }
        catch (SqlException xe)
        {

        }
        sqlcon.Close();

    }
    public DataTable select_CategoryMasterByCategoryId(BALCategoryMaster bal)
    {
        string strcat = "select * from tbl_category where id=@CategoryId";
        SqlCommand sqlCmd = new SqlCommand(strcat, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter CategoryId = new SqlParameter("@CategoryId", SqlDbType.Int);
        CategoryId.Value = bal.CategoryId;
        sqlCmd.Parameters.Add(CategoryId);
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataTable dt = new DataTable();
        SqlDataAdapter adp = new SqlDataAdapter(sqlCmd);
        adp.Fill(dt);
        sqlcon.Close();
        return dt;
    }
}

DALProductMaster.cs

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
/// <summary>
/// Summary description for DALProductMaster
/// </summary>
public class DALProductMaster : Connection
{
    SqlConnection sqlcon = new SqlConnection();

    public DALProductMaster()
    {
        sqlcon = FetchConnection();
    }

    public void insert_ProductMaster(BALProductMaster bal)
    {
        string insert = "insert into tbl_product (productname,productcode,cat_id,image,detail) values (@productname,@productcode,@cat_id,@image,@detail)";
        SqlCommand sqlCmd = new SqlCommand(insert, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter paraCategoryName = new SqlParameter("@productname", SqlDbType.VarChar);
        paraCategoryName.Value = bal.ProductName;
        sqlCmd.Parameters.Add(paraCategoryName);

        SqlParameter paraCategorycode = new SqlParameter("@productcode", SqlDbType.VarChar);
        paraCategorycode.Value = bal.ProductCode;
        sqlCmd.Parameters.Add(paraCategorycode);

        SqlParameter cat_id = new SqlParameter("@cat_id", SqlDbType.Int);
        cat_id.Value = bal.CategoryId;
        sqlCmd.Parameters.Add(cat_id);

        SqlParameter image = new SqlParameter("@image", SqlDbType.VarChar);
        image.Value = bal.Image;
        sqlCmd.Parameters.Add(image);

        SqlParameter detail = new SqlParameter("@detail", SqlDbType.VarChar);
        detail.Value = bal.Detail;
        sqlCmd.Parameters.Add(detail);

        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }

        sqlCmd.ExecuteNonQuery();
        sqlcon.Close();
    }
    public DataTable Select_ProductMaster()
    {
        string str = "select * from tbl_product order by id desc";
        SqlCommand sqlCmd = new SqlCommand(str, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataSet ds = new DataSet();
        SqlDataAdapter adp = new SqlDataAdapter(str, sqlcon);
        adp.Fill(ds);
        sqlcon.Close();
        return ds.Tables[0];
    }

    public void delete_ProductMaster(BALProductMaster bal)
    {
        string delete = "delete from tbl_Product where id=@ProductID";
        SqlCommand sqlCmd = new SqlCommand(delete, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter ProductID = new SqlParameter("@ProductID", SqlDbType.Int);
        ProductID.Value = bal.ProductID;
        sqlCmd.Parameters.Add(ProductID);
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        sqlCmd.ExecuteNonQuery();
        sqlcon.Close();
    }

    public void updateR_ProductMaster(BALProductMaster bal)
    {
        string str = "update tbl_product set productname=@productname,productcode=@productcode,cat_id=@cat_id,image=@image,detail=@detail where id=@ProductID";
        SqlCommand sqlCmd = new SqlCommand(str, sqlcon);
        sqlCmd.CommandType = CommandType.Text;

        SqlParameter productid = new SqlParameter("@ProductID", SqlDbType.Int);
        productid.Value = bal.ProductID;
        sqlCmd.Parameters.Add(productid);

        SqlParameter paraCategoryName = new SqlParameter("@productname", SqlDbType.VarChar);
        paraCategoryName.Value = bal.ProductName;
        sqlCmd.Parameters.Add(paraCategoryName);

        SqlParameter paraCategorycode = new SqlParameter("@productcode", SqlDbType.VarChar);
        paraCategorycode.Value = bal.ProductCode;
        sqlCmd.Parameters.Add(paraCategorycode);

        SqlParameter cat_id = new SqlParameter("@cat_id", SqlDbType.Int);
        cat_id.Value = bal.CategoryId;
        sqlCmd.Parameters.Add(cat_id);

        SqlParameter image = new SqlParameter("@image", SqlDbType.VarChar);
        image.Value = bal.Image;
        sqlCmd.Parameters.Add(image);

        SqlParameter detail = new SqlParameter("@detail", SqlDbType.VarChar);
        detail.Value = bal.Detail;
        sqlCmd.Parameters.Add(detail);

        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        try
        {
            sqlCmd.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {

        }
        sqlcon.Close();

    }

    public DataTable select_ProductMasterByProductId(BALProductMaster bal)
    {
        string strcat = "select * from tbl_product where id=@ProductId";
        SqlCommand sqlCmd = new SqlCommand(strcat, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter CategoryId = new SqlParameter("@ProductId", SqlDbType.Int);
        CategoryId.Value = bal.ProductID;
        sqlCmd.Parameters.Add(CategoryId);
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataTable dt = new DataTable();
        SqlDataAdapter adp = new SqlDataAdapter(sqlCmd);
        adp.Fill(dt);
        sqlcon.Close();
        return dt;

    }
    public void Image_remove(BALProductMaster bal)
    {
        string updateimage = "update tbl_product set image=@image where id=@productid";
        SqlCommand sqlCmd = new SqlCommand(updateimage, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter ProductID = new SqlParameter("@productid", SqlDbType.VarChar);
        ProductID.Value = bal.ProductID;
        sqlCmd.Parameters.Add(ProductID);

        SqlParameter image = new SqlParameter("@image", SqlDbType.VarChar);
        image.Value = "";
        sqlCmd.Parameters.Add(image);

        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        sqlCmd.ExecuteNonQuery();
        sqlcon.Close();
    }
    public DataTable Select_ProductMasterSearch(string search)
    {
        string str = "select * from tbl_product where productname like '%[" + search + "]%' order by id asc";
        SqlCommand sqlCmd = new SqlCommand(str, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataSet ds = new DataSet();
        SqlDataAdapter adp = new SqlDataAdapter(str, sqlcon);
        adp.Fill(ds);
        sqlcon.Close();
        return ds.Tables[0];
    }
    public DataTable selectR_ProductMasterByCategoryId(BALCategoryMaster bal)
    {
        string strcat = "select * from tbl_product where cate_id=@CategoryID";
        SqlCommand sqlCmd = new SqlCommand(strcat, sqlcon);
        sqlCmd.CommandType = CommandType.Text;
        SqlParameter CategoryId = new SqlParameter("@CategoryID", SqlDbType.Int);
        CategoryId.Value = bal.CategoryId;
        sqlCmd.Parameters.Add(CategoryId);
        if (sqlcon.State == ConnectionState.Closed)
        {
            sqlcon.Open();
        }
        DataTable dt = new DataTable();
        SqlDataAdapter adp = new SqlDataAdapter(sqlCmd);
        adp.Fill(dt);
        sqlcon.Close();
        return dt;

    }

}

Product Catelog App class in asp.net c# -1

2012-04-01T23:31:00.004-07:00

BALCategoryMaster.cs

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

/// <summary>

/// Summary description for BALCategoryMaster

/// </summary>

public class BALCategoryMaster

{

    private int _CategoryId;

    public int CategoryId

{

        get { return _CategoryId; }

        set { _CategoryId = value; }

}

    private string _CategoryName;

    public string CategoryName

{

        get { return _CategoryName; }

        set { _CategoryName = value; }

}

}

BALProductMaster.cs 

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
/// Summary description for BALProductMaster
/// </summary>
public class BALProductMaster
{
    public BALProductMaster()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    private string _ProductName;
    public string ProductName
    {
        get { return _ProductName; }
        set { _ProductName = value; }
    }
    private int _ProductID;
    public int ProductID
    {
        get { return _ProductID; }
        set { _ProductID = value; }
    }

    private string _ProductCode;
    public string ProductCode 
    {
        get { return _ProductCode; }
        set { _ProductCode = value; }
    }
    private int _CategoryId;
    public int CategoryId
    {
        get { return _CategoryId; }
        set { _CategoryId = value; }
    }
    private string _Image;
    public string Image
    {
        get { return _Image; }
        set { _Image = value; }
    }
    private string _Detail;
    public string Detail
    {
        get { return _Detail; }
        set { _Detail = value; }
    } 
}

Dropbox API For asp.net c#

2012-04-01T23:26:00.001-07:00

static public class FileUtils
    {
        public enum FolderMode
        {
            /// <summary>
            /// Operate on sub-folders recursively
            /// </summary>
            Recursive,

            /// <summary>
            /// Operate on just the specified folder
            /// </summary>
            NonRecursive,
        }

        public enum CopyFileMode
        {
            /// <summary>
            /// Replace all existing files
            /// </summary>
            Replace,

            /// <summary>
            /// Replace existing files if the file write date is newer
            /// </summary>
            ReplaceIfNewer,

            /// <summary>
            /// Do not replace existing files
            /// </summary>
            SkipIfExists
        }

       /// <summary>
        /// Copy a folder to another folder with optional recursive behavior.
        /// </summary>
        static public void CopyFolder(string source, string dest, FolderMode mode, CopyFileMode fileMode)
        {
            DirectoryInfo sourceDI = new DirectoryInfo(source);
            DirectoryInfo destDI = new DirectoryInfo(dest);

            CopyFolder(sourceDI, destDI, mode, fileMode);
        }

        /// <summary>
        /// Create a folder if it does not exist
        /// </summary>
        static public void CreateFolderIfDoesNotExist(string path)
        {
            DirectoryInfo di = new DirectoryInfo(Path.GetDirectoryName(path));
            if (!di.Exists)
            {
                di.Create();
            }
        }

        /// <summary>
        /// Moves a folder to another location. If the folders are on different volumes,
        /// the source folder will be copied to the destination folder then deleted.
        /// </summary>
        static public void MoveFolder(string source, string dest)
        {
            MoveFolder(new DirectoryInfo(source), new DirectoryInfo(dest));
        }

        /// <summary>
        /// Moves a folder to another location. If the folders are on different volumes,
        /// the source folder will be copied to the destination folder then deleted.
        /// </summary>
        static public void MoveFolder(DirectoryInfo source, DirectoryInfo dest)
        {
            if (source.Root == dest.Root)
            {
                source.MoveTo(dest.FullName);
            }
            else
            {
                dest.Create();
                CopyFolder(source, dest, FolderMode.Recursive, CopyFileMode.Replace);
                DeleteFolder(source.FullName);
            }
        }

        /// <summary>
        /// Copy a folder to another folder with optional recursive behavior.
        /// </summary>
       static public void CopyFolder(DirectoryInfo sourceInfo, DirectoryInfo destInfo, FolderMode mode, CopyFileMode fileMode)
        {
            if (!destInfo.Exists)
            {
                destInfo.Create();
            }

            foreach (FileInfo fi in sourceInfo.GetFiles())
            {
                CopyFile(fi, destInfo, fileMode);
            }

           if (mode == FolderMode.Recursive)
            {
                foreach (DirectoryInfo di in sourceInfo.GetDirectories())
                {
                    DirectoryInfo childDestDir = new DirectoryInfo(destInfo.FullName + "\\" + di.Name);
                    CopyFolder(di, childDestDir, mode, fileMode);
                }
            }
        }

        /// <summary>
        /// Copy a list of specified files.
        /// </summary>
        static public void CopyFiles(string sourceDir, string destDir, List<string> relativeFiles, CopyFileMode fileMode)
        {
            foreach (string file in relativeFiles)
            {
                FileInfo sourceInfo = new FileInfo(sourceDir + "\\" + file);
                DirectoryInfo destInfo = new DirectoryInfo(Path.GetDirectoryName(destDir + "\\" + file));

                CopyFile(sourceInfo, destInfo, fileMode);
            }
        }

        /// <summary>
        /// Copy a specified file.
        /// </summary>
        /// <param name="source">Source file or directory</param>
        /// <param name="dest">Destination file or directory</param>
        static public void CopyFile(string source, string dest, CopyFileMode mode)
        {
            FileInfo sourceInfo = new FileInfo(source);
            if (!sourceInfo.Exists)
            {
                return;
            }

            DirectoryInfo destInfo = new DirectoryInfo(dest);

            CopyFile(sourceInfo, destInfo, mode);
        }

        /// <summary>
        /// Copy a specified file.
        /// </summary>
        /// <param name="sourceInfo">Source file to copy.</param>
        /// <param name="destInfo">Destination directory.</param>
        static public void CopyFile(System.IO.FileInfo sourceInfo, System.IO.DirectoryInfo destInfo, CopyFileMode mode)
        {
            System.Diagnostics.Debug.Assert(sourceInfo.Exists == true, "Source file does not exist!");

            // Avoid a missing folder exception
            if (!destInfo.Exists)
            {
                destInfo.Create();
            }

            // Avoid copying over a read only file exception
            FileInfo destPathInfo = new FileInfo(destInfo.FullName + "\\" + sourceInfo.Name);

            if (destPathInfo.Exists)
            {
                if (mode == CopyFileMode.Replace ||
                    (mode == CopyFileMode.ReplaceIfNewer && destPathInfo.LastWriteTime < sourceInfo.LastWriteTime))
                {
                    destPathInfo.IsReadOnly = false;
                    destPathInfo.Delete();
                }
                else // SkipIfExists or ReplaceIfNewer fails
                {
                    return;
                }
            }

            // Perform the actual copy
            sourceInfo.CopyTo(destPathInfo.FullName, true);
        }

       /// <summary>
       /// Make the specified file read/writable
       /// </summary>
       static public void MakeFileWritable(System.IO.FileInfo fileInfo)
       {
           if (fileInfo.Exists)
           {
               fileInfo.IsReadOnly = false;
           }
       }

       /// <summary>
       /// Make the specified file read/writable
       /// </summary>
       static public void MakeFolderContentsWritable(System.IO.DirectoryInfo dirInfo, FolderMode mode)
       {
           foreach (FileInfo fi in dirInfo.GetFiles())
           {
               MakeFileWritable(fi);
           }

           if (mode == FolderMode.Recursive)
           {
               foreach (DirectoryInfo di in dirInfo.GetDirectories())
               {
                   DirectoryInfo childDestDir = new DirectoryInfo(dirInfo.FullName + "\\" + di.Name);
                   MakeFolderContentsWritable(childDestDir, mode);
               }
           }
       }

       /// <summary>
       /// Delete the specified folder (and any sub-folders/files)
       /// </summary>
       static public void DeleteFolder(string dir)
       {
            DeleteFolder(new DirectoryInfo(dir));
       }

        /// <summary>
        /// Delete the specified folder (and any sub-folders/files)
        /// </summary>
        static public void DeleteFolder(DirectoryInfo dirInfo)
        {
            if (dirInfo.Exists)
            {
                MakeFolderContentsWritable(dirInfo, FolderMode.Recursive);
                dirInfo.Delete(true);
            }
        }

        /// <summary>
        /// Given a directory select a random file from it.
        /// </summary>
        static public string SelectRandomFileFromFolder(string folderName)
        {
            DirectoryInfo di = new DirectoryInfo(folderName);

            if (di.Exists)
            {
                FileInfo[] files = di.GetFiles();
                if (files.Length > 0)
                {
                    Random randGenerator = new Random();
                    int index = randGenerator.Next(0, files.Length - 1);
                    return files[index].FullName;
                }
            }

            return null;
        }

        /// <summary>
        /// Computes the MD5 checksum for a single file.
        /// </summary>
        public static string ComputeMD5ForFile(string file)
        {
            FileInfo finfo = new FileInfo(file);
            BinaryReader br = new BinaryReader(finfo.OpenRead());
            byte[] fileBytes = br.ReadBytes((int)finfo.Length);
            br.Close();

            MD5 hasher = MD5.Create();
            byte[] hash = hasher.ComputeHash(fileBytes);

            StringBuilder hashString = new StringBuilder();
            foreach (byte b in hash)
            {
                hashString.Append(b.ToString("x2"));
            }
            return hashString.ToString();
        }
    }

Paypal IPN in PHP

2012-02-04T00:01:00.000-08:00

// PHP 4.1

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('ssl://www.paypal.com', 443, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// check that payment_amount/payment_currency are correct
// process payment
}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
?>

Paypal IPN in asp.net VB

2012-02-04T00:00:00.001-08:00

' ASP.NET VB

Imports System.Net
Imports System.IO

Partial Class vbIPNexample
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Post back to either sandbox or live
Dim strSandbox As String = "https://www.sandbox.paypal.com/cgi-bin/webscr"
Dim strLive As String = "https://www.paypal.com/cgi-bin/webscr"
Dim req As HttpWebRequest = CType(WebRequest.Create(strSandbox), HttpWebRequest)

'Set values for the request back
req.Method = "POST"
req.ContentType = "application/x-www-form-urlencoded"
Dim Param() As Byte = Request.BinaryRead(HttpContext.Current.Request.ContentLength)
Dim strRequest As String = Encoding.ASCII.GetString(Param)
strRequest = strRequest + "&cmd=_notify-validate"
req.ContentLength = strRequest.Length

'for proxy
'Dim proxy As New WebProxy(New System.Uri("http://url:port#"))
'req.Proxy = proxy

'Send the request to PayPal and get the response
Dim streamOut As StreamWriter = New StreamWriter(req.GetRequestStream(), Encoding.ASCII)
streamOut.Write(strRequest)
streamOut.Close()
Dim streamIn As StreamReader = New StreamReader(req.GetResponse().GetResponseStream())
Dim strResponse As String = streamIn.ReadToEnd()
streamIn.Close()

If strResponse = "VERIFIED" Then
'check the payment_status is Completed
'check that txn_id has not been previously processed
'check that receiver_email is your Primary PayPal email
'check that payment_amount/payment_currency are correct
'process payment
ElseIf strResponse = "INVALID" Then
'log for manual investigation
Else
'Response wasn't VERIFIED or INVALID, log for manual investigation
End If
End Sub
End Class

Paypal IPN in asp.net c#

2012-02-03T23:55:00.001-08:00

// ASP .NET C#

using System;
using System.IO;
using System.Text;
using System.Net;
using System.Web;

public partial class csIPNexample : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//Post back to either sandbox or live
string strSandbox = "https://www.sandbox.paypal.com/cgi-bin/webscr";
string strLive = "https://www.paypal.com/cgi-bin/webscr";
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(strSandbox);

//Set values for the request back
req.Method = "POST";
req.ContentType = "application/x-www-form-urlencoded";
byte[] param = Request.BinaryRead(HttpContext.Current.Request.ContentLength);
string strRequest = Encoding.ASCII.GetString(param);
strRequest += "&cmd=_notify-validate";
req.ContentLength = strRequest.Length;

//for proxy
//WebProxy proxy = new WebProxy(new Uri("http://url:port#"));
//req.Proxy = proxy;

//Send the request to PayPal and get the response
StreamWriter streamOut = new StreamWriter(req.GetRequestStream(), System.Text.Encoding.ASCII);
streamOut.Write(strRequest);
streamOut.Close();
StreamReader streamIn = new StreamReader(req.GetResponse().GetResponseStream());
string strResponse = streamIn.ReadToEnd();
streamIn.Close();

if (strResponse == "VERIFIED")
{
//check the payment_status is Completed
//check that txn_id has not been previously processed
//check that receiver_email is your Primary PayPal email
//check that payment_amount/payment_currency are correct
//process payment
}
else if (strResponse == "INVALID")
{
//log for manual investigation
}
else
{
//log response/ipn data for manual investigation
}
}
}

ASP.NET AJAX UpdateProgress Control

2012-02-03T23:33:00.000-08:00

In head Section

<script language="javascript" type="text/javascript">

   var prm = Sys.WebForms.PageRequestManager.getInstance();
   prm.add_initializeRequest(InitializeRequest);
   prm.add_endRequest(EndRequest);
   var postBackElement;
   function InitializeRequest(sender, args)
   {

      if (prm.get_isInAsyncPostBack())
         args.set_cancel(true);
      postBackElement = args.get_postBackElement();
      if (postBackElement.id == 'Button1')
         $get('UpdateProgress1').style.display = 'block';
   }

   function EndRequest(sender, args)
   {
       if (postBackElement.id == 'Button1')
          $get('UpdateProgress1').style.display = 'none';
   }

</script>

In Body Section

<body>
    <form id="form1" runat="server">
    <div>
         
    </div>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>
                <asp:Label ID="Label1" runat="server" Width="145px"></asp:Label>
            </ContentTemplate>
         <Triggers>
            <asp:AsyncPostBackTrigger ControlID="Button1" EventName="Click"/>
        </Triggers>
        </asp:UpdatePanel>
       <asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="0" AssociatedUpdatePanelID="UpdatePanel1">
            <ProgressTemplate>
                <script type="text/javascript">document.write("<div class='UpdateProgressBackground'></div>");</script>
                <center><div class="UpdateProgressContent">Loading...</div></center>
            </ProgressTemplate>
        </asp:UpdateProgress>

        <br />
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
    </form>
</body>

School Managment System

2012-01-06T09:09:00.000-08:00

This project is based on “School Management System” is an outcome of practical work at XYZ Khan School. One can get considerable satisfaction when and when only some positive efforts are translated into some concrete things. It is relay a very pleasant task of acknowledgement the help we received while developing this website.

At last we thanks to all who supported us for making this project.

Project Profile

Project Title : School Management
System Developed For : XYZ School. Siddhpur.
Project Guide : Prof. Ritu Chaudhari
Prof. Viral Sir

Team Member : 2
Front End : Microsoft Visual Studio 2008
Back End : MS SQL Server
Web Server : IIS (Internet Information Service)
Platform : Windows XP,
Documentation Tools : Microsoft Office 2003.

Project Definition

This website is based on “School Management System”. In this project, administrator can see the different reports like text reports and different kind of graph reports like Pie Chart, Bar Chart. Administrator can also getsee these reports with total calls with percentage of row wise and column wise.

For Get this Project Please Contact hitendra.softwareengg@gmail.com