private VehicleModel DTOItemToModel(VehicleMakeModelDTO vehicleModelDTO)
{
VehicleModel tempItem = new VehicleModel();
if (vehicleModelDTO != null)
{
tempItem.VehicleModelId = vehicleModelDTO.VehicleModelId;
if (!string.IsNullOrEmpty(vehicleModelDTO.ModelName))
tempItem.VehicleModelName = vehicleModelDTO.ModelName;
}
return tempItem;
}
public static int Save(VehicleModel vehicleModeltoSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
//check for Valid Person - if existis, UPDATE else INSERT
// 10 = INSERT_ITEM
//20 = UPDATE_ITEM
if (vehicleModeltoSave.VehicleModelId > 0)
queryId = ExecuteTypeEnum.UpdateItem;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteVehicleModel", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
if (vehicleModeltoSave.VehicleModelId > 0)
myCommand.Parameters.AddWithValue("@VehicleModelId", vehicleModeltoSave.VehicleModelId);
if (vehicleModeltoSave.VehicleModelName != null)
myCommand.Parameters.AddWithValue("@VehicleModelName", vehicleModeltoSave.VehicleModelName);
if (vehicleModeltoSave.Make != null)
myCommand.Parameters.AddWithValue("@VehicleMakeId", vehicleModeltoSave.Make.VehicleMakeId);
//add return Output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("returnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//get return Value from stored Procedure and return ID
result = (int)myCommand.Parameters["@returnValue"].Value;
}
myConnection.Close();
}
return result;
}
private VehicleMakeModelDTO ModelItemToDTO(VehicleModel vehicleModel)
{
VehicleMakeModelDTO tempItem = new VehicleMakeModelDTO();
if(vehicleModel != null)
{
tempItem.VehicleModelId = vehicleModel.VehicleModelId;
if (!string.IsNullOrEmpty(vehicleModel.VehicleModelName))
tempItem.ModelName = vehicleModel.VehicleModelName;
if(vehicleModel.Make != null)
{
tempItem.VehicleMakeId = vehicleModel.Make.VehicleMakeId;
if(!string.IsNullOrEmpty(vehicleModel.Make.VehicleMakeName))
tempItem.MakeName = vehicleModel.Make.VehicleMakeName;
}
}
return tempItem;
}
public static int SaveModel(int vehicleMakeId, VehicleModel vehicleModeltoSave)
{
BrokenRuleCollection saveBrokenRules = new BrokenRuleCollection();
if (vehicleMakeId<=0)
saveBrokenRules.Add("Vehicle Make Id", "Vehicle Model must be associated with a valid VehicleMake Id .");
if (vehicleModeltoSave == null)
saveBrokenRules.Add("Vehicle Model", "Invalid VehicleModel Object.");
else
{
if (string.IsNullOrEmpty(vehicleModeltoSave.VehicleModelName))
saveBrokenRules.Add("Vehicle Model Name", "Value is Required.");
}
if (saveBrokenRules.Count() > 0)
throw new BLLException("Validation rules failed.", saveBrokenRules);
else
{
vehicleModeltoSave.Make = new VehicleMake { VehicleMakeId = vehicleMakeId };
return VehicleModelDAL.Save(vehicleModeltoSave);
}
}
public static int SaveModel(string vehicleMakeName, VehicleModel vehicleModeltoSave)
{
BrokenRuleCollection saveBrokenRules = new BrokenRuleCollection();
if (string.IsNullOrEmpty(vehicleMakeName))
saveBrokenRules.Add("Vehicle Make Name", "Vehicle Model must be associated with a valid Vehicle Make Name.");
if (vehicleModeltoSave == null)
saveBrokenRules.Add("Vehicle Model", "Invaild VehicleModel object.");
else
{
if (string.IsNullOrEmpty(vehicleModeltoSave.VehicleModelName))
saveBrokenRules.Add("Vehicle Make Name", "Value is Required.");
}
if (saveBrokenRules.Count() > 0)
throw new BLLException("Validation rules failed.", saveBrokenRules);
else
{
//check to make sure name dosent exist
VehicleMake itemMake = GetMake(vehicleMakeName);
if (itemMake == null)
{
itemMake = new VehicleMake();
itemMake.VehicleMakeId = SaveMake(new VehicleMake{VehicleMakeName = vehicleMakeName});
}
vehicleModeltoSave.Make = itemMake;
return VehicleModelDAL.Save(vehicleModeltoSave);
}
}
private static VehicleModel FillDataRecord(IDataRecord myDataRecord)
{
VehicleModel myObject = new VehicleModel();
myObject.VehicleModelId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("VehicleModelId"));
myObject.VehicleModelName = myDataRecord.GetString(myDataRecord.GetOrdinal("VehicleModelName"));
VehicleMake vehicleMake = new VehicleMake();
vehicleMake.VehicleMakeId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("VehicleMakeId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("VehicleMakeName")))
vehicleMake.VehicleMakeName = myDataRecord.GetString(myDataRecord.GetOrdinal("VehicleMakeName"));
myObject.Make = vehicleMake;
return myObject;
}
