Esempio n. 1
0
        private void DeleteButton_Click(object sender, EventArgs e)
        {
            HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();

            try
            {
                if (Hepsa.Core.Common.MessageBox.ConfirmDeleteMessage() == false)
                {
                    return;
                }


                HPS.BLL.CountryBLL.BLLCountry_TFactory Country_TFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
                HPS.BLL.CountryBLL.BLLCountry_TKeys    CountryKey       = new HPS.BLL.CountryBLL.BLLCountry_TKeys();

                CountryKey.CountryID_int = (Int32?)CountryGridView.CurrentRow.Cells["colCountryID_int"].Value;
                CountryFactory.Delete(CountryKey);

                DataRow[] dr = ((DataTable)this.CountryGridView.DataSource).Select(HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryID_int.ToString() + "='" + CountryKey.CountryID_int.ToString() + "'");
                if (dr.Length > 0)
                {
                    dr[0].Delete();
                }
                ((DataTable)this.CountryGridView.DataSource).AcceptChanges();
            }

            catch (Exception ex)
            {
                Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
            }
        }
Esempio n. 2
0
        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;
            }
        }
Esempio n. 3
0
        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;
            }
        }
Esempio n. 4
0
        protected override void Delete()
        {
            HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();

            try
            {
                if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.DeleteMessage) == true)
                {
                    CountryFactory.BeginProc();
                    CountryFactory.Delete((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].Delete();
                        }
                        DataTable.AcceptChanges();
                    }
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                CountryFactory.RollBackProc();
                throw ex;
            }
        }
Esempio n. 5
0
 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;
     }
 }
Esempio n. 6
0
 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);
 }
