private void TransferCar(string FilePath, string TableName) { HPS.BLL.CarBLL.BLLCar_TFactory CarFactory = new HPS.BLL.CarBLL.BLLCar_TFactory(); try { CarFactory.CommitProc(); CarFactory.TransferData(FilePath, TableName); CarFactory.CommitProc(); } catch (Exception ex) { CarFactory.RollBackProc(); throw ex; } }
protected override void Delete() { HPS.BLL.CarBLL.BLLCar_TFactory CarFactory = new HPS.BLL.CarBLL.BLLCar_TFactory(); try { if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.DeleteMessage) == true) { CarFactory.BeginProc(); CarFactory.Delete((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].Delete(); } DataTable.AcceptChanges(); } this.Close(); } } catch (Exception ex) { CarFactory.RollBackProc(); throw ex; } }
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; } }
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; } }