public void AssignCompany(string companyGUID) { RemoveAssignCompany(companyGUID); string sql = @"INSERT INTO CompanyUser VALUES( @CompanyUserGUID, @CompanyGUID, @UserGUID)"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@CompanyGUID", companyGUID)); paramList.Add(new SQLiteParameter("@UserGUID", UserGUID)); paramList.Add(new SQLiteParameter("@CompanyUserGUID", GlobalVariables.GetNewGUID())); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); connector = null; }
public void SaveLog(string userGUID, string companyGUID, string logMessage, string logType) { string sql = @"INSERT INTO LogTable( LogGUID, LogDateTime, LogType, LogMessage, UserGUID, CompanyGUID ) Values( @LogGUID, @LogDateTime, @LogType, @LogMessage, @UserGUID, @CompanyGUID )"; List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>(); paramList.Add(new SQLiteParameter("@LogGUID", GlobalVariables.GetNewGUID())); paramList.Add(new SQLiteParameter("@LogDateTime", DateTime.Now)); paramList.Add(new SQLiteParameter("@LogType", logType)); paramList.Add(new SQLiteParameter("@LogMessage", logMessage)); paramList.Add(new SQLiteParameter("@UserGUID", userGUID)); paramList.Add(new SQLiteParameter("@CompanyGUID", companyGUID)); NGSConnector connector = new NGSConnector(); connector.execSQL(sql, paramList); }