/// <summary> /// Parsed and persist the submission list response to the database /// </summary> /// <param name="response">The submission list response to parsed and to save</param> /// <param name="isUpdate">Flag if it is to update or add the response to database</param> private void parsedAndPersistSubmissionListResponse(GetFeedSubmissionListResponse response, ref bool isUpdate) { if (!response.IsSetGetFeedSubmissionListResult()) { return; } var submissionInfo = response.GetFeedSubmissionListResult.FeedSubmissionInfo.First(); var requestReport = new MarketplaceRequestReport { RequestId = response.ResponseMetadata.RequestId, ReportRequestId = submissionInfo.FeedSubmissionId, FeedType = submissionInfo.FeedType, ProcessingStatus = submissionInfo.FeedProcessingStatus, StartDate = submissionInfo.StartedProcessingDate, EndDate = submissionInfo.CompletedProcessingDate, SubmittedDate = submissionInfo.SubmittedDate, SubmittedBy = _submittedBy }; if (isUpdate) { _logger.UpdateRequestReport(requestReport); } else { _logger.AddRequestReport(requestReport); isUpdate = true; } }
public void AddRequestReport(MarketplaceRequestReport requestReportModel) { var report = Mapper.Map <MarketplaceRequestReport, requestreport>(requestReportModel); using (var context = new EisInventoryContext()) { context.requestreports.Add(report); context.SaveChanges(); } }
public void AddRequestReport(MarketplaceRequestReport model) { using (var context = new EisInventoryContext()) { var report = new requestreport(); CopyObject.CopyFields(model, report); context.requestreports.Add(report); context.SaveChanges(); } }
public void UpdateRequestReport(MarketplaceRequestReport requestReportModel) { using (var context = new EisInventoryContext()) { // find the existing report request by id var oldRequestReport = context.requestreports .FirstOrDefault(x => x.ReportRequestId == requestReportModel.ReportRequestId); context.Entry(oldRequestReport).CurrentValues.SetValues(requestReportModel); context.SaveChanges(); } }
public static void AddRequestReport(MarketplaceRequestReport report) { using (var conn = new MySqlConnection(_inventoryConnectionString)) { var parameters = new Dictionary <string, object> { { "@RequestId", report.RequestId }, { "@ReportRequestId", report.ReportRequestId }, { "@FeedType", report.FeedType }, { "@StartDate", report.StartDate }, { "@EndDate", report.EndDate }, { "@ProcessingStatus", report.ProcessingStatus }, { "@IsScheduled", report.IsScheduled }, { "@SubmittedDate", report.SubmittedDate }, { "@SubmittedBy", report.SubmittedBy }, }; // insert first the report MySqlHelper.ExecuteNonQuery(conn, @"INSERT INTO requestreports(RequestId,ReportRequestId,FeedType, StartDate,EndDate,ProcessingStatus,IsScheduled,SubmittedDate,SubmittedBy) VALUES(@RequestId,@ReportRequestId,@FeedType,@StartDate,@EndDate, @ProcessingStatus,@IsScheduled,@SubmittedDate,@SubmittedBy)", parameters); } }
public static void UpdateRequestReport(MarketplaceRequestReport report) { using (var conn = new MySqlConnection(_inventoryConnectionString)) { var parameters = new Dictionary <string, object> { { "@RequestId", report.RequestId }, { "@ReportRequestId", report.ReportRequestId }, { "@FeedType", report.FeedType }, { "@StartDate", report.StartDate }, { "@EndDate", report.EndDate }, { "@ProcessingStatus", report.ProcessingStatus }, { "@IsScheduled", report.IsScheduled }, { "@SubmittedDate", report.SubmittedDate }, { "@SubmittedBy", report.SubmittedBy }, }; // insert first the report MySqlHelper.ExecuteNonQuery(conn, @"UPDATE requestreports SET FeedType=@FeedType, StartDate=@StartDate, EndDate=@EndDate, ProcessingStatus=@ProcessingStatus, IsScheduled=@IsScheduled, SubmittedDate=@SubmittedDate, SubmittedBy=@SubmittedBy WHERE ReportRequestId = @ReportRequestId", parameters); } }