/// <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()); } }