public void CreateAndInsertIntoPantryTable()
{
var db = new DatabaseStuff();
var PantryColumns = new List <string>()
{
"Pantry_Id int not null identity(1,1) primary key",
"Name nvarchar(60) not null",
"Ounces_Consumed decimal(6,2) not null",
"Ounces_Remaining decimal(6,2) not null",
"Expired int not null",
"Expiring_Soon int not null",
"Restock_Required int not null"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "Pantry", PantryColumns);
var pan = new Pantry();
pan.Pantry_Id = 1;
pan.Name = "Bread Flour";
pan.Ounces_Consumed = 32.4m;
pan.Ounces_Remaining = 47.6m;
pan.Expired = 0;
pan.Expiring_Soon = 0;
pan.Restock_Required = 0;
context.Pantry.Add(pan);
context.SaveChanges();
var pantryCount =
(from p in context.Pantry
select p).Count();
Assert.AreEqual(1, pantryCount);
}
}
public void CreateAndINsertIntoRecipeInformationTable()
{
var db = new DatabaseStuff();
var RecipesColumns = new List <string>()
{
"Id int not null identity(1,1) primary key",
"Name nvarchar(80) not null",
"Yield int not null",
"TotalPrice decimal(7,2) not null",
"PricePerYield decimal(5,2) not null",
"HaveEnoughToMakeCurrently int not null"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "Recipes", RecipesColumns);
var R = new Recipes();
R.Id = 1;
R.Name = "Honeywheat Bread";
R.Yield = 24;
R.TotalPrice = 0m;
R.PricePerYield = 0m;
R.HaveEnoughToMakeCurrently = 1;
context.Recipes.Add(R);
context.SaveChanges();
var recipesCount = (from r in context.Recipes
select r).Count();
Assert.AreEqual(1, recipesCount);
}
}
public void CreateAndInsertIntoIngredientsTable()
{
var db = new DatabaseStuff();
var IngredientsColumns = new List <string>()
{
"Id int not null identity(1,1) primary key",
"Name nvarchar(70)",
"Recipe_Id int",
"Measurement nvarchar(70)",
"Type nvarchar(50)",
"Classification nvarchar(50)",
"Selling_Weight nvarchar(50)"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "Ingredients", IngredientsColumns);
var Ing = new Ingredients();
Ing.Id = 1;
Ing.Name = "Bread Flour";
Ing.Measurement = "6 cups";
Ing.Selling_Weight = "5 lb";
Ing.Recipe_Id = 1;
Ing.Type = "Bread Flour";
context.Ingredients.Add(Ing);
context.SaveChanges();
var ingredientsCount =
(from i in context.Ingredients
select i).Count();
Assert.AreEqual(1, ingredientsCount);
}
}
public void CreateAndInsertIntoCostsTable()
{
var db = new DatabaseStuff();
var CostsColumns = new List <string>()
{
"Id int not null identity(1,1) primary key",
"Name nvarchar(70) not null",
"Selling_Price decimal(6,2) not null",
"Selling_Weight nvarchar(50) not null",
"Selling_Weight_Ounces decimal(6,2) not null",
"Count_Ingredient_Recorded_In_Costs int not null",
"Average_Price decimal(6,2) not null"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "Costs", CostsColumns);
var costs = new Costs();
costs.Id = 1;
costs.Name = "Bread Flour";
costs.Selling_Price = 4.69m;
costs.Selling_Weight = "5 lb";
costs.Selling_Weight_Ounces = 80m;
costs.Count_Ingredient_Recorded_In_Costs = 1;
costs.Average_Price = 4.69m;
context.Costs.Add(costs);
context.SaveChanges();
var costsCount =
(from c in context.Costs
select c).Count();
Assert.AreEqual(1, costsCount);
}
}
public void CreateAndInsertIntoSellingInformationTable()
{
var db = new DatabaseStuff();
var SellingInformationColumns = new List <string>()
{
"Id int not null identity(1,1) primary key",
"Name nvarchar(80) not null",
"Selling_Weight nvarchar(50) not null",
"Selling_Weight_Ounces decimal(6,2)"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "SellingInformation", SellingInformationColumns);
var SI = new SellingInformation();
SI.Id = 1;
SI.Name = "Bread Flour";
SI.Selling_Weight = "5 lb";
SI.Selling_Weight_Ounces = 80m;
context.SellingInformation.Add(SI);
context.SaveChanges();
var sellingInformationCount = (from s in context.SellingInformation
select s).Count();
Assert.AreEqual(1, sellingInformationCount);
}
}
public void CreateAndINsretIntoIngredientConsumptionTable()
{
var db = new DatabaseStuff();
var IngredientConsumptionColumns = new List <string>()
{
"Id int not null identity(1,1) primary key",
"Name nvarchar(70) not null",
"Measurement nvarchar(70) not null",
"Ounces_Consumed decimal(6,2)"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "IngredientConsumption", IngredientConsumptionColumns);
var con = new IngredientConsumption();
con.Name = "Bread Flour";
con.Id = 1;
con.Ounces_Consumed = 32.4m;
//con.Measurement = "6 cups";
con.Measurement = "6 cups";
context.IngredientConsumption.Add(con);
context.SaveChanges();
var ingredientConsumptionCount =
(from c in context.IngredientConsumption
select c).Count();
Assert.AreEqual(1, ingredientConsumptionCount);
}
}
public SmsResponse PingmePleasebySms(SmsRequest smsRequest)
{
SmsResponse smsResponse = new SmsResponse();
DatabaseStuff databaseStuff = new DatabaseStuff();
string request, response, streamResponse;
try
{
#region for wcf basic auth services
var hostIdentity = WindowsIdentity.GetCurrent().Name;
var primaryIdentity = ServiceSecurityContext.Current.PrimaryIdentity.Name;
var windowsIdentity = ServiceSecurityContext.Current.WindowsIdentity.Name;
var threadIdentity = Thread.CurrentPrincipal.Identity.Name;
//var isAdmin = Thread.CurrentPrincipal.IsInRole("admin");
#endregion
//todo: Implement the sms stuff in the wcf service
}
catch (Exception ex)
{
smsResponse.Success = false;
smsResponse.Message = "An error has occurred: " + ex.Message;
smsResponse.ApiMessageId = null;
smsResponse.SubmittedDateTime = null;
}
return(smsResponse);
}
public async void SearchCommandExecuted(object param)
{
_searchingDb = true;
DatabaseSearchResults.Clear();
if (String.IsNullOrEmpty(FirstName.Trim()))
{
FirstName = String.Empty;
}
if (String.IsNullOrEmpty(LastName.Trim()))
{
FirstName = String.Empty;
}
if (String.IsNullOrEmpty(StreetAddress.Trim()))
{
StreetAddress = String.Empty;
}
if (String.IsNullOrEmpty(City.Trim()))
{
City = String.Empty;
}
if (String.IsNullOrEmpty(ZipCode.Trim()))
{
ZipCode = String.Empty;
}
Parallel.ForEach((await DatabaseStuff.RunQuery(FirstName, LastName,
(UseDateOfBirth ? DateOfBirth : DateTime.MinValue), DobEqual, DobAfter, DobBefore, StreetAddress, City, ZipCode)), personModel =>
Application.Current.Dispatcher.BeginInvoke(new Action(() =>
DatabaseSearchResults.Add(personModel)
))
);
_searchingDb = false;
}
private async void RunSpouseQuery(FacebookLinkModel facebookLinkModel)
{
if (!String.IsNullOrEmpty(facebookLinkModel.MarriedTo))
{
facebookLinkModel.PossibleSpouseLinks =
await DatabaseStuff.RunQuery(facebookLinkModel.SpouseFirstName,
facebookLinkModel.SpouseLastName, facebookLinkModel.CurrentCity);
}
}
public ActionResult IDTest()
{
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
var db = new DatabaseStuff();
db.RecreateDatabase(context);
var IngDen = new IngredientDensities();
try {
IngDen.Name = "all purpose flour";
IngDen.Density = 5m;
//context.IngredientDensities.Add(IngDen);
context.IngredientDensities.Add(IngDen);
context.SaveChanges();
} catch (Exception e) {
ViewBag.InnerExceptionMessage = e.ToString();
}
return(View());
}
}
public async void SearchVoterDBCommandExecuted(object args)
{
FacebookLinkModel facebookLinkModel = args as FacebookLinkModel;
if (facebookLinkModel == null ||
String.IsNullOrEmpty(facebookLinkModel.CurrentCity) ||
String.IsNullOrEmpty(facebookLinkModel.CurrentCity))
{
MessageBox.Show("You must first scrape facebook before doing sub operations");
return;
}
IsLoading = true;
SelectedFacebookLinkModel = facebookLinkModel;
facebookLinkModel.PossibleLinks =
await DatabaseStuff.RunQuery(facebookLinkModel.FirstName,
facebookLinkModel.LastName, facebookLinkModel.CurrentCity);
RunSpouseQuery(facebookLinkModel);
if (facebookLinkModel.PossibleSpouseLinks != null && facebookLinkModel.PossibleSpouseLinks != null && facebookLinkModel.PossibleLinks.Count > 0 && facebookLinkModel.PossibleSpouseLinks.Count > 0)
{
bool matched = false;
foreach (PersonModel possibleLink in facebookLinkModel.PossibleLinks)
{
if (matched)
{
break;
}
foreach (PersonModel possibleSpouseLink in facebookLinkModel.PossibleSpouseLinks)
{
if (possibleLink.address == possibleSpouseLink.address)
{
facebookLinkModel.VoterDBMatch = possibleLink;
facebookLinkModel.SouseVoterDBMatch = possibleSpouseLink;
matched = true;
}
}
}
}
IsLoading = false;
}
//[PrincipalPermission(SecurityAction.Demand, Role = "admin")]
public EmailResponse NotifymeThankyoubyEmail(EmailRequest emailRequest)
{
EmailResponse emailResponse = new EmailResponse();
DatabaseStuff databaseStuff = new DatabaseStuff();
string request, response;
try
{
#region for wcf basic auth services
var hostIdentity = WindowsIdentity.GetCurrent().Name;
var primaryIdentity = ServiceSecurityContext.Current.PrimaryIdentity.Name;
var windowsIdentity = ServiceSecurityContext.Current.WindowsIdentity.Name;
var threadIdentity = Thread.CurrentPrincipal.Identity.Name;
//var isAdmin = Thread.CurrentPrincipal.IsInRole("admin");
#endregion
var pigeonRequest = EmailFactory.CreatePigeonRequest(emailRequest);
var pigeonResponse = notifyByPigeon.SendAFitPigeon(pigeonRequest);
if (pigeonResponse.Success)
{
emailResponse = EmailFactory.CreateEmailResponse(pigeonResponse);
request = CommonUtility.SerializeObject(emailRequest);
response = CommonUtility.SerializeObject(emailResponse);
var isSaved = databaseStuff.SaveaSomethingAwesome(request, response, 1);
}
}
catch (Exception ex)
{
emailResponse.Success = false;
emailResponse.Message = "An error has occurred: " + ex.Message;
emailResponse.SubmittedDateTime = null;
}
return(emailResponse);
}
public void CreateAndInsertIntoIngredientDensities2()
{
var db = new DatabaseStuff();
var IngredientDensityColumns = new List <string>()
{
"Id int not null identity(1,1) primary key",
"Name nvarchar(60)",
"Density decimal(5,2)"
};
using (var context = new RachelsRosesMobileDevelopmentEntities()) {
db.RecreateDatabase(context, "IngredientDensities", IngredientDensityColumns);
var IngDen = new IngredientDensities();
IngDen.Id = 1;
IngDen.Name = "bread flour";
IngDen.Density = 5.4m;
context.IngredientDensities.Add(IngDen);
context.SaveChanges();
var densitiesCount =
(from d in context.IngredientDensities
select d).Count();
Assert.AreEqual(1, densitiesCount);
}
}
public Derived(DatabaseStuff d, TimerStuff t, Something <Other> something) : base(d, t)
{
public Base(DatabaseStuff d, TimerStuff t)
{
