/// <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;
}
