public CustomerMenu(SavvyContext context, DBMapper mapper)
{
this.repo = new SavvyRepo(context, mapper);
productMenu = new ProductMenu(context, mapper, customer);
cartMenu = new CartMenu();
//orderhistorymenu = new OrderHistoryMenu(context, mapper);
}
public async Task AddAnalysisAsyncShouldHandleErrorsAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddAnalysisAsyncShouldHandleErrorsAsync")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator b = new BusinessLogic.Creator()
{
Email = "*****@*****.**",
ChannelName = "Mathemartian"
};
AverageSentiment avg = new AverageSentiment()
{
VideoURL = "Abc",
AverageSentimentScore = 0.5
};
//act
try
{
await repo.AddAnalysisAsync(avg, b);
Assert.True(false);
} catch (CreatorDoesNotExistException)
{
//assert
Assert.True(true);
}
}
public async Task ChannelNameShouldBeUniqueTest2Async()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("ChannelNameShouldBeUniqueTest2")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
//act
await repo.AddCreatorAsync(c);
try
{
await repo.AddChannelAsync(c, "MatheMartian");
await repo.UpdateChannelNameAsync("MatheMartian", c);
//assert
Assert.True(false);
}
catch
{
Assert.True(true);
}
}
public async Task AddCreatorsShouldAddCreatorsAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddCreatorsShouldAdd")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
//act
await repo.AddCreatorAsync(c);
//assert
using var assertContext = new YouTubeJamContext(options);
var rest = assertContext.Creator.Select(c => c);
Assert.NotNull(rest);
}
public async Task LogInShouldLogInAsync()
{
//assert
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("LogInShouldLogIn")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
string email = "*****@*****.**";
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = email
};
//act
await repo.AddCreatorAsync(c);
await repo.AddChannelAsync(c, "Amrs");
//assert
using var assertContext = new YouTubeJamContext(options);
mapper = new DBMapper(assertContext);
repo = new Repository(assertContext, mapper);
var result = await repo.LogInAsync(email);
Assert.NotNull(result);
}
public async Task LogInShouldHandleExceptionsAsync()
{
//assert
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("LogInShouldHandleExceptions")
.Options;
string email = "*****@*****.**";
using var assertContext = new YouTubeJamContext(options);
var mapper = new DBMapper(assertContext);
var repo = new Repository(assertContext, mapper);
//act & assert
try
{
var result = await repo.LogInAsync(email);
Assert.True(false);
}
catch (Persistence.CreatorDoesNotExistException)
{
Assert.True(true);
}
}
public async Task UpdateChannelNameShouldUpdateAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("UpdateChannelNameShouldUpdate")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
//act
await repo.AddCreatorAsync(c);
await repo.AddChannelAsync(c, "MatheMartian");
await repo.UpdateChannelNameAsync("MathMars", c);
//assert
using var assertContext = new YouTubeJamContext(options);
mapper = new DBMapper(assertContext);
repo = new Repository(assertContext, mapper);
var result = await repo.GetUserAsync("*****@*****.**");
Assert.True(result.ChannelName == "MathMars");
}
public async Task AddCreatorandChannelShouldAddAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddCreatorandChannelShouldAdd")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
string channelName = "MatheMartian";
//act
await repo.AddCreatorandChannelAsync(c, channelName);
//assert
using var assertContext = new YouTubeJamContext(options);
var result = assertContext.Channel.FirstOrDefaultAsync(c => c.ChannelName == channelName);
Assert.NotNull(result);
}
public async Task AddCreatorandChannelShouldBeUniqueAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddCreatorandChannelShouldBeUnique")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
string channelName = "MatheMartian";
//act
try
{
await repo.AddCreatorandChannelAsync(c, channelName);
await repo.AddCreatorandChannelAsync(c, channelName);
Assert.True(false);
}
catch (ChannelNameTakenException)
{
Assert.True(true);
}
}
// Use this for initialization
void Start()
{
SqliteInit.InitSqlite();
FieldLister lister = new FieldLister();
UserData[] data = new UserData[2];
data[0] = new UserData();
data[0].ID = 1;
data[0].Name = "Tarou";
data[0].Hoge = "fuga";
data[0].Age = 32;
data[0].LastUpdated = new DateTime(2013, 4, 1);
data[0].NestedClass.Fuga = "bbbb";
data[0].NestedClass.Hoge = 23;
data[1] = new UserData();
data[1].ID = 2;
data[1].Name = "Jirou";
data[1].Hoge = "wahoo";
data[1].Age = 11;
data[1].AddressData = "aaaaa";
data[1].LastUpdated = new DateTime(2013, 5, 1);
Write(data[0].ToString());
var info = lister.ListUp <UserData>();
Write(info.ToString());
var sqlMaker = new SQLMaker();
string insert = sqlMaker.GenerateInsertSQL(info, data[0]);
string update = sqlMaker.GenerateUpdateSQL(info, data[0]);
Write("Insert = {0}", insert);
Write("Update = {0}", update);
DBMapper mapper = new DBMapper(SqliteInit.Evolution.Database);
mapper.UpdateOrInsertAll(data);
UserData[] fromDb = mapper.Read <UserData>("SELECT * FROM UserData;");
Write(fromDb[0].ToString());
Write(fromDb[1].ToString());
JSONMapper jsonMapper = new JSONMapper();
string json = jsonMapper.Write <UserData>(fromDb);
UserData[] fromJson = jsonMapper.Read <UserData>(json);
Write("Json = {0}", json);
Write(fromJson[0].ToString());
Write(fromJson[1].ToString());
}
public async Task AddVideoShouldAddVideoAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddVideoShouldAdd")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
var url = "abc";
string channelName = "MatheMartian";
//act
await repo.AddCreatorAsync(c);
await repo.AddChannelAsync(c, channelName);
await repo.AddVideoAsync(url, channelName);
//assert
using var assertContext = new YouTubeJamContext(options);
var rest = await assertContext.Video.FirstAsync(v => v.URL == url);
Assert.NotNull(rest);
}
// Use this for initialization
void Start()
{
SqliteInit.InitSqlite();
FieldLister lister = new FieldLister();
UserData[] data = new UserData[2];
data[0] = new UserData();
data[0].ID = 1;
data[0].Name = "Tarou";
data[0].Hoge = "fuga";
data[0].Age = 32;
data[0].LastUpdated = new DateTime(2013,4,1);
data[0].NestedClass.Fuga = "bbbb";
data[0].NestedClass.Hoge = 23;
data[1] = new UserData();
data[1].ID = 2;
data[1].Name = "Jirou";
data[1].Hoge = "wahoo";
data[1].Age = 11;
data[1].AddressData = "aaaaa";
data[1].LastUpdated = new DateTime(2013,5,1);
Debug.Log(data[0]);
var info = lister.ListUp<UserData>();
Debug.Log(info);
var sqlMaker = new SQLMaker();
string insert = sqlMaker.GenerateInsertSQL(info,data[0]);
string update = sqlMaker.GenerateUpdateSQL(info,data[0]);
Debug.Log("Insert = " + insert);
Debug.Log("Update = " + update);
DBMapper mapper = new DBMapper(SqliteInit.Evolution.Database);
mapper.UpdateOrInsertAll(data);
UserData[] fromDb = mapper.Read<UserData>("SELECT * FROM UserData;");
Debug.Log(fromDb[0]);
Debug.Log(fromDb[1]);
JSONMapper jsonMapper = new JSONMapper();
string json = jsonMapper.Write<UserData>(fromDb);
UserData[] fromJson = jsonMapper.Read<UserData>(json);
Debug.Log("Json = " + json);
Debug.Log(fromJson[0]);
Debug.Log(fromJson[1]);
}
public OrderHistoryMenu(SavvyContext context, DBMapper mapper)
{
this.repo = new SavvyRepo(context, mapper);
this.locationtask = new LocationTask(repo);
this.inventorytask = new InventoryTask(repo);
this.producttask = new ProductTask(repo);
this.ordertask = new OrderTask(repo);
this.orderitemtask = new OrderItemTask(repo);
this.customertask = new CustomerTask(repo);
}
static void Main(string[] args)
{
SavvyContext context = new SavvyContext();
DBMapper mapper = new DBMapper();
Log.Logger = new LoggerConfiguration()
.WriteTo.File("Logs\\Logtxt.txt")
.CreateLogger();
MainMenu mainMenu = new MainMenu(context, mapper);
mainMenu.start();
}
public List <int> getUsers(DateTime dt)
{
DBMapper dm = new DBMapper();
ListDictionary Params = new ListDictionary();
Params.Add("@dt", dt);
DataSet ds = dm.BLAddOrUpdateScreeningsKings();
return(new List <int>());
}
public CartMenu()
{
SavvyContext context = new SavvyContext();
DBMapper mapper = new DBMapper();
this.repo = new SavvyRepo(context, mapper);
this.locationtask = new LocationTask(repo);
this.inventorytask = new InventoryTask(repo);
this.producttask = new ProductTask(repo);
this.carttask = new CartTask(repo);
this.cartitemtask = new CartItemTask(repo);
this.ordertask = new OrderTask(repo);
this.orderitemtask = new OrderItemTask(repo);
}
public async Task AddAnalysisShouldNotCreateNewCreatorsAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddAnalysisShouldNotCreateNewCreators")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
AverageSentiment avg = new AverageSentiment()
{
VideoURL = "Abc",
AverageSentimentScore = 0.5
};
//act
await repo.AddCreatorAsync(c);
await repo.AddChannelAsync(c, "MatheMartian");
await repo.AddVideoAsync("Abc", "MatheMartian");
await repo.AddAnalysisAsync(avg, c);
//assert
using var assertContext = new YouTubeJamContext(options);
mapper = new DBMapper(assertContext);
repo = new Repository(assertContext, mapper);
var result = await repo.GetCreatorsAsync();
if (result.Count > 1)
{
Assert.True(false);
}
else
{
Assert.True(true);
}
}
// Use this for initialization
void Start()
{
#if UNITY_ANDROID
MyLibs.InitializeSQLCipher();
#endif
if (dataObjects.Length < 1)
{
Write("No data to write database!");
return;
}
ORMSQLiteInit.InitSqlite(dbFile, dbDirectory, password);
Write("Open Database at " + ORMSQLiteInit.pathDB);
FieldLister lister = new FieldLister();
Write(dataObjects[0].ToString());
var info = lister.ListUp <UserData>();
Write(info.ToString());
string insert = SQLMaker.GenerateInsertSQL(info, dataObjects[0]);
string update = SQLMaker.GenerateUpdateSQL(info, dataObjects[0]);
Write("Insert = {0}", insert);
Write("Update = {0}", update);
DBMapper mapper = new DBMapper(ORMSQLiteInit.Evolution.Database);
mapper.UpdateOrInsertAll(dataObjects);
UserData[] fromDb = mapper.Read <UserData>("SELECT * FROM UserData;");
Write(fromDb[0].ToString());
Write(fromDb[1].ToString());
JSONMapper jsonMapper = new JSONMapper();
string json = jsonMapper.Write <UserData>(fromDb);
UserData[] fromJson = jsonMapper.Read <UserData>(json);
Write("Json = {0}", json);
Write(fromJson[0].ToString());
Write(fromJson[1].ToString());
#if UNITY_ANDROID
MyLibs.ToastMessage("SQLCipher Done");
#endif
}
public async Task AddAnalysisAsyncWithLimitedInfoShouldAddAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("AddAnalysisAsyncWithLimitedInfoShouldAddAsync")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
BusinessLogic.Creator b = new BusinessLogic.Creator()
{
Email = "*****@*****.**",
ChannelName = "Mathemartian"
};
AverageSentiment avg = new AverageSentiment()
{
VideoURL = "Abc",
AverageSentimentScore = 0.5
};
//act
await repo.AddCreatorAsync(c);
await repo.AddChannelAsync(c, "MatheMartian");
await repo.AddAnalysisAsync(avg, b);
//assert
using var assertContext = new YouTubeJamContext(options);
var rest = await assertContext.Analysis1.FirstAsync();
Assert.NotNull(rest);
}
public async Task GetUserHistoryShouldGetSomethingAsync()
{
//arrange
var options = new DbContextOptionsBuilder <YouTubeJamContext>()
.UseInMemoryDatabase("GetUserHistoryShouldGetSomething")
.Options;
using var context = new YouTubeJamContext(options);
var mapper = new DBMapper(context);
var repo = new Repository(context, mapper);
BusinessLogic.Creator c = new BusinessLogic.Creator()
{
FirstName = "Marielle",
LastName = "Nolasco",
Email = "*****@*****.**"
};
AverageSentiment avg = new AverageSentiment()
{
VideoURL = "Abc",
AverageSentimentScore = 0.5
};
//act
await repo.AddCreatorAsync(c);
await repo.AddChannelAsync(c, "MatheMartian");
await repo.AddVideoAsync("Abc", "MatheMartian");
await repo.AddAnalysisAsync(avg, c);
//assert
using var assertContext = new YouTubeJamContext(options);
mapper = new DBMapper(assertContext);
repo = new Repository(assertContext, mapper);
var result = await repo.GetUserSearchHistoryAsync("*****@*****.**");
Assert.NotNull(result[0].VideoURL);
}
/// <summary>
/// Validates Authentication
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool ValidateAuthentication(HttpRequestMessage request)
{
bool accepted = true;
HttpRequestHeaders headers = request.Headers;
if (!headers.Contains("x-tdws-authid"))
{
return(false);
}
SimpleAES decryptText = new SimpleAES("V&WWJ3d39brdR5yUh5(JQGHbi:FB@$^@", "W4aRWS!D$kgD8Xz@");
string strDecrypt = decryptText.DecryptString(headers.GetValues("x-tdws-authid").First());
DBMapper dbMapper = new DBMapper();
if (!dbMapper.ValidateDevice(Guid.Parse(strDecrypt)))
{
return(false);
}
accepted = ValidateAuthenticationBase(request);
return(accepted);
}
public ReadExcelData()
{
dbMapper = new DBMapper();
}
public MainMenu(SavvyContext context, DBMapper mapper)
{
this.customerMenu = new CustomerMenu(context, mapper);
this.managerMenu = new ManagerMenu(new SavvyRepo(context, mapper));
}
public HomeRepo()
{
this.context = new HomeContext();
this.mapper = new DBMapper();
}
public ProductMenu(SavvyContext context, DBMapper mapper, Customer Customer)
{
this.repo = new SavvyRepo(context, mapper);
this.Customer = Customer;
}
public void InsertError(ApplicationLog appLog)
{
DBMapper dataMapper = new DBMapper();
dataMapper.InsertError(appLog);
}
