public void SyncVendorClassification(string SystemCode) { OCRVVendorService CRVWebService = new OCRVVendorService(OApplicationSetting.Current.CRVVendorServiceURL); CRVWebService.Codes = CRVWebService.GetVendorClassificationCodes(SystemCode); if (CRVWebService.Codes == null) return; OCode Parent = TablesLogic.tCode.Load(TablesLogic.tCode.ObjectName == "VendorClassification" & TablesLogic.tCode.CodeType.ObjectName == "VendorRelated"); OCode CodeType = TablesLogic.tCode.Load(TablesLogic.tCode.CodeType.ObjectName == "VendorClassification"); if (Parent == null) return; for (int i = 0; i < CRVWebService.Codes.Length; i++) { OCode VendorClassification = TablesLogic.tCode.Load(TablesLogic.tCode.ObjectName == CRVWebService.Codes[i].ObjectName.Trim() & TablesLogic.tCode.CodeTypeID == CodeType.ObjectID & TablesLogic.tCode.ParentID == Parent.ObjectID); if (VendorClassification == null) { VendorClassification = TablesLogic.tCode.Create(); VendorClassification.ParentID = Parent.ObjectID; VendorClassification.CodeTypeID = CodeType.ObjectID; VendorClassification.ObjectName = CRVWebService.Codes[i].ObjectName.Trim(); using (Connection c = new Connection()) { VendorClassification.Save(); c.Commit(); } } } }
/// <summary> /// Executes the service. /// </summary> public override void OnExecute() { DateTime ServiceStartTime = System.DateTime.Now; int updateCounter = 0; int createCounter = 0; OCRVVendorService CRVWebService = new OCRVVendorService(OApplicationSetting.Current.CRVVendorServiceURL); ArrayList SystemCodes = TablesLogic.tLocation.SelectDistinct(TablesLogic.tLocation.SystemCode) .Where(TablesLogic.tLocation.SystemCode != null); foreach (string SystemCode in SystemCodes) { //ArrayList VendorBizRegList = TablesLogic.tVendor.SelectDistinct(TablesLogic.tVendor.CompanyRegistrationNumber) // .Where(TablesLogic.tVendor.IsDeleted == 0 & // TablesLogic.tVendor.IsInActive == 0 & // TablesLogic.tVendor.IsDebarred == 0 & // TablesLogic.tVendor.CompanyRegistrationNumber != string.Empty & // TablesLogic.tVendor.CompanyRegistrationNumber != null); //SubscribedVendors(VendorBizRegList.ToArray(), SystemCode); //SyncVendorClassification(SystemCode);//Under-Construction //SyncVendorTradeType(SystemCode);//Under-Construction string[] OutdatedAndNewVendorList = CRVWebService.GetOutdatedAndNewVendorList(SystemCode); if (OutdatedAndNewVendorList != null) for (int i = 0; i < OutdatedAndNewVendorList.Length; i++) OVendor.SyncVendorInfo(OutdatedAndNewVendorList[i], SystemCode, ServiceStartTime, ref updateCounter, ref createCounter); } LogEvent(String.Format("{0} vendor(s) updated. {1} vendor(s) created.", updateCounter, createCounter), BackgroundLogMessageType.Information); }