private void txtExportTotalVehicles_Leave(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtExportTotalVehicles.Text)) return; var totalVehicles = Convert.ToInt32(txtExportTotalVehicles.Text); VehicleInfo vehicleInfo; for (int i = 0; i < totalVehicles - grdVehicle.Rows.Count; i++) { vehicleInfo = new VehicleInfo(); // Add to the list object _vehicleInfosTemp.Add(vehicleInfo); } // Bind to datagrid BindVehicle(_vehicleInfosTemp); } catch (Exception exception) { MessageBox.Show(exception.ToString()); } }
/// <summary> /// Insert vehicel /// </summary> /// <param name="vehicleInfo">VehicleInfo object</param> /// <returns>Number of rows are effectd</returns> public int Insert(VehicleInfo vehicleInfo) { // get hour and miniutes if (!string.IsNullOrEmpty(vehicleInfo.ImportHour) && vehicleInfo.ImportDate != null) { var importHour = Convert.ToInt32(vehicleInfo.ImportHour.Split(':')[0]); var importMinitues = Convert.ToInt32(vehicleInfo.ImportHour.Split(':')[1]); // add import our vehicleInfo.ImportDate = vehicleInfo.ImportDate.Value.AddHours(importHour - vehicleInfo.ImportDate.Value.Hour); // Add imort minutes vehicleInfo.ImportDate = vehicleInfo.ImportDate.Value.AddMinutes(importMinitues - vehicleInfo.ImportDate.Value.Minute); } if (!string.IsNullOrEmpty(vehicleInfo.ExportHour) && vehicleInfo.ExportDate != null) { var exporttHour = Convert.ToInt32(vehicleInfo.ExportHour.Split(':')[0]); var exporMinitues = Convert.ToInt32(vehicleInfo.ExportHour.Split(':')[1]); // Add export minitues vehicleInfo.ExportDate = vehicleInfo.ExportDate.Value.AddMinutes(exporMinitues - vehicleInfo.ExportDate.Value.Minute); // Add export hour vehicleInfo.ExportDate = vehicleInfo.ExportDate.Value.AddHours(exporttHour - vehicleInfo.ExportDate.Value.Hour); } if (vehicleInfo.ImportDate == null) { vehicleInfo.ImportDate = new DateTime(1900, 1, 1); } if (vehicleInfo.ExportDate == null) { vehicleInfo.ExportDate = new DateTime(1900, 1, 1); } if (_vehicleDAL.IsExistVehicleInDeclaration(vehicleInfo.PlateNumber, vehicleInfo.DeclarationID)) throw new Exception("Biển số phương tiện đã tồn tại trong tời khai này"); return _vehicleDAL.Insert(vehicleInfo); }
private void txtExportTotalVehicles_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue.Equals(13))// Enter key { try { if (string.IsNullOrEmpty(txtExportTotalVehicles.Text)) return; var totalVehicles = Convert.ToInt32(txtExportTotalVehicles.Text); if (_vehicleInfosTemp.Count > totalVehicles) throw new Exception("Bạn phải nhập số phương tiện lớn hơn số phương tiện hiện tại hoặc bạn phải xóa phương tiện đi"); VehicleInfo vehicleInfo; var bias = totalVehicles - _vehicleInfosTemp.Count; for (int i = 0; i < bias; i++) { vehicleInfo = new VehicleInfo(); // Add to the list object _vehicleInfosTemp.Add(vehicleInfo); } // Bind to datagrid BindVehicle(_vehicleInfosTemp); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void BindDataToControls(VehicleInfo vehicleInfo) { try { txtDriverName.Text = vehicleInfo.DriverName; txtPlateNumber.Text = vehicleInfo.PlateNumber; txtNumberOfContainer.Text = vehicleInfo.NumberOfContainer.ToString(); if (vehicleInfo.IsImport) { dtpImportDate.Value = (DateTime)vehicleInfo.ImportDate; dtpImportDate.Visible = true; mtxtImportHour.Text = vehicleInfo.ImportDate.Value.ToString("HH:mm"); mtxtImportHour.Visible = true; lblIsImport.Visible = false; } else { dtpImportDate.Visible = false; mtxtImportHour.Visible = false; lblIsImport.Visible = true; } if (vehicleInfo.IsExport) { dtpExportDate.Value = (DateTime)vehicleInfo.ExportDate; dtpExportDate.Visible = true; mtxtExportHour.Text = vehicleInfo.ExportDate.Value.ToString("HH:mm"); mtxtExportHour.Visible = true; lblIsExport.Visible = false; } else { dtpExportDate.Visible = false; mtxtExportHour.Visible = false; lblIsExport.Visible = true; } txtStatus.Text = vehicleInfo.Status; txtNote.Text = vehicleInfo.Note; _isImport = vehicleInfo.IsImport; _isExport = vehicleInfo.IsExport; if (vehicleInfo.ConfirmImportBy != 0 && vehicleInfo.ConfirmImportBy != _userInfo.UserID) btnConfirmImport.Enabled = false; if (vehicleInfo.ConfirmExportBy != 0 && vehicleInfo.ConfirmExportBy != _userInfo.UserID) btnConfirmExport.Enabled = false; } catch (Exception ex) { logger.Error(ex.ToString()); if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString()); } }
/// <summary> /// Update vehicle /// </summary> /// <param name="vehicleInfo">vehicleInfo object</param> /// <returns>Number of rows are effected</returns> public int Update(VehicleInfo vehicleInfo) { // get hour and miniutes if (!string.IsNullOrEmpty(vehicleInfo.ImportHour) && vehicleInfo.ImportDate != null && vehicleInfo.IsImport) { var importHour = Convert.ToInt32(vehicleInfo.ImportHour.Split(':')[0]); var importMinitues = Convert.ToInt32(vehicleInfo.ImportHour.Split(':')[1]); // add import our vehicleInfo.ImportDate = vehicleInfo.ImportDate.Value.AddHours(importHour - vehicleInfo.ImportDate.Value.Hour); // Add imort minutes vehicleInfo.ImportDate = vehicleInfo.ImportDate.Value.AddMinutes(importMinitues - vehicleInfo.ImportDate.Value.Minute); } if (!string.IsNullOrEmpty(vehicleInfo.ExportHour) && vehicleInfo.ExportDate != null && vehicleInfo.IsExport) { var exporttHour = Convert.ToInt32(vehicleInfo.ExportHour.Split(':')[0]); var exporMinitues = Convert.ToInt32(vehicleInfo.ExportHour.Split(':')[1]); // Add export minitues vehicleInfo.ExportDate = vehicleInfo.ExportDate.Value.AddMinutes(exporMinitues - vehicleInfo.ExportDate.Value.Minute); // Add export hour vehicleInfo.ExportDate = vehicleInfo.ExportDate.Value.AddHours(exporttHour - vehicleInfo.ExportDate.Value.Hour); } if (vehicleInfo.ImportDate == null || !vehicleInfo.IsImport) { vehicleInfo.ImportDate = new DateTime(1900, 1, 1); } if (vehicleInfo.ExportDate == null || !vehicleInfo.IsExport) { vehicleInfo.ExportDate = new DateTime(1900, 1, 1); } if (!vehicleInfo.IsGoodsImported) { vehicleInfo.ImportedLocalTime = new DateTime(1900, 1, 1); } return _vehicleDAL.Update(vehicleInfo); }
private void btnAdd_Click(object sender, EventArgs e) { // add new vehicle try { if (!Validate()) return; // Add data to veicleInfo list var vehicleInfo = new VehicleInfo(); vehicleInfo.DriverName = txtDriverName.Text.Trim(); vehicleInfo.PlateNumber = txtPlateNumber.Text.Trim(); if (txtNumberOfContainer.Text != "") { vehicleInfo.NumberOfContainer = Convert.ToInt32(txtNumberOfContainer.Text.Trim()); } if (_isExport) { vehicleInfo.ExportDate = dtpExportDate.Value; vehicleInfo.ExportHour = mtxtExportHour.Text; vehicleInfo.ConfirmExportBy = _userInfo.UserID; } if (_isImport) { vehicleInfo.ImportDate = dtpImportDate.Value; vehicleInfo.ImportHour = mtxtImportHour.Text; vehicleInfo.ConfirmImportBy = _userInfo.UserID; } vehicleInfo.Status = txtStatus.Text; vehicleInfo.Note = txtNote.Text; vehicleInfo.VehicleID = _vehicleInfosTemp.Count + 1; vehicleInfo.IsExport = _isExport; vehicleInfo.IsImport = _isImport; vehicleInfo.IsCompleted = _isCompleted; vehicleInfo.DeclarationID = _parrentDeclaration.DeclarationID; if (vehicleInfo.ExportDate != null && vehicleInfo.ExportDate.Value.Year.Equals(1900)) { vehicleInfo.ExportDate = null; } if (vehicleInfo.ImportDate != null && vehicleInfo.ImportDate.Value.Year.Equals(1900)) { vehicleInfo.ImportDate = null; } // Add Mode if (_mode == 0) { // Bind to gridview. _vehicleInfosTemp.Add(vehicleInfo); _newAddingVehicles.Add(vehicleInfo); _parrent.BindVehicle(_vehicleInfosTemp); } else { _vehicleBOL = new VehicleFactory(); // Insert into database // _vehicleBOL.Insert(vehicleInfo); _newAddingVehicles.Add(vehicleInfo); // Bind to gridview. // Get Vehicle by DeclarationID var listVehicle = _vehicleBOL.SelectByDeclarationID(vehicleInfo.DeclarationID); _parrent.BindVehicle(listVehicle); } grdVehicle.DataSource = null; grdVehicle.DataSource = _newAddingVehicles; //Set curent cell for poiter to bottom this.grdVehicle.CurrentCell = this.grdVehicle[0, this.grdVehicle.Rows.Count - 1]; // MessageBox.Show(ConstantInfo.MESSAGE_INSERT_SUCESSFULLY); ResetForm(); } catch (Exception ex) { logger.Error(ex.ToString()); if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString()); } }
/// <summary> /// Handles the KeyPress event of the txtPlateNumber control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.Windows.Forms.KeyPressEventArgs"/> instance containing the event data.</param> private void txtPlateNumber_KeyPress(object sender, KeyPressEventArgs e) { try { if ((_mode == 0 || _mode == 4) && e.KeyChar == 13) { if (!Validate()) return; // Add data to veicleInfo list var vehicleInfo = new VehicleInfo(); vehicleInfo.DriverName = txtDriverName.Text.Trim(); vehicleInfo.PlateNumber = txtPlateNumber.Text.Trim(); if (txtNumberOfContainer.Text != "") { vehicleInfo.NumberOfContainer = Convert.ToInt32(txtNumberOfContainer.Text.Trim()); } if (_isExport) { vehicleInfo.ExportDate = dtpExportDate.Value; vehicleInfo.ExportHour = mtxtExportHour.Text; } if (_isImport) { vehicleInfo.ImportDate = dtpImportDate.Value; vehicleInfo.ImportHour = mtxtImportHour.Text; } vehicleInfo.Status = txtStatus.Text; vehicleInfo.Note = txtNote.Text; vehicleInfo.VehicleID = _vehicleInfosTemp.Count + 1; vehicleInfo.IsExport = _isExport; vehicleInfo.IsImport = _isImport; vehicleInfo.IsCompleted = _isCompleted; vehicleInfo.DeclarationID = _parrentDeclaration.DeclarationID; if (vehicleInfo.ExportDate != null && vehicleInfo.ExportDate.Value.Year.Equals(1900)) { vehicleInfo.ExportDate = null; } if (vehicleInfo.ImportDate != null && vehicleInfo.ImportDate.Value.Year.Equals(1900)) { vehicleInfo.ImportDate = null; } _vehicleInfosTemp.Add(vehicleInfo); _newAddingVehicles.Add(vehicleInfo); ResetForm(); grdVehicle.DataSource = null; grdVehicle.DataSource = _newAddingVehicles; grdVehicle.Refresh(); //Set curent cell for poiter to bottom this.grdVehicle.CurrentCell = this.grdVehicle[0, this.grdVehicle.Rows.Count - 1]; _parrent.BindVehicle(_vehicleInfosTemp); txtPlateNumber.Focus(); } } catch (Exception ex) { logger.Error(ex.ToString()); if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString()); } }
public List<VehicleInfo> GetExportingVehicles(int mode, int declarationID, string search) { var result = new List<VehicleInfo>(); VehicleInfo vehicleInfo; try { //var sqlCommand = // "SELECT TOP(1) * FROM tblVehicle AS a WHERE a.PlateNumber='" + search + "' AND a.IsExport = 1 AND a.IsImport = 0 AND a.PlateNumber NOT IN ( SELECT a.PlateNumber FROM dbo.tblVehicle AS a WHERE a.DeclarationID = " + declarationID + " ) ORDER BY a.ExportDate DESC"; var sqlCommand = string.Empty; if (mode == 1) sqlCommand = "SELECT * FROM tblVehicle AS a WHERE a.PlateNumber LIKE '%" + search + "%' AND a.IsExport = 1 AND a.IsImport = 0 AND a.PlateNumber NOT IN ( SELECT a.PlateNumber FROM dbo.tblVehicle AS a WHERE a.DeclarationID = " + declarationID + " ) ORDER BY a.ExportDate DESC"; else if(mode==2) sqlCommand = "SELECT * FROM tblVehicle AS a WHERE a.PlateNumber LIKE '%" + search + "%' AND a.IsExport = 1 AND a.IsImport = 1 AND IsGoodsImported = 0 AND HasGoodsImported = 1 AND a.PlateNumber NOT IN ( SELECT a.PlateNumber FROM dbo.tblVehicle AS a WHERE a.DeclarationID = " + declarationID + " ) ORDER BY a.ExportDate DESC"; //var sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND IsImport=0 AND PlateNumber = '" + search + "' AND NOT DeclarationID =" + declarationID; //var sqlCommand = string.Empty; //if (search.Equals("")) //{ // if (mode == 1) // sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND IsImport=0 AND NOT DeclarationID =" + declarationID; // else if (mode == 2) // sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND IsImport=1 AND ImportStatus ='Nhập cảnh có hàng' AND NOT DeclarationID =" + declarationID; // else if (mode == 3) //Vehicle is exported // sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND NOT DeclarationID =" + declarationID; //} //else //{ // if (mode == 1) // sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND IsImport=0 AND PlateNumber like '%" + search + "%' AND NOT DeclarationID =" + declarationID; // else if (mode == 2) // sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND IsImport=1 AND ImportStatus ='Nhập cảnh có hàng' AND PlateNumber like '%" + search + "%' AND NOT DeclarationID =" + declarationID; // else if (mode == 3) //Vehicle is exported // sqlCommand = "SELECT * FROM tblVehicle WHERE IsExport=1 AND PlateNumber like '%" + search + "%' AND NOT DeclarationID =" + declarationID; //} var dataTable = _dbConnection.ExecuteSelectCommandText(sqlCommand); foreach (DataRow dr in dataTable.Rows) { vehicleInfo = new VehicleInfo(); vehicleInfo.CreateFrom(dr); result.Add(vehicleInfo); } return result; } catch (Exception ex) { throw; } }
/// <summary> /// Update vehicle /// </summary> /// <param name="vehicleInfo">vehicleInfo object</param> /// <returns>Number of rows are effected</returns> public int Update(VehicleInfo vehicleInfo) { try { var parameters = new SqlParameter[19]; parameters[0] = new SqlParameter("@VehicleID", vehicleInfo.VehicleID); parameters[1] = new SqlParameter("@PlateNumber", vehicleInfo.PlateNumber); parameters[2] = new SqlParameter("@NumberOfContainer", vehicleInfo.NumberOfContainer); parameters[3] = new SqlParameter("@DriverName", vehicleInfo.DriverName); parameters[4] = new SqlParameter("@ImportDate", vehicleInfo.ImportDate); parameters[5] = new SqlParameter("@ExportDate", vehicleInfo.ExportDate); parameters[6] = new SqlParameter("@Status", vehicleInfo.Status); parameters[7] = new SqlParameter("@Note", vehicleInfo.Note); parameters[8] = new SqlParameter("@IsExport", Convert.ToInt32(vehicleInfo.IsExport)); parameters[9] = new SqlParameter("@IsImport", Convert.ToInt32(vehicleInfo.IsImport)); parameters[10] = new SqlParameter("@IsCompleted", Convert.ToInt32(vehicleInfo.IsCompleted)); parameters[11] = new SqlParameter("@ImportedLocalTime", Convert.ToDateTime(vehicleInfo.ImportedLocalTime)); parameters[12] = new SqlParameter("@ImportStatus", vehicleInfo.ImportStatus); parameters[13] = new SqlParameter("@HasGoodsImported", Convert.ToInt32(vehicleInfo.HasGoodsImported)); parameters[14] = new SqlParameter("@IsGoodsImported", Convert.ToInt32(vehicleInfo.IsGoodsImported)); parameters[15] = new SqlParameter("@DeclarationID", Convert.ToInt32(vehicleInfo.DeclarationID)); // Phuong add parameters[16] = new SqlParameter("@ConfirmImportBy", Convert.ToInt32(vehicleInfo.ConfirmImportBy)); parameters[17] = new SqlParameter("@ConfirmExportBy", Convert.ToInt32(vehicleInfo.ConfirmExportBy)); parameters[18] = new SqlParameter("@ConfirmLocalImportBy", Convert.ToInt32(vehicleInfo.ConfirmLocalImportBy)); return _dbConnection.ExecuteNonQuery(ConstantInfo.SP_UPDATEVEHICLE, parameters); } catch (Exception ex) { throw ex; } }
/// <summary> /// Select Vehicle by VehicleID /// </summary> /// <param name="vehicleID"></param> /// <returns></returns> public VehicleInfo SelectByID(int vehicleID) { var vehicleInfo = new VehicleInfo(); try { var parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@VehicleID", vehicleID); var dataTable = _dbConnection.ExecuteSelectQuery(ConstantInfo.SP_SELECTVEHICLEBYID, parameters); if (dataTable.Rows.Count == 1) { vehicleInfo.CreateFrom(dataTable.Rows[0]); } return vehicleInfo; } catch (Exception ex) { throw ex; } }
/// <summary> /// Get Vehicle by DeclarationID /// </summary> /// <param name="declarationID">DeclarationID</param> /// <returns>List VehicleInfo objects</returns> public List<VehicleInfo> SelectByDeclarationID(int declarationID) { var result = new List<VehicleInfo>(); VehicleInfo vehicleInfo; try { var parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@DeclarationID", declarationID); var dataTable = _dbConnection.ExecuteSelectQuery(ConstantInfo.SP_SELECTVEHICLEBYDECLARATIONID, parameters); foreach (DataRow dr in dataTable.Rows) { vehicleInfo = new VehicleInfo(); vehicleInfo.CreateFrom(dr); result.Add(vehicleInfo); } return result; } catch (Exception) { throw; } }
private VehicleInfo GetVehicle() { var vehicleInfo = new VehicleInfo(); try { if (!Validate()) return null; // Add data to veicleInfo list vehicleInfo.DriverName = txtDriverName.Text.Trim(); vehicleInfo.PlateNumber = txtPlateNumber.Text.Trim(); if (txtNumberOfContainer.Text != "") { vehicleInfo.NumberOfContainer = Convert.ToInt32(txtNumberOfContainer.Text.Trim()); } if (cbConfirmExport.Checked) { vehicleInfo.ExportDate = dateTimePickerExport.Value; vehicleInfo.ExportHour = mtxtExportHour.Text; vehicleInfo.ConfirmExportBy = _userInfo.UserID; } if (cbConfirmImport.Checked) { vehicleInfo.ImportDate = dateTimePickerImport.Value; vehicleInfo.ImportHour = mtxtImportHour.Text; vehicleInfo.ConfirmImportBy = _userInfo.UserID; } vehicleInfo.Status = txtStatus.Text; vehicleInfo.Note = txtNote.Text; vehicleInfo.VehicleID = _vehicleInfosTemp.Count + 1; vehicleInfo.IsExport = cbConfirmExport.Checked; vehicleInfo.IsImport = cbConfirmImport.Checked; vehicleInfo.IsCompleted = false; //vehicleInfo.DeclarationID = _parrentDeclaration.DeclarationID; if (vehicleInfo.ExportDate != null && vehicleInfo.ExportDate.Value.Year.Equals(1900)) { vehicleInfo.ExportDate = null; } if (vehicleInfo.ImportDate != null && vehicleInfo.ImportDate.Value.Year.Equals(1900)) { vehicleInfo.ImportDate = null; } } catch (Exception ex) { logger.Error(ex.ToString()); if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString()); } return vehicleInfo; }