示例#1
0
        private EXP_ExportForm ConvertModel(ExpExportForm model, int userId, string url)
        {
            var entity = model.ExportFormID == 0 ? new EXP_ExportForm() : (from b in _context.EXP_ExportForm.AsEnumerable()
                                                                           where b.ExportFormID == model.ExportFormID
                                                                           select b).FirstOrDefault();

            entity.DealerID           = model.DealerID;
            entity.ExportFormID       = model.ExportFormID;
            entity.ExportFormNo       = model.ExportFormNo;
            entity.ExportFormDate4    = DalCommon.SetDate(model.ExportFormDate4);
            entity.ExportFormRef      = model.ExportFormRef;
            entity.ExportFormRef1     = model.ExportFormRef1;
            entity.ExportFormRef2     = model.ExportFormRef2;
            entity.ExportFormRef3     = model.ExportFormRef3;
            entity.CIID               = model.CIID;
            entity.PLID               = model.PLID;
            entity.Comodity           = model.Comodity;
            entity.ComodityCode       = model.ComodityCode;
            entity.DestinationCountry = model.DestinationCountry;
            entity.CountryCode        = model.CountryCode;
            entity.DestinationPort    = model.DestinationPort;
            entity.PortCode           = model.PortCode;
            entity.PackQTy            = model.PackQTy;
            entity.PackUnit           = model.PackUnit;
            entity.PackUnitCode       = model.PackUnitCode;
            entity.VolumeQty          = model.VolumeQty;
            entity.VolumeUnit         = model.VolumeUnit;
            entity.DeclaredCurrency   = model.DeclaredCurrency;
            entity.InvoiceValue       = model.InvoiceValue;
            entity.InvoiceCurrency    = model.InvoiceCurrency;
            entity.DeliveryTerm       = model.DeliveryTerm;
            entity.TermOfSaleNo       = model.TermOfSaleNo;
            entity.TermSaleDate       = DalCommon.SetDate(model.TermSaleDate);
            entity.Importer           = model.Importer;
            entity.CarryingVassal     = model.CarryingVassal;
            entity.ExportBillDtl      = model.ExportBillDtl;
            entity.PortOfShipment     = model.PortOfShipment;
            entity.LandCustomPort     = model.LandCustomPort;
            entity.ShipmentDate       = DalCommon.SetDate(model.ShipmentDate);
            entity.Exporter           = model.Exporter;
            entity.CCIESNo            = model.CCIESNo;
            entity.CCIESDate          = DalCommon.SetDate(model.CCIESDate);
            entity.Sector             = model.Sector;
            entity.SectorCode         = model.SectorCode;
            entity.SetOn              = model.ExportFormID == 0
                ? DateTime.Now
                : _unit.ExportFormRepository.GetByID(model.ExportFormID).SetOn;
            entity.SetBy = model.ExportFormID == 0
                ? userId
                : _unit.ExportFormRepository.GetByID(model.ExportFormID).SetBy;
            entity.ModifiedOn   = model.ExportFormID == 0 ? (DateTime?)null : DateTime.Now;
            entity.ModifiedBy   = model.ExportFormID == 0 ? (int?)null : userId;
            entity.RecordStatus = model.RecordStatus ?? "NCF";
            return(entity);
        }
示例#2
0
 public ValidationMsg Save(ExpExportForm model, int userId, string url)
 {
     try
     {
         var expFrm = ConvertModel(model, userId, url);
         if (model.ExportFormID == 0)
         {
             _context.EXP_ExportForm.Add(expFrm);
             _context.SaveChanges();
             _mode = 1;
         }
         else
         {
             _context.SaveChanges();
             _mode = 2;
         }
         if (_mode == 1)
         {
             _validationMsg.ReturnId   = expFrm.ExportFormID;
             _validationMsg.ReturnCode = expFrm.ExportFormNo;
             _validationMsg.Type       = Enums.MessageType.Success;
             _validationMsg.Msg        = "Saved successfully";
         }
         if (_mode == 2)
         {
             _validationMsg.Type = Enums.MessageType.Update;
             _validationMsg.Msg  = "Updated successfully";
         }
     }
     catch
     {
         _validationMsg.Type = Enums.MessageType.Error;
         _validationMsg.Msg  = "Failed to save";
     }
     return(_validationMsg);
 }
示例#3
0
        public ExpExportForm GetExpFrm(long id)
        {
            var expFrm = _context.EXP_ExportForm.FirstOrDefault(ob => ob.ExportFormID == id);
            var result = new ExpExportForm();

            result.DealerID   = expFrm.DealerID;
            result.DealerCode = expFrm.DealerID == null
                ? ""
                : _context.Sys_Branch.FirstOrDefault(ob => ob.BranchID == expFrm.DealerID).BanchCode;
            result.DealerName = expFrm.DealerID == null
                ? ""
                : _context.Sys_Branch.FirstOrDefault(ob => ob.BranchID == expFrm.DealerID).BranchName;
            result.DealerAddress = expFrm.DealerID == null
                ? ""
                : _context.Sys_Branch.FirstOrDefault(ob => ob.BranchID == expFrm.DealerID).Address1;
            result.ExportFormID    = expFrm.ExportFormID;
            result.ExportFormNo    = expFrm.ExportFormNo;
            result.ExportFormRef   = expFrm.ExportFormRef;
            result.ExportFormRef1  = expFrm.ExportFormRef1;
            result.ExportFormRef2  = expFrm.ExportFormRef2;
            result.ExportFormRef3  = expFrm.ExportFormRef3;
            result.ExportFormDate4 = string.Format("{0:dd/MM/yyyy}", expFrm.ExportFormDate4);
            result.CIID            = expFrm.CIID;
            result.CINo            = expFrm.CIID == null ? "" : _context.EXP_CI.FirstOrDefault(ob => ob.CIID == expFrm.CIID).CINo;
            result.CIDate          = expFrm.CIID == null
                ? ""
                : string.Format("{0:dd/MM/yyyy}", _context.EXP_CI.FirstOrDefault(ob => ob.CIID == expFrm.CIID).CIDate);
            result.LCID   = expFrm.LCID;
            result.PIID   = expFrm.PIID;
            result.PLID   = expFrm.PLID;
            result.PLNo   = expFrm.PLID == null ? "" : _context.EXP_PackingList.FirstOrDefault(ob => ob.PLID == expFrm.PLID).PLNo;
            result.PLDate = expFrm.PLID == null
                ? ""
                : string.Format("{0:dd/MM/yyyy}",
                                _context.EXP_PackingList.FirstOrDefault(ob => ob.PLID == expFrm.PLID).PLDate);
            result.Comodity               = expFrm.Comodity;
            result.ComodityCode           = expFrm.ComodityCode;
            result.DestinationCountry     = expFrm.DestinationCountry;
            result.DestinationCountryName = expFrm.DestinationCountry == null
                ? ""
                : _context.Sys_Country.FirstOrDefault(ob => ob.CountryID == expFrm.DestinationCountry).CountryName;
            result.CountryCode         = expFrm.CountryCode;
            result.DestinationPort     = expFrm.DestinationPort;
            result.DestinationPortName = expFrm.DestinationPort == null
                ? ""
                : _context.Sys_Port.FirstOrDefault(ob => ob.PortID == expFrm.DestinationPort).PortName;
            result.PortCode     = expFrm.PortCode;
            result.PackQTy      = expFrm.PackQTy;
            result.PackUnit     = expFrm.PackUnit;
            result.PackUnitName = expFrm.PackUnit == null
                ? ""
                : _context.Sys_Unit.FirstOrDefault(ob => ob.UnitID == expFrm.PackUnit).UnitName;
            result.PackUnitCode   = expFrm.PackUnitCode;
            result.VolumeQty      = expFrm.VolumeQty;
            result.VolumeUnit     = expFrm.VolumeUnit;
            result.VolumeUnitName = expFrm.VolumeUnit == null
                ? ""
                : _context.Sys_Unit.FirstOrDefault(ob => ob.UnitID == expFrm.VolumeUnit).UnitName;
            result.DeclaredCurrency     = expFrm.DeclaredCurrency;
            result.DeclaredCurrencyName = expFrm.DeclaredCurrency == null
                ? ""
                : _context.Sys_Currency.FirstOrDefault(ob => ob.CurrencyID == expFrm.DeclaredCurrency).CurrencyName;
            result.InvoiceValue        = expFrm.InvoiceValue;
            result.InvoiceCurrency     = expFrm.InvoiceCurrency;
            result.InvoiceCurrencyName = expFrm.InvoiceCurrency == null
                ? ""
                : _context.Sys_Currency.FirstOrDefault(ob => ob.CurrencyID == expFrm.InvoiceCurrency).CurrencyName;
            result.DeliveryTerm = expFrm.DeliveryTerm;
            result.TermOfSaleNo = expFrm.TermOfSaleNo;
            result.TermSaleDate = string.Format("{0:dd/MM/yyyy}", expFrm.TermSaleDate);
            result.Importer     = expFrm.Importer;
            result.ImporterName = expFrm.Importer == null
                ? ""
                : _context.Sys_Buyer.FirstOrDefault(ob => ob.BuyerID == expFrm.Importer).BuyerName;
            result.CarryingVassal     = expFrm.CarryingVassal;
            result.ExportBillDtl      = expFrm.ExportBillDtl;
            result.PortOfShipment     = expFrm.PortOfShipment;
            result.PortOfShipmentName = expFrm.PortOfShipment == null
                ? ""
                : _context.Sys_Port.FirstOrDefault(ob => ob.PortID == expFrm.PortOfShipment).PortName;
            result.LandCustomPort     = expFrm.LandCustomPort;
            result.LandCustomPortName = expFrm.LandCustomPort == null
                ? ""
                : _context.Sys_Port.FirstOrDefault(ob => ob.PortID == expFrm.LandCustomPort).PortName;
            result.ShipmentDate = string.Format("{0:dd/MM/yyyy}", expFrm.ShipmentDate);
            result.Exporter     = expFrm.Exporter;
            result.ExporterName = expFrm.Exporter == null
                ? ""
                : _context.Sys_Buyer.FirstOrDefault(ob => ob.BuyerID == expFrm.Exporter).BuyerName;
            result.CCIESNo      = expFrm.CCIESNo;
            result.CCIESDate    = string.Format("{0:dd/MM/yyyy}", expFrm.CCIESDate);
            result.Sector       = expFrm.Sector;
            result.SectorCode   = expFrm.SectorCode;
            result.RecordStatus = expFrm.RecordStatus;
            return(result);
        }
 public ActionResult Save(ExpExportForm model)
 {
     _userId        = Convert.ToInt32(Session["UserID"]);
     _validationMsg = _dalExportForm.Save(model, _userId, "");
     return(Json(_validationMsg, JsonRequestBehavior.AllowGet));
 }