private void btn_get30DaysBefore_Click(object sender, EventArgs e) { if (Functions.IsNull(this.date_get30DaysBefore.Text)) { MessageBox.Show("تاریخی انتخاب نشده است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { DateTime date = Functions.solarToMiladi(this.date_get30DaysBefore.Text); } catch (Exception ex) { MessageBox.Show("خطا در تاریخ انتخاب شده", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } List <long?> lstWagonNo = new List <long?>(); using (var entityLogistic = new Model.logisticEntities()) { if (!string.IsNullOrEmpty(this.txtbx_get30DaysBeforeWagonNo.Text)) { long wagonNo; if (!long.TryParse(this.txtbx_get30DaysBeforeWagonNo.Text, out wagonNo)) { MessageBox.Show("WagonNo is not an integer value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (wagonNo < 0) { MessageBox.Show("WagonNo should be a positive value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } lstWagonNo.Add(wagonNo); } else { lstWagonNo = entityLogistic.Wagons.Select(o => o.wagonNo).ToList(); } wagonInfoTrackingDetail trackingDetail = new wagonInfoTrackingDetail(); for (int i = 0; i <= lstWagonNo.Count - 1; i++) { trackingDetail.readAndSaveWagonToDB(lstWagonNo[i].Value, this.date_get30DaysBefore.Text, (int)this.numeric_cycleNumber.Value); } } }
private void btn_trackWagons_Click(object sender, EventArgs e) { long?wagonNoStart, wagonNoEnd; wagonNoStart = wagonNoEnd = null; long temp; if (!string.IsNullOrEmpty(this.txtbx_wagonNoStart.Text)) { if (!long.TryParse(this.txtbx_wagonNoStart.Text, out temp)) { MessageBox.Show("WagonNoStart is not an integer value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (temp < 0) { MessageBox.Show("WagonNoStart should be a positive value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } wagonNoStart = temp; } if (!string.IsNullOrEmpty(this.txtbx_wagonNoEnd.Text)) { if (!long.TryParse(this.txtbx_wagonNoEnd.Text, out temp)) { MessageBox.Show("WagonNoEnd is not an integer value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (temp < 0) { MessageBox.Show("WagonNoEnd should be a positive value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } wagonNoEnd = temp; } if (wagonNoStart.HasValue && wagonNoEnd.HasValue && wagonNoStart.Value >= wagonNoEnd.Value) { MessageBox.Show("WagonNoEnd should be greater than than WagonNoStart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } wagonInfoTrackingResult trackingResult = new wagonInfoTrackingResult(); using (var entityLogistic = new Model.logisticEntities()) { do { wagonNoStart = entityLogistic.Wagons.Where(o => !wagonNoStart.HasValue || o.wagonNo >= wagonNoStart.Value).Min(o => o.wagonNo); if (wagonNoStart.HasValue) { wagonNoEnd = entityLogistic.Wagons.Where(o => o.wagonNo <= wagonNoStart.Value + 50).Max(o => o.wagonNo); if (wagonNoEnd.HasValue) { trackingResult.readAndSaveWagonToDB(wagonNoStart.Value, wagonNoEnd.Value , int.Parse(this.numeric_cycleNumber.Value.ToString()), this.chkbx_trackWagons_get30DaysAgo.Checked); wagonNoStart = wagonNoEnd.Value + 1; } } } while (wagonNoStart.HasValue && wagonNoEnd.HasValue); } }
private void btn_history_Click(object sender, EventArgs e) { if (Functions.IsNull(this.date_history_fromDate.Text)) { MessageBox.Show("تاریخ شروع مشخص نشده است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DateTime fromDate, toDate; fromDate = DateTime.MinValue; toDate = DateTime.MaxValue; try { fromDate = Functions.solarToMiladi(this.date_history_fromDate.Text); } catch (Exception ex) { MessageBox.Show("خطا در تاریخ انتخاب شده شروع", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Functions.IsNull(this.date_history_toDate.Text)) { MessageBox.Show("تاریخ پایان مشخص نشده است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { toDate = Functions.solarToMiladi(this.date_history_toDate.Text); } catch (Exception ex) { MessageBox.Show("خطا در تاریخ انتخاب شده شروع", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (fromDate > toDate) { MessageBox.Show("تاریخ شروع باید قبل از تاریخ پایان باشد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } List <long?> lstWagonNo = new List <long?>(); using (var entityLogistic = new Model.logisticEntities()) { if (!string.IsNullOrEmpty(this.txtbx_history_wagonNo.Text)) { long wagonNo; if (!long.TryParse(this.txtbx_history_wagonNo.Text, out wagonNo)) { MessageBox.Show("WagonNo is not an integer value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (wagonNo < 0) { MessageBox.Show("WagonNo should be a positive value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } lstWagonNo.Add(wagonNo); } else { lstWagonNo = entityLogistic.Wagons.Select(o => o.wagonNo).ToList(); } wagonInfoSeirHistory trackingHistory = new wagonInfoSeirHistory(); for (int i = 0; i <= lstWagonNo.Count - 1; i++) { trackingHistory.readAndSaveWagonToDB(lstWagonNo[i].Value, this.date_history_fromDate.Text, this.date_history_toDate.Text, (int)this.numeric_cycleNumber.Value); } } }