JarvisJobExecutorNonBooks

JarvisJobExecutorNonBooks

1. Modul:- JobExecutor

   • JobExecutor()
     • GetRefreshInventoryJobsToExecute()
       • !IsBusy
         • StartExecution()
           • IsBusy=true GetjobsToExecute()
             • GetjobsToExecute()
               • SP_J_GetjobExecutorJobsToExecute Tables J_Master_job ,J_Master_Job_Log
                 • Note that JobType is ItemCreation
               • jobs!=null && Jobs.count>0
                 • StartRange=0 Foreach(job in jobs ) StartRange=0
                   • LogStatus==null
                     • Status=InProcess, LogStatus=Running, UpdateJobLogAndStatus(job,true,false,true)
                       • by this method update and insert in DB table J_Master_Job and J_Master_job_Log
                   • LogStatus!=null
                     • j_jobMasterLogId==0
                       • UpdateJobLogAndStatus(Jobs,true,false,true)
                     • LogStatus=Running StartRange=LastBatchCount ,StatrRefreshInventory()
                       • StartRefrshInventory(StartRange ,Job, client )
                         • Batchdata=GetItemsFromDB()
                           • LastBatchDatacount+=Batchdata.count , Batchdatalist=SplitIntoChunks(Batchdata,10)
                             • Batchdatalist!=null && Batchdata.count>0
                               • SendMailCount=0 Foreach(list in Batchdatalist)
                                 • SendMailCount++ AttempGetInventory()
                                   • GetInventory()
                                     • here create req and send to Amazon using Webservices and get Response fromAmazon
                                     • ResponseResult== Success
                                       • ReadResponse()
                                         • Get lowestlisting price on Amazon
                                           • GetAveragePrice()
                                             • here get avgOfLowest5Price
                                 • SendMailCount%100==0
                                   • LastBatchCountTemp+=1000 UpdateTempStatus() , SendMailCount=0
                                     • here update LastBatchCountTemp in DB table J_Master_Job_Log
                               • SendMailCount>0
                                 • LastBatchCountTemp+=1000 UpdateTempStatus() ,SendMailCount=0
                               • !append
                                 • LastItemMasterId=Batchdata[Batchdata.count-1].itemMasterId
                                   • here ItemMasterId is get from Master_Item Table
                                   • UpdateJobLogAndStatus(job,False,true,False)
                                     • GetMarketPlaceToExport()
                                       • Here Get data from DB by joining of tables J_Detail_Job and Master_MarketPlace
                                       • DetailJob!=null && DetailJob.count>0
                                         • WriteIntoFile()
                                           • createSingleJobInDB()
                                             • Here create single job in DB tbl Master_Job And Status='New'
                                             • UpdateJobInDetailTable()
                                               • here only update filepath in DB Table J_Detail_Job
                                               • SendNotification("Completed for ItemCreation (UsedBooks) Batch "Batchcuont" Submmited for Processing.+Filename ")
                                                 • SendEMail("Completed for ItemCreation (UsedBooks)")
                                                   • LogStatus='Completed' ,Status='Completed'
                                                     • UpdateJobLogAndStatus(job,False,true,true)
                                                 • SendNotification("Completed for ItemCreation")
                           • Here get items from Joining of tables Master_Item and Tbl_Inventory