|
Hi All,
I have created a windows based Hotel Management Application software in VS 2005 .NET (VB .NET) with SQL server 2005 Express as database. Now I have to upgrade this to a centralize server based application. There are 4 hotels located in different places. The application should run on all the 4 PCs and the SQL database will be centralized. i.e. Updates from the database will be available to all the 4 PCs so that user on these respective PCs can see what is the present state of any room, e.g., vaccant or occupied.
For this I need some information from You all for following:
1) Do I need to build an ASP.NET based application for this? I mean, will it be like a website, which is accessible to all the 4 PCs having internet connection?
2) Any other way to create this application, as I already created this as windows based in VB .NET ?
3) How to create the centralize SQL database?
Overall I want to know like, what are the steps involved to create such kind of applications and their requirement?
Any links/suggestions/references/tutorials is appriciated.
Thanks
Raja S.
|
|
|
|
|
You don't have to rebuild your application into a web based application. If you have already defined placed business logic and presentations classes separately, then just put a web service wrapper around your business logic and use your existing Windows Forms UI to consume the service.
If not, then you will have to separate your business logic [BL] and data access[DA] code from the presentation [PL] code. Ensure that all data access from PL is done only through your BL, via DA. Now expose the BL as webservice.
Creating a central database repository is something your DBA should be taking care of. If your existing DB is capable of handling data from all locations, then just hand them your existing DB scripts. Else, make necessary changes to your DB and pass on the script.
|
|
|
|
|
Hi,
I didnot get Your idea. I am just looking for a tutorial to build such kind of application.
|
|
|
|
|
What he is trying to say, that it is not necessary that you create a ASP.NET application. Your current win application needs to have one kind of communication with the centralized database. For this you could use a webservice installed on that centralized server that performs the communication between the outside world and the database. And your application needs to be modified so that it can consume this webservice. In other words consult, insert, update and delete.
It's nice and clean but you should think of alternatives before starting of. Communication with a webserver can expose data, you can't loose the security behind this idea.
|
|
|
|
|
Hi friends,
We are developing a web application that uses sessions and Forms authentication. I want to call Session.Abandon() to kill the session when the user closes the browser window(from any page of the application after logging in). How to achieve this?
Please shed some light on this to help me.
Thank you,
Shah_tech
|
|
|
|
|
|
Hi
You can call a javascript function on closing the browser. In that javascript function navigate to a logout page where you can then kill the session.
function AlertForBrowserClose()
{
var clicked=false;
var winClosed=false;
if (window.screenTop&&(window.screenTop>screen.height))
{
winClosed=true;
}
if ((!clicked) && (!winClosed))
{
}
else if(window.event.clientY < 0 && window.event.clientX < 0)
{
var MCPageName = document.location.href.substring
(
document.location.href.length , document.location.href.lastIndexOf('/') + 1
);
if(MCPageName!="MCAlerts.aspx")
{
window.location.href = '../logout.aspx';
alert('Please use proper "LogOut" for next sessions!');
}
}
}
I have used alert statement
alert('Please use proper "LogOut" for next sessions!');
Make sure that this alert is used. Else the logout page will not get hit and session soes not end.
Naina
|
|
|
|
|
Thank you for quick reply.
One thing is should I write the code in all the aspx pages of my application?
How can we kill the session when the browser is closed without writing the code in every page?
Thank you,
Shah_tech
|
|
|
|
|
Are you using master page in your application which is referred in all the aspx pages. If so you can write the code in master page and redirect to logout page. If not i guess you should write in every aspx page.
Regards
Naina
Naina
|
|
|
|
|
or just put it in a .js file and include it in all the pages.
|
|
|
|
|
dear all
recently i am working on gridview.
The problem that i have been facing is that i need to insert textbox in gridview and row of gridview need to be automatically incremented as per user input.Therfore,can anyone help me out from this problem?
thanx in advanced
|
|
|
|
|
|
Hi all,
I have to create plugins toolbar(like google toolbar) for IE,FireFox and Flock
But I have no idea where to start for it.
I had search on google but not getting any help.
Thanks in advance.
|
|
|
|
|
|
Hi all
I m inserting an event date in my databse like marriage.
so we want that before coming marriage date automatic mail will be shoot after a particular time like 1 or 2 or 5 day etc, when that marriage will not be finished.
so how we fixed that time that email shoot automatically
|
|
|
|
|
A windows service, or scheduled task that reads the database and generates the emails?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
As ashfeild suggested to go for task scheduller ..!Its A good idea..!
apart from tht you can go for triggers or sql jobs..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
I am planning for write an article for all possible Automatic Email generation scenarios. This is one of the most common question now a day ! I have to find out some times for it. 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Great to hear from you..!
Because there is no good articles which are related to tht..!
all the best..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Yeah ! I need some good time for it  . I will manage.... 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
For Me also thts the problem I am little bit busy with my project ..!May Be i will try to write an article on quartz scheduller.!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
How is a trigger going to do it? Unless you plan on running a check each time the trigger fires, which would be ridiculously wasteful.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
sorry my mistake..! i thought after he entered "marriage" in database....!
rummer wrote: mail will be shoot after a particular time like 1 or 2 or 5 day etc
i missed tht line..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Hello Friends,
I'm sending mail using the following code and mail is working fine.
SmtpClient client = new SmtpClient();
string from = "manoj.msb1984@gmail.com";
MailAddress From = new MailAddress(from);
//To whom the mail is being sent
string to = "depth.heart@gmail.com";
MailAddress To = new MailAddress(to);
//To whom Carbon copy is being sent if there is not don't write this code
//string cc = "rawgirish@gmail.com";
//MailAddress Cc = new MailAddress(cc);
//Creat an object for MailMessage
MailMessage message = new MailMessage(From, To);
//Set Message body HTML true otherwise sometime it send html code
message.IsBodyHtml = true;
//Add Your Subject
message.Subject = "Add You Subject Here";
//Add Body of the Mail here
string strBody = "Hello, This is Manoj Bisht <br> Got It";
message.Body = strBody;
try
{
//Send the Mail
client.Send(message);
//Show sent message if mail is sent successfully
Response.Write("Mail Sent Successfully");
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
But when im using this code to send email over intranet it's throwing error as shown below
{"Failure sending mail."}
[System.Net.Mail.SmtpException]: {"Failure sending mail."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: {"Unable to connect to the remote server"}
Message: "Failure sending mail."
Source: "System"
StackTrace: " at System.Net.Mail.SmtpClient.Send(MailMessage message)\r\n at Rough_New.cmdSend_Click(Object sender, EventArgs e)"
TargetSite: {Void Send(System.Net.Mail.MailMessage)}
|
|
|
|
|
Where is your SMTP Server name ? Does your SMTP in local Intranet configured properly ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
