We need a C# Sharp server which listen on port 5050 using SSL and on port 5051 without ssl
What it will do
connect to mysql database for obtaining login id and password and news. (database already there)
it will list connected users, allow us to disconnect any user, show connected since, data in and data out for each user
client will send following commands
Login userid
pass(on new line)
Server Response:
Error Invalid Login
Error Invalid Password
Success Login
SEND CATEGORYNAME
Server will send following command
Error Login Required
Success will send group data from excel comma separated
SEND STOCK CODE LIKE ZLC1
Server will send following command
Error Login Required
Success will send stock data from excel comma separated
We will read data from ACTIVE EXCEEL SHEET and not from excel file - excel data file is given here for reference only
TIP 1 :
Sample Code for reading from active excel sheet
[login to view URL] app = [login to view URL]("[login to view URL]") as [login to view URL];
Workbook workBook = [login to view URL] as [login to view URL];
Worksheet xlWorksheet = [login to view URL][SheetNo] as [login to view URL];
string excelValue = [login to view URL](([login to view URL][row, col] as [login to view URL]).Value);
TIP 2: Don't cache excel data as it changes on each second when in production
TIP 3: stores StockCode,Excel RowNo and StockGroupCode/CategoryName,start row,endRow for quick access from excel sheet upon client request