/// <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);
}
}
