private void CarLadeBillReportForm_Load(object sender, EventArgs e) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(TrafficFactory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(TrafficFactory.ServerJalaliDate); HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); DataTable LaderTypeDataTable = new DataTable(); LaderTypeFactory.GetAll(ref LaderTypeDataTable); this.LaderTypecheckedComboBox.DropDownDataSource = LaderTypeDataTable; this.LaderTypecheckedComboBox.DropDownDataMember = "LaderType_T"; this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString(); this.LaderTypecheckedComboBox.DropDownValueMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString(); LaderTypecheckedComboBox.RetrieveStructure(); LaderTypecheckedComboBox.DropDownList.Columns[1].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[2].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[4].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[5].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[6].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[7].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[8].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[9].Visible = false; LaderTypecheckedComboBox.DropDownList.Columns[3].Caption = "نوع بارگیر"; LaderTypecheckedComboBox.DropDownList.Columns[10].Caption = "تعداد محور"; LaderTypecheckedComboBox.DropDownList.Columns[3].Width = 300; }
public AcceptedTurnNumberRemainedByLaderTypeCountReport(string FromDate, string ToDate) { // // Required for Windows Form Designer support // InitializeComponent(); try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable LaderTypeReportTable = new DataTable(); TrafficFactory.SelectRemainedAcceptedTurnNumberByLaderTypeReport(FromDate, ToDate, LaderTypeReportTable); this.DataSource = LaderTypeReportTable; FromDatetxt.Text = FromDate; ToDatetxt.Text = ToDate; UserNametxt.Text = HPS.Common.CurrentUser.user.UserName_nvc; Datetxt.Text = TrafficFactory.ServerJalaliDate; Timetxt.Text = TrafficFactory.ServerTime; LaderType_nvctxt.DataField = "LaderType_nvc"; Counttxt.DataField = "RemainedCount_int"; Int64?AllcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["RemainedCount_int"]).Sum(); AllCounttxt.Text = AllcountRecords.HasValue ? AllcountRecords.ToString() : "0"; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
public ForeignInNotOutReport(string FromDate, string ToDate, int TrafficType) { // // Required for Windows Form Designer support // InitializeComponent(); FromDatetxt.Text = FromDate; ToDatetxt.Text = ToDate; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable TrafficDataTable = new DataTable(); string Condition = "(T1.TrafficTypeID_int='2') AND (T1.Date_nvc>='" + FromDatetxt.Text + "') AND (T1.Date_nvc<='" + ToDate + "')"; TrafficFactory.GetAllByConditionAllInTrafficNotTemporaryOut(Condition, ref TrafficDataTable); this.DataSource = TrafficDataTable; Datetxt.DataField = "Date_nvc"; Timetxt.DataField = "Time_nvc"; TrafficNumbertxt.DataField = "TrafficNumber_bint"; NumberPlateTextBox.DataField = "NumberPlate_nvc"; SerialPlateTextBox.DataField = "SerialPlate_nvc"; Pricetxt.DataField = "Price_dec"; Usertxt.DataField = "UserName_nvc"; FirstNametxt.DataField = "FirstName_nvc"; LastNametxt.DataField = "LastName_nvc"; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc; decimal?AllPrice = (from row in TrafficDataTable.AsEnumerable() select(decimal) row["Price_dec"]).Sum(); AllPricetxt.Text = AllPrice.HasValue ? AllPrice.ToString() : "0"; }
private void AllInfoByDateReportForm_Load(object sender, EventArgs e) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory Factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); //this.FromTimeTextBox.Text = "08:00:00"; //this.ToTimeTextBox.Text = Factory.ServerTime.ToString(); 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"); //CompanyGroupComboBox Fill. HPS.BLL.CompanyGroupBLL.BLLCompanyGroup_TFactory GroupID_intFatory = new BLL.CompanyGroupBLL.BLLCompanyGroup_TFactory(); DataTable GroupID_intDataTable = new DataTable(); GroupID_intFatory.GetAll(ref GroupID_intDataTable); this.CompanyGroupComboBox.DisplayMember = "GroupName_nvc"; this.CompanyGroupComboBox.ValueMember = "GroupID_int"; this.CompanyGroupComboBox.DataSource = GroupID_intDataTable; this.CompanyGroupComboBox.SelectedIndex = -1; var LadeAssignmentFactory = new BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory(); string LastDate_vc = string.Empty; LadeAssignmentFactory.SelectLastPerBarnameDate(out LastDate_vc); LastDateLabel.Text = LastDate_vc; }
public AllInTrafficReport(string FromDate, string FromTime, string ToDate, string ToTime) { // // Required for Windows Form Designer support // InitializeComponent(); try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable LaderTypeReportTable = new DataTable(); TrafficFactory.SelectAllInTrafficReport(FromDate, FromTime, ToDate, ToTime, ref LaderTypeReportTable); this.DataSource = LaderTypeReportTable; FromDatetxt.Text = FromDate; FromTimetxt.Text = FromTime; ToDatetxt.Text = ToDate; ToTimetxt.Text = ToTime; UserNametxt.Text = HPS.Common.CurrentUser.user.UserName_nvc; Datetxt.Text = TrafficFactory.ServerJalaliDate; Timetxt.Text = TrafficFactory.ServerTime; Cartxt.DataField = "LaderType_nvc"; Counttxt.DataField = "Count_int"; CountPercenttxt.DataField = "CountPercent"; Pricetxt.DataField = "Price_dec"; PricePercenttxt.DataField = "PricePercent"; Int64?AllcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["Count_int"]).Sum(); AllCounttxt.Text = AllcountRecords.HasValue ? AllcountRecords.ToString() : "0"; decimal?AllPriceRecords = (from row in LaderTypeReportTable.AsEnumerable() select(decimal) row["Price_dec"]).Sum(); AllPricetxt.Text = AllPriceRecords.HasValue ? AllPriceRecords.ToString() : "0"; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void PrinterSelectionButton_Click(object sender, EventArgs e) { ShowwithConditionbutton.Visible = true; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(TrafficFactory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(TrafficFactory.ServerJalaliDate); }
private void TurnPrintStripButton_Click(object sender, EventArgs e) { try { HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory(); string condition = "LadBillCredit_T.TrafficID_bint='" + Hepsa.Core.Common.PersentationController.GetEntityValue(this.TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value, TypeCode.Int64) + "' or (LadBillCredit_T.LadBillCreditID_int is not null and LadBillCredit_T.Canceled_bit=0 AND LadBillCredit_T.Turn_bit is not NULL)"; List <HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T> LadBillCreditList = LadBillCreditFactory.GetAllByCondition(condition); if (LadBillCreditList != null && LadBillCreditList.Count > 0) { bool?ladturn = LadBillCreditList[LadBillCreditList.Count - 1].Turn_bit; if (LadBillCreditList[LadBillCreditList.Count - 1].Canceled_bit == false || (LadBillCreditList[LadBillCreditList.Count - 1].Canceled_bit == true && ladturn == false)) { throw new ApplicationException("نوبت مورد نظر مجوز گرفته است"); } } HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory(); string conditionTurnManagement = string.Format("TurnManagement_T.TrafficID_bint='{0}' ", Hepsa.Core.Common.PersentationController.GetEntityValue(this.TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value, TypeCode.Int64)); DataTable TurnManagementTable = new DataTable(); TurnManagementFactory.GetAllByCondition(conditionTurnManagement, ref TurnManagementTable); if (TurnManagementTable != null && TurnManagementTable.Rows.Count > 0) { if (TurnManagementTable.Rows[TurnManagementTable.Rows.Count - 1]["Return_bit"].ToString() == "False") { throw new ApplicationException("نوبت مورد نظر باطل شده است"); } } //HPS.Reports.ReportDoc.AcceptedTurnReport rpt = new HPS.Reports.ReportDoc.AcceptedTurnReport((Int64)Hepsa.Core.Common.PersentationController.GetEntityValue(this.TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value, TypeCode.Int64)); //rpt.Document.Printer.PrinterName = string.Empty; //rpt.Run(); //Properties.Settings s = new HPS.Properties.Settings(); //if (string.IsNullOrEmpty(s.PrinterName)) //{ // rpt.Document.Print(true, true, true); //} //else //{ // rpt.Document.Printer.PrinterName = s.PrinterName; // rpt.Document.Print(false, true, true); //} /// HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); HPS.BLL.TrafficBLL.BLLTraffic_TKeys TrafficKey = new HPS.BLL.TrafficBLL.BLLTraffic_TKeys(); HPS.BLL.TrafficBLL.BLLTraffic_T TrafficEntityrpt = new HPS.BLL.TrafficBLL.BLLTraffic_T(); TrafficKey.TrafficID_bint = (Int64)Hepsa.Core.Common.PersentationController.GetEntityValue(this.TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value, TypeCode.Int64); TrafficEntityrpt = TrafficFactory.GetBy(TrafficKey); HPS.Reports.Forms.StimulViewer frm = new Reports.Forms.StimulViewer(TrafficEntityrpt, false, false); frm.ShowDialog(); // } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void PrintCanceledButton_Click(object sender, EventArgs e) { try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = string.Empty; AllCanceledTurnstiReport.Dictionary.Synchronize(); AllCanceledTurnstiReport.Dictionary.Databases.Clear(); AllCanceledTurnstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AllCanceledTurnstiReport.Compile(); AllCanceledTurnstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); AllCanceledTurnstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; AllCanceledTurnstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; AllCanceledTurnstiReport["@FromTime_nvc"] = FromTimeTextBox.Text; AllCanceledTurnstiReport["@ToTime_nvc"] = ToTimeTextBox.Text; AllCanceledTurnstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; AllCanceledTurnstiReport["todate_vc"] = ToDatefaDatePicker.Text; AllCanceledTurnstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; AllCanceledTurnstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; AllCanceledTurnstiReport.Render(); AllCanceledTurnstiReport.Show(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void AllOutTrafficReportForm_Load(object sender, EventArgs e) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory Factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); //this.ToTimeTextBox.Text = Factory.ServerTime; this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } string Condition = string.Empty; if (WithProductionYear == true) { Condition = "T1.TurnDate_nvc>='" + FromDatefaDatePicker + "' AND T1.TurnDate_nvc<='" + ToDatefaDatePicker.Text + "' And T1.Area_bit=1 AND T1.ProductionYear_int IS NOT NULL"; } else { Condition = "T1.TurnDate_nvc>='" + FromDatefaDatePicker.Text + "' AND T1.TurnDate_nvc<='" + ToDatefaDatePicker.Text + " And T1.Area_bit=1'"; } if (!string.IsNullOrEmpty(AcceptedTurnNumber_binttextBox.Text)) { Condition = string.Format(" T1.AcceptedTurnNumber_bint={0} And T1.Area_bit=1 ", AcceptedTurnNumber_binttextBox.Text); } if (!string.IsNullOrEmpty(TrafficNumber_binttextBox.Text)) { Condition = string.Format(" T1.TrafficNumber_bint={0} And T1.Area_bit=1", TrafficNumber_binttextBox.Text); } if (!string.IsNullOrEmpty(NumberPlate_nvctextBox.Text) && !string.IsNullOrEmpty(SerialPlate_nvctextBox.Text)) { Condition = string.Format(" T1.NumberPlate_nvc ='{0}' AND T1.SerialPlate_nvc='{1}' And T1.Area_bit=1", NumberPlate_nvctextBox.Text, SerialPlate_nvctextBox.Text); } if (!string.IsNullOrEmpty(LastName_nvctextBox.Text)) { Condition = string.Format(" LastName_nvc LIKE '%{0}%' And T1.Area_bit=1", LastName_nvctextBox.Text); } HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable TrafficDataTable = new DataTable(); TrafficFactory.SelectAcceptedTurns(TrafficDataTable, Condition); this.TrafficGridView.DataSource = TrafficDataTable; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
public OtherOutReport(string FromDate, string ToDate, string FromTime, string ToTime, string FromTrafficNumber, string ToTrafficNumber) { // // Required for Windows Form Designer support // InitializeComponent(); FromDatetxt.Text = FromDate; ToDatetxt.Text = ToDate; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable TrafficDataTable = new DataTable(); string Condition = string.Empty; //if (!(string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) && (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime))) //{ // Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc>='" + FromDatetxt.Text + "') AND (T.Date_nvc<='" + ToDate + "') AND (T.Time_nvc>='" + FromTime + "') AND (T.Time_nvc<='" + ToTime + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; //} //if (string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber) && !((string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)))) //{ // Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "') AND (T.Time_nvc>='" + FromTime + "') AND (T.Time_nvc<='" + ToTime + "')"; //} //else if (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime) || (string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) //{ // Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "')"; //} if (!(string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) && (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime))) { Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; } else if (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime) && (string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) { Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "')"; } else if (!(string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) { Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc+ ' ' +T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "')"; } else if (!((string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) { Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') AND (T.TrafficTypeID_int<>'2') AND (T.Date_nvc + ' ' + T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; } TrafficFactory.GetAllByConditionAllTraffic(Condition, ref TrafficDataTable); this.DataSource = TrafficDataTable; Datetxt.DataField = "Date_nvc"; Timetxt.DataField = "Time_nvc"; TrafficNumbertxt.DataField = "TrafficNumber_bint"; NumberPlateTextBox.DataField = "NumberPlate_nvc"; PlateCitytxt.DataField = "PlateCityID_intPlateCity_nvc"; SerialPlateTextBox.DataField = "SerialPlate_nvc"; Pricetxt.DataField = "Price_dec"; Usertxt.DataField = "UserName_nvc"; AllPricetxt.DataField = "Price_dec"; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc; }
private void AllInTrafficWithPriceReportForm_Load(object sender, EventArgs e) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(factory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(factory.ServerJalaliDate); //FromTimeTextBox.Text = "08:00:00"; //ToTimeTextBox.Text = factory.ServerTime; }
private void LoadAllTraffic() { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = "[T1].[TrafficTypeID_int]=1 AND T1.Date_nvc='" + TrafficFactory.ServerJalaliDate + "'"; DataTable TrafficDataTable = new DataTable(); TrafficFactory.GetAllByConditionAllInTrafficForTurnAcception(Condition, ref TrafficDataTable); this.TrafficGridView.DataSource = TrafficDataTable; }
private void LoadDriverTraffic() { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string TrafficCondition = "[T].[DriverCardNumber_nvc]= '" + DriverCardNumber + "'"; DataTable DriverTrafficDatatable = new DataTable(); TrafficFactory.GetAllByConditionAllTraffic(TrafficCondition, ref DriverTrafficDatatable); DriverTrafficGridView.DataSource = DriverTrafficDatatable; }
public CarAllTrafficReport(string FromDate, string Todate, string NumberPlate, string SerialPlate, string CarCardNumber) { // // Required for Windows Form Designer support // InitializeComponent(); FromDatetxt.Text = FromDate; ToDatetxt.Text = Todate; CarCardNumbertxt.Text = CarCardNumber; UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string TrafficCondition = string.Empty; if (!string.IsNullOrEmpty(NumberPlate) && !string.IsNullOrEmpty(SerialPlate)) { TrafficCondition += string.Format(" T.NumberPlate_nvc='{0}' AND T.SerialPlate_nvc='{1}' ", NumberPlate, SerialPlate); if (!string.IsNullOrEmpty(CarCardNumber)) { TrafficCondition += string.Format(" AND T.CarCardNumber_nvc={0} ", CarCardNumber); } } else if (!string.IsNullOrEmpty(CarCardNumber)) { TrafficCondition += string.Format(" T.CarCardNumber_nvc={0} ", CarCardNumber); } if (!string.IsNullOrEmpty(FromDate) && !string.IsNullOrEmpty(Todate)) { TrafficCondition += string.Format(" AND T.Date_nvc>='{0}' AND T.Date_nvc<='{1}' ", FromDate, Todate); } DataTable CarTrafficDatatable = new DataTable(); TrafficFactory.GetAllByConditionAllTraffic(TrafficCondition, ref CarTrafficDatatable); this.DataSource = CarTrafficDatatable; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; Datetxt.DataField = "Date_nvc"; Timetxt.DataField = "Time_nvc"; InTextTextBox.DataField = "InText"; TurnNumbertxt.DataField = "TurnNumber_bint"; TrafficNumbertxt.DataField = "TrafficNumber_bint"; DriverCardNumbertxt.DataField = "DriverCardNumber_nvc"; FullNameTextBox.DataField = "FullName_nvc"; //FirstNameTextBox.DataField = "FirstName_nvc"; //LastNameTextBox.DataField = "LastName_nvc"; Pricetxt.DataField = "Price_dec"; Usertxt.DataField = "UserName_nvc"; PlateTypetxt.DataField = "PlateType_nvc"; NumberPlateTextBox.Text = NumberPlate + "-"; SerialPlateTextBox.Text = SerialPlate; AllPricetxt.DataField = "Price_dec"; }
private void AllTurntoolStripButton_Click(object sender, EventArgs e) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = "[T1].[TrafficTypeID_int]=1 "; DataTable TrafficDataTable = new DataTable(); TrafficFactory.GetAllByConditionAllInTrafficForTurnAcception(Condition, ref TrafficDataTable); this.TrafficGridView.DataSource = TrafficDataTable; }
private void LoadCarTraffic() { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string TrafficCondition = "([T].[NumberPlate_nvc]= '" + NumberPlate + "') AND ([T].[SerialPlate_nvc]='" + SerialPlate + "') AND ([T].[PlateCityID_int]= '" + PlateCityID + "')"; DataTable CarTrafficDatatable = new DataTable(); TrafficFactory.GetAllByConditionAllTraffic(TrafficCondition, ref CarTrafficDatatable); CarTrafficGridView.DataSource = CarTrafficDatatable; }
public ForeignInTrafficReport(string FromDate, string ToDate, int TrafficType, string FromTime, string ToTime, string FromTrafficNumber, string ToTrafficNumber) { // // Required for Windows Form Designer support // InitializeComponent(); FromDatetxt.Text = FromDate; ToDatetxt.Text = ToDate; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable TrafficDataTable = new DataTable(); string Condition = string.Empty; if (!(string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) && (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime))) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; } else if (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime) && (string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "')"; } else if (!(string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc+ ' ' +T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "')"; } else if (!((string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc + ' ' + T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; } TrafficFactory.GetAllByConditionAllTraffic(Condition, ref TrafficDataTable); this.DataSource = TrafficDataTable; Datetxt.DataField = "Date_nvc"; Timetxt.DataField = "Time_nvc"; TrafficNumbertxt.DataField = "TrafficNumber_bint"; NumberPlateTextBox.DataField = "NumberPlate_nvc"; SerialPlateTextBox.DataField = "SerialPlate_nvc"; Pricetxt.DataField = "Price_dec"; Usertxt.DataField = "UserName_nvc"; FirstNametxt.DataField = "FirstName_nvc"; LastNametxt.DataField = "LastName_nvc"; WithLadeChkBox.DataField = "WithLade_bit"; Services_nvctxt.DataField = "ServiceID_intServiceType_nvc"; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc; decimal?AllPrice = (from row in TrafficDataTable.AsEnumerable() select(decimal) row["Price_dec"]).Sum(); AllPricetxt.Text = AllPrice.HasValue ? AllPrice.ToString() : "0"; decimal?Allcount = (from row in TrafficDataTable.AsEnumerable() select(decimal?) row["Price_dec"]).Count(); AllCounttxt.Text = Allcount.HasValue ? Allcount.ToString() : "0"; }
protected override void Edit() { try { if (TrafficGridView.CurrentRow != null && (Int64)TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value != 0) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable OutDataTable = new DataTable(); string outcondition = ""; TrafficFactory.GetAllByConditionOut("", ref OutDataTable); if ((Int64)TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value != (Int64)TrafficGridView.CurrentRow.Cells[colMaxTrafficID_bint.Name].Value) { Hepsa.Core.Common.MessageBox.ErrorMessage("امکان احیای این خروج وجود ندارد ، این ناوگان ورود داشته است"); return; } if (Hepsa.Core.Common.MessageBox.ConfirmMessage("آیا از احیای این خروج اطمینان دارید؟") == true) { HPS.BLL.TrafficBLL.BLLTraffic_TFactory trafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); HPS.BLL.TrafficBLL.BLLTraffic_TKeys trafficKey = new HPS.BLL.TrafficBLL.BLLTraffic_TKeys(); trafficKey.TrafficID_bint = (Int64)TrafficGridView.CurrentRow.Cells[colTrafficID_bint.Name].Value; string _LogBody = "<table border=\"1\">"; foreach (DataGridViewColumn col in TrafficGridView.Columns) { if (col.Visible) { _LogBody += string.Format("<tr><td>{0}</td><td>{1}</td></tr>", col.HeaderText, TrafficGridView.CurrentRow.Cells[col.Name].Value); } } _LogBody += "</table>"; trafficFactory.BeginProc(); trafficFactory.Delete(trafficKey); /********Start Logging********/ Hepsa.Core.BLL.BLLLog_TFactory LogFactory = new Hepsa.Core.BLL.BLLLog_TFactory(); Hepsa.Core.BLL.BLLLog_T LogEntity = new Hepsa.Core.BLL.BLLLog_T(); LogEntity.Date_nvc = LogFactory.ServerJalaliDate; LogEntity.Time_nvc = LogFactory.ServerTime; LogEntity.IPAddress_nvc = Hepsa.Core.Common.ApplicationInfo.IpAddress; LogEntity.MacAddress_nvc = Hepsa.Core.Common.ApplicationInfo.MacAddress; LogEntity.UserName_nvc = Hepsa.Core.Common.CurrentUser.User.UserName_nvc; LogEntity.FormText_nvc = String.IsNullOrEmpty(this.Text) ? this.Name : this.Text; LogEntity.ActionID_int = Convert.ToInt32(Hepsa.Core.BLL.BLLAction_T.Actions.Delete); LogEntity.Body_nvc = _LogBody; LogFactory.Insert(LogEntity); /********End Logging********/ trafficFactory.CommitProc(); this.LoadGrid(); } } } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void Foreign() { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); TrafficCondition = "([Traffic_T].[NumberPlate_nvc]= '" + NumberPlate + "') AND ([Traffic_T].[SerialPlate_nvc]=" + SerialPlate + ")"; List <HPS.BLL.TrafficBLL.BLLTraffic_T> TrafficList = TrafficFactory.GetAllByCondition(TrafficCondition); if (TrafficList != null && TrafficList.Count > 0 && TrafficList[TrafficList.Count - 1].In_bit == true) { this.TrafficFields(); } }
private void LoadWithoutDriverCardNumber() { HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_TFactory DriverSpecificationFactory = new HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_TFactory(); DataTable DriverFieldTable = new DataTable(); DriverSpecificationFactory.SelectByDriverField(_FirstName, _LastName, _NationalCode, ref DriverFieldTable); if (DriverFieldTable != null && DriverFieldTable.Rows.Count > 0) { _DriverSpecificationID = (Int32)DriverFieldTable.Rows[0]["DriverSpecificationID_int"]; Key = new HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_TKeys(); Key.DriverSpecificationID_int = _DriverSpecificationID; DriverCardNumber_nvcTextBox.Text = DriverFieldTable.Rows[0]["DriverCardNumber_nvc"].ToString(); FirstName_nvcTextBox.Text = DriverFieldTable.Rows[0]["FirstName_nvc"].ToString(); LastName_nvcTextBox.Text = DriverFieldTable.Rows[0]["LastName_nvc"].ToString(); NationalCode_intNumericTextBox.Text = DriverFieldTable.Rows[0]["NationalCode_int"].ToString(); licenceNumber_nvcTextBox.Text = DriverFieldTable.Rows[0]["licenceNumber_nvc"].ToString(); LicenceEnd_nvcTextBox.Text = DriverFieldTable.Rows[0]["LicenceEnd_nvc"].ToString(); CarExaminationEndDate_nvcTextBox.Text = DriverFieldTable.Rows[0]["CarExaminationEndDate_nvc"].ToString(); InsuranceEndDate_nvcTextBox.Text = DriverFieldTable.Rows[0]["InsuranceEndDate_nvc"].ToString(); ClassID_intComboBox.SelectedValue = DriverFieldTable.Rows[0]["ClassID_int"]; HealthCardEndDate_nvcTextBox.Text = DriverFieldTable.Rows[0]["HealthCardEndDate_nvc"].ToString(); DriverCardSharjeEndDate_nvcTextBox.Text = DriverFieldTable.Rows[0]["DriverCardSharjeEndDate_nvc"].ToString(); } else { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = "Traffic_T.FirstName_nvc=N'" + _FirstName + "' AND Traffic_T.LastName_nvc=N'" + _LastName + "' AND Traffic_T.NationalCode_int='" + _NationalCode + "'"; List <HPS.BLL.TrafficBLL.BLLTraffic_T> TrafficList = TrafficFactory.GetAllByCondition(Condition); if (TrafficList != null && TrafficList.Count > 0) { DriverCardNumber_nvcTextBox.Text = TrafficList[TrafficList.Count - 1].DriverCardNumber_nvc; FirstName_nvcTextBox.Text = TrafficList[TrafficList.Count - 1].FirstName_nvc; LastName_nvcTextBox.Text = TrafficList[TrafficList.Count - 1].LastName_nvc; NationalCode_intNumericTextBox.Text = Convert.ToString(TrafficList[TrafficList.Count - 1].NationalCode_int); licenceNumber_nvcTextBox.Text = Convert.ToString(TrafficList[TrafficList.Count - 1].licenceNumber_int); } else { HPS.BLL.DriverBLL.BLLDriver_TFactory DriverFactory = new HPS.BLL.DriverBLL.BLLDriver_TFactory(); List <HPS.BLL.DriverBLL.BLLDriver_T> DriverList = DriverFactory.GetAllBy(HPS.BLL.DriverBLL.BLLDriver_T.Driver_TField.DriverCardNumber_nvc, _DriverCardNumber); if (DriverList != null && DriverList.Count > 0) { DriverCardNumber_nvcTextBox.Text = DriverList[0].DriverCardNumber_nvc; FirstName_nvcTextBox.Text = DriverList[0].FirstName_nvc; LastName_nvcTextBox.Text = DriverList[0].LastName_nvc; NationalCode_intNumericTextBox.Text = Convert.ToString(DriverList[0].NationalCode_int); licenceNumber_nvcTextBox.Text = Convert.ToString(DriverList[0].licenceNumber_nvc); } } } }
public AllAcceptedTurnReport(string FromDate, string ToDate, bool WithProductionYear) { // // Required for Windows Form Designer support // InitializeComponent(); try { FromDatetxt.Text = FromDate; ToDatetxt.Text = ToDate; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = string.Empty; if (WithProductionYear == true) { Condition = "[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND (T1.TurnDate_nvc>='" + FromDatetxt.Text + "') AND (T1.TurnDate_nvc<='" + ToDate + "') AND T1.ProductionYear_int IS NOT NULL"; } else { Condition = "[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND (T1.TurnDate_nvc>='" + FromDatetxt.Text + "') AND (T1.TurnDate_nvc<='" + ToDate + "')"; } DataTable TrafficDataTable = new DataTable(); TrafficFactory.SelectAcceptedTurns(TrafficDataTable, Condition); this.DataSource = TrafficDataTable; Datetxt.DataField = "Date_nvc"; Timetxt.DataField = "Time_nvc"; TurnNumbertxt.DataField = "TurnNumber_bint"; TrafficNumbertxt.DataField = "TrafficNumber_bint"; NumberPlateTextBox.DataField = "NumberPlate_nvc"; PlateCitytxt.DataField = "PlateCityID_intPlateCity_nvc"; SerialPlateTextBox.DataField = "SerialPlate_nvc"; CarCardNumbertxt.DataField = "CarCardNumber_nvc"; DriverCardNumbertxt.DataField = "DriverCardNumber_nvc"; Usertxt.DataField = "UserName_nvc"; FirstNametxt.DataField = "FirstName_nvc"; LastNametxt.DataField = "LastName_nvc"; TurnAcceptedchk.DataField = "TurnAccepted_bit"; TurnAcceptedNumbertxt.DataField = "AcceptedTurnNumber_bint"; TurnAcceptedDatetxt.DataField = "TurnDate_nvc"; TurnAcceptedTimetxt.DataField = "TurnTime_nvc"; LaderTypetxt.DataField = "LaderTypeID_intLaderType_nvc"; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc; PivotGrouptxt.Text = "تمامی کامیون ها"; ProductionYeartxt.DataField = "ProductionYear_int"; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void TrafficPicturesForm_Load(object sender, EventArgs e) { try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory Factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void OnlineCardCheckingReportForm_Load(object sender, EventArgs e) { try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory Factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); } catch (Exception ex) { throw; } }
private void LoadDrivers() { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable DriverDataTable = new DataTable(); string Condition = string.Empty; TrafficFactory.SelectDriverMobile_nvc(Condition, ref DriverDataTable); DriverDataTable.Columns.Add(new DataColumn("Checked_bit", Type.GetType("System.Boolean"))); DriverDataTable.Columns["Checked_bit"].AllowDBNull = true; DriverDataTable.Columns["Checked_bit"].DefaultValue = false; this.DriversdataGridView.AutoGenerateColumns = false; this.DriversdataGridView.DataSource = DriverDataTable; }
public override bool Validate(params object[] value) { try { this.Description = string.Empty; if (value.Length != Field.Length) { this.Description = Hepsa.Core.My.Resources.ValidationMessage.IncorrectDataType; return(false); } string DriverMobileNumber_nvc = Convert.ToString(value[0]); Int64 DriverNationalCode_bint = Convert.ToInt64(value[1]); bool In_bit = Convert.ToBoolean(value[2]); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); List <HPS.BLL.TrafficBLL.BLLTraffic_TFactory> TrafficList = new List <HPS.BLL.TrafficBLL.BLLTraffic_TFactory>(); DataTable DublicateNumberDataTable = new DataTable(); if (In_bit) { if (!string.IsNullOrEmpty(DriverMobileNumber_nvc) && !string.IsNullOrEmpty(DriverNationalCode_bint.ToString())) { TrafficFactory.SelectDriverDuplicateNumber(DriverMobileNumber_nvc, DriverNationalCode_bint, DublicateNumberDataTable); if (DublicateNumberDataTable != null && DublicateNumberDataTable.Rows.Count > 0) { //this.Description = "شماره موبایل از قبل موجود می باشد"; //return false; DataRow[] dr = DublicateNumberDataTable.Select(string.Format("DriverMobileNumber_nvc={0} AND NationalCode_int={1}", DriverMobileNumber_nvc, DriverNationalCode_bint)); if (dr.Length > 0) { return(true); } else { DataRow[] drNotMine = DublicateNumberDataTable.Select(string.Format("DriverMobileNumber_nvc <> {0} OR NationalCode_int <> {1}", DriverMobileNumber_nvc, DriverNationalCode_bint)); if (drNotMine.Length > 0) { this.Description = "شماره موبایل از قبل موجود می باشد"; return(false); } } } } } return(true); } catch (System.Exception ex) { this.Description = ex.Message; return(false); } }
private void ShowwithConditionbutton_Click(object sender, EventArgs e) { try { string AcceptedTurnNumber_nvc = string.Empty; string TrafficNumber_nvc = string.Empty; string NumberPlate_nvc = string.Empty; string SerialPlate_nvc = string.Empty; string FromDate_nvc = string.Empty; string ToDate_nvc = string.Empty; string LastName_nvc = string.Empty; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); if (!FromDatefaDatePicker.IsNull) { FromDate_nvc = FromDatefaDatePicker.Text; } if (!ToDatefaDatePicker.IsNull) { ToDate_nvc = ToDatefaDatePicker.Text; } if (string.IsNullOrEmpty(AcceptedTurnNumber_binttextBox.Text) == false) { AcceptedTurnNumber_nvc = AcceptedTurnNumber_binttextBox.Text; } if (string.IsNullOrEmpty(TrafficNumber_binttextBox.Text) == false) { TrafficNumber_nvc = TrafficNumber_binttextBox.Text; } if (string.IsNullOrEmpty(NumberPlate_nvctextBox.Text) == false) { NumberPlate_nvc = NumberPlate_nvctextBox.Text; } if (string.IsNullOrEmpty(SerialPlate_nvctextBox.Text) == false) { SerialPlate_nvc = SerialPlate_nvctextBox.Text; } if (string.IsNullOrEmpty(LastName_nvctextBox.Text) == false) { LastName_nvc = LastName_nvctextBox.Text; } DataTable TrafficDataTable = new DataTable(); TrafficFactory.SelectTurnAcceptedWithFields(ref TrafficDataTable, AcceptedTurnNumber_nvc, TrafficNumber_nvc, NumberPlate_nvc, SerialPlate_nvc, FromDate_nvc, ToDate_nvc, LastName_nvc); this.TrafficGridView.DataSource = TrafficDataTable; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void LoadActiveTurns() { try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable TrafficDataTable = new DataTable(); TrafficFactory.SelectActiveTurns(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, TrafficDataTable); this.TrafficGridView.DataSource = TrafficDataTable; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void LoadWithDriverCardNumber() { HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_TFactory DriverSpecificationFactory = new HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_TFactory(); List <HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_T> DriverSpecificationList = DriverSpecificationFactory.GetAllBy(HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_T.DriverSpecification_TField.NationalCode_int, _NationalCode); if (DriverSpecificationList != null && DriverSpecificationList.Count > 0) { _DriverSpecificationID = DriverSpecificationList[0].DriverSpecificationID_int; Key = new HPS.BLL.DriverSpecificationBLL.BLLDriverSpecification_TKeys(); Key.DriverSpecificationID_int = _DriverSpecificationID; DriverCardNumber_nvcTextBox.Text = DriverSpecificationList[0].DriverCardNumber_nvc; FirstName_nvcTextBox.Text = DriverSpecificationList[0].FirstName_nvc; LastName_nvcTextBox.Text = DriverSpecificationList[0].LastName_nvc; NationalCode_intNumericTextBox.Text = Convert.ToString(DriverSpecificationList[0].NationalCode_int); licenceNumber_nvcTextBox.Text = DriverSpecificationList[0].licenceNumber_nvc; LicenceEnd_nvcTextBox.Text = DriverSpecificationList[0].LicenceEnd_nvc; ClassID_intComboBox.SelectedValue = DriverSpecificationList[0].ClassID_int.HasValue?DriverSpecificationList[0].ClassID_int:0; HealthCardEndDate_nvcTextBox.Text = DriverSpecificationList[0].HealthCardEndDate_nvc; DriverCardSharjeEndDate_nvcTextBox.Text = DriverSpecificationList[0].DriverCardSharjeEndDate_nvc; SaveAndCloseButton.Visible = false; } else { Editbutton.Visible = false; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); List <HPS.BLL.TrafficBLL.BLLTraffic_T> TrafficList = TrafficFactory.GetAllBy(HPS.BLL.TrafficBLL.BLLTraffic_T.Traffic_TField.NationalCode_int, _NationalCode); if (TrafficList != null && TrafficList.Count > 0) { DriverCardNumber_nvcTextBox.Text = TrafficList[TrafficList.Count - 1].DriverCardNumber_nvc; FirstName_nvcTextBox.Text = TrafficList[TrafficList.Count - 1].FirstName_nvc; LastName_nvcTextBox.Text = TrafficList[TrafficList.Count - 1].LastName_nvc; NationalCode_intNumericTextBox.Text = Convert.ToString(TrafficList[TrafficList.Count - 1].NationalCode_int); licenceNumber_nvcTextBox.Text = Convert.ToString(TrafficList[TrafficList.Count - 1].licenceNumber_int); } else { HPS.BLL.DriverBLL.BLLDriver_TFactory DriverFactory = new HPS.BLL.DriverBLL.BLLDriver_TFactory(); List <HPS.BLL.DriverBLL.BLLDriver_T> DriverList = DriverFactory.GetAllBy(HPS.BLL.DriverBLL.BLLDriver_T.Driver_TField.NationalCode_int, _NationalCode); if (DriverList != null && DriverList.Count > 0) { DriverCardNumber_nvcTextBox.Text = DriverList[0].DriverCardNumber_nvc; FirstName_nvcTextBox.Text = DriverList[0].FirstName_nvc; LastName_nvcTextBox.Text = DriverList[0].LastName_nvc; NationalCode_intNumericTextBox.Text = Convert.ToString(DriverList[0].NationalCode_int); licenceNumber_nvcTextBox.Text = Convert.ToString(DriverList[0].licenceNumber_nvc); } } } }
private void FillCombo() { try { HPS.BLL.LaderPivotGroupBLL.BLLLaderPivotGroup_TFactory LaderPivotGroupID_intFactory = new HPS.BLL.LaderPivotGroupBLL.BLLLaderPivotGroup_TFactory(); DT.DataTable LaderPivotGroupID_intDataTable = new DT.DataTable(); LaderPivotGroupID_intFactory.GetAll(ref LaderPivotGroupID_intDataTable); this.LaderPivotGroupID_intComboBox.DisplayMember = HPS.BLL.LaderPivotGroupBLL.BLLLaderPivotGroup_T.LaderPivotGroup_TField.LaderPivotGroup_nvc.ToString(); this.LaderPivotGroupID_intComboBox.ValueMember = HPS.BLL.LaderPivotGroupBLL.BLLLaderPivotGroup_T.LaderPivotGroup_TField.LaderPivotGroupID_int.ToString(); this.LaderPivotGroupID_intComboBox.DataSource = LaderPivotGroupID_intDataTable; this.LaderPivotGroupID_intComboBox.SelectedIndex = -1; HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); DT.DataTable LaderTypeID_intDataTable = new DT.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.ServicesBLL.BLLServices_TFactory ServicesFactory = new HPS.BLL.ServicesBLL.BLLServices_TFactory(); DT.DataTable ServicesDataTable = new DT.DataTable(); string condition = "[Services_T].[Activie_bit]='true'"; ServicesFactory.GetAllByCondition(condition, ref ServicesDataTable); ServicescomboBox.DataSource = ServicesDataTable; ServicescomboBox.DisplayMember = HPS.BLL.ServicesBLL.BLLServices_T.Services_TField.ServicesType_nvc.ToString(); ServicescomboBox.ValueMember = HPS.BLL.ServicesBLL.BLLServices_T.Services_TField.ServicesID_int.ToString(); ServicescomboBox.SelectedIndex = -1; HPS.BLL.TrafficTypeBLL.BLLTrafficType_TFactory TrafficTypeFactory = new HPS.BLL.TrafficTypeBLL.BLLTrafficType_TFactory(); string TrafficTypeCondition = "[TrafficType_T].[TrafficTypeID_int]!=1 And [TrafficType_T].[TrafficTypeID_int]!=2"; DT.DataTable TrafficTypeDataTable = new DT.DataTable(); TrafficTypeFactory.GetAllByCondition(TrafficTypeCondition, ref TrafficTypeDataTable); TrafficTypeID_intComboBox.DataSource = TrafficTypeDataTable; TrafficTypeID_intComboBox.DisplayMember = HPS.BLL.TrafficTypeBLL.BLLTrafficType_T.TrafficType_TField.TrafficType_nvc.ToString(); TrafficTypeID_intComboBox.ValueMember = HPS.BLL.TrafficTypeBLL.BLLTrafficType_T.TrafficType_TField.TrafficTypeID_int.ToString(); TrafficTypeID_intComboBox.SelectedIndex = 0; HPS.BLL.TrafficBLL.BLLTraffic_TFactory Factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate); } catch (Exception ex) { throw ex; } }