Relish your food with kosher restaurants

The best way to spend quality time with someone would be over a meal. And that meal should be sumptuous enough to leave you with a smile on yohttp://www.blogger.com/img/blank.gifur face. Well, that’s the kind of thing that kosher restaurants menus offer. These restaurants are well reputed all over the world. They offer you a wide variety to choose from but they stick to the kosher lawshttp://www.blogger.com/img/blank.gif. Each food item is given equal attention, http://www.blogger.com/img/blank.gifin case you have specifications like if you are allergic to a particular ingredient, you can address the problem well befhttp://www.blogger.com/img/blank.gifore. And it will be prepared adhering to all your needs.
Kosher restaurants menus cater to the customers desires making it quite popular. There has been seen a huge demand for kosher food from quite some time. Undoubtedly, kosher restaurants menus are pretty impressive that has made it famous over night. You name it and you will get it. They give everything that further touch of style and magic. Not only the delicious food but their wine list is remarkable as well. You get that perfect wine paired with your meal. Kosher restaurants menus are indeed interesting and there has been an increase in total number of kosher restaurants.

Where to find kosher restaurants?

Although kosher food is getting popular it might still be a challenge to find Kosher food and restaurants. In case you happen to live in a kosher restaurants with large Jewish population, then of course you will not face any problem finding a big range of good Kosher restaurants. But in case if you are in a new place where there are no Jews and no one has even heard of Kosher, then youhttp://www.blogger.com/img/blank.gif my have a tough time finding an authentic .
There are certain big metro cities all across the world where the Jewish population stays in large numbers and has already left a big impact on the food and culture around. A very good example is New York, with large Jewish community as well other blend of cultures. While here you will have no problem finding a good Kosher restaurants. But with the rising popularity of Kosher foods, you will find Kosher restaurants springing up even with hardly any Jewish people or community living there.
Even with the above information, one can never be very sure if the food served in many popular Kosher restaurants is really authentic. Therefore you need to consult your own knowledgeable Orthodox Rabbi for precise instructions before purchasing from an unverified establishment. Getting Kosher food while traveling may also offer many challenges.

Kosher restaurants

Serving food as per Jewish dietary laws, kosher restaurants will serve pizzerias, cafés,
fast food and cafeterias. You will come across kosher bakeries, caterers, butchers and
kosher Chinese as well as kosher sushi food. These establishments work under rabbinical
supervision and observe certain other Jewish laws. And if under Jewish ownership, these
locations must be closed during Jewish holidays and during Shabbat.

You will come across dairy or meat foods at such locations but at some Kosher
restaurants, you will find even delicatessens served. Some of these restaurants may
specialize in a particular kind of food and also offer different popular foods among Jews.
You will find Pizza a common and well liked food served at these kosher restaurants, buthttp://www.blogger.com/img/blank.gif
then there are kosher pizza shops that usually serve Middle Eastern cuisine, like falafel,
bagels with cream cheese and other foods such as fish. Salads may also be served.
New York City has the maximum number of kosher restaurants in US and in Canada,
you will find Toronto having the most restaurants. You will even find Kosher Chinese
restaurants too getting popular. In smaller cities, with lesser Jewish populations, you will
find kosher dining limited to just a single establishment. Jewish people often get ready-
made kosher meals that may be difficult to get otherwise.

Viste : Kosher restaurants

HPCL Bathinda

HPCL Bathinda

Project will keep 3 phases.
1. Masters
2. Transactions
3. Reports
In Master Phase…… We will make some master creations from admin side….. as per below…
1.Vendor ID* (supply material to HP)
1.Name * 2. Address 3.City* 4.Phone 5.Mobile* 6.email id* 7. Remarks
2.Site*
1. Site Name* 2. Address 3.State
3. Architecture
1. Name* 2.Address 3.City* 4. Contact Details
4. Items Data
1. Hp will provide the all items data which will use in everywhere in project
5.Purchase Order
1.PO Number 2.Site 3. %( - or +)(This will clear in next )*

• After these all masters admin will map vendor with site & purchase order number.
• This mapping process will help to vendor due to submit the bill

 Admin Can change/Delete/View all master database




Transaction Mode
1. Request Mode 2.Give authentication 3.Vendor will login 4.Submitt Bill. 5. Make a queue of invoices, Approve/rejection process.
1.1 Request mode from vendor for get password from HP then the below columns will appear on his dashboard.
1. Vendor ID 2.Email id 3. Mobile 4. PO Number 5.Remarks 6.Submitt.
 After above submission admin will access the same request in his own panel & approve him for submission of his bill
 As well as admin will approve the submission a mail will send on vendor mail id, this mail will auto generated by system contains password for login in system.
4. Vendor login
First screen will appear for submit his bill & the columns will as per below…
4.1 submission number 4.2 Site Name (auto appear from master) 4.3 %{( - or +) Auto appear from master} 4.4 Bill Number 4.5 Bill submission date(system date will appear auto) 4.6 Date of site handover 4.7 Date of dispatch hard copy of invoice 4.8 Remarks
In next box
4.9 Line number (Manually) 4.10 Item description will appear auto coz of already entered in item masters. 4.11 sub items details will open in extra dialogue box eg.
Line Number 16 (Item Code)
Then In item desc. Sand Filling
Then sub items of sand filling will appear in next box
Item name Unit Qty Unit Rate Value
(Drop down) 4 Decimals 4 Decimals Net Value

After enter the figures in all items user will click OK Button then it will come back on first screen with that figures

There are two rate basically used in database.
One Is already prefixed in database of HP.
2nd is offered by vendor that he will supply his stock in % ( - or +) mode.
For exp.:- Item Standard Rate is 1000.
HP was order to vendor who is ready to supply his stock less 5% from standard rate
Now the net price of item will 950 ( 1000 – 5% =950) this value will take in bill. But on the vendor screen both prices will display. St. Price, Net Price.
4 i. after submission bill vendor can print this invoice or generate PDF.
5. Make a queue of invoices…
5.1 After the submission the bill all bill will appear in architecture’s dashboard.
5.2 Arch. can Edit/reject invoice.
5.3 Arch. will approve invoice then it will goes to admin for final approvation.
5.4 Admin can directly access all invoice with Edit/approve/reject.
5.5 If admin or arch will reject the bill then it will send back to vendor’s mail id (used for submission the bill).Then it will process again.









Reports
1.in admin panel
1.1 Total bill submitted/approved/rejected by vendors.
1. date from to 2. Approved/rejected/submitted/all 3.Show

1.2 In Admin panel due to access of bills standard rates & actual rates both will appear.
1. Vendor ID 2. Bill Number 3.Site Name 4. Lines 5.qty 6 st.rate 7. Act. unit rate 7 value

If want to expand then click on it & the bill will expand.

This report will also exportable to excel with detail or summery.

1.3 vendor wise, site wise, Line wise total purchases


All Reports export to excel, PDF.

Some other points.

 Until admin will approve the bill vendor can view the submitted bill.
 After approve his bill the password will auto de-activate.
 Items database will provide us by party
 Some calculations also will appeared in bill submission like if item in number then direct qty will appear. But if item unit will QB then qty field appear from some calculation steps.(these all formulas provide us by party).

Trigger for insert update and delete( automatic create triggers)

GO

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Audit')
CREATE TABLE Audit
(
AuditID [int]IDENTITY(1,1) NOT NULL,
Type char(1),
TableName varchar(128),
PrimaryKeyField varchar(1000),
PrimaryKeyValue varchar(1000),
FieldName varchar(128),
OldValue varchar(1000),
NewValue varchar(1000),
UpdateDate datetime DEFAULT (GetDate()),
UserNamevarchar(128)
)
GO

DECLARE @sql varchar(8000), @TABLE_NAMEsysname
SET NOCOUNT ON

SELECT @TABLE_NAME= MIN(TABLE_NAME)
FROM INFORMATION_SCHEMA.Tables
WHERE
TABLE_TYPE= 'BASE TABLE'
AND TABLE_NAME!= 'sysdiagrams'
AND TABLE_NAME!= 'Audit'

WHILE @TABLE_NAMEIS NOT NULL
BEGIN
EXEC('IF OBJECT_ID (''' + @TABLE_NAME+ '_ChangeTracking'', ''TR'') IS NOT NULL DROP TRIGGER ' + @TABLE_NAME+ '_ChangeTracking')
SELECT @sql =
'
create trigger ' + @TABLE_NAME+ '_ChangeTracking on ' + @TABLE_NAME+ ' for insert, update, delete
as

declare @bit int ,
@field int ,
@maxfield int ,
@char int ,
@fieldname varchar(128) ,
@TableName varchar(128) ,
@PKCols varchar(1000) ,
@sql varchar(2000),
@UpdateDate varchar(21) ,
@UserName varchar(128) ,
@Type char(1) ,
@PKFieldSelect varchar(1000),
@PKValueSelect varchar(1000)

select @TableName = ''' + @TABLE_NAME+ '''

-- date and user
select @UserName = system_user ,
@UpdateDate = convert(varchar(8), getdate(), 112) + '' '' + convert(varchar(12), getdate(), 114)

-- Action
if exists (select * from inserted)
if exists (select * from deleted)
select @Type = ''U''
else
select @Type = ''I''
else
select @Type = ''D''

-- get list of columns
select * into #ins from inserted
select * into #del from deleted

-- Get primary key columns for full outer join
select@PKCols = coalesce(@PKCols + '' and'', '' on'') + '' i.'' + c.COLUMN_NAME + '' = d.'' + c.COLUMN_NAME
fromINFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
where pk.TABLE_NAME = @TableName
andCONSTRAINT_TYPE = ''PRIMARY KEY''
andc.TABLE_NAME = pk.TABLE_NAME
andc.CONSTRAINT_NAME = pk.CONSTRAINT_NAME

-- Get primary key fields select for insert
select @PKFieldSelect = coalesce(@PKFieldSelect+''+'','''') + '''''''' + COLUMN_NAME + ''''''''
fromINFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
where pk.TABLE_NAME = @TableName
andCONSTRAINT_TYPE = ''PRIMARY KEY''
andc.TABLE_NAME = pk.TABLE_NAME
andc.CONSTRAINT_NAME = pk.CONSTRAINT_NAME

select @PKValueSelect = coalesce(@PKValueSelect+''+'','''') + ''convert(varchar(100), coalesce(i.'' + COLUMN_NAME + '',d.'' + COLUMN_NAME + ''))''
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
where pk.TABLE_NAME = @TableName
and CONSTRAINT_TYPE = ''PRIMARY KEY''
and c.TABLE_NAME = pk.TABLE_NAME
and c.CONSTRAINT_NAME = pk.CONSTRAINT_NAME

if @PKCols is null
begin
raiserror(''no PK on table %s'', 16, -1, @TableName)
return
end

select @field = 0, @maxfield = max(ORDINAL_POSITION) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @TableName
while @field < @maxfield
begin
select @field = min(ORDINAL_POSITION) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @TableName and ORDINAL_POSITION > @field
select @bit = (@field - 1 )% 8 + 1
select @bit = power(2,@bit - 1)
select @char = ((@field - 1) / 8) + 1
if substring(COLUMNS_UPDATED(),@char, 1) & @bit > 0 or @Type in (''I'',''D'')
begin
select @fieldname = COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @TableName and ORDINAL_POSITION = @field
select @sql = ''insert Audit (Type, TableName, PrimaryKeyField, PrimaryKeyValue, FieldName, OldValue, NewValue, UpdateDate, UserName)''
select @sql = @sql + '' select '''''' + @Type + ''''''''
select @sql = @sql + '','''''' + @TableName + ''''''''
select @sql = @sql + '','' + @PKFieldSelect
select @sql = @sql + '','' + @PKValueSelect
select @sql = @sql + '','''''' + @fieldname + ''''''''
select @sql = @sql + '',convert(varchar(1000),d.'' + @fieldname + '')''
select @sql = @sql + '',convert(varchar(1000),i.'' + @fieldname + '')''
select @sql = @sql + '','''''' + @UpdateDate + ''''''''
select @sql = @sql + '','''''' + @UserName + ''''''''
select @sql = @sql + '' from #ins i full outer join #del d''
select @sql = @sql + @PKCols
select @sql = @sql + '' where i.'' + @fieldname + '' <> d.'' + @fieldname
select @sql = @sql + '' or (i.'' + @fieldname + '' is null and d.'' + @fieldname + '' is not null)''
select @sql = @sql + '' or (i.'' + @fieldname + '' is not null and d.'' + @fieldname + '' is null)''
exec (@sql)
end
end
'
SELECT @sql
EXEC(@sql)
SELECT @TABLE_NAME= MIN(TABLE_NAME) FROM INFORMATION_SCHEMA.Tables
WHERE TABLE_NAME> @TABLE_NAME
AND TABLE_TYPE= 'BASE TABLE'
AND TABLE_NAME!= 'sysdiagrams'
AND TABLE_NAME!= 'Audit'
END

Asp.net interview questions

1. Explain the life cycle of an ASP .NET page.?
Following are the events occur during ASP.NET Page Life Cycle:

1)Page_PreInit
2)Page_Init
3)Page_InitComplete
4)Page_PreLoad
5)Page_Load
6)Control Events
7)Page_LoadComplete
8)Page_PreRender
9)SaveViewState
10)Page_Render
11)Page_Unload

Among above events Page_Render is the only event which is raised by page. So we can't write code for this event.

2. how does the cookies work in asp.net?
we know Http is an state-less protocol which is required for interaction between clinet and server .

so there is an need to remeber state of request raised by an web browser so that
web server can recognize you have already previously visited or not.

There are two types of state management techniques:
a) Client side state management
b) Server - side statemanagement

Using cookies comes under clinet side statemanagement .In HttpResponse we write
Cookie containing sessionId and other information within it.

when a browser made a request to the web server the same cookie is sent to the server where server recognize the session id and get other information stored to it previously.

3. What is Ispostback method in ASP.Net? Why do we use that??
Basically Post back is an action performed by a interactive Webpage. When it goes to the server side for a non-client Operation Server again posts it back to the client and hence the name.
Ex:

if(!IsPostBack)

will not allow the page to post back again n again bcoz it reduces the performance.

4. Can User Control be stored in library?.
I will say "NO"

there are 3 types of controls:
1) User Control
2) Custom Control
3) Web parts

you can reuse User control in the current project in which you have built it, but you can't move it to other project as unless you just copy paste the same file there and make the changes for that project ( which violets the concept of library).

but custom control can be shared between projects. and you can precompile them even as a dll, so this means you can use them in library of any type.

5. what is the difference between application state and caching?
Application Object and Cached Object both falls under Server side State Management.

Application object resides in InProc i.e. on the same server where we hosted our application.
Cache Object resides on server side/ DownStream/Client Side.

Application Object will be disposed once application will stop.
Cache Object can be disposed using Time based cache dependency.

Only one user can access Application Object at a time hence we have to lock it every time we modify it.

6. what is boxing and unboxing?
Boxing is what happens when a value-type object is assigned to a reference-type variable.
Unboxing is what happens when a reference-type variable is assigned to a value-type variable.


7. What are the uses of Reflection??
Reflection is a concept using which we can

1) Load assemblies dynamically
2) Invoke methods at runtime
3) Retriving type information at runtime.

8. What is the use of AutoWireup in asp.net?
AutoEventWireup attribute is used to set whether the events needs to be automatically generated or not.
In the case where AutoEventWireup attribute is set to false (by default) event handlers are automatically required for Page_Load or Page_Init. However when we set the value of the AutoEventWireup attribute to true the ASP.NET runtime does not require events to specify event handlers like Page_Load or Page_Init.

9. what events will occur when a page is loaded?
Below are the events occures during page load.

1) Page_PreInit
2) Page_Init
3) Page_InitComplete
4) Page_PreLoad

10. Where is the View state Data stored?
ViewState data is stored in the hidden field. When the page is submitted to the server the data is sent to the server in the form of hidden fields for each control. If th viewstate of the control is enable true the value is retained on the post back to the client when the page is post backed.

11. What is the difference between custom web user control and a custom web server control?
Web User Control:
1) Easy to Create.
2) It Can be used inside the same Application.(To use it in other application we need to add it to that project.)
3) It Can take advantage of Caching Technique.

Web Server Control:
1) Bit tuff to create as compare to User Control.
2) Easy to use.
3) Can be added to ToolBox.

12. Where do the Cookie State and Session State information be stored?
Cookie Information will be stored in a txt file on client system under a
folder named Cookies. Search for it in your system you will find it.

Coming to Session State
As we know for every process some default space will be allocated by OS.

In case of InProc Session Info will be stored inside the process where our
application is running.
In case of StateServer Session Info will be stored using ASP.NET State Service.
In case of SQLServer Session info will be stored inside Database. Default DB
which will be created after running InstallSQLState Script is ASPState.

13. What is the difference between adding reference in solution Explorer and adding references by USING ?
Adding reference in solution explorer is used to add the DLL for that project for reference only. If you want to utilize that DLL methods/functions in our aspx.cs/.cs file etc you must write using that nameclass library name in file.

14. What are the different types of sessions in ASP.Net? Name them.?
Session Management can be achieved in two ways

1)InProc
2)OutProc

OutProc is again two types
1)State Server
2)SQL Server

InProc
Adv.:
1) Faster as session resides in the same process as the application
2) No need to serialize the data

DisAdv.:
1) Will degrade the performance of the application if large chunk of data is stored
2) On restart of IIS all the Session info will be lost

State Server
Adv.:
1) Faster then SQL Server session management
2) Safer then InProc. As IIS restart
won't effect the session data

DisAdv.:
1) Data need to be serialized
2) On restart of ASP.NET State Service session info will be lost
3)Slower as compared to InProc

SQL Server
Adv.:
1) Reliable and Durable
2) IIS and ASP.NET State Service
restart won't effect the session data
3) Good place for storing large chunk of data

