public JsonResult CreateInventoryAction(InventoryActionModel 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 inventory action." }); } try { JourListDMContainer dm = new JourListDMContainer(); InventoryAction item = new InventoryAction(); item.Description = model.Description; dm.AddToInventoryActions(item); dm.SaveChanges(); model.Id = item.Id; return Json(new { Result = "OK", Record = model }); } catch (Exception e) { return Json(new { Result = "ERROR", Message = e.Message }); } }
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(); }