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;
}