DisAdv.:
1) Data need to be serialized
2) Slower as compare to InProc and State Server
3)Need to purchase Licensed
version of SQL Serve
15. How do you design a website with multilingual support in ASP.NET?
Multilingual website can be created using Globalization and Localization.

Using Globalization we change the Currency Date Numbers etc to Language Specific Format.

To change the string which is there in the label button etc to language specific string we use Localization.

In Localization we have to create different Resource files for different languages.
During this process we use some classes present in System.Resources System.Globalization System.Threading namespaces.
16. What is caching? What are different ways of caching in ASP.NET?
Caching is a technique of persisting the data in memory for immediate access to requesting program calls. This is considered as the best way to enhance the performance of the application.

Caching is of 3 types:
Output Caching - Caches the whole page.
Fragment Caching - Caches a part of the page
Data Caching - Caches the data

17. What is meant by 3-tier architecture.
We generally split our application into 3-Layers
1)Presentation Layer ( Where we keep all web forms Master Pages and User Controls).
2)Business Layer (Where we keep business logic). e.g Code related to manipulating data Custom Exception classes Custom Control classes Login related code if any etc. etc.
3)Data Access Layer (Where we keep code used to interact with DB). e.g. We can have the methods which are using SQL Helper (Application Block).

18. Explain the basic functionality of garbage collector?
Garbage Collector in .Net Framework is used for Automatic Memory Management i.e. it is collect all unused memory area and give to application. system.gc.collect() is a method for release the memory. But remember one think it is only an request i.e. we can't explicitly release the memory by using system.gc.collect().

19. What is the difference between mechine.config and web.config?
machine.config is a system level configuration i.e it is applied on all application in o/s that the configuration is set where as in web.config it is applicable to only one application i.e each asp.net webapplication will contain atleast on web.config file.

20. How can exception be handled with out the use of try catch?
using Exception Management application block

or
Page_error
Application_error objects

21. What is the difference between Response.Redirect and Server.Transfer.
Server.Transfer transfers page processing from one page directly to the next page without making a round-trip back to the client's browser. This provides a faster response with a little less overhead on the server.Server.Transfer does not update the clients url history list or current url.

Response.Redirect is used toredirect the user's browser to another page or site. This performs a trip back to the client where the client's browser is redirected to the new page. The user's browser history list is updated to reflect the new address.

22. Where the assembly is stored in asp.net?.
private are stored in application / bin directory and public are stored in GAC.

23. How we implement Web farm and Web Garden concept in ASP.NET?.
A web farm is a multi-server scenario. So we may have a server in each state of US. If the load on one server is in excess then the other servers step in to bear the brunt.
How they bear it is based on various models.
1. RoundRobin. (All servers share load equally)
2. NLB (economical)
3. HLB (expensive but can scale up to 8192 servers)
4. Hybrid (of 2 and 3).
5. CLB (Component load balancer).
A web garden is a multi-processor setup. i.e. a single server (not like the multi server above).
How to implement webfarms in .Net:
Go to web.config and
Here for mode you have 4 options.
a) Say mode inproc (non web farm but fast when you have very few customers).
b) Say mode StateServer (for webfarm)
c) Say mode SqlServer (for webfarm)
Whether to use option b or c depends on situation. StateServer is faster but SqlServer is more reliable and used for mission critical applications.
How to use webgardens in .Net:
Go to web.config and
Change the false to true. You have one more attribute that is related to webgarden in the same tag called cpuMask.

24. Is there any limit for query string? means what is the maximum size?..
Servers should be cautious about depending on URI lengths above 255 bytes because some older client or proxy implementations may not properly support these lengths.

Query string length depends on browser compatability

IE supports upto 255
Firefox supports upto 4000

25. What is the exact purpose of http handlers?
ASP.NET maps HTTP requests to HttpHandlers. Each HttpHandler enables processing of individual HTTP URLs or groups of URL extensions within an application. HttpHandlers have the same functionality as ISAPI extensions with a much simpler programming model

Ex
1.Default HttpHandler for all ASP.NET pages ->ASP.NET Page Handler (*.aspx)
2.Default HttpHandler for all ASP.NET service pages->ASP.NET Service Handler (*.asmx)

An HttpHandler can be either synchronous or asynchronous. A synchronous handler does not return until it finishes processing the HTTP request for which it is called. An asynchronous handler usually launches a process that can be lengthy and returns before that process finishes
After writing and compiling the code to implement an HttpHandler you must register the handler using your application's Web.config file.

My Sweet Home