/// <summary> /// Saves a CarModel to the data store. /// </summary> /// <param name="item">The item to save</param> public static void Save(CarModel item) { if (item.IsItemModified) { if (item.ModelId == null) { item.ModelId = Insert(item); } else { Update(item); } } }
public bool SaveControl() { bool valid = false; CarModel modelToSave = new CarModel(); modelToSave.MakeId = MakeId; modelToSave.CarImage = null; if (EditOption) { modelToSave = CarModelManager.Load(ModelId); } modelToSave.Name = txtModelName.Text; if (RadAsyncUpload1.UploadedFiles.Count > 0) { UploadedFile file = RadAsyncUpload1.UploadedFiles[0]; System.Drawing.Image.GetThumbnailImageAbort thumbnailImageAbortDelegate = new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback); using (Bitmap originalImage = new Bitmap(file.InputStream)) { decimal w1, h1, width2; int expectedWidth = 250; w1 = originalImage.Width; h1 = originalImage.Height; width2 = Calculations(w1, h1, expectedWidth); int height = Convert.ToInt32(width2); using (System.Drawing.Image thumbnail = originalImage.GetThumbnailImage(expectedWidth, height, thumbnailImageAbortDelegate, IntPtr.Zero)) { ImageConverter converter = new ImageConverter(); byte[] attachedBytes = (byte[])converter.ConvertTo(thumbnail, typeof(byte[])); modelToSave.CarImage = attachedBytes; } } } string errorMessage; valid = CarModelManager.Save(modelToSave, out errorMessage); return valid; }
public void CarModelValidateTest() { Assert.IsNotNull(CarModelTestObject, "Test object was null"); string errorMessage; bool valid = CarModelManager.Validate(CarModelTestObject, out errorMessage); Assert.IsTrue(valid, "CarModel was not valid when it should have been"); Assert.IsTrue(errorMessage.IsNullOrWhiteSpace(), "Errors found when there shouldn't have been any"); string name = CarModelTestObject.Name; int makeId = CarModelTestObject.MakeId; CarModelTestObject.Name = string.Empty; CarModelTestObject.MakeId = -1; valid = CarModelManager.Validate(CarModelTestObject, out errorMessage); Assert.IsFalse(valid, "CarModel was valid when it shouldn't have been"); Assert.IsTrue(errorMessage.HasValue(), "Errors not found when there should have been any"); Assert.IsTrue(errorMessage.Contains("MakeId must be valid", StringComparison.InvariantCultureIgnoreCase)); Assert.IsTrue(errorMessage.Contains("Name is required", StringComparison.InvariantCultureIgnoreCase)); CarModel newCarModel = new CarModel { MakeId = makeId, Name = name }; valid = CarModelManager.Validate(newCarModel, out errorMessage); Assert.IsFalse(valid, "CarModel was valid when it shouldn't have been"); Assert.IsTrue(errorMessage.HasValue(), "Errors not found when there should have been any"); Assert.IsTrue(errorMessage.Contains("Cannot have multiple car models with the same name from the same make", StringComparison.InvariantCultureIgnoreCase)); }
public void CreateTestObject() { int carMakeId = default(int); string errorMessage; Random rand = new Random(); List<CarMake> carMakes = CarMakeManager.LoadAll().ToList(); if (carMakes.SafeAny()) { carMakeId = carMakes.First().MakeId.GetValueOrDefault(); } else { CarMake carMake = new CarMake { Name = string.Format("TestCarMake_{0}", rand.Next(1, 1000)), Manufacturer = "TestManufacturer" }; CarMakeManager.Save(carMake, out errorMessage); if (carMake.MakeId.HasValue) { carMakeId = carMake.MakeId.Value; } } CarModelTestObject = new CarModel { ModelId = null, MakeId = carMakeId, Name = string.Format("TestCarModel_{0}", rand.Next(1, 1000)) }; CarModelManager.Save(CarModelTestObject, out errorMessage); }
public void CreateTestObject() { int inventoryId; Guid userId = Guid.Empty; Random rand = new Random(); string errorMessage; string userName = string.Format("NewUser_{0}", rand.Next(1, 100000)); const string passWord = "******"; string email = string.Format("emailaddress{0}@test.com", rand.Next(1, 1000000000)); MembershipCreateStatus status; MembershipUser user = Membership.CreateUser(userName, passWord, email, "quieres apple?", "no, apple es para mujeres", true, out status); if (user != null && user.ProviderUserKey is Guid) { userId = (Guid)user.ProviderUserKey; } List<Inventory> inventoryList = InventoryManager.LoadAll().ToList(); if (inventoryList.SafeAny()) { inventoryId = inventoryList.First().InventoryId.GetValueOrDefault(); } else { CarMake newMake = new CarMake { Manufacturer = "TestManufacturer", Name = string.Format("Make_{0}", rand.Next(1, 1000)) }; CarMakeManager.Save(newMake, out errorMessage); CarModel newModel = new CarModel { MakeId = newMake.MakeId.GetValueOrDefault(), Name = string.Format("Model_{0}", rand.Next(1, 1000)) }; CarModelManager.Save(newModel, out errorMessage); Location location = new Location { Name = string.Format("Location_{0}", rand.Next(1, 100000)), Address = string.Format("{0} Street St", rand.Next(10, 1000)), City = "Fake City", State = "FS", Zip = "11111", Email = "*****@*****.**", Phone = "1112223333" }; LocationManager.Save(location, out errorMessage); Inventory inventory = new Inventory { ModelId = newModel.ModelId.GetValueOrDefault(), LocationId = location.LocationId.GetValueOrDefault(), Color = "Red", Price = (decimal) ((rand.NextDouble() + 0.1)*rand.Next(10, 60)), Quantity = rand.Next(1, 10), Year = rand.Next(1990, 2015) }; inventoryId = inventory.InventoryId.GetValueOrDefault(); } TransactionTestObject = new Transaction { BillingAddress = "123 Fake Street", BillingCity = "Fake City", BillingState = "FS", BillingZip = "12345", CCV = 123, CreditCardNumber = "4444999911110000", ExpirationDate = DateTime.Today.AddYears(rand.Next(5, 10)), InventoryId = inventoryId, Price = (decimal)( ( rand.NextDouble() + 0.1 ) * rand.Next(10, 60) ), RentalDateEnd = DateTime.Today.AddDays(rand.Next(11, 50)), RentalDateStart = DateTime.Today.AddDays(rand.Next(1, 10)), TransactionDate = DateTime.Today, UserId = userId }; TransactionManager.Save(TransactionTestObject, out errorMessage); }
public static Inventory CreateTestObject() { int carModelId = default(int), locationId = default(int); string errorMessage; Random rand = new Random(); List<CarModel> carModels = CarModelManager.LoadAll().ToList(); if (carModels.SafeAny()) { carModelId = carModels.First().ModelId.GetValueOrDefault(); } else { CarModel carModel = new CarModel { Name = string.Format("TestCarModel_{0}", rand.Next(1, 1000)) }; CarModelManager.Save(carModel, out errorMessage); if (carModel.ModelId.HasValue) { carModelId = carModel.ModelId.Value; } } List<Location> locations = LocationManager.LoadAll().ToList(); if (locations.SafeAny()) { locationId = locations.First(l => l.LocationId.HasValue).LocationId.GetValueOrDefault(); } else { Location location = new Location { Name = string.Format("TestLocation_{0}", rand.Next(1, 1000)), Address = "123 Fake Street", City = "Fake City", Email = "*****@*****.**", Phone = "5555555555", State = "FS", Zip = "55555" }; LocationManager.Save(location, out errorMessage); if (location.LocationId.HasValue) { locationId = location.LocationId.Value; } } Inventory inventory = new Inventory { ModelId = carModelId, Color = "Black", Price = (decimal)((rand.NextDouble() + .01) * rand.Next(5, 100)), LocationId = locationId, Quantity = rand.Next(1, 50), Year = rand.Next(DateTime.Now.AddYears(rand.Next(1, 100).NegativeValue()).Year, DateTime.Now.Year) }; InventoryManager.Save(inventory, out errorMessage); return inventory; }
/// <summary> /// Updates a CarModel /// </summary> /// <param name="item">The CarModel item to save</param> private static void Update(CarModel item) { List<SqlParameter> parameters = new List<SqlParameter> { new SqlParameter("@ModelId", item.ModelId), new SqlParameter("@MakeId", item.MakeId), new SqlParameter("@Name", item.Name), new SqlParameter("@CarImage", SqlDbType.VarBinary) { Value = item.CarImage }, new SqlParameter("@Deleted", item.Deleted) }; DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_UpdateCarModel", parameters); }
/// <summary> /// Inserts a new CarModel /// </summary> /// <param name="item">The CarModel item to insert</param> /// <returns>The id of the CarModel item just inserted</returns> private static int Insert(CarModel item) { List<SqlParameter> parameters = new List<SqlParameter> { new SqlParameter("@MakeId", item.MakeId), new SqlParameter("@Name", item.Name), new SqlParameter("@CarImage", SqlDbType.VarBinary) { Value = item.CarImage }, new SqlParameter("@Deleted", item.Deleted) }; return Convert.ToInt32(DataManager.ExecuteScalarProcedure(KarzPlusConnectionString, "PKP_InsertCarModel", parameters)); }
/// <summary> /// Validate CarModel Entity /// </summary> /// <param name="item">Entity to validate</param> /// <param name="errorMessage">error message if validation failed</param> /// <returns>return true if entity passes validation logic, else return false</returns> public static bool Validate(CarModel item, out string errorMessage) { errorMessage = string.Empty; CarMake carMake = CarMakeManager.Load(item.MakeId); if (carMake == null) { errorMessage += "MakeId must be valid. "; } if (item.Name.IsNullOrWhiteSpace()) { errorMessage += "Name is required. "; } if (Search(new SearchCarModel { Name = item.Name, MakeId = item.MakeId }).SafeAny(c => c.ModelId != item.ModelId)) { errorMessage += "Cannot have multiple car models with the same name from the same make. "; } errorMessage = errorMessage.TrimSafely(); return errorMessage.IsNullOrWhiteSpace(); }
/// <summary> /// Save CarModel Entity /// </summary> /// <param name="item">Entity to save</param> /// <param name="errorMessage">Error Message</param> /// <returns>return true if save successfully, else return false</returns> public static bool Save(CarModel item, out string errorMessage) { bool isValid = Validate(item, out errorMessage); if (isValid) { CarModelDao.Save(item); } return isValid; }