public void PopulateBusinessObjectFromReader(HPS.BLL.CountryBLL.BLLCountry_T businessObject, IDataReader dataReader)
{
businessObject.CountryID_int = dataReader.GetInt32(dataReader.GetOrdinal(HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryID_int.ToString()));
businessObject.CountryCode_nvc = dataReader.GetString(dataReader.GetOrdinal(HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryCode_nvc.ToString()));
businessObject.Country_nvc = dataReader.GetString(dataReader.GetOrdinal(HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Country_nvc.ToString()));
businessObject.Active_bit = dataReader.GetBoolean(dataReader.GetOrdinal(HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Active_bit.ToString()));
}
protected override void Edit()
{
HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
try
{
HPS.BLL.CountryBLL.BLLCountry_T CountryEntity = new HPS.BLL.CountryBLL.BLLCountry_T();
CountryEntity.CountryCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(CountryCode_nvcTextBox.Text, TypeCode.String).ToString();
CountryEntity.Country_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(Country_nvcTextBox.Text, TypeCode.String).ToString();
CountryEntity.Active_bit = Active_bitCheckBox.Checked;
if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.EditMessage) == true)
{
CountryFactory.BeginProc();
CountryFactory.Update(CountryEntity, (HPS.BLL.CountryBLL.BLLCountry_TKeys)Key);
CountryFactory.CommitProc();
if (DataTable != null)
{
DataRow[] dr = DataTable.Select(HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryID_int.ToString() + "='" + ((HPS.BLL.CountryBLL.BLLCountry_TKeys)Key).CountryID_int.ToString() + "'");
if (dr.Length > 0)
{
dr[0][HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.CountryCode_nvc, TypeCode.String);
dr[0][HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Country_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.Country_nvc, TypeCode.String);
dr[0][HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Active_bit.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.Active_bit, TypeCode.Boolean);
}
DataTable.AcceptChanges();
}
}
}
catch (Exception ex)
{
CountryFactory.RollBackProc();
throw ex;
}
}
protected override void Insert()
{
HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
try
{
HPS.BLL.CountryBLL.BLLCountry_T CountryEntity = new HPS.BLL.CountryBLL.BLLCountry_T();
CountryEntity.CountryCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(CountryCode_nvcTextBox.Text, TypeCode.String).ToString();
CountryEntity.Country_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(Country_nvcTextBox.Text, TypeCode.String).ToString();
CountryEntity.Active_bit = Active_bitCheckBox.Checked;
CountryFactory.BeginProc();
CountryFactory.Insert(CountryEntity);
CountryFactory.CommitProc();
if (DataTable != null)
{
DataRow dr = this.DataTable.NewRow();
dr[HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.CountryID_int, TypeCode.Int32);
dr[HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.CountryCode_nvc, TypeCode.String);
dr[HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Country_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.Country_nvc, TypeCode.String);
dr[HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Active_bit.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CountryEntity.Active_bit, TypeCode.Boolean);
DataTable.Rows.Add(dr);
DataTable.AcceptChanges();
}
this.ClearForm(this);
}
catch (Exception ex)
{
CountryFactory.RollBackProc();
throw ex;
}
}
public HPS.BLL.CountryBLL.BLLCountry_T SelectByPrimaryKey(HPS.BLL.CountryBLL.BLLCountry_TKeys businessObjectKey)
{
bool ControlConnection = !(this.ConnectionState == System.Data.ConnectionState.Open);
this.Command.CommandText = "[sp_Country_T_SelectByPrimaryKey]";
this.Command.CommandType = CommandType.StoredProcedure;
try{
this.Command.Parameters.Clear();
SqlParameter CountryID_int = new SqlParameter();
CountryID_int.ParameterName = "@CountryID_int";
CountryID_int.SqlDbType = SqlDbType.Int;
CountryID_int.Direction = ParameterDirection.Input;
CountryID_int.IsNullable = false;
CountryID_int.Value = businessObjectKey.CountryID_int;
this.Command.Parameters.Add(CountryID_int);
if (ControlConnection)
{
this.BeginTransaction();
}
IDataReader dataReader = this.Command.ExecuteReader();
HPS.BLL.CountryBLL.BLLCountry_T businessObject = new HPS.BLL.CountryBLL.BLLCountry_T();
if (dataReader.Read())
{
PopulateBusinessObjectFromReader(businessObject, dataReader);
}
else
{
businessObject = null;
}
if (dataReader.IsClosed == false)
{
dataReader.Close();
}
if (ControlConnection)
{
this.Commit();
}
return(businessObject);
}
catch (System.Exception ex) {
if (ControlConnection)
{
this.RollBack();
}
throw ex;
}
}
private void CountryID_intComboBox_SelectionChangeCommitted(object sender, EventArgs e)
{
HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
HPS.BLL.CountryBLL.BLLCountry_TKeys CountryKey = new HPS.BLL.CountryBLL.BLLCountry_TKeys();
CountryKey.CountryID_int = (Int32?)CountryID_intComboBox.SelectedValue;
countryEntity = CountryFactory.GetBy(CountryKey);
if (countryEntity != null && countryEntity.CountryID_int != 0)
{
CountryCode_nvcTextBox.Text = countryEntity.CountryCode_nvc;
}
}
public List <HPS.BLL.CountryBLL.BLLCountry_T> PopulateObjectsFromReader(IDataReader dataReader)
{
List <HPS.BLL.CountryBLL.BLLCountry_T> list = new List <HPS.BLL.CountryBLL.BLLCountry_T>();
while (dataReader.Read())
{
HPS.BLL.CountryBLL.BLLCountry_T businessObject = new HPS.BLL.CountryBLL.BLLCountry_T();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
public void Insert(HPS.BLL.CountryBLL.BLLCountry_T businessObject)
{
try{
if (businessObject.IsValid(Hepsa.Core.Validation.ValidationExceptionType.Except, "CountryID_int") == false)
{
throw new Hepsa.Core.Validation.InvalidBusinessObjectException(businessObject.BrokenRulesList().ToString());
}
_dataObject.Insert(businessObject);
}catch (System.Exception ex) {
throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this);
}
}
protected override void ShowForm()
{
this.FillCombo();
HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
HPS.BLL.CountryBLL.BLLCountry_T CountryEntity = CountryFactory.GetBy((HPS.BLL.CountryBLL.BLLCountry_TKeys)Key);
if (CountryEntity == null)
{
throw new HPS.Exceptions.CountryNotFound();
}
CountryCode_nvcTextBox.Text = Hepsa.Core.Common.PersentationController.GetEntityValue(CountryEntity.CountryCode_nvc, TypeCode.String).ToString();
Country_nvcTextBox.Text = Hepsa.Core.Common.PersentationController.GetEntityValue(CountryEntity.Country_nvc, TypeCode.String).ToString();
Active_bitCheckBox.Checked = (Boolean)Hepsa.Core.Common.PersentationController.GetEntityValue(CountryEntity.Active_bit, TypeCode.Boolean);
}
public void Update(HPS.BLL.CountryBLL.BLLCountry_T businessObject, HPS.BLL.CountryBLL.BLLCountry_TKeys businessObjectKey)
{
try{
if (businessObject.CountryID_int == businessObjectKey.CountryID_int)
{
if (businessObject.IsValid(Hepsa.Core.Validation.ValidationExceptionType.Except, "UniqueCountryID_int") == false)
{
throw new Hepsa.Core.Validation.InvalidBusinessObjectException(businessObject.BrokenRulesList().ToString());
}
}
else
{
if (businessObject.IsValid() == false)
{
throw new Hepsa.Core.Validation.InvalidBusinessObjectException(businessObject.BrokenRulesList().ToString());
}
}
_dataObject.Update(businessObject, businessObjectKey);
}catch (System.Exception ex) {
throw Hepsa.Core.Exception.HandleException.ChangeExceptionLanguage(ex, this);
}
}
protected override void Insert()
{
HPS.BLL.CarBLL.BLLCar_TFactory CarFactory = new HPS.BLL.CarBLL.BLLCar_TFactory();
try
{
HPS.BLL.CarBLL.BLLCar_T CarEntity = new HPS.BLL.CarBLL.BLLCar_T();
CarEntity.CarCardDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(CarCardDate_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.CarCardNumber_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(CarCardNumber_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.PlateType_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(PlateType_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.NumberPlate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(NumberPlate_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.SerialPlate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(SerialPlate_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.PlateCityID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(PlateCityID_intComboBox.SelectedValue, TypeCode.Int32);
CarEntity.PlateColorID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(PlateColorID_intComboBox.SelectedValue, TypeCode.Int32);
CarEntity.CountryID_int = (Int32)Hepsa.Core.Common.PersentationController.GetEntityValue(CountryID_intComboBox.SelectedValue, TypeCode.Int32);
HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
HPS.BLL.CountryBLL.BLLCountry_TKeys CountryKey = new HPS.BLL.CountryBLL.BLLCountry_TKeys();
CountryKey.CountryID_int = (Int32?)CountryID_intComboBox.SelectedValue;
HPS.BLL.CountryBLL.BLLCountry_T countryEntity = CountryFactory.GetBy(CountryKey);
if (countryEntity.CountryID_int != 0)
{
CarEntity.Country_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(countryEntity.Country_nvc, TypeCode.String).ToString();
CarEntity.CountryCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(countryEntity.CountryCode_nvc, TypeCode.String).ToString();
}
CarEntity.YearType_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(YearType_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.ProductionYear_int = (Int32)Hepsa.Core.Common.PersentationController.GetEntityValue(ProductionYear_intNumericTextBox.NumericText, TypeCode.Int32);
CarEntity.LaderTypeID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(LaderTypeID_intComboBox.SelectedValue, TypeCode.Int32);
CarEntity.LaderTypeCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(LaderTypeCode_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.SystemCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(SystemCode_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.System_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(System_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.Capacity_flt = (Nullable <Double>)Hepsa.Core.Common.PersentationController.GetEntityValue(Capacity_fltNumericTextBox.NumericText, TypeCode.Double);
CarEntity.InfractionGroupID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(InfractionGroupID_intComboBox.SelectedValue, TypeCode.Int32);
CarEntity.InsertDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(InsertDate_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.UpdateDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(UpdateDate_nvcTextBox.Text, TypeCode.String).ToString();
CarEntity.Active_bit = Active_bitCheckBox.Checked;
CarEntity.Deleted_bit = Deleted_bitCheckBox.Checked;
CarEntity.Active_bit = Active_bit.Checked;
CarFactory.BeginProc();
CarFactory.Insert(CarEntity);
CarFactory.CommitProc();
if (DataTable != null)
{
DataRow dr = this.DataTable.NewRow();
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.CarID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CarID_int, TypeCode.Int32);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.CarCardDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CarCardDate_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.CarCardNumber_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CarCardNumber_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.PlateType_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.PlateType_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.NumberPlate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.NumberPlate_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.SerialPlate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.SerialPlate_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.PlateCityID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.PlateCityID_int, TypeCode.Int32);
dr["PlateCityID_intPlateCity_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(PlateCityID_intComboBox);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.PlateColorID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.PlateColorID_int, TypeCode.Int32);
dr["PlateColorID_intColor_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(PlateColorID_intComboBox);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.CountryID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CountryID_int, TypeCode.Int32);
dr["CountryID_intCountry_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(CountryID_intComboBox);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.CountryCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CountryCode_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.Country_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Country_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.YearType_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.YearType_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.ProductionYear_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.ProductionYear_int, TypeCode.Int32);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.LaderTypeID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.LaderTypeID_int, TypeCode.Int32);
dr["LaderTypeID_intLaderType_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(LaderTypeID_intComboBox);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.LaderTypeCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.LaderTypeCode_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.SystemCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.SystemCode_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.System_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.System_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.Capacity_flt.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Capacity_flt, TypeCode.Double);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.InfractionGroupID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.InfractionGroupID_int, TypeCode.Int32);
dr["InfractionGroupID_intInfractionGroup_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(InfractionGroupID_intComboBox);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.InsertDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.InsertDate_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.UpdateDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.UpdateDate_nvc, TypeCode.String);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.Active_bit.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Active_bit, TypeCode.Boolean);
dr[HPS.BLL.CarBLL.BLLCar_T.Car_TField.Deleted_bit.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Deleted_bit, TypeCode.Boolean);
DataTable.Rows.Add(dr);
DataTable.AcceptChanges();
}
this.ClearForm(this);
}
catch (Exception ex)
{
CarFactory.RollBackProc();
throw ex;
}
}
public void Update(HPS.BLL.CountryBLL.BLLCountry_T businessObject, HPS.BLL.CountryBLL.BLLCountry_TKeys businessObjectKey)
{
bool ControlConnection = !(this.ConnectionState == System.Data.ConnectionState.Open);
this.Command.CommandText = "[sp_Country_T_Update]";
this.Command.CommandType = CommandType.StoredProcedure;
try{
this.Command.Parameters.Clear();
SqlParameter CountryCode_nvc = new SqlParameter();
CountryCode_nvc.ParameterName = "@CountryCode_nvc";
CountryCode_nvc.SqlDbType = SqlDbType.NVarChar;
CountryCode_nvc.Direction = ParameterDirection.Input;
CountryCode_nvc.IsNullable = false;
CountryCode_nvc.Value = businessObject.CountryCode_nvc;
this.Command.Parameters.Add(CountryCode_nvc);
SqlParameter Country_nvc = new SqlParameter();
Country_nvc.ParameterName = "@Country_nvc";
Country_nvc.SqlDbType = SqlDbType.NVarChar;
Country_nvc.Direction = ParameterDirection.Input;
Country_nvc.IsNullable = false;
Country_nvc.Value = businessObject.Country_nvc;
this.Command.Parameters.Add(Country_nvc);
SqlParameter Active_bit = new SqlParameter();
Active_bit.ParameterName = "@Active_bit";
Active_bit.SqlDbType = SqlDbType.Bit;
Active_bit.Direction = ParameterDirection.Input;
Active_bit.IsNullable = false;
Active_bit.Value = businessObject.Active_bit;
this.Command.Parameters.Add(Active_bit);
SqlParameter pk_CountryID_int = new SqlParameter();
pk_CountryID_int.ParameterName = "@pk_CountryID_int";
pk_CountryID_int.SqlDbType = SqlDbType.Int;
pk_CountryID_int.Direction = ParameterDirection.Input;
pk_CountryID_int.IsNullable = false;
pk_CountryID_int.Value = businessObjectKey.CountryID_int;
this.Command.Parameters.Add(pk_CountryID_int);
if (ControlConnection)
{
this.BeginTransaction();
}
this.Command.ExecuteNonQuery();
if (ControlConnection)
{
this.Commit();
}
}
catch (System.Exception ex) {
if (ControlConnection)
{
this.RollBack();
}
throw ex;
}
}