protected override void Insert() { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); try { HPS.BLL.GoodBLL.BLLGood_T GoodEntity = new HPS.BLL.GoodBLL.BLLGood_T(); GoodEntity.GoodCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(GoodCode_nvcTextBox.Text, TypeCode.String).ToString(); GoodEntity.Good_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(Good_nvcTextBox.Text, TypeCode.String).ToString(); GoodEntity.Avtive_bit = Avtive_bitCheckBox.Checked; GoodFactory.BeginProc(); GoodFactory.Insert(GoodEntity); GoodFactory.CommitProc(); if (DataTable != null) { DataRow dr = this.DataTable.NewRow(); dr[HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.GoodID_int, TypeCode.Int32); dr[HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.GoodCode_nvc, TypeCode.String); dr[HPS.BLL.GoodBLL.BLLGood_T.Good_TField.Good_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.Good_nvc, TypeCode.String); dr[HPS.BLL.GoodBLL.BLLGood_T.Good_TField.Avtive_bit.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.Avtive_bit, TypeCode.Boolean); DataTable.Rows.Add(dr); DataTable.AcceptChanges(); } this.ClearForm(this); } catch (Exception ex) { GoodFactory.RollBackProc(); throw ex; } }
private void DeleteButton_Click(object sender, EventArgs e) { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); try { if (Hepsa.Core.Common.MessageBox.ConfirmDeleteMessage() == false) { return; } HPS.BLL.GoodBLL.BLLGood_TFactory Good_TFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); HPS.BLL.GoodBLL.BLLGood_TKeys GoodKey = new HPS.BLL.GoodBLL.BLLGood_TKeys(); GoodKey.GoodID_int = (Int32?)GoodGridView.CurrentRow.Cells["colGoodID_int"].Value; GoodFactory.Delete(GoodKey); DataRow[] dr = ((DataTable)this.GoodGridView.DataSource).Select(HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodID_int.ToString() + "='" + GoodKey.GoodID_int.ToString() + "'"); if (dr.Length > 0) { dr[0].Delete(); } ((DataTable)this.GoodGridView.DataSource).AcceptChanges(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
protected override void Edit() { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); try { HPS.BLL.GoodBLL.BLLGood_T GoodEntity = new HPS.BLL.GoodBLL.BLLGood_T(); GoodEntity.GoodCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(GoodCode_nvcTextBox.Text, TypeCode.String).ToString(); GoodEntity.Good_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(Good_nvcTextBox.Text, TypeCode.String).ToString(); GoodEntity.Avtive_bit = Avtive_bitCheckBox.Checked; if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.EditMessage) == true) { GoodFactory.BeginProc(); GoodFactory.Update(GoodEntity, (HPS.BLL.GoodBLL.BLLGood_TKeys)Key); GoodFactory.CommitProc(); if (DataTable != null) { DataRow[] dr = DataTable.Select(HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodID_int.ToString() + "='" + ((HPS.BLL.GoodBLL.BLLGood_TKeys)Key).GoodID_int.ToString() + "'"); if (dr.Length > 0) { dr[0][HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodCode_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.GoodCode_nvc, TypeCode.String); dr[0][HPS.BLL.GoodBLL.BLLGood_T.Good_TField.Good_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.Good_nvc, TypeCode.String); dr[0][HPS.BLL.GoodBLL.BLLGood_T.Good_TField.Avtive_bit.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(GoodEntity.Avtive_bit, TypeCode.Boolean); } DataTable.AcceptChanges(); } } } catch (Exception ex) { GoodFactory.RollBackProc(); throw ex; } }
protected override void Delete() { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); try { if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.DeleteMessage) == true) { GoodFactory.BeginProc(); GoodFactory.Delete((HPS.BLL.GoodBLL.BLLGood_TKeys)Key); GoodFactory.CommitProc(); if (DataTable != null) { DataRow[] dr = DataTable.Select(HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodID_int.ToString() + "='" + ((HPS.BLL.GoodBLL.BLLGood_TKeys)Key).GoodID_int.ToString() + "'"); if (dr.Length > 0) { dr[0].Delete(); } DataTable.AcceptChanges(); } this.Close(); } } catch (Exception ex) { GoodFactory.RollBackProc(); throw ex; } }
private void FillCombo() { try { HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); DataTable LaderTypeID_intDataTable = new DataTable(); string laderCondition = "[LaderType_T].[Active_bit]='true'"; LaderTypeID_intFactory.GetAllByCondition(laderCondition, 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.CompanyBLL.BLLCompany_TFactory CompanyID_intFactory = new HPS.BLL.CompanyBLL.BLLCompany_TFactory(); //string CompanyCondition = "[Company_T].[Active_bit]='true'"; //CompanyID_intFactory.GetAllByCondition(CompanyCondition, ref CompanyID_intDataTable); ////DataRow Companydr = CompanyID_intDataTable.NewRow(); ////Companydr["CompanyID_int"] = 0; ////CompanyID_intDataTable.Rows.InsertAt(Companydr, 0); //this.CompanyID_intComboBox.DisplayMember = HPS.BLL.CompanyBLL.BLLCompany_T.Company_TField.Company_nvc.ToString(); //this.CompanyID_intComboBox.ValueMember = HPS.BLL.CompanyBLL.BLLCompany_T.Company_TField.CompanyID_int.ToString(); //this.CompanyID_intComboBox.DataSource = CompanyID_intDataTable; //this.CompanyID_intComboBox.SelectedIndex = -1; HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); DataTable GoodID_intDataTable = new DataTable(); GoodFactory.GetAll(ref GoodID_intDataTable); this.GoodID_intcomboBox.DisplayMember = HPS.BLL.GoodBLL.BLLGood_T.Good_TField.Good_nvc.ToString(); this.GoodID_intcomboBox.ValueMember = HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodID_int.ToString(); this.GoodID_intcomboBox.DataSource = GoodID_intDataTable; this.GoodID_intcomboBox.SelectedIndex = -1; HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); DataTable PortPlaceID_intDataTable = new DataTable(); PortPlaceFactory.GetAll(ref PortPlaceID_intDataTable); this.PortPlaceID_intcomboBox.DisplayMember = HPS.BLL.PortPlacesBLL.BLLPortPlaces_T.PortPlaces_TField.PortPlaces_nvc.ToString(); this.PortPlaceID_intcomboBox.ValueMember = HPS.BLL.PortPlacesBLL.BLLPortPlaces_T.PortPlaces_TField.PortPlacesID_int.ToString(); this.PortPlaceID_intcomboBox.DataSource = PortPlaceID_intDataTable; this.PortPlaceID_intcomboBox.SelectedIndex = -1; HPS.BLL.CityBLL.BLLCity_TFactory CityFactory = new HPS.BLL.CityBLL.BLLCity_TFactory(); DataTable DestinationCityID_intDataTable = new DataTable(); CityFactory.GetAll(ref DestinationCityID_intDataTable); this.DestinationCityID_intcomboBox.DisplayMember = HPS.BLL.CityBLL.BLLCity_T.City_TField.City_nvc.ToString(); this.DestinationCityID_intcomboBox.ValueMember = HPS.BLL.CityBLL.BLLCity_T.City_TField.CityID_int.ToString(); this.DestinationCityID_intcomboBox.DataSource = DestinationCityID_intDataTable; this.DestinationCityID_intcomboBox.SelectedIndex = -1; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
protected override void ShowForm() { this.FillCombo(); HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); HPS.BLL.GoodBLL.BLLGood_T GoodEntity = GoodFactory.GetBy((HPS.BLL.GoodBLL.BLLGood_TKeys)Key); if (GoodEntity == null) { throw new HPS.Exceptions.GoodNotFound(); } GoodCode_nvcTextBox.Text = Hepsa.Core.Common.PersentationController.GetEntityValue(GoodEntity.GoodCode_nvc, TypeCode.String).ToString(); Good_nvcTextBox.Text = Hepsa.Core.Common.PersentationController.GetEntityValue(GoodEntity.Good_nvc, TypeCode.String).ToString(); Avtive_bitCheckBox.Checked = (Boolean)Hepsa.Core.Common.PersentationController.GetEntityValue(GoodEntity.Avtive_bit, TypeCode.Boolean); }
private void LoadGood() { try { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); DataTable GoodDataTable = new DataTable(); GoodFactory.GetAll(ref GoodDataTable); this.GoodGridView.DataSource = GoodDataTable; } catch (System.Exception ex) { throw ex; } }
private void LoadGood() { try { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); string Condition = "[Good_T].[Avtive_bit]='true'"; DataTable GoodDataTabale = new DataTable(); GoodFactory.GetAllByCondition(Condition, ref GoodDataTabale); this.GoodGridView.DataSource = GoodDataTabale; } catch (System.Exception ex) { throw ex; } }
private void TransferGood(string FilePath, string TableName) { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); try { GoodFactory.BeginProc(); GoodFactory.TransferData(FilePath, TableName); GoodFactory.CommitProc(); } catch (Exception ex) { GoodFactory.RollBackProc(); throw ex; } }
private void SearchButton_Click(object sender, EventArgs e) { if (GoodGridView.CurrentRow != null) { HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); HPS.BLL.GoodBLL.BLLGood_TKeys GoodKey = new HPS.BLL.GoodBLL.BLLGood_TKeys(); GoodKey.GoodID_int = (Int32)GoodGridView.CurrentRow.Cells[colGoodID_int.Name].Value; GoodEntity = GoodFactory.GetBy(GoodKey); if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetEntityValue(GoodGridView.CurrentRow.Cells[colGoodID_int.Name].Value, TypeCode.String).ToString()) == false) { GoodEntity.Good_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(GoodGridView.CurrentRow.Cells[colGood_nvc.Name].Value, TypeCode.String).ToString(); GoodEntity.GoodCode_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(GoodGridView.CurrentRow.Cells[colGoodCode_nvc.Name].Value, TypeCode.String).ToString(); } } this.Close(); }
private void FillGrid() { try { HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); DataTable LaderTypeID_intDataTable = new DataTable(); string laderCondition = "[LaderType_T].[Active_bit]='true'"; LaderTypeID_intFactory.GetAllByCondition(laderCondition, ref LaderTypeID_intDataTable); laderTypeGrid.SetDataBinding(LaderTypeID_intDataTable, "LaderTypeID_intDataTable"); HPS.BLL.CompanyBLL.BLLCompany_TFactory CompanyID_intFactory = new HPS.BLL.CompanyBLL.BLLCompany_TFactory(); string CompanyCondition = "[Company_T].[Active_bit]='true'"; CompanyID_intFactory.GetAllByCondition(CompanyCondition, ref CompanyID_intDataTable); companyGrid.SetDataBinding(CompanyID_intDataTable, "CompanyID_intDataTable"); HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); DataTable GoodID_intDataTable = new DataTable(); GoodFactory.GetAll(ref GoodID_intDataTable); goodGrid.SetDataBinding(GoodID_intDataTable, "GoodID_intDataTable"); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); DataTable PortPlaceID_intDataTable = new DataTable(); string PortPlacesCondition = "[PortPlaces_T].[Active_bit]='true'"; PortPlaceFactory.GetAllByCondition(PortPlacesCondition, ref PortPlaceID_intDataTable); portPlaceGrid.SetDataBinding(PortPlaceID_intDataTable, "PortPlaceID_intDataTable"); HPS.BLL.CityBLL.BLLCity_TFactory CityFactory = new HPS.BLL.CityBLL.BLLCity_TFactory(); DataTable DestinationCityID_intDataTable = new DataTable(); string CityCondition = "[City_T].[Active_bit]='true'"; CityFactory.GetAllByCondition(CityCondition, ref DestinationCityID_intDataTable); destinationCityGrid.SetDataBinding(DestinationCityID_intDataTable, "DestinationCityID_intDataTable"); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(CityFactory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(CityFactory.ServerJalaliDate); //this.FromTimeTextBox.Text = "08:00:00"; //this.ToTimeTextBox.Text = CityFactory.ServerTime; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void FillCombo() { try { HPS.BLL.AnnouncementTimeBLL.BLLAnnouncementTime_TFactory AnnouncementTimeID_intFactory = new HPS.BLL.AnnouncementTimeBLL.BLLAnnouncementTime_TFactory(); DataTable AnnouncementTimeID_intDataTable = new DataTable(); AnnouncementTimeID_intFactory.GetAll(ref AnnouncementTimeID_intDataTable); this.AnnouncementTimeID_intComboBox.DisplayMember = HPS.BLL.AnnouncementTimeBLL.BLLAnnouncementTime_T.AnnouncementTime_TField.AnnouncementTime_nvc.ToString(); this.AnnouncementTimeID_intComboBox.ValueMember = HPS.BLL.AnnouncementTimeBLL.BLLAnnouncementTime_T.AnnouncementTime_TField.AnnouncementTimeID_int.ToString(); this.AnnouncementTimeID_intComboBox.DataSource = AnnouncementTimeID_intDataTable; this.AnnouncementTimeID_intComboBox.SelectedIndex = -1; HPS.BLL.CityBLL.BLLCity_TFactory CityID_intFactory = new HPS.BLL.CityBLL.BLLCity_TFactory(); DataTable CityID_intDataTable = new DataTable(); CityID_intFactory.GetAll(ref CityID_intDataTable); this.CityID_intComboBox.DisplayMember = HPS.BLL.CityBLL.BLLCity_T.City_TField.City_nvc.ToString(); this.CityID_intComboBox.ValueMember = HPS.BLL.CityBLL.BLLCity_T.City_TField.CityID_int.ToString(); this.CityID_intComboBox.DataSource = CityID_intDataTable; this.CityID_intComboBox.SelectedIndex = -1; HPS.BLL.GoodBLL.BLLGood_TFactory GoodID_intFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); DataTable GoodID_intDataTable = new DataTable(); GoodID_intFactory.GetAll(ref GoodID_intDataTable); this.GoodID_intComboBox.DisplayMember = HPS.BLL.GoodBLL.BLLGood_T.Good_TField.Good_nvc.ToString(); this.GoodID_intComboBox.ValueMember = HPS.BLL.GoodBLL.BLLGood_T.Good_TField.GoodID_int.ToString(); this.GoodID_intComboBox.DataSource = GoodID_intDataTable; this.GoodID_intComboBox.SelectedIndex = -1; HPS.BLL.BoxingBLL.BLLBoxing_TFactory BoxingID_intFactory = new HPS.BLL.BoxingBLL.BLLBoxing_TFactory(); DataTable BoxingID_intDataTable = new DataTable(); BoxingID_intFactory.GetAll(ref BoxingID_intDataTable); this.BoxingID_intComboBox.DisplayMember = HPS.BLL.BoxingBLL.BLLBoxing_T.Boxing_TField.BoxingType_nvc.ToString(); this.BoxingID_intComboBox.ValueMember = HPS.BLL.BoxingBLL.BLLBoxing_T.Boxing_TField.BoxingID_int.ToString(); this.BoxingID_intComboBox.DataSource = BoxingID_intDataTable; this.BoxingID_intComboBox.SelectedIndex = -1; HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceID_intFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); DataTable PortPlaceID_intDataTable = new DataTable(); PortPlaceID_intFactory.GetAll(ref PortPlaceID_intDataTable); this.PortPlaceID_intComboBox.DisplayMember = HPS.BLL.PortPlacesBLL.BLLPortPlaces_T.PortPlaces_TField.PortPlaces_nvc.ToString(); this.PortPlaceID_intComboBox.ValueMember = HPS.BLL.PortPlacesBLL.BLLPortPlaces_T.PortPlaces_TField.PortPlacesID_int.ToString(); this.PortPlaceID_intComboBox.DataSource = PortPlaceID_intDataTable; this.PortPlaceID_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.CompanyBLL.BLLCompany_TFactory CompanyID_intFactory = new HPS.BLL.CompanyBLL.BLLCompany_TFactory(); DataTable CompanyID_intDataTable = new DataTable(); CompanyID_intFactory.GetAll(ref CompanyID_intDataTable); this.CompanyID_intComboBox.DisplayMember = HPS.BLL.CompanyBLL.BLLCompany_T.Company_TField.Company_nvc.ToString(); this.CompanyID_intComboBox.ValueMember = HPS.BLL.CompanyBLL.BLLCompany_T.Company_TField.CompanyID_int.ToString(); this.CompanyID_intComboBox.DataSource = CompanyID_intDataTable; this.CompanyID_intComboBox.SelectedIndex = -1; HPS.BLL.TrafficTypeBLL.BLLTrafficType_TFactory TrafficTypeID_intFactory = new HPS.BLL.TrafficTypeBLL.BLLTrafficType_TFactory(); DataTable TrafficTypeID_intDataTable = new DataTable(); TrafficTypeID_intFactory.GetAll(ref TrafficTypeID_intDataTable); this.TrafficTypeID_intComboBox.DisplayMember = HPS.BLL.TrafficTypeBLL.BLLTrafficType_T.TrafficType_TField.TrafficType_nvc.ToString(); this.TrafficTypeID_intComboBox.ValueMember = HPS.BLL.TrafficTypeBLL.BLLTrafficType_T.TrafficType_TField.TrafficTypeID_int.ToString(); this.TrafficTypeID_intComboBox.DataSource = TrafficTypeID_intDataTable; this.TrafficTypeID_intComboBox.SelectedIndex = -1; } catch (Exception ex) { throw ex; } }
private void FillGrid() { HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); DataTable LaderTypeID_intDataTable = new DataTable(); string laderCondition = "[LaderType_T].[Active_bit]='true'"; LaderTypeID_intFactory.GetAllByCondition(laderCondition, ref LaderTypeID_intDataTable); laderTypeGrid.SetDataBinding(LaderTypeID_intDataTable, "LaderTypeID_intDataTable"); HPS.BLL.CompanyBLL.BLLCompany_TFactory CompanyID_intFactory = new HPS.BLL.CompanyBLL.BLLCompany_TFactory(); string CompanyCondition = "[Company_T].[Active_bit]='true'"; CompanyID_intFactory.GetAllByCondition(CompanyCondition, ref CompanyID_intDataTable); companyGrid.SetDataBinding(CompanyID_intDataTable, "CompanyID_intDataTable"); HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory(); DataTable LadbillOrder1Table = new DataTable(); LadBillCreditFactory.SelectCompanyRemainedLadBillReportOrderColumns(LadbillOrder1Table); DataRow emptyRow1 = LadbillOrder1Table.NewRow(); LadbillOrder1Table.Rows.InsertAt(emptyRow1, 0); this.Order1ComboBox.DisplayMember = "PropertyValue"; this.Order1ComboBox.ValueMember = "ColumnName"; this.Order1ComboBox.DataSource = LadbillOrder1Table; this.Order1ComboBox.SelectedIndex = 0; DataTable LadbillOrder2Table = new DataTable(); LadBillCreditFactory.SelectCompanyRemainedLadBillReportOrderColumns(LadbillOrder2Table); DataRow emptyRow2 = LadbillOrder2Table.NewRow(); LadbillOrder2Table.Rows.InsertAt(emptyRow2, 0); this.Order2ComboBox.DisplayMember = "PropertyValue"; this.Order2ComboBox.ValueMember = "ColumnName"; this.Order2ComboBox.DataSource = LadbillOrder2Table; this.Order2ComboBox.SelectedIndex = 0; DataTable LadbillOrder3Table = new DataTable(); LadBillCreditFactory.SelectCompanyRemainedLadBillReportOrderColumns(LadbillOrder3Table); DataRow emptyRow3 = LadbillOrder3Table.NewRow(); LadbillOrder3Table.Rows.InsertAt(emptyRow3, 0); this.Order3ComboBox.DisplayMember = "PropertyValue"; this.Order3ComboBox.ValueMember = "ColumnName"; this.Order3ComboBox.DataSource = LadbillOrder3Table; this.Order3ComboBox.SelectedIndex = 0; DataTable LadbillOrder4Table = new DataTable(); LadBillCreditFactory.SelectCompanyRemainedLadBillReportOrderColumns(LadbillOrder4Table); DataRow emptyRow4 = LadbillOrder4Table.NewRow(); LadbillOrder4Table.Rows.InsertAt(emptyRow4, 0); this.Order4ComboBox.DisplayMember = "PropertyValue"; this.Order4ComboBox.ValueMember = "ColumnName"; this.Order4ComboBox.DataSource = LadbillOrder4Table; this.Order4ComboBox.SelectedIndex = 0; DataTable LadbillOrder5Table = new DataTable(); LadBillCreditFactory.SelectCompanyRemainedLadBillReportOrderColumns(LadbillOrder5Table); DataRow emptyRow5 = LadbillOrder5Table.NewRow(); LadbillOrder5Table.Rows.InsertAt(emptyRow5, 0); this.Order5ComboBox.DisplayMember = "PropertyValue"; this.Order5ComboBox.ValueMember = "ColumnName"; this.Order5ComboBox.DataSource = LadbillOrder5Table; this.Order5ComboBox.SelectedIndex = 0; HPS.BLL.GoodBLL.BLLGood_TFactory GoodFactory = new HPS.BLL.GoodBLL.BLLGood_TFactory(); DataTable GoodID_intDataTable = new DataTable(); GoodFactory.GetAll(ref GoodID_intDataTable); goodGrid.SetDataBinding(GoodID_intDataTable, "GoodID_intDataTable"); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); DataTable PortPlaceID_intDataTable = new DataTable(); string PortPlacesCondition = "[PortPlaces_T].[Active_bit]='true'"; PortPlaceFactory.GetAllByCondition(PortPlacesCondition, ref PortPlaceID_intDataTable); portPlaceGrid.SetDataBinding(PortPlaceID_intDataTable, "PortPlaceID_intDataTable"); HPS.BLL.CityBLL.BLLCity_TFactory CityFactory = new HPS.BLL.CityBLL.BLLCity_TFactory(); DataTable DestinationCityID_intDataTable = new DataTable(); string CityCondition = "[City_T].[Active_bit]='true'"; CityFactory.GetAllByCondition(CityCondition, ref DestinationCityID_intDataTable); destinationCityGrid.SetDataBinding(DestinationCityID_intDataTable, "DestinationCityID_intDataTable"); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(CompanyID_intFactory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(CompanyID_intFactory.ServerJalaliDate); //FromTimeTextBox.Text = "08:00:00"; // ToTimeTextBox.Text = CompanyID_intFactory.ServerTime; }