/// <summary>
/// Update Vehicle
/// </summary>
/// <param name="vehicle"></param>
/// <returns></returns>
public static int UpdateVehicle(tblVehicle vehicle )
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
// Get orgin vehicle
var vehicleOrgin = db.tblVehicles.Where(g => g.VehicleID == vehicle.VehicleID).FirstOrDefault();
db.Attach(vehicleOrgin);
db.ApplyPropertyChanges("tblVehicles", vehicle);
return db.SaveChanges();
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (!Validate()) return;
var declarationInfo = GetDeclarationInfo();
var listVehicleInfo = new List<tblVehicle>();
tblVehicle vehicleInfo;
// Validate Vehicle information
if (grdVehicle.Rows.Count > 0)
{
for (int i = 0; i < grdVehicle.Rows.Count; i++)
{
vehicleInfo = new tblVehicle();
if (grdVehicle.Rows[i].Cells["PlateNumber"].Value != null)
vehicleInfo.PlateNumber = grdVehicle.Rows[i].Cells["PlateNumber"].Value.ToString();
if (grdVehicle.Rows[i].Cells["NumberOfContainer"].Value != null)
vehicleInfo.NumberOfContainer = Convert.ToInt32(grdVehicle.Rows[i].Cells["NumberOfContainer"].Value);
if (grdVehicle.Rows[i].Cells["DriverName"].Value != null)
vehicleInfo.DriverName = grdVehicle.Rows[i].Cells["DriverName"].Value.ToString();
if (grdVehicle.Rows[i].Cells["IsExport"].Value != null)
vehicleInfo.IsExport = Convert.ToBoolean(grdVehicle.Rows[i].Cells["IsExport"].Value);
// Set Export Date
if (vehicleInfo.IsExport.Value) {
if (grdVehicle.Rows[i].Cells["ExportDate"].Value != null && grdVehicle.Rows[i].Cells["ExportHour"].Value != null)
{
var exportDate = Convert.ToDateTime(grdVehicle.Rows[i].Cells["ExportDate"].Value);
var exportHour = Convert.ToInt32(grdVehicle.Rows[i].Cells["ExportHour"].Value.ToString().Split(':')[0]);
var exportMinitues = Convert.ToInt32(grdVehicle.Rows[i].Cells["ExportHour"].Value.ToString().Split(':')[1]);
// Set export hour
vehicleInfo.ExportDate = exportDate.AddHours(exportHour - exportDate.Hour);
// Set Minitues
vehicleInfo.ExportDate = vehicleInfo.ExportDate.Value.AddMinutes(exportMinitues - vehicleInfo.ExportDate.Value.Minute);
}
}
if (grdVehicle.Rows[i].Cells["IsImport"].Value != null)
vehicleInfo.IsImport = Convert.ToBoolean(grdVehicle.Rows[i].Cells["IsImport"].Value);
// Set Import Date
if (vehicleInfo.IsImport.Value) {
if (grdVehicle.Rows[i].Cells["ImportDate"].Value != null && grdVehicle.Rows[i].Cells["ImportHour"].Value != null)
{
var importDate = Convert.ToDateTime(grdVehicle.Rows[i].Cells["ImportDate"].Value);
var importHour = Convert.ToInt32(grdVehicle.Rows[i].Cells["ImportHour"].Value.ToString().Split(':')[0]);
var importMinitues = Convert.ToInt32(grdVehicle.Rows[i].Cells["ImportHour"].Value.ToString().Split(':')[1]);
// Set import hour
vehicleInfo.ImportDate = importDate.AddHours(importHour - importDate.Hour);
// Set Minitues
vehicleInfo.ImportDate = vehicleInfo.ImportDate.Value.AddMinutes(importMinitues - vehicleInfo.ImportDate.Value.Minute);
}
}
if (grdVehicle.Rows[i].Cells["Note"].Value != null)
vehicleInfo.Note = grdVehicle.Rows[i].Cells["Note"].Value.ToString();
if (grdVehicle.Rows[i].Cells["Status"].Value != null)
vehicleInfo.Status = grdVehicle.Rows[i].Cells["Status"].Value.ToString();
// TODO: Có thể thiếu trường HasGoodExport
if (!string.IsNullOrEmpty(txtImportNumber.Text) && Convert.ToInt32(txtImportNumber.Text) > 0)
vehicleInfo.HasGoodsImported = true;
else
vehicleInfo.HasGoodsImported = false;
// Add to list vehicles
listVehicleInfo.Add(vehicleInfo);
} // End for
}
// TODO: Need to check return value
_declarationBOL.AddDeclaration(declarationInfo, listVehicleInfo, _userInfo.UserID);
MessageBox.Show(ConstantInfo.MESSAGE_INSERT_SUCESSFULLY);
switch (this._parent.Name.ToUpper())
{
case "FRMDECLERATION":
{
// close the form
this.Close();
// Bind data to the gridivew
((frmDecleration)_parent).BindData();
}
break;
case "FRMMAINFORM":
{
// Just close from if this form is opened from main from
this.Close();
}
break;
default:
break;
}
// Reset form
ResetForm();
}
catch (Exception ex)
{
logger.Error(ex.ToString());
}
}
private void btnUpdate_Click_1(object sender, EventArgs e)
{
try
{
if (_declerationID != 0)
{
var declerationInfo = GetDeclarationInfo();
// Set DeclerationID
declerationInfo.DeclarationID = this._declerationID;
// Update Decleration
DeclarationFactory.Update(declerationInfo);
foreach (var vehicle in this._vehicleInfosTemp)
{
//update declationId
var v = new tblVehicle();
v.VehicleID = vehicle.VehicleID;
v.PlateNumber = vehicle.PlateNumber;
v.NumberOfContainer = vehicle.NumberOfContainer;
v.DriverName = vehicle.DriverName;
v.ImportDate = vehicle.ImportDate;
v.IsImport = vehicle.IsImport;
v.ExportDate = vehicle.ExportDate;
v.IsExport = vehicle.IsExport;
v.Note = vehicle.Note;
v.Status = vehicle.Status;
v.IsCompleted = vehicle.IsCompleted;
v.IsGoodsImported = vehicle.IsGoodsImported;
v.ImportStatus = vehicle.ImportStatus;
v.ImportedLocalTime = vehicle.ImportedLocalTime;
v.HasGoodsImported = vehicle.HasGoodsImported;
v.ConfirmExportBy = vehicle.ConfirmExportBy;
v.ConfirmImportBy = vehicle.ConfirmImportBy;
v.ConfirmLocalImportBy = vehicle.ConfirmLocalImportBy;
v.ModifiedById = _userInfo.UserID;
VehicleFactory.UpdateVehicle(v);
}
MessageBox.Show("Cập nhật thành công");
}
}
catch (Exception ex)
{
logger.Error(ex.ToString());
if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
}
}
private void frmVehicle_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
if (_parrentDeclaration == null || _parrentDeclaration.DeclarationID == 0)
{
return;
}
// add to database when closing form
foreach (var vehicle in _newAddingVehicles)
{
var v = new tblVehicle();
v.VehicleID = vehicle.VehicleID;
v.PlateNumber = vehicle.PlateNumber;
v.NumberOfContainer = vehicle.NumberOfContainer;
v.DriverName = vehicle.DriverName;
v.ImportDate = vehicle.ImportDate;
v.IsImport = vehicle.IsImport;
v.ExportDate = vehicle.ExportDate;
v.IsExport = vehicle.IsExport;
v.Note = vehicle.Note;
v.Status = vehicle.Status;
v.IsCompleted = vehicle.IsCompleted;
v.IsGoodsImported = vehicle.IsGoodsImported;
v.ImportStatus = vehicle.ImportStatus;
v.ImportedLocalTime = vehicle.ImportedLocalTime;
v.HasGoodsImported = vehicle.HasGoodsImported;
v.ConfirmExportBy = vehicle.ConfirmExportBy;
v.ConfirmImportBy = vehicle.ConfirmImportBy;
v.ConfirmLocalImportBy = vehicle.ConfirmLocalImportBy;
v.CreatedById = _userInfo.UserID;
VehicleFactory.InsertVehicle(v,_parrentDeclaration.DeclarationID);
}
((FrmDecleExport)this.Owner).grdVehicle.DataSource = null;
var listVehicle = VehicleFactory.GetFromViewByDeclarationID(_parrentDeclaration.DeclarationID);
((FrmDecleExport)this.Owner).BindVehicle(listVehicle);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
}
}
//c ap nhat so lan in ticket cua vehicle
public static int UpdateTicketTotalPrint(tblVehicle vehicle)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
tblVehicle vehicleObj = db.tblVehicles.Where(g => g.VehicleID == vehicle.VehicleID).FirstOrDefault();
vehicleObj.HasGoodsImportedTocalPrint = vehicle.HasGoodsImportedTocalPrint;
vehicleObj.ParkingTotalPrint = vehicle.ParkingTotalPrint;
vehicleObj.HasGoodsImportedPrintOrderNumber = vehicle.HasGoodsImportedPrintOrderNumber;
vehicleObj.ParkingTotalPrintOrderNumber = vehicle.ParkingTotalPrintOrderNumber;
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int InsertVehicle(tblVehicle vehicle, long declarationID)
{
// Update created, last modified date by now
var now = CommonFactory.GetCurrentDate();
vehicle.CreatedDate = now;
vehicle.ModifiedDate = now;
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
db.tblDeclarations.Where(g => g.DeclarationID == declarationID).FirstOrDefault();
db.AddTotblVehicles(vehicle);
db.SaveChanges();
// Insert to tblVehicleDeclerate
var vehicleDeclere = new tblDeclarationVehicle();
vehicleDeclere.VehicleID = vehicle.VehicleID;
vehicleDeclere.DeclarationID = declarationID;
db.AddTotblDeclarationVehicles(vehicleDeclere);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int InsertVehicle(tblVehicle vehicle)
{
return InsertVehicle(vehicle, 0);
}
/// <summary>
/// Update Vehicle
/// </summary>
/// <param name="vehicle"></param>
/// <param name="declerationID"></param>
/// <returns></returns>
public static int UpdateVehicle(tblVehicle vehicle, long declerationID)
{
// Set last modified date to now
vehicle.ModifiedDate = CommonFactory.GetCurrentDate();
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
switch (declerationID)
{
case 0:
{
// Get orgin vehicle
var vehicleOrgin = db.tblVehicles.Where(g => g.VehicleID == vehicle.VehicleID).FirstOrDefault();
if (vehicleOrgin != null)
{
db.Attach(vehicleOrgin);
db.ApplyPropertyChanges("tblVehicles", vehicle);
if (vehicle.ListVehicleChangeGood != null)
{
//update tblVehicleChange
VehicleFactory.DeleteVehicleChangeByVehicleId(vehicle.VehicleID);
VehicleFactory.AddVehicleChangeByVehicleId(vehicle.VehicleID, vehicle.ListVehicleChangeGood.Select(x => x.VehicleId).ToList());
}
db.Connection.Close();
int re = db.SaveChanges();
return re;
}
return -1;
}
default:
{
var vehicleOrgin = db.tblVehicles.Where(g => g.VehicleID == vehicle.VehicleID).FirstOrDefault();
db.Attach(vehicleOrgin);
db.ApplyPropertyChanges("tblVehicles", vehicle);
//db.SaveChanges();
// Insert to tblVehicleDeclerateion
var vehicleDeclara = new tblDeclarationVehicle();
vehicleDeclara.VehicleID = vehicle.VehicleID;
vehicleDeclara.DeclarationID = declerationID;
db.AddTotblDeclarationVehicles(vehicleDeclara);
int re = db.SaveChanges();
db.Connection.Close();
db.Dispose();
return re;
}
}
}
public static int UpdateVehicle(tblVehicle vehicle)
{
return UpdateVehicle(vehicle, 0);
}
private void btnSaveAll_Click(object sender, EventArgs e)
{
try
{
if (VehicleInfosTemp.Count == 0)
throw new Exception("Phương tiện không được để trống");
foreach (var info in VehicleInfosTemp)
{
var vehicleInfo = new tblVehicle();
vehicleInfo.DriverName = info.DriverName;
vehicleInfo.PlateNumber = info.PlateNumber;
vehicleInfo.NumberOfContainer = info.NumberOfContainer;
vehicleInfo.ExportDate = info.ExportDate;
vehicleInfo.ConfirmExportBy = info.ConfirmExportBy;
vehicleInfo.ImportDate = info.ImportDate;
vehicleInfo.ConfirmImportBy = info.ConfirmImportBy;
vehicleInfo.Status = info.Status;
vehicleInfo.Note = info.Note;
vehicleInfo.VehicleID = info.VehicleID;
vehicleInfo.IsExport = info.IsExport;
vehicleInfo.IsImport = info.IsImport;
vehicleInfo.IsCompleted = info.IsCompleted;
vehicleInfo.vehicleTypeId = info.vehicleTypeId;
vehicleInfo.ExportGoodTypeId = info.ExportGoodTypeId;
vehicleInfo.ImportGoodTypeId = info.ImportGoodTypeId;
vehicleInfo.IsExportParking = info.IsExportParking;
vehicleInfo.ExportParkingDate = info.ExportParkingDate;
vehicleInfo.ConfirmExportParkingBy = info.ConfirmExportParkingBy;
vehicleInfo.CreatedById = _userInfo.UserID;
VehicleFactory.InsertVehicle(vehicleInfo);
}
MessageBox.Show(ConstantInfo.MESSAGE_INSERT_SUCESSFULLY);
// Reset form
ResetForm(true);
this.Close();
}
catch (Exception ex)
{
logger.Error(ex.ToString());
if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
}
}
private void GetInfoVehicleDialog(StringBuilder message, tblVehicle vehicleInfo, int type)
{
//Loại trọng tải
var vehicleType = string.Empty;
if (vehicleInfo.vehicleTypeId == null)
{
vehicleType = "Chưa xác định";
}
else
{
var vehicleTypeInfo = VehicleTypeFactory.FindById((int)vehicleInfo.vehicleTypeId);
if (vehicleTypeInfo != null)
{
vehicleType = vehicleTypeInfo.Capacity;
}
}
message.AppendLine("Loại trọng tải: " + vehicleType);
//Tình trạng thu phí, type = 0 : XN xuất khẩu, type = 1: XN nhập khẩu
if (type == 0)
{
message.AppendLine("Tình trạng thu phí xuất: " + GetFeeStatus(vehicleInfo.feeExportStatus));
}
else
{
message.AppendLine("Tình trạng thu phí nhập: " + GetFeeStatus(vehicleInfo.feeImportStatus));
}
//Loại hàng
var goodTypeId = type == 0 ? vehicleInfo.ExportGoodTypeId : vehicleInfo.ImportGoodTypeId;
var goodType = goodTypeId == null ? "Chưa xác định" : GoodTypeFactory.GetTypeNameById((int)goodTypeId);
message.AppendLine("Loại hàng: " + goodType);
}
private void printTicket(int printType, tblVehicle vehicleInfo)
{
//print khi xuat canh
//print ticket report
List<viewDeclarationVehicle> listViewDeclarationVehicle = VehicleFactory.GetImportDeclarationVehicleByVehicleID(vehicleInfo.VehicleID);
vehicleTicket = new ECustoms.vehicleTicket();
((TextObject)vehicleTicket.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper();
var txtPrintUser = (TextObject)vehicleTicket.Section1.ReportObjects["txtPrintUser"];
var txtPrintType = (TextObject)vehicleTicket.Section1.ReportObjects["txtPrintType"];
var txtVehicleNumber = (TextObject)vehicleTicket.Section1.ReportObjects["txtVehicleNumber"];
var txtVehicleType = (TextObject)vehicleTicket.Section1.ReportObjects["txtVehicleType"];
var txtExportDate = (TextObject)vehicleTicket.Section1.ReportObjects["txtExportDate"];
var txtImportDate = (TextObject)vehicleTicket.Section1.ReportObjects["txtImportDate"];
var txtParkingDate = (TextObject)vehicleTicket.Section1.ReportObjects["txtParkingDate"];
var txtDecleNumber = (TextObject)vehicleTicket.Section1.ReportObjects["txtDecleNumber"];
var txtType = (TextObject)vehicleTicket.Section1.ReportObjects["txtType"];
var txtRegisterDate = (TextObject)vehicleTicket.Section1.ReportObjects["txtRegisterDate"];
var txtCompany = (TextObject)vehicleTicket.Section1.ReportObjects["txtCompany"];
var txtGoodName = (TextObject)vehicleTicket.Section1.ReportObjects["txtGoodName"];
var txtAmount = (TextObject)vehicleTicket.Section1.ReportObjects["txtAmount"];
var txtUnit = (TextObject)vehicleTicket.Section1.ReportObjects["txtUnit"];
var txtBarcode = (TextObject)vehicleTicket.Section1.ReportObjects["txtBarcode"];
var txtSTT = (TextObject)vehicleTicket.Section1.ReportObjects["txtSTT"];
var txtTotalPrintVehicleTicketOfDay = (TextObject)vehicleTicket.Section1.ReportObjects["txtTotalPrintVehicleTicketOfDay"];
var txtPrintDate = (TextObject)vehicleTicket.Section1.ReportObjects["txtPrintDate"];
txtVehicleNumber.Text = vehicleInfo.PlateNumber;
if (vehicleInfo.vehicleTypeId != null && vehicleInfo.vehicleTypeId > 0)
{
tblVehicleType vehicleType = VehicleTypeFactory.FindById(vehicleInfo.vehicleTypeId.GetValueOrDefault());
if (vehicleType != null)
{
txtVehicleType.Text = vehicleType.Name;
}
else
{
txtVehicleType.Text = "Không phân loại";
}
}
else
{
txtVehicleType.Text = "Không phân loại";
}
if (vehicleInfo.ExportDate != null)
{
txtExportDate.Text = ((DateTime)vehicleInfo.ExportDate).ToString("dd/MM/yyyy HH:mm");
}
if (vehicleInfo.ImportDate != null)
{
txtImportDate.Text = ((DateTime)vehicleInfo.ImportDate).ToString("dd/MM/yyyy HH:mm");
}
if (vehicleInfo.ParkingDate != null)
{
txtParkingDate.Text = ((DateTime)vehicleInfo.ParkingDate).ToString("dd/MM/yyyy HH:mm");
}
//string listDeclarationNumber = "";
//foreach (viewDeclarationVehicle view in listViewDeclarationVehicle)
//{
// listDeclarationNumber += view.Number + "; ";
//}
//if (string.IsNullOrEmpty(listDeclarationNumber) == false)
//{
// listDeclarationNumber.Remove(listDeclarationNumber.Length - 2, 1);
// txtDecleNumber.Text = listDeclarationNumber;
//}
viewDeclarationVehicle viewVehicle = listViewDeclarationVehicle.FirstOrDefault();
if (viewVehicle != null)
{
txtDecleNumber.Text = viewVehicle.Number + "";
txtType.Text = viewVehicle.Type;
if (viewVehicle.RegisterDate != null)
{
txtRegisterDate.Text = ((DateTime)viewVehicle.RegisterDate).ToString("dd/MM/yyyy HH:mm");
}
txtCompany.Text = viewVehicle.CompanyName;
txtGoodName.Text = viewVehicle.ProductName;
txtAmount.Text = viewVehicle.ProductAmount;
txtUnit.Text = viewVehicle.Unit;
}
txtPrintUser.Text = _userInfo.Name;
switch (printType)
{
case 1:
txtPrintType.Text = "Xuất cảnh";
break;
case 2:
txtPrintType.Text = "Nhập cảnh";
if (vehicleInfo.HasGoodsImportedTocalPrint != null)
{
//tang so lan in
vehicleInfo.HasGoodsImportedTocalPrint = vehicleInfo.HasGoodsImportedTocalPrint + 1;
}
else
{
//in lan dau tien
vehicleInfo.HasGoodsImportedTocalPrint = 1;
//update tong so lan print ticket trong 1 ngay
long orderNumber = updateTotalTicketPrint();
//cap nhat so tu thu in cua xe
vehicleInfo.HasGoodsImportedPrintOrderNumber = orderNumber;
}
txtSTT.Text = vehicleInfo.HasGoodsImportedTocalPrint.ToString();
txtTotalPrintVehicleTicketOfDay.Text = vehicleInfo.HasGoodsImportedPrintOrderNumber.GetValueOrDefault().ToString();
break;
case 3:
txtPrintType.Text = "Xác nhận hàng vào bãi";
if (vehicleInfo.ParkingTotalPrint != null)
{
//tang so lan in
vehicleInfo.ParkingTotalPrint = vehicleInfo.ParkingTotalPrint + 1;
}
else
{
//in lan dau tien
vehicleInfo.ParkingTotalPrint = 1;
//update tong so lan print ticket trong 1 ngay
long orderNumber = updateTotalTicketPrint();
//cap nhat so tu thu in cua xe
vehicleInfo.ParkingTotalPrintOrderNumber = orderNumber;
}
txtSTT.Text = vehicleInfo.ParkingTotalPrint.ToString();
txtTotalPrintVehicleTicketOfDay.Text = vehicleInfo.ParkingTotalPrintOrderNumber.GetValueOrDefault().ToString();
break;
}
//txtBarcode.Text = "*" + vehicleInfo.PlateNumber + "*";
//String PlateNumberKey = Utilities.EnCryptDecrypt.Encrypt(vehicleInfo.PlateNumber, true);
txtBarcode.Text = "*" + vehicleInfo.PlateNumber + "*";
DateTime currentDate = CommonFactory.GetCurrentDate();
//cap nhat so lan in ticket cua phuong tien vao CSDL
VehicleFactory.UpdateTicketTotalPrint(vehicleInfo);
txtPrintDate.Text = currentDate.ToString("dd/MM/yyyy HH:mm");
//preview ticket
//var report = new FrmCrystalReport(vehicleTicket, _userInfo);
//report.MaximizeBox = true;
//report.Show(this);
//Print ticket directly
vehicleTicket.ExportToDisk(ExportFormatType.CrystalReport, "VehicleTicket.rpt");
foreach (String printerName in _printSetting.ListPrinter)
{
if (Utilities.PrinterChecking.IsValid(printerName))
{
try
{
AutoPrintReport(printerName, "VehicleTicket.rpt");
}
catch (Exception ex)
{
MessageBox.Show("Không kết nối được với máy in: " + printerName);
}
}
else
{
MessageBox.Show("Không kết nối được với máy in: " + printerName);
}
}
return;
}
private tblVehicle GetVehicle()
{
var vehicleInfo = new tblVehicle();
try
{
if (!Validate())
return null;
// Add data to veicleInfo list
vehicleInfo.DriverName = txtDriverName.Text.Trim();
vehicleInfo.vehicleTypeId = Int32.Parse(cbVehicleType.SelectedValue.ToString());
vehicleInfo.ImportGoodTypeId = Int32.Parse(cbGoodType.SelectedValue.ToString());
vehicleInfo.PlateNumber = txtPlateNumber.Text = StringUtil.RemoveAllNonAlphanumericString(txtPlateNumber.Text).ToUpper();
vehicleInfo.IsChineseVehicle = true;
if (txtNumberOfContainer.Text != "")
{
vehicleInfo.NumberOfContainer = txtNumberOfContainer.Text.Trim();
}
if (cbConfirmExport.Checked)
{
vehicleInfo.ExportDate = dateTimePickerExport.Value;
vehicleInfo.ConfirmExportBy = _userInfo.UserID;
}
if (cbConfirmImport.Checked)
{
vehicleInfo.ImportDate = dateTimePickerImport.Value;
vehicleInfo.ConfirmImportBy = _userInfo.UserID;
if (rbHasGoods.Checked)
{
vehicleInfo.HasGoodsImported = true;
vehicleInfo.ImportStatus = "Nhập cảnh có hàng";
}
else
{
vehicleInfo.HasGoodsImported = false;
vehicleInfo.ImportStatus = "Nhập cảnh không có hàng";
vehicleInfo.IsExportParking = true;
}
}
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;
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (!Validate()) return;
var declaratioInfo = new tblDeclaration();
var declarationInfo = GetDeclarationInfo(ref declaratioInfo);
var listVehicleInfo = new List<tblVehicle>();
var listVehicleUpdate = new List<tblVehicle>();
tblVehicle vehicleInfo;
// Validate Vehicle information
if (grdVehicle.Rows.Count > 0)
{
List<tblVehicleFeeSetting> listFee = null;
if (_statusFee == 1)
{
listFee = VehicleFeeSettingFactory.getAllVehicleFeeSetting();
}
for (int i = 0; i < grdVehicle.Rows.Count; i++)
{
if (grdVehicle.Rows[i].Cells["VehicleID"].Value != null && Convert.ToInt64(grdVehicle.Rows[i].Cells["VehicleID"].Value) > 0) // Update this vehicle only.
{
// Get vehcleInfor from database
vehicleInfo = VehicleFactory.GetByID(Convert.ToInt64(grdVehicle.Rows[i].Cells["VehicleID"].Value));
}
else
{
vehicleInfo = new tblVehicle();
}
// Do not save the record that platNumber is empty
if (grdVehicle.Rows[i].Cells["PlateNumber"].Value != null && grdVehicle.Rows[i].Cells["PlateNumber"].Value != "")
{
vehicleInfo.PlateNumber = grdVehicle.Rows[i].Cells["PlateNumber"].Value.ToString();
}
else // Don't insert the record that the platnumber is null
{
continue;
}
if (grdVehicle.Rows[i].Cells["NumberOfContainer"].Value != null)
vehicleInfo.NumberOfContainer = grdVehicle.Rows[i].Cells["NumberOfContainer"].Value.ToString();
if (grdVehicle.Rows[i].Cells["VehicleType"].Value != null)
{
vehicleInfo.vehicleTypeId = Int32.Parse(grdVehicle.Rows[i].Cells["VehicleType"].Value.ToString());
}
if (grdVehicle.Rows[i].Cells["ExportGoodType"].Value != null)
{
vehicleInfo.ExportGoodTypeId = Int32.Parse(grdVehicle.Rows[i].Cells["ExportGoodType"].Value.ToString());
}
if (grdVehicle.Rows[i].Cells["ImportGoodType"].Value != null)
{
vehicleInfo.ImportGoodTypeId = Int32.Parse(grdVehicle.Rows[i].Cells["ImportGoodType"].Value.ToString());
}
if (grdVehicle.Rows[i].Cells["DriverName"].Value != null)
vehicleInfo.DriverName = grdVehicle.Rows[i].Cells["DriverName"].Value.ToString();
if (grdVehicle.Rows[i].Cells["IsExport"].Value != null)
vehicleInfo.IsExport = Convert.ToBoolean(grdVehicle.Rows[i].Cells["IsExport"].Value);
// Set Export Date
if (vehicleInfo.IsExport != null && vehicleInfo.IsExport.Value && grdVehicle.Rows[i].Cells["ExportDate"].Value != null)
{
vehicleInfo.ExportDate = Convert.ToDateTime(grdVehicle.Rows[i].Cells["ExportDate"].Value);
}
if (grdVehicle.Rows[i].Cells["IsImport"].Value != null)
vehicleInfo.IsImport = Convert.ToBoolean(grdVehicle.Rows[i].Cells["IsImport"].Value);
// Set Import Date
if (vehicleInfo.IsImport != null && vehicleInfo.IsImport.Value && grdVehicle.Rows[i].Cells["ImportDate"].Value != null)
{
vehicleInfo.ImportDate = Convert.ToDateTime(grdVehicle.Rows[i].Cells["ImportDate"].Value);
if (grdVehicle.Rows[i].Cells["ImportStatus"].Value != null) vehicleInfo.ImportStatus = grdVehicle.Rows[i].Cells["ImportStatus"].Value.ToString();
if (grdVehicle.Rows[i].Cells["HasGoodsImported"].Value != null) vehicleInfo.HasGoodsImported = bool.Parse(grdVehicle.Rows[i].Cells["HasGoodsImported"].Value.ToString());
}
if (grdVehicle.Rows[i].Cells["Note"].Value != null)
vehicleInfo.Note = grdVehicle.Rows[i].Cells["Note"].Value.ToString();
if (grdVehicle.Rows[i].Cells["Status"].Value != null)
vehicleInfo.Status = grdVehicle.Rows[i].Cells["Status"].Value.ToString();
//Set Fee
if (_statusFee == 1)
{
var currentDate = CommonFactory.GetCurrentDate();
if (_declerationType.Equals(Common.DeclerationType.Export))
{
vehicleInfo.ExportReceiptNumber = "9999";
var feeSetting = listFee.Where(f =>f.VehicleTypeId == vehicleInfo.vehicleTypeId && f.GoodsTypeId == vehicleInfo.ExportGoodTypeId).FirstOrDefault();
var amount = feeSetting != null ? (feeSetting.Fee ?? 0) : 0;
vehicleInfo.feeExportAmount = amount;
vehicleInfo.feeExportDate = currentDate;
vehicleInfo.feeExportStatus = (int)FeeStatus.PaidFee;
vehicleInfo.confirmFeeExportBy = _userInfo.UserID;
}
else
{
vehicleInfo.ImportReceiptNumber = "9999";
var feeSetting = listFee.Where(f => f.VehicleTypeId == vehicleInfo.vehicleTypeId && f.GoodsTypeId == vehicleInfo.ImportGoodTypeId).FirstOrDefault();
var amount = feeSetting != null ? (feeSetting.Fee ?? 0) : 0;
vehicleInfo.feeImportAmount = amount;
vehicleInfo.feeImportDate = currentDate;
vehicleInfo.feeImportStatus = (int)FeeStatus.PaidFee;
vehicleInfo.confirmFeeImportBy = _userInfo.UserID;
}
}
else
{
var currentDate = CommonFactory.GetCurrentDate();
if (_declerationType.Equals(Common.DeclerationType.Export))
{
if ((grdVehicle.Rows[i].Cells["ExportReceiptNumber"].Value == null) || string.IsNullOrEmpty(grdVehicle.Rows[i].Cells["ExportReceiptNumber"].Value.ToString().Trim()) || (grdVehicle.Rows[i].Cells["feeExportAmount"].Value == null))
{
if (vehicleInfo.feeExportStatus == (int)FeeStatus.PaidFee)
{
vehicleInfo.ExportReceiptNumber = null;
vehicleInfo.feeExportAmount = null;
vehicleInfo.feeExportDate = null;
vehicleInfo.feeExportStatus = (int)FeeStatus.HasNotPayFee;
vehicleInfo.confirmFeeExportBy = _userInfo.UserID;
}
}
else
{
vehicleInfo.ExportReceiptNumber = grdVehicle.Rows[i].Cells["ExportReceiptNumber"].Value.ToString().Trim();
vehicleInfo.feeExportAmount = Convert.ToInt64(grdVehicle.Rows[i].Cells["feeExportAmount"].Value);
vehicleInfo.feeExportDate = currentDate;
vehicleInfo.feeExportStatus = (int)FeeStatus.PaidFee;
vehicleInfo.confirmFeeExportBy = _userInfo.UserID;
}
}
else
{
if ((grdVehicle.Rows[i].Cells["ImportReceiptNumber"].Value == null) || string.IsNullOrEmpty(grdVehicle.Rows[i].Cells["ImportReceiptNumber"].Value.ToString().Trim()) || (grdVehicle.Rows[i].Cells["feeImportAmount"].Value == null))
{
if (vehicleInfo.feeImportStatus == (int)FeeStatus.PaidFee)
{
vehicleInfo.ImportReceiptNumber = null;
vehicleInfo.feeImportAmount = null;
vehicleInfo.feeImportDate = null;
vehicleInfo.feeImportStatus = (int)FeeStatus.HasNotPayFee;
vehicleInfo.confirmFeeExportBy = _userInfo.UserID;
}
}
else
{
vehicleInfo.ImportReceiptNumber = grdVehicle.Rows[i].Cells["ImportReceiptNumber"].Value.ToString().Trim();
vehicleInfo.feeImportAmount = Convert.ToInt64(grdVehicle.Rows[i].Cells["feeImportAmount"].Value);
vehicleInfo.feeImportDate = currentDate;
vehicleInfo.feeImportStatus = (int)FeeStatus.PaidFee;
vehicleInfo.confirmFeeImportBy = _userInfo.UserID;
}
}
}
var vehicleRow = (ViewAllVehicleHasGood) grdVehicle.Rows[i].DataBoundItem;
if (vehicleRow.StatusChangeGood != null)
{
vehicleInfo.StatusChangeGood = vehicleRow.StatusChangeGood;
vehicleInfo.ListVehicleChangeGood = vehicleRow.ListVehicleChangeGood ?? VehicleFactory.GetListVehicleChangeById(vehicleRow.VehicleID);
}
if (grdVehicle.Rows[i].Cells["VehicleID"].Value != null && Convert.ToInt64(grdVehicle.Rows[i].Cells["VehicleID"].Value) > 0) // Update this vehicle only.
{
listVehicleUpdate.Add(vehicleInfo);
continue;
}
// If this vehicle is set import/export, set the confirmImport by /confirmExpor by
if (vehicleInfo.IsExport != null && vehicleInfo.IsExport.Value)
{
vehicleInfo.ConfirmExportBy = _userInfo.UserID;
}
if (vehicleInfo.IsImport != null && vehicleInfo.IsImport.Value)
{
vehicleInfo.ConfirmImportBy = _userInfo.UserID;
}
// Add to list vehicles
listVehicleInfo.Add(vehicleInfo);
} // End for
}
//cap nhat So tiep nhap tai khai Xuat chuyen khai trong nam
//cap nhat khi la xuat khau chuyen cua khau
if (declarationInfo.DeclarationType == (short)Common.DeclerationType.Export && declarationInfo.TypeOption==1)
{
long receiveNumber = ApplicationObjectFactory.updateTotalReceiveNumber();
declarationInfo.ReceiveNumberInYear = receiveNumber;
}
// TODO: Need to check return value
DeclarationFactory.AddDeclaration(declarationInfo, listVehicleInfo, listVehicleUpdate, _userInfo.UserID);
//MessageBox.Show(ConstantInfo.MESSAGE_INSERT_SUCESSFULLY);
if (declarationInfo.DeclarationType == (short)Common.DeclerationType.Export && declarationInfo.TypeOption == 1)
{
FrmReceiveNumber frmReceiveNumber = new FrmReceiveNumber(declarationInfo.ReceiveNumberInYear.GetValueOrDefault());
frmReceiveNumber.MdiParent = this.MdiParent;
frmReceiveNumber.Show(this);
}
switch (this.Owner.Name.ToUpper())
{
case "FRMDECLERATION":
{
// Bind data to the gridivew
((frmDecleration)Owner).BindData();
// close the form
//this.Close();
}
break;
case "FRMMAINFORM":
{
// Just close from if this form is opened from main from
//this.Close();
}
break;
default:
break;
}
// Reset form
ResetForm();
}
catch (Exception ex)
{
logger.Error(ex.ToString());
if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
}
}
private void btnSaveAll_Click(object sender, EventArgs e)
{
try
{
DeclarationFactory _declarationBOL = new DeclarationFactory();
var declarationInfo = GetDeclarationInfo();
declarationInfo.ModifiedDate = DateTime.Now;
declarationInfo.ModifiedByID = _userInfo.UserID;
if (VehicleInfosTemp.Count == 0)
throw new Exception("Phương tiện không được để trống");
List<tblVehicle> listVehicle = new List<tblVehicle>();
foreach (VehicleInfo info in VehicleInfosTemp)
{
tblVehicle vehicleInfo = new tblVehicle();
vehicleInfo.DriverName = info.DriverName;
vehicleInfo.PlateNumber = info.PlateNumber;
vehicleInfo.NumberOfContainer = info.NumberOfContainer;
vehicleInfo.ExportDate = info.ExportDate;
vehicleInfo.ConfirmExportBy = info.ConfirmExportBy;
vehicleInfo.ImportDate = info.ImportDate;
vehicleInfo.ConfirmImportBy = info.ConfirmImportBy;
vehicleInfo.Status = vehicleInfo.Status;
vehicleInfo.Note = vehicleInfo.Note;
vehicleInfo.VehicleID = info.VehicleID;
vehicleInfo.IsExport = info.IsExport;
vehicleInfo.IsImport = info.IsImport;
vehicleInfo.IsCompleted = info.IsCompleted;
listVehicle.Add(vehicleInfo);
}
_declarationBOL.AddDeclaration(declarationInfo, listVehicle, _userInfo.UserID);
MessageBox.Show(ConstantInfo.MESSAGE_INSERT_SUCESSFULLY);
// Reset form
ResetForm();
}
catch (Exception ex)
{
logger.Error(ex.ToString());
if (GlobalInfo.IsDebug) MessageBox.Show(ex.ToString());
}
}