Esempio n. 7
0
 private void LoadCountry()
 {
     try
     {
         HPS.BLL.CountryBLL.BLLCountry_TFactory CountryFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
         DataTable CountryDataTable = new DataTable();
         CountryFactory.GetAll(ref CountryDataTable);
         this.CountryGridView.DataSource = CountryDataTable;
     }
     catch (System.Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 8
0
        private void FillCombo()
        {
            try
            {
                HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory PlateCityID_intFactory = new HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory();
                DataTable PlateCityID_intDataTable = new DataTable();
                PlateCityID_intFactory.GetAll(ref PlateCityID_intDataTable);
                this.PlateCityID_intComboBox.DisplayMember = HPS.BLL.PlateCityBLL.BLLPlateCity_T.PlateCity_TField.PlateCity_nvc.ToString();
                this.PlateCityID_intComboBox.ValueMember   = HPS.BLL.PlateCityBLL.BLLPlateCity_T.PlateCity_TField.PlateCityID_int.ToString();
                this.PlateCityID_intComboBox.DataSource    = PlateCityID_intDataTable;
                this.PlateCityID_intComboBox.SelectedIndex = -1;

                HPS.BLL.ColorBLL.BLLColor_TFactory PlateColorID_intFactory = new HPS.BLL.ColorBLL.BLLColor_TFactory();
                DataTable PlateColorID_intDataTable = new DataTable();
                PlateColorID_intFactory.GetAll(ref PlateColorID_intDataTable);
                this.PlateColorID_intComboBox.DisplayMember = HPS.BLL.ColorBLL.BLLColor_T.Color_TField.Color_nvc.ToString();
                this.PlateColorID_intComboBox.ValueMember   = HPS.BLL.ColorBLL.BLLColor_T.Color_TField.ColorID_int.ToString();
                this.PlateColorID_intComboBox.DataSource    = PlateColorID_intDataTable;
                this.PlateColorID_intComboBox.SelectedIndex = -1;

                HPS.BLL.CountryBLL.BLLCountry_TFactory CountryID_intFactory = new HPS.BLL.CountryBLL.BLLCountry_TFactory();
                DataTable CountryID_intDataTable = new DataTable();
                CountryID_intFactory.GetAll(ref CountryID_intDataTable);
                this.CountryID_intComboBox.DisplayMember = HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.Country_nvc.ToString();
                this.CountryID_intComboBox.ValueMember   = HPS.BLL.CountryBLL.BLLCountry_T.Country_TField.CountryID_int.ToString();
                this.CountryID_intComboBox.DataSource    = CountryID_intDataTable;
                this.CountryID_intComboBox.SelectedIndex = -1;

                HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory();
                DataTable LaderTypeID_intDataTable = new DataTable();
                LaderTypeID_intFactory.GetAll(ref LaderTypeID_intDataTable);
                this.LaderTypeID_intComboBox.DisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
                this.LaderTypeID_intComboBox.ValueMember   = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
                this.LaderTypeID_intComboBox.DataSource    = LaderTypeID_intDataTable;
                this.LaderTypeID_intComboBox.SelectedIndex = -1;

                HPS.BLL.InfractionGroupBLL.BLLInfractionGroup_TFactory InfractionGroupID_intFactory = new HPS.BLL.InfractionGroupBLL.BLLInfractionGroup_TFactory();
                DataTable InfractionGroupID_intDataTable = new DataTable();
                InfractionGroupID_intFactory.GetAll(ref InfractionGroupID_intDataTable);
                this.InfractionGroupID_intComboBox.DisplayMember = HPS.BLL.InfractionGroupBLL.BLLInfractionGroup_T.InfractionGroup_TField.InfractionGroup_nvc.ToString();
                this.InfractionGroupID_intComboBox.ValueMember   = HPS.BLL.InfractionGroupBLL.BLLInfractionGroup_T.InfractionGroup_TField.InfractionGroupID_int.ToString();
                this.InfractionGroupID_intComboBox.DataSource    = InfractionGroupID_intDataTable;
                this.InfractionGroupID_intComboBox.SelectedIndex = -1;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 9
0
        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;
            }
        }
Esempio n. 10
0
        protected override void Edit()
        {
            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;
                countryEntity            = CountryFactory.GetBy(CountryKey);
                if (countryEntity != null && 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();
                }
                else
                {
                    CountryKey.CountryID_int = 82;
                    countryEntity            = CountryFactory.GetBy(CountryKey);

                    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;

                if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.EditMessage) == true)
                {
                    CarFactory.BeginProc();
                    CarFactory.Update(CarEntity, (HPS.BLL.CarBLL.BLLCar_TKeys)Key);
                    CarFactory.CommitProc();
                    if (DataTable != null)
                    {
                        DataRow[] dr = DataTable.Select(HPS.BLL.CarBLL.BLLCar_T.Car_TField.CarID_int.ToString() + "='" + ((HPS.BLL.CarBLL.BLLCar_TKeys)Key).CarID_int.ToString() + "'");
                        if (dr.Length > 0)
                        {
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.CarCardDate_nvc.ToString()]   = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CarCardDate_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.CarCardNumber_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CarCardNumber_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.PlateType_nvc.ToString()]     = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.PlateType_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.NumberPlate_nvc.ToString()]   = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.NumberPlate_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.SerialPlate_nvc.ToString()]   = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.SerialPlate_nvc, TypeCode.String);
                            dr[0]["PlateCityID_intPlateCity_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(PlateCityID_intComboBox);
                            dr[0]["PlateColorID_intColor_nvc"]    = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(PlateColorID_intComboBox);
                            dr[0]["CountryID_intCountry_nvc"]     = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(CountryID_intComboBox);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.CountryCode_nvc.ToString()]    = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.CountryCode_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.Country_nvc.ToString()]        = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Country_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.YearType_nvc.ToString()]       = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.YearType_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.ProductionYear_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.ProductionYear_int, TypeCode.Int32);
                            dr[0]["LaderTypeID_intLaderType_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(LaderTypeID_intComboBox);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.LaderTypeCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.LaderTypeCode_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.SystemCode_nvc.ToString()]    = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.SystemCode_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.System_nvc.ToString()]        = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.System_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.Capacity_flt.ToString()]      = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Capacity_flt, TypeCode.Double);
                            dr[0]["InfractionGroupID_intInfractionGroup_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(InfractionGroupID_intComboBox);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.InsertDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.InsertDate_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.UpdateDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.UpdateDate_nvc, TypeCode.String);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.Active_bit.ToString()]     = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Active_bit, TypeCode.Boolean);
                            dr[0][HPS.BLL.CarBLL.BLLCar_T.Car_TField.Deleted_bit.ToString()]    = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(CarEntity.Deleted_bit, TypeCode.Boolean);
                        }
                        DataTable.AcceptChanges();
                    }
                }
            }
            catch (Exception ex)
            {
                CarFactory.RollBackProc();
                throw ex;
            }
        }