private void WithProductionYearStripButton_Click(object sender, EventArgs e) { try { WithProductionYear = true; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = "[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND ProductionYear_int IS NOT NULL"; DataTable TrafficDataTable = new DataTable(); TrafficFactory.GetAllByConditionAllInTrafficArea(Condition, ref TrafficDataTable); this.TrafficGridView.DataSource = TrafficDataTable; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void LoadAllTrafficArea() { try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = string.Format("[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 And T1.TurnDate_nvc='{0}'", TrafficFactory.ServerJalaliDate.ToString()); DataTable TrafficDataTable = new DataTable(); TrafficFactory.GetAllByConditionAllInTrafficArea(Condition, ref TrafficDataTable); this.TrafficGridView.DataSource = TrafficDataTable; this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(TrafficFactory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(TrafficFactory.ServerJalaliDate); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }