protected void LoadDefaultData()
{
JourList.Models.JourListDMContainer dm = new Models.JourListDMContainer();
MembershipUser muc;
if (dm.Members.SingleOrDefault(z => z.Name == "TeamBrett") == null &&
(muc = Membership.GetUser("TeamBrett")) != null)
{
mod.Member m = new mod.Member();
m.UserId = (Guid)muc.ProviderUserKey;
m.Name = muc.UserName;
dm.AddToMembers(m);
dm.SaveChanges();
}
// Recurrence Intervals
if (dm.RecurrenceIntervals.Count() == 0)
{
mod.RecurrenceInterval rid = new Models.RecurrenceInterval();
rid.Description = "Daily";
dm.AddToRecurrenceIntervals(rid);
mod.RecurrenceInterval riw = new Models.RecurrenceInterval();
riw.Description = "Weekly";
dm.AddToRecurrenceIntervals(riw);
mod.RecurrenceInterval rim = new Models.RecurrenceInterval();
rim.Description = "Monthly";
dm.AddToRecurrenceIntervals(rim);
mod.RecurrenceInterval riy = new Models.RecurrenceInterval();
riy.Description = "Yearly";
dm.AddToRecurrenceIntervals(riy);
mod.RecurrenceInterval rin = new Models.RecurrenceInterval();
rin.Description = "Never";
dm.AddToRecurrenceIntervals(rin);
dm.SaveChanges();
}
// Unit Types
if (dm.UnitTypes.Count() == 0)
{
string[] icDescriptions = new string[] { "Other", "Volume", "Distance", "Weight", "Time", "Temperature", "None" };
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List <mod.UnitType> ic = new List <mod.UnitType>(icDescriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < icDescriptions.Length; i++)
{
ic.Add(new mod.UnitType());
ic[i].Description = icDescriptions[i];
dm.AddToUnitTypes(ic[i]);
}
dm.SaveChanges();
}
// Inventory Actions
if (dm.InventoryActions.Count() == 0)
{
string[] icDescriptions = Enum.GetNames(typeof(mod.StockUpdateEnum));;
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List <mod.InventoryAction> ic = new List <mod.InventoryAction>(icDescriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < icDescriptions.Length; i++)
{
ic.Add(new mod.InventoryAction());
ic[i].Description = icDescriptions[i];
dm.AddToInventoryActions(ic[i]);
}
dm.SaveChanges();
}
// Recurrence Interval
if (dm.RecurrenceIntervals.Count() == 0)
{
string[] Descriptions = new string[] { "Minute", "Hour", "Day", "Week", "Month", "Year" };
long[] Minutes = new long[] { 1, 60, 1440, 10080, 0, 525600 };
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List <mod.RecurrenceInterval> ic = new List <mod.RecurrenceInterval>(Descriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < Descriptions.Length; i++)
{
ic.Add(new mod.RecurrenceInterval());
ic[i].Description = Descriptions[i];
ic[i].Minutes = Minutes[i];
dm.AddToRecurrenceIntervals(ic[i]);
}
dm.SaveChanges();
}
// Units
if (dm.Units.Count() == 0)
{
object[,] values =
{
{ "Gram", "gm", 1.0, "Weight" }
,{ "Pound", "lb", 453.59237, "Weight" }
,{ "Ounces", "oz", 28.3495231, "Weight" }
,{ "Liter", "l", 1.0, "Volume" }
,{ "Fluid Once", "fl oz", 0.02395735296, "Volume" }
,{ "Gallon", "gal", 3.78541178, "Volume" }
,{ "Cubic Feet", "ft3", 28.3168466, "Volume" }
,{ "Cubic Meter", "m3", 1000.0, "Volume" }
,{ "Cubic Inch", "in3", 0.016387064, "Volume" }
,{ "Cubic Yards", "yd3", 28.3495231, "Volume" }
,{ "Ounces", "oz", 764.554858, "Weight" }
,{ "Mile", "m", 1609.344, "Distance" }
,{ "Inch", "in", 0.0254, "Distance" }
,{ "Yard", "yd", 0.9144, "Distance" }
,{ "Foot", "ft", 0.3048, "Distance" }
,{ "Kilometer", "km", 1000.0, "Distance" }
,{ "Meter", "m", 1.0, "Distance" }
,{ "Centimeter", "cm", .01, "Distance" }
,{ "Second", "s", 0.016666666666, "Time" }
,{ "Hour", "h", 60.0, "Time" }
,{ "Minute", "m", 1.0, "Time" }
,{ "Day", "d", 1440.0, "Time" }
,{ "Celsius", "C", 1.0, "Temperature" }
,{ "Unit", "u", 1.0, "Other" }
};
for (int i = 0; i < values.Length / 4; i++)
{
int j = 0;
var u = new mod.Unit();
u.Description = (string)values[i, j++];
u.Abbreviation = (string)values[i, j++];
u.ConversionFactor = (double)values[i, j++];
string utDesc = (string)values[i, j];
u.UnitType = dm.UnitTypes.Single(z => z.Description == utDesc);
dm.AddToUnits(u);
}
foreach (var type in dm.UnitTypes)
{
type.DefaultUnit = type.Units.FirstOrDefault(z => z.ConversionFactor == 1);
}
dm.SaveChanges();
}
foreach (var type in dm.UnitTypes)
{
type.DefaultUnit = type.Units.FirstOrDefault(z => z.ConversionFactor == 1);
}
dm.SaveChanges();
// Item Categories
if (dm.ItemCategories.Count() == 0)
{
string[] icDescriptions = new string[] { "Food", "Clothes", "Appliances", "Bath", "Electronics" };
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List <mod.ItemCategory> ic = new List <mod.ItemCategory>(icDescriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < icDescriptions.Length; i++)
{
ic.Add(new mod.ItemCategory());
ic[i].Description = icDescriptions[i];
dm.AddToItemCategories(ic[i]);
}
dm.SaveChanges();
}
dm.Dispose();
}
public JsonResult CreateUnit(UnitModel model)
{
if (!ModelState.IsValid)
{
return Json(new
{
Result = "ERROR",
Message = "Form is not valid! " +
"Please correct it and try again."
});
}
if (!User.IsInRole("Officer"))
{
return Json(new
{
Result = "ERROR",
Message = "You do not have the authority to create a new unit."
});
}
try
{
JourListDMContainer dm = new JourListDMContainer();
Unit unit = new Unit();
unit.UnitType = dm.UnitTypes.Single(z => z.Id == model.UnitTypeId);
unit.Description = model.Description;
unit.ConversionFactor = model.ConversionFactor;
unit.Abbreviation = model.Abbreviation;
if (model.ConversionFactor == 1)
{
if (unit.UnitType.DefaultUnit != null && unit.UnitType.DefaultUnit.Active)
return Json(new
{
Result = "ERROR",
Message = "A default unit with conversion factor of 1 already exists."
});
dm.AddToUnits(unit);
dm.SaveChanges();
unit.UnitType.DefaultUnit = unit;
}
else
{
dm.AddToUnits(unit);
}
dm.SaveChanges();
model.Id = unit.Id;
return Json(new { Result = "OK", Record = model });
}
catch (Exception e)
{
return Json(new { Result = "ERROR", Message = e.Message });
}
}
/// <summary>
/// Deprecated Method for adding a new object to the Units EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToUnits(Unit unit)
{
base.AddObject("Units", unit);
}
protected void LoadDefaultData()
{
JourList.Models.JourListDMContainer dm = new Models.JourListDMContainer();
MembershipUser muc;
if ( dm.Members.SingleOrDefault(z => z.Name == "TeamBrett") == null
&& (muc = Membership.GetUser("TeamBrett")) != null)
{
mod.Member m = new mod.Member();
m.UserId = (Guid)muc.ProviderUserKey;
m.Name = muc.UserName;
dm.AddToMembers(m);
dm.SaveChanges();
}
// Recurrence Intervals
if (dm.RecurrenceIntervals.Count() == 0)
{
mod.RecurrenceInterval rid = new Models.RecurrenceInterval();
rid.Description = "Daily";
dm.AddToRecurrenceIntervals(rid);
mod.RecurrenceInterval riw = new Models.RecurrenceInterval();
riw.Description = "Weekly";
dm.AddToRecurrenceIntervals(riw);
mod.RecurrenceInterval rim = new Models.RecurrenceInterval();
rim.Description = "Monthly";
dm.AddToRecurrenceIntervals(rim);
mod.RecurrenceInterval riy = new Models.RecurrenceInterval();
riy.Description = "Yearly";
dm.AddToRecurrenceIntervals(riy);
mod.RecurrenceInterval rin = new Models.RecurrenceInterval();
rin.Description = "Never";
dm.AddToRecurrenceIntervals(rin);
dm.SaveChanges();
}
// Unit Types
if (dm.UnitTypes.Count() == 0)
{
string[] icDescriptions = new string[] { "Other", "Volume", "Distance", "Weight", "Time", "Temperature", "None" };
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List<mod.UnitType> ic = new List<mod.UnitType>(icDescriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < icDescriptions.Length; i++)
{
ic.Add(new mod.UnitType());
ic[i].Description = icDescriptions[i];
dm.AddToUnitTypes(ic[i]);
}
dm.SaveChanges();
}
// Inventory Actions
if (dm.InventoryActions.Count() == 0)
{
string[] icDescriptions = Enum.GetNames(typeof(mod.StockUpdateEnum)); ;
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List<mod.InventoryAction> ic = new List<mod.InventoryAction>(icDescriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < icDescriptions.Length; i++)
{
ic.Add(new mod.InventoryAction());
ic[i].Description = icDescriptions[i];
dm.AddToInventoryActions(ic[i]);
}
dm.SaveChanges();
}
// Recurrence Interval
if (dm.RecurrenceIntervals.Count() == 0)
{
string[] Descriptions = new string[] { "Minute", "Hour", "Day", "Week", "Month", "Year" };
long[] Minutes = new long[] { 1, 60, 1440, 10080, 0, 525600 };
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List<mod.RecurrenceInterval> ic = new List<mod.RecurrenceInterval>(Descriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < Descriptions.Length; i++)
{
ic.Add(new mod.RecurrenceInterval());
ic[i].Description = Descriptions[i];
ic[i].Minutes = Minutes[i];
dm.AddToRecurrenceIntervals(ic[i]);
}
dm.SaveChanges();
}
// Units
if (dm.Units.Count() == 0)
{
object[,] values = {
{"Gram", "gm", 1.0, "Weight"}
,{"Pound", "lb", 453.59237, "Weight"}
,{"Ounces", "oz", 28.3495231, "Weight"}
,{"Liter", "l" , 1.0, "Volume"}
,{"Fluid Once", "fl oz",0.02395735296, "Volume"}
,{"Gallon", "gal", 3.78541178, "Volume"}
,{"Cubic Feet", "ft3", 28.3168466, "Volume"}
,{"Cubic Meter","m3", 1000.0, "Volume"}
,{"Cubic Inch", "in3", 0.016387064, "Volume"}
,{"Cubic Yards","yd3", 28.3495231, "Volume"}
,{"Ounces", "oz", 764.554858, "Weight"}
,{"Mile", "m", 1609.344, "Distance"}
,{"Inch", "in", 0.0254, "Distance"}
,{"Yard", "yd", 0.9144, "Distance"}
,{"Foot", "ft", 0.3048, "Distance"}
,{"Kilometer", "km", 1000.0, "Distance"}
,{"Meter", "m", 1.0, "Distance"}
,{"Centimeter", "cm", .01, "Distance"}
,{"Second", "s", 0.016666666666, "Time"}
,{"Hour", "h", 60.0, "Time"}
,{"Minute", "m", 1.0, "Time"}
,{"Day", "d", 1440.0, "Time"}
,{"Celsius", "C", 1.0, "Temperature"}
,{"Unit", "u", 1.0, "Other"}
};
for (int i = 0; i < values.Length/4; i++)
{
int j = 0;
var u = new mod.Unit();
u.Description = (string)values[i, j++];
u.Abbreviation = (string)values[i, j++];
u.ConversionFactor = (double)values[i, j++];
string utDesc = (string)values[i, j];
u.UnitType = dm.UnitTypes.Single(z => z.Description == utDesc);
dm.AddToUnits(u);
}
foreach (var type in dm.UnitTypes)
type.DefaultUnit = type.Units.FirstOrDefault(z => z.ConversionFactor == 1);
dm.SaveChanges();
}
foreach (var type in dm.UnitTypes)
type.DefaultUnit = type.Units.FirstOrDefault(z => z.ConversionFactor == 1);
dm.SaveChanges();
// Item Categories
if (dm.ItemCategories.Count() == 0)
{
string[] icDescriptions = new string[] {"Food","Clothes","Appliances","Bath","Electronics"};
// Can't just insert the same object with changes over and over, so we need a list of unique item categories
List<mod.ItemCategory> ic = new List<mod.ItemCategory>(icDescriptions.Length);
// Populate the item category descriptions with our list
for (int i = 0; i < icDescriptions.Length; i++)
{
ic.Add(new mod.ItemCategory());
ic[i].Description = icDescriptions[i];
dm.AddToItemCategories(ic[i]);
}
dm.SaveChanges();
}
dm.Dispose();
}
/// <summary>
/// Create a new Unit object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="description">Initial value of the Description property.</param>
/// <param name="conversionFactor">Initial value of the ConversionFactor property.</param>
/// <param name="abbreviation">Initial value of the Abbreviation property.</param>
public static Unit CreateUnit(global::System.Int32 id, global::System.String description, global::System.Double conversionFactor, global::System.String abbreviation)
{
Unit unit = new Unit();
unit.Id = id;
unit.Description = description;
unit.ConversionFactor = conversionFactor;
unit.Abbreviation = abbreviation;
return unit;
}