public void RegisterAccident( int amount, DateTime time, int Drinks, DateTime TimeSleep, DateTime TimeToilet, int ToiletVisit ) { Transaction trans; SqlCommand cmd; trans = new Transaction(); trans.BegindTransactions(); int i = 101; try { cmd = new SqlCommand("RegisterBWAcc", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Amount", amount)); cmd.Parameters.Add(new SqlParameter("@TimeOfAccident", time)); cmd.Parameters.Add(new SqlParameter("@DeviceID", DeviceNumber)); cmd.Parameters.Add(new SqlParameter("@Drinks", Drinks)); cmd.Parameters.Add(new SqlParameter("@TimeSleep", TimeSleep)); cmd.Parameters.Add(new SqlParameter("@TimeToilet", TimeToilet)); cmd.Parameters.Add(new SqlParameter("@Toilet", ToiletVisit)); //cmd.Parameters.Add(new SqlParameter("@Version", (Version + 1))); i = cmd.ExecuteNonQuery(); trans.Commit(); } catch (Exception e) { trans.RollBack(); throw e; } //trans.Commit(); }
public void SendMessage(string Messagtxt, DateTime senddate, string Tittle, int UserID) { Transaction trans; SqlCommand cmd; trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("SendMessage", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Message", Messagtxt)); cmd.Parameters.Add(new SqlParameter("@sendDate", senddate)); cmd.Parameters.Add(new SqlParameter("@Tittle", Tittle)); cmd.Parameters.Add(new SqlParameter("@UserID", UserID)); cmd.ExecuteNonQuery(); trans.Commit(); } catch (Exception e) { trans.RollBack(); throw e; } }
public void DeleteAccidents(int AccidentID) { Transaction trans; SqlCommand cmd; trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("DeleteAccident", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@AccidentID", AccidentID)); cmd.ExecuteNonQuery(); } catch (Exception e) { trans.RollBack(); throw e; } trans.Commit(); }
public void UpdateAccident(int accID, DateTime time, int amount, int DeviceID) { Transaction trans; SqlCommand cmd; int versionCheck = getVersion(accID); trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("UpdateAccident", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@AccidentID", accID)); cmd.Parameters.Add(new SqlParameter("@Amount", amount)); cmd.Parameters.Add(new SqlParameter("@TimeOfAccident", time)); cmd.Parameters.Add(new SqlParameter("@DeviceID", DeviceID)); cmd.Parameters.Add(new SqlParameter("@versionCheck", versionCheck)); cmd.ExecuteNonQuery(); } catch (Exception e) { trans.RollBack(); throw e; } trans.Commit(); }
public void RegisterDevice(int userID) { Transaction trans = new Transaction(); SqlCommand cmd; trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("RegisterDevice", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@UserID", userID)); cmd.ExecuteNonQuery(); } catch (Exception e) { trans.RollBack(); throw e; } trans.Commit(); }
public int getUserIDFromUsername(string username) { int userID = 0; trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("getIDfromUsername", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Username", username)); SqlDataReader dbr; dbr = cmd.ExecuteReader(); while (dbr.Read() == true) { if (dbr.HasRows) { userID = (int)dbr["UserID"]; } } dbr.Close(); } catch (Exception e) { trans.RollBack(); throw e; // trans.getcon().Close(); } trans.Commit(); trans.getcon().Close(); return userID; }
public void SignUp(string type, string birthday, string UserName, string PassWord, string Name, int deviceID) { Transaction trans; SqlCommand cmd; trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("NewSignUp", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@type", type)); cmd.Parameters.Add(new SqlParameter("@birthday", birthday)); cmd.Parameters.Add(new SqlParameter("@UserName", UserName)); cmd.Parameters.Add(new SqlParameter("@PassWord", PassWord)); cmd.Parameters.Add(new SqlParameter("@Name", Name)); cmd.Parameters.Add(new SqlParameter("@deviceID", deviceID)); cmd.ExecuteNonQuery(); } catch (Exception e) { trans.RollBack(); throw e; } trans.Commit(); }
public int login(string Username, string Password) { int Perm = 3; Transaction trans; SqlCommand cmd; trans = new Transaction(); trans.BegindTransactions(); String query = "Select UserName ,PassWord ,TypeOfUser from LogIn1 where UserName = '******'and PassWord = '******'"; cmd = new SqlCommand(query, trans.getcon(), trans.GetTransaction()); SqlDataReader dbr; dbr = cmd.ExecuteReader(); while (dbr.Read() == true) { if (dbr.HasRows) { Perm = (int)dbr["TypeOfUser"]; } } dbr.Close(); trans.Commit(); trans.GetConnection().Close(); return Perm; }