// Required for working with SqlBulkCopy
private DataRow ConvertToDataRow(DeliveryFile file, PpcExampleRow row)
{
DataRow data = table.NewRow();
data["Day_Code"] = DayCode.ToDayCode(file.TargetDateTime);
data["AccountID"] = _delivery.AccountID;
data["Campaign_GK"] = GKManager.GetCampaignGK(_delivery.AccountID, row.CampaignName);
data["Adgroup_GK"] = GKManager.GetAdgroupGK(_delivery.AccountID, row.AdgroupName);
//etc.
}
public void GetDelivery(int deliveryId)
{
using (DataManager.Current.OpenConnection())
{
SqlCommand EngineCmd = DataManager.CreateCommand("SP_GetDeliveryData(@DeliveryID:int)", CommandType.StoredProcedure);
EngineCmd.Parameters["@DeliveryID"].Value = deliveryId;
SqlDataReader reader = EngineCmd.ExecuteReader();
reader.Read();
if (!reader["DeliveryID"].Equals(System.DBNull.Value))
{
this.DeliveryID = (int)reader["DeliveryID"];
}
if (!reader["Description"].Equals(System.DBNull.Value))
{
this.Description = (string)reader["Description"];
}
if (!reader["DeliveryState"].Equals(System.DBNull.Value))
{
this.DeliveryState = (eDeliveryState)reader["DeliveryState"];
}
if (!reader["Parameters"].Equals(System.DBNull.Value))
{
this.Description = (string)reader["Parameters"];
}
reader.Close();
EngineCmd = DataManager.CreateCommand("SP_GetDeliveryFileData(@DeliveryID:int)", CommandType.StoredProcedure);
EngineCmd.Parameters["@DeliveryID"].Value = deliveryId;
reader = EngineCmd.ExecuteReader();
while (reader.Read())
{
DeliveryFile df = new DeliveryFile();
if (!reader["FileID"].Equals(System.DBNull.Value))
{
df.FileID = (int)reader["FileID"];
}
if (!reader["DeliveryID"].Equals(System.DBNull.Value))
{
df.DeliveryID = (int)reader["DeliveryID"];
}
if (!reader["FileName"].Equals(System.DBNull.Value))
{
df.FileName = (string)reader["FileName"];
}
if (!reader["FilePath"].Equals(System.DBNull.Value))
{
df.FilePath = (string)reader["FilePath"];
}
if (!reader["DownloadUrl"].Equals(System.DBNull.Value))
{
df.DownloadUrl = (string)reader["DownloadUrl"];
}
if (!reader["TargetDateTime"].Equals(System.DBNull.Value))
{
df.TargetDateTime = (DateTime)reader["TargetDateTime"];
}
if (!reader["ReaderType"].Equals(System.DBNull.Value))
{
df.ReaderType = (string)reader["ReaderType"];
}
if (!reader["Parameters"].Equals(System.DBNull.Value))
{
df.Parameters = (string)reader["Parameters"];
}
if (this.Files == null)
{
this.Files = new List <DeliveryFile>();
}
this.Files.Add(df);
}
reader.Close();
}
}