public IActionResult Index() { var AspVendorViewModel = new AspVendorViewModel(); AspVendorViewModel.VendorList = from vendor in _MainSystemContext.AspNetVendor select vendor; return(View(AspVendorViewModel)); }
public IActionResult ActivateVendor(AspVendorViewModel model) { var id = model.VendorDetail.Id; //get vendor with this id var getVendor = _MainSystemContext.AspNetVendor.FirstOrDefault(a => a.Id == id); if (getVendor == null) { return(RedirectToAction("Show", new RouteValueDictionary( new { Controller = "Vendors", Action = "Show", adhfliewgfblbksdfUEOfbiualbgfE1038RYHWEO = id } ))); } //update vendor and activate getVendor.PaymentTerms = model.VendorDetail.PaymentTerms; getVendor.VendorPostingGroup = model.VendorDetail.VendorPostingGroup; getVendor.GenBusPostingGroup = model.VendorDetail.GenBusPostingGroup; getVendor.VATBusPostingGroup = model.VendorDetail.VATBusPostingGroup; getVendor.LocationCode = model.VendorDetail.LocationCode; getVendor.IsActive = "Yes"; _MainSystemContext.Update(getVendor); _MainSystemContext.SaveChanges(); //Tambahkan Vendor baru di tabel BML if (getVendor.VendorNo == null || getVendor.VendorNo == "") { //Generate Vendor No new string Vnumbers = GeneratevendorNo(); //lakukan Insert Ke db Vendors di BML Context var Vendors = new Vendors { VendorNo = Vnumbers, VendorName = getVendor.CompanyName, VendorName2 = "", VendorAddress = getVendor.Address, VendorAddress2 = "", VendorCity = getVendor.VendorCity, VendorContact = getVendor.ContactName, VendorPhoneNo = getVendor.Contact, VendorFaxNo = getVendor.VendorFaxNo, VendorTelexNo = "", OurAccountNo = "", TerritoryCode = "", GlobalDimension1Code = "", GlobalDimension2Code = "", BudgetedAmount = 0, VendorPostingGroup = model.VendorDetail.VendorPostingGroup, CurrencyCode = getVendor.Currency, LanguageCode = "", StatisticsGroup = 0, PaymentTermsCode = model.VendorDetail.PaymentTerms, FinChargeTermsCode = "", PurchaserCode = "", ShipmentMethodCode = "", ShippingAgentCode = "", InvoiceDiscCode = "", Country = getVendor.Country, Blocked = 0, PaytoVendorNo = "", Priority = 0, PaymentMethodCode = "", ApplicationMethod = 0, PricesIncludingVat = 0, TelexAnswerBack = "", VatregistrationNo = "", GenBusPostingGroup = model.VendorDetail.GenBusPostingGroup, MobileNo = getVendor.InvoiceContact, PostCode = "", Email = getVendor.ContactEmail, HomePage = "", NoSeries = "", TaxAreaCode = "", TaxLiable = 0, VatbusPostingGroup = model.VendorDetail.VATBusPostingGroup, BlockPaymentTolerance = 0, IcpartnerCode = "", PrepaymentPercent = 0, PrimaryContactNo = "", ResponsibilityCenter = "", LocationCode = model.VendorDetail.LocationCode, LeadTimeCalculation = "", BaseCalendarCode = "", RtcfilterField = 0, BuyerGroupCode = "", BuyerId = "", RowStatus = 0, CreatedBy = _userManager.GetUserName(User), CreatedTime = DateTime.Now, Swiftcode = getVendor.Swiftcode, }; _bmlContext.Vendors.Add(Vendors); _bmlContext.SaveChanges(); //isi vendors no di aspnetvendor tabel getVendor.VendorNo = Vnumbers; _MainSystemContext.AspNetVendor.Update(getVendor); _MainSystemContext.SaveChanges(); } else { var getVendorsInBMLContext = _bmlContext.Vendors.FirstOrDefault(a => a.VendorNo == getVendor.VendorNo); //lakukan update getVendorsInBMLContext.VendorName = getVendor.CompanyName; getVendorsInBMLContext.VendorAddress = getVendor.Address; getVendorsInBMLContext.VendorCity = getVendor.VendorCity; getVendorsInBMLContext.VendorContact = getVendor.ContactName; getVendorsInBMLContext.VendorPhoneNo = getVendor.Contact; getVendorsInBMLContext.VendorFaxNo = getVendor.VendorFaxNo; getVendorsInBMLContext.VendorPostingGroup = model.VendorDetail.VendorPostingGroup; getVendorsInBMLContext.CurrencyCode = getVendor.Currency; getVendorsInBMLContext.PaymentTermsCode = model.VendorDetail.PaymentTerms; getVendorsInBMLContext.Country = getVendor.Country; getVendorsInBMLContext.GenBusPostingGroup = model.VendorDetail.GenBusPostingGroup; getVendorsInBMLContext.MobileNo = getVendor.InvoiceContact; getVendorsInBMLContext.Email = getVendor.ContactEmail; getVendorsInBMLContext.VatbusPostingGroup = model.VendorDetail.VATBusPostingGroup; getVendorsInBMLContext.LocationCode = model.VendorDetail.LocationCode; getVendorsInBMLContext.Swiftcode = getVendor.Swiftcode; getVendorsInBMLContext.LastModifiedBy = _userManager.GetUserName(User); getVendorsInBMLContext.LastModifiedTime = DateTime.Now; _bmlContext.Vendors.Update(getVendorsInBMLContext); _bmlContext.SaveChanges(); } return(RedirectToAction("Show", new RouteValueDictionary( new { Controller = "Vendors", Action = "Show", adhfliewgfblbksdfUEOfbiualbgfE1038RYHWEO = id } ))); }