public void GetUtcAuctionDateByBranchTest()
{
var request = new GetBranchAuctionsRequest()
{
PartnerId = PartnerID, UserRequestInfo = User, BranchCode = "811"
};
var utcAuctionDate = Client.GetUtcAuctionDateByBranch(request);
Assert.IsTrue(utcAuctionDate.WasSuccessful);
}
public void GetAuctionDateTest()
{
var request = new GetBranchAuctionsRequest()
{
PartnerId = PartnerID, UserRequestInfo = User, BranchCode = "811"
};
var auctionDateList = Client.GetAuctionDatesByBranch(request);
Assert.IsTrue(auctionDateList.WasSuccessful);
}
private void GetAuctionDates()
{
BranchList.ForEach(branch =>
{
var request = new GetBranchAuctionsRequest() { PartnerId = PartnerID, UserRequestInfo = User, BranchCode = branch.BranchCode };
var response = Client.GetAuctionDatesByBranch(request);
if (response.WasSuccessful && response.RequestedData != null)
{
branch.Auctions = new List<BranchAuction>(response.RequestedData.ToList().ConvertAll(c => new BranchAuction() { AuctionDate = c.AuctionDate.DateTime }).ToList());
}
else
{
clsLog.LogInfo("GetAuctionDates - didn't get auction dates for branch " + branch.BranchCode);
}
});
try
{
var connection = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
var branchDataTable = new DataTable();
var flatBranchList = from b in BranchList
from a in b.Auctions
select new FlatBranch { BranchCode = b.BranchCode, AuctionDate = a.AuctionDate };
using (var reader = ObjectReader.Create(flatBranchList, "BranchCode", "AuctionDate"))
{
branchDataTable.Load(reader);
}
clsLog.LogInfo("GetAuctionDates - trying to save auction dates, Records - " + branchDataTable.Rows.Count);
using (SqlConnection con = new SqlConnection(connection))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
sqlBulkCopy.DestinationTableName = "dyndata.dbo.Auction_stg";
sqlBulkCopy.ColumnMappings.Add("BranchCode", "BranchID");
sqlBulkCopy.ColumnMappings.Add("AuctionDate", "AuctionDateTime");
con.Open();
sqlBulkCopy.BulkCopyTimeout = 0;
sqlBulkCopy.WriteToServer(branchDataTable);
SqlCommand cmd = new SqlCommand("dyndata.dbo.SP_AUCTION", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
con.Close();
}
}
clsLog.LogInfo("GetAuctionDates - saved auction dates, Records saved - " + branchDataTable.Rows.Count);
}
catch (Exception ex)
{
clsLog.LogError("GetAuctionDates - Error while getting auction dates. Error " + ex.Message);
}
}
