public bool userAuthentication(string username, string password) { ConnectionManager.DataBaseConn con = new ConnectionManager.DataBaseConn(1); SqlConnection sql=con.DBConnect(); DatabaseAccess.Query query = new DatabaseAccess.Query(); bool status= query.checkAuthentication(username, password,sql); return status; }
private void threadStartFun(Socket soc, string req) { Program.ServerForm.addtoConsole("Sign In thread Started"); Message.MessageParser parser = new Message.MessageParser(); MessageClasses.MsgSignIn.req reqobj = new MessageClasses.MsgSignIn.req(); reqobj = parser.signInParseReq(req); ConnectionManager.DataBaseConn con = new ConnectionManager.DataBaseConn(1); SqlConnection conn = con.DBConnect(); //check if user already exits UserAuth.SignInFunctions userauth = new UserAuth.SignInFunctions(); if(userauth.userAuthentication(reqobj.userName,reqobj.psw)==true) { Program.ServerForm.addtoConsole("User Exists"); MessageClasses.MsgSignIn.resp resp = new MessageClasses.MsgSignIn.resp(); resp.ack = "OK"; resp.addiMsg = "EXISTING"; Message.CreateMsg msg = new Message.CreateMsg(); string res = msg.signInResp(resp); SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter(); rw.writetoSocket(soc, res); Program.ServerForm.addtoConsole("Wrote Respose to scoket"); } else { Program.ServerForm.addtoConsole("User Does Not Exist"); MessageClasses.MsgSignIn.resp resp = new MessageClasses.MsgSignIn.resp(); resp.ack = "ERRORS"; resp.addiMsg = "NON-EXISTING"; Message.CreateMsg msg = new Message.CreateMsg(); string res = msg.signInResp(resp); SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter(); rw.writetoSocket(soc, res); Program.ServerForm.addtoConsole("Wrote Response to socket. Exiting"); } Thread.CurrentThread.Abort(); }
private void threadStartFun(Socket soc, string req) { Program.ServerForm.addtoConsole("Service SignUpReq Thread Started"); //parse msg received //System.Windows.Forms.MessageBox.Show("Signup service started:"+ req, "Server"); Message.MessageParser parser = new Message.MessageParser(); MessageClasses.MsgSignUp.req reqobj = new MessageClasses.MsgSignUp.req(); reqobj = parser.signUpParseReq(req); //create connection with sql ConnectionManager.DataBaseConn con = new ConnectionManager.DataBaseConn(1); SqlConnection conn = con.DBConnect(); //check if user already exits DatabaseAccess.Query q = new DatabaseAccess.Query(); if (true == q.checkIfUserExists(reqobj.userName, conn)) { con.DBClose(); //System.Windows.Forms.MessageBox.Show("Signup service if user exists", "Server"); MessageClasses.MsgSignUp.resp resp = new MessageClasses.MsgSignUp.resp(); resp.ack = "ERRORS"; resp.addiMsg = "AlreadyExist"; Message.CreateMsg msg = new Message.CreateMsg(); string res= msg.signUpResp(resp); SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter(); rw.writetoSocket(soc, res); Program.ServerForm.addtoConsole("Writing response to Socket"); Program.ServerForm.addtoConsole("Exiting"); Thread.CurrentThread.Abort(); } else { ConnectionManager.DataBaseConn con1 = new ConnectionManager.DataBaseConn(1); SqlConnection conn1 = con.DBConnect(); if (true == q.insertNewUser(reqobj.userName, reqobj.psw, conn1)) { Program.ServerForm.addtoConsole("New User Added"); conn1.Close(); //System.Windows.Forms.MessageBox.Show("Signup service insert user", "Server"); MessageClasses.MsgSignUp.resp resp = new MessageClasses.MsgSignUp.resp(); resp.ack = "OK"; resp.addiMsg = "Added"; Message.CreateMsg msg = new Message.CreateMsg(); string res = msg.signUpResp(resp); SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter(); rw.writetoSocket(soc, res); Program.ServerForm.addtoConsole("Wrote response to Socket"); //conn.Close(); } else { conn1.Close(); Program.ServerForm.addtoConsole("Sign Up Error while inserting to Database"); //System.Windows.Forms.MessageBox.Show("Signup service could insert", "Server"); MessageClasses.MsgSignUp.resp resp = new MessageClasses.MsgSignUp.resp(); resp.ack = "ERRORS"; resp.addiMsg = "ERRORWHILEINSERTING"; Message.CreateMsg msg = new Message.CreateMsg(); string res = msg.signUpResp(resp); SocketCommunication.ReaderWriter rw = new SocketCommunication.ReaderWriter(); rw.writetoSocket(soc, res); Program.ServerForm.addtoConsole("Wrote Respose to Socket"); //conn.Close(); } //conn.Close(); Program.ServerForm.addtoConsole("Exiting"); Thread.CurrentThread.Abort(); } //TBD }