private void ManagePackage_Load(object sender, EventArgs e)
{
#region Populate Grid
_sourcePackage =
new List <PackageList>();
List <PackageList> usedPackage = new List <PackageList>();
List <PackageList> unUsedPackage = new List <PackageList>();
SAPEventAttendeeReadWrite eventAttendeeRW =
new SAPEventAttendeeReadWrite(Config._dbConnectionName);
SAPPackageReadWrite packageRW =
new SAPPackageReadWrite(Config._dbConnectionName);
using (SAPDataReaderPackage rdrPackage =
packageRW.ReaderSelectAll())
{
if (rdrPackage.DataReader != null &&
rdrPackage.DataReader.HasRows)
{
SAPDataSetEventAttendee.EventAttendeeDataTable dtEventAttendee =
eventAttendeeRW.SelectAll().EventAttendee;
while (rdrPackage.DataReader.Read())
{
PackageList item = new PackageList();
item.PackageName = rdrPackage.PackageName;
item.PackageDescription = rdrPackage.PackageDescription;
item.PackagePhoto = rdrPackage.PackageImage;
item.PackageID = rdrPackage.PackageID;
DataRow[] rows =
dtEventAttendee.Select("packageid = " + item.PackageID.ToString());
if (rows != null && rows.Length > 0)
{
item.PackageTag = true;
usedPackage.Add(item);
}
else
{
item.PackageTag = false;
unUsedPackage.Add(item);
}
} //while (rdrPackage.DataReader.Read());
_sourcePackage.AddRange(unUsedPackage);
_sourcePackage.AddRange(usedPackage);
}
}
//SAPEventAttendeeReadWrite
#endregion
#region Create Data Grid
dataGridViewPackage.VirtualMode = true;
DataGridViewTextBoxColumn columnName =
new DataGridViewTextBoxColumn();
columnName.HeaderText = "Name";
columnName.Name = "ColumnName";
columnName.Width = 100;
dataGridViewPackage.Columns.Add(columnName);
DataGridViewTextBoxColumn columnDesc =
new DataGridViewTextBoxColumn();
columnDesc.HeaderText = "Description";
columnDesc.Name = "ColumnDescription";
columnDesc.Width = 150;
columnDesc.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewPackage.Columns.Add(columnDesc);
//create icon edit column
DataGridViewImageColumn editColumn =
new DataGridViewImageColumn();
editColumn.Image = Resources.icoedit;
editColumn.Width = 25;
editColumn.Name = "ColumnEdit";
editColumn.HeaderText = string.Empty;
editColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
//create icond delete column
DataGridViewImageColumn deleteColumn = new DataGridViewImageColumn();
deleteColumn.Image = Resources.icodelete;
deleteColumn.Width = 25;
deleteColumn.Name = "ColumnDelete";
deleteColumn.HeaderText = string.Empty;
deleteColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridViewPackage.Columns.Insert(2, editColumn);
editColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dataGridViewPackage.Columns.Insert(3, deleteColumn);
deleteColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
#endregion
dataGridViewPackage.RowCount = _sourcePackage.Count;
pictureBoxNewPackage.Image = Resources.iconew;
//set first image on poster panel
if (_sourcePackage.Count > 0)
{
pictureBoxPoster.Image =
UtilityHelper.ByteToImage(_sourcePackage[0].PackagePhoto);
}
}
private void CreatePackageSlide()
{
Slide slide;
Shape pictureShape;
Slide slidePackage;
slidePackage = slides[SlideTemplate.PackageSlide];
//set image layout
imageTop = slidePackage.Shapes[1].Top;
imageLeft = slidePackage.Shapes[1].Left;
imageWidth = slidePackage.Shapes[1].Width;
imageHeight = slidePackage.Shapes[1].Height;
_packageImageFileName =
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures),
"PackageImage" +
_packageID.ToString() +
".jpg");
SAPPackageReadWrite packageRW = new SAPPackageReadWrite(Config._dbConnectionName);
using (SAPDataReaderPackage rdrPackage =
packageRW.ReaderSelectByPackageID(_packageID))
{
if (rdrPackage.DataReader != null && rdrPackage.DataReader.HasRows)
{
rdrPackage.DataReader.Read();
ByteToFile(rdrPackage.PackageImage, _packageImageFileName);
slide = DuplicateSlide(slidePackage);
_pptxFileName = rdrPackage.PackageName.Trim();
_pptxFileName = _pptxFileName.Replace(" ", "");
//package poster
do
{
slide.Shapes[1].Delete();
} while (slide.Shapes.Count > 0);
if (File.Exists(_packageImageFileName))
{
pictureShape = slide.Shapes.AddPicture(
_packageImageFileName,
MsoTriState.msoFalse,
MsoTriState.msoCTrue,
imageLeft,
imageTop,
imageWidth,
imageHeight);
pictureShape.ZOrder(MsoZOrderCmd.msoSendToBack);
}
slide = DuplicateSlide(slidePackage);
slide.Shapes[1].Delete();
if (File.Exists(_packageImageFileName))
{
pictureShape = slide.Shapes.AddPicture(
_packageImageFileName,
MsoTriState.msoFalse,
MsoTriState.msoCTrue,
imageLeft,
imageTop,
imageWidth,
imageHeight);
pictureShape.ZOrder(MsoZOrderCmd.msoSendToBack);
}
slide.Shapes[4].TextFrame.TextRange.Text = rdrPackage.PackageName.Trim();
slide.Shapes[5].TextFrame.TextRange.Text = rdrPackage.PackageDescription.Trim();
}
}
}
private void PopulateItems()
{
_sourceEvent = new List <AssociatedEventList>();
if (_packageID > 0)
{
//get associated events
SAPPackageEventMapReadWrite eventMap =
new SAPPackageEventMapReadWrite(Config._dbConnectionName);
using (SAPDataReaderPackageEventMap readerEventMap =
eventMap.ReaderSelectByPackageID(_packageID))
{
if (readerEventMap.DataReader != null &&
readerEventMap.DataReader.HasRows)
{
while (readerEventMap.DataReader.Read())
{
AssociatedEventList item =
GetItem(readerEventMap.EventID);
item.EventID = readerEventMap.EventID;
item.IsNewID = false;
item.PackageMapID = readerEventMap.PackageEventMapID;
_sourceEvent.Add(item);
}// while (readerEventMap.DataReader.Read());
}
}
//get pacakage info
SAPPackageReadWrite package =
new SAPPackageReadWrite(Config._dbConnectionName);
using (SAPDataReaderPackage readerPackage =
package.ReaderSelectByPackageID(_packageID))
{
if (readerPackage.DataReader != null &&
readerPackage.DataReader.HasRows)
{
readerPackage.DataReader.Read();
textBoxName.Text = readerPackage.PackageName;
textBoxDescription.Text = readerPackage.PackageDescription;
pictureBoxPoster.Image =
UtilityHelper.ByteToImage(readerPackage.PackageImage);
_imageSelected = readerPackage.PackageImage;
}
}
}
#region Create Datagrid
dataGridViewEvents.VirtualMode = true;
dataGridViewEvents.Columns.Add(
CreateColumn("Name", EventNameColumn, 100, ""));
dataGridViewEvents.Columns.Add(
CreateColumn("Date", EventDateColumn, 100, ""));
dataGridViewEvents.Columns.Add(
CreateColumn("Venue", EventVenueColumn, 100, ""));
dataGridViewEvents.Columns.Add(
CreateColumn("Gold Price", EventGoldPriceColumn, 75, "c"));
dataGridViewEvents.Columns.Add(
CreateColumn("Silver", EventSilverPriceColumn, 75, "c"));
dataGridViewEvents.Columns.Add(
CreateColumn("Bronze", EventBronzePriceColumn, 75, "c"));
#endregion
_removedEvent = new List <AssociatedEventList>();
dataGridViewEvents.RowCount = _sourceEvent.Count;
}
public static void CreateSeedData()
{
#region create random name/date of birth list
Random rand = new Random((int)DateTime.Now.Ticks);
int index = 0;
List <string> names = new List <string>();
List <string> nameList =
Properties.Resources.ValidNames.Split(
Environment.NewLine.ToCharArray(),
StringSplitOptions.RemoveEmptyEntries).ToList <string>();
DateTime[] dobs = new DateTime[Config.SeedDataLimit * 4 + 1];
int month = DateTime.Now.Month;
int day = DateTime.Now.Day;
int year = DateTime.Now.Year;
int nameCounter = 0;
do
{
if (!names.Contains(nameList[nameCounter]))
{
names.Add(nameList[nameCounter]);
index = rand.Next(year - 40, year);
dobs[names.Count - 1] = new DateTime(index, month, day);
nameCounter++;
}
} while (names.Count < Config.SeedDataLimit * 4 + 1);
#endregion
cityCountry =
new SortedDictionary <string, string>();
SetCityCountry();
#region Clear Tables
SAPEventActorMapReadWrite eventActorMapRW =
new SAPEventActorMapReadWrite(Config._dbConnectionName);
SAPDataSetEventActorMap eventActorMapDataSet = eventActorMapRW.SelectAll();
foreach (SAPDataSetEventActorMap.EventActorMapRow row in
eventActorMapDataSet.EventActorMap.Rows)
{
eventActorMapRW.Delete(row.EventActorMapID);
}
SAPEventAttendeeAgencyMapReadWrite eventAttendeeAgencyMapRW =
new SAPEventAttendeeAgencyMapReadWrite(Config._dbConnectionName);
SAPDataSetEventAttendeeAgencyMap eventAttendeeAgencyMapDataSet =
eventAttendeeAgencyMapRW.SelectAll();
foreach (SAPDataSetEventAttendeeAgencyMap.EventAttendeeAgencyMapRow row
in eventAttendeeAgencyMapDataSet.EventAttendeeAgencyMap.Rows)
{
eventAttendeeAgencyMapRW.Delete(row.EventAttendeeAgencyMapID);
}
SAPEventAttendeeReadWrite eventAttendeeRW =
new SAPEventAttendeeReadWrite(Config._dbConnectionName);
SAPDataSetEventAttendee eventAttendeeDataSet = eventAttendeeRW.SelectAll();
foreach (SAPDataSetEventAttendee.EventAttendeeRow row in
eventAttendeeDataSet.EventAttendee.Rows)
{
eventAttendeeRW.Delete(row.EventAttendeeID);
}
SAPEventActorReadWrite eventActorRW =
new SAPEventActorReadWrite(Config._dbConnectionName);
SAPDataSetEventActor eventActorDataSet = eventActorRW.SelectAll();
foreach (SAPDataSetEventActor.EventActorRow row in
eventActorDataSet.EventActor.Rows)
{
eventActorRW.Delete(row.EventActorID);
}
SAPPackageEventMapReadWrite packageEventMapRW =
new SAPPackageEventMapReadWrite(Config._dbConnectionName);
SAPDataSetPackageEventMap packageEventMapDataset = packageEventMapRW.SelectAll();
foreach (SAPDataSetPackageEventMap.PackageEventMapRow row in
packageEventMapDataset.PackageEventMap.Rows)
{
packageEventMapRW.Delete(row.PackageEventMapID);
}
SAPPackageReadWrite packageRW =
new SAPPackageReadWrite(Config._dbConnectionName);
SAPDataSetPackage packageDataSet = packageRW.SelectAll();
foreach (SAPDataSetPackage.PackageRow row in
packageDataSet.Package.Rows)
{
packageRW.Delete(row.PackageID);
}
SAPEventReadWrite eventRW =
new SAPEventReadWrite(Config._dbConnectionName);
SAPDataSetEvent eventDataSet = eventRW.SelectAll();
foreach (SAPDataSetEvent.EventRow row in eventDataSet.Event.Rows)
{
eventRW.Delete(row.EventID);
}
SAPEventTypeReadWrite eventTypeRW =
new SAPEventTypeReadWrite(Config._dbConnectionName);
SAPDataSetEventType eventTypeDataSet = eventTypeRW.SelectAll();
foreach (SAPDataSetEventType.EventTypeRow row in
eventTypeDataSet.EventType.Rows)
{
eventTypeRW.Delete(row.EventTypeID);
}
#endregion
#region Repopulate Tables
SAPEventTypeReadWrite seedEventTypeRW =
new SAPEventTypeReadWrite(Config._dbSeedConnectionName);
SAPDataSetEventType seedEventTypeDataSet =
seedEventTypeRW.SelectAll();
int retEventTypeID = 0;
foreach (SAPDataSetEventType.EventTypeRow row in
seedEventTypeDataSet.EventType.Rows)
{
eventTypeRW.Insert(row.EventTypeName, row.EventTypeDescription, out retEventTypeID);
}
SAPEventReadWrite seedEventRW =
new SAPEventReadWrite(Config._dbSeedConnectionName);
SAPDataSetEvent seedEventDataSet = seedEventRW.SelectAll();
int retEventID = 0;
//check the difference in seed date to adjust the event dates
long monthDiff = UtilityHelper.GetMonthDifference(
Config.DateLastSeed,
DateTime.Now);
foreach (SAPDataSetEvent.EventRow row in
seedEventDataSet.Event.Rows)
{
using (SAPDataReaderEventType rdrSeedEventType =
eventTypeRW.ReaderSelectByEventTypeName(row.EventTypeName))
{
if (rdrSeedEventType.DataReader != null &&
rdrSeedEventType.DataReader.HasRows)
{
DateTime newDate = new DateTime();
//long monthDifference =
// UtilityHelper.GetMonthDifference(DateTime.Now, row.EventDate);
newDate = row.EventDate.AddMonths((int)monthDiff);
rdrSeedEventType.DataReader.Read();
eventRW.Insert(row.VenueID, rdrSeedEventType.EventTypeID, row.EventName,
row.EventDescription, row.EventPhoto, newDate, row.GoldPackagePrice,
row.SilverPackagePrice, row.BronzePackagePrice, row.GoldPackageTrueCost,
row.SilverPackageTrueCost, row.BronzePackageTrueCost, row.EventTotalCost,
out retEventID);
}
}
}
SAPPackageReadWrite seedPackageRW =
new SAPPackageReadWrite(Config._dbSeedConnectionName);
SAPDataSetPackage seedPackageDataset =
seedPackageRW.SelectAll();
int retPackageID = 0;
foreach (SAPDataSetPackage.PackageRow row in
seedPackageDataset.Package.Rows)
{
packageRW.Insert(row.PackageName, row.PackageDescription,
row.PackageImage, out retPackageID);
}
int retPackageEventMapID = 0;
int[] seedNumberOfEventPerPackage = { 4, 3, 4, 4 };
int packageIndex = 0;
using (SAPDataReaderPackage rdrPackage = packageRW.ReaderSelectAll())
{
if (rdrPackage.DataReader != null &&
rdrPackage.DataReader.HasRows)
{
int eventIdx = 0;
while (rdrPackage.DataReader.Read())
{
int eventID = 0;
for (int idx = 0; idx < seedNumberOfEventPerPackage[packageIndex]; idx++)
{
using (SAPDataReaderEvent rdrEvent = eventRW.ReaderSelectAll())
{
if (rdrEvent.DataReader != null &&
rdrEvent.DataReader.HasRows)
{
if (eventIdx == 0)
{
rdrEvent.DataReader.Read();
eventID = rdrEvent.EventID;
}
else
{
for (int eidx = 0; eidx <= eventIdx; eidx++)
{
rdrEvent.DataReader.Read();
eventID = rdrEvent.EventID;
}
}
}
}
packageEventMapRW.Insert(rdrPackage.PackageID, eventID, out retPackageEventMapID);
eventIdx++;
}
packageIndex++;
}
}
}
#endregion
int currentNameIndex = 0;
//get the 3 package here
SAPPackageEventReadOnly packageEvent =
new SAPPackageEventReadOnly(Config._dbConnectionName);
_flightConnection =
new SAPFlightConnection(Config.SAPUserName, Config.SAPPassword);
#region generate data
using (SAPDataReaderPackage rdrPackage =
packageRW.ReaderSelectAll())
{
if (rdrPackage.DataReader != null &&
rdrPackage.DataReader.HasRows)
{
while (rdrPackage.DataReader.Read())
{
if (Array.IndexOf(packages, rdrPackage.PackageName.ToUpper().Trim()) > -1)
{
List <string> location = new List <string>();
SeedEventDataList[] flights = GetEvent(rdrPackage.PackageID);
for (int i = 1; i <= Config.SeedDataLimit; i++)
{
DateTime previousDate = DateTime.MinValue;
string cityFrom = string.Empty;
#region iterate for each event
for (int idx = 0; idx < flights.Length; idx++)
{
BAPISCODAT selectedItem = null;
string selectedClass = string.Empty;
if (_flightConnection.GetList("", Config.SeedTravelAgency, cityFrom, flights[idx].VenueCity))
{
List <int> classTypeIndex = new List <int>();
BAPISCODAT[] flightList = _flightConnection._bapiConnectionList;
do
{
#region random classtype
if (classTypeIndex.Count < 3)
{
do
{
int ridx = rand.Next(0, 3);
if (!classTypeIndex.Contains(ridx))
{
classTypeIndex.Add(ridx);
break;
}
} while (true);
}
string classType = _classType[classTypeIndex[classTypeIndex.Count - 1]];
#endregion
foreach (BAPISCODAT item in flightList)
{
bool isAvailable = true;
if (!IsValidFlightDate(item.FLIGHTDATE, flights[idx].EventDate, previousDate))
{
continue;
}
isAvailable = IsFlightAvailable(item, classType);
#region check if city to is not found on previous list
//make sure that this is the startup point of the event
if (isAvailable)
{
if (previousDate == DateTime.MinValue)
{
if (location.Contains(item.CITYFROM))
{
//mark this in case there would be no more cityfrom on the list
if (selectedItem == null)
{
selectedItem = item;
selectedClass = classType;
}
}
else
{
location.Add(item.CITYFROM);
selectedItem = item;
selectedClass = classType;
classTypeIndex.Add(1);
classTypeIndex.Add(2);
classTypeIndex.Add(3);
break;
}
}
else
{
selectedItem = item;
selectedClass = classType;
classTypeIndex.Add(1);
classTypeIndex.Add(2);
classTypeIndex.Add(3);
break;
}
}
#endregion
}
} while (classTypeIndex.Count < 3);
}
previousDate = flights[idx].EventDate;
if (selectedItem != null)
{
SeedEventDataList eventData = flights[idx];
eventData.AgencyNum = selectedItem.AGENCYNUM;
eventData.FlightConnNo = selectedItem.FLIGHTCONN;
eventData.CityFrom = selectedItem.CITYFROM;
eventData.FlightDate = selectedItem.FLIGHTDATE;
eventData.ClassType = selectedClass;
flights[idx] = eventData;
cityFrom = eventData.VenueCity;
}
}
#endregion
#region verify if there's flight
bool isReady = true;
for (int idx = 0; idx < flights.Length; idx++)
{
if (String.IsNullOrEmpty(flights[idx].FlightConnNo))
{
isReady = false;
}
}
#endregion
if (isReady)
{
string customerCity = flights[0].CityFrom;
string customerName = names[currentNameIndex];
string language = string.Empty;
string country = GetCountry(customerCity, out language);
string dob =
string.Format("{0:yyyy-MM-dd}", dobs[currentNameIndex]);
string customerNumber = string.Empty;
bool isError = false;
#region save customer
SAPCustomer customer =
new SAPCustomer(Config.SAPUserName, Config.SAPPassword);
if (customer.CreateFromData(
customerCity,
country,
customerName,
"P",
"none",
language,
"N/A",
"",
""))
{
//get customer number of inserted customer
bool found = false;
while (!found)
{
customer.GetList();
if (customer._customerList.Length > 0)
{
//search last 3
for (int j = customer._customerList.Length - 1;
j > (customer._customerList.Length - 3);
j--)
{
if (customer._customerList[j].CUSTNAME.Trim() == customerName.Trim())
{
customerNumber = customer._customerList[j].CUSTOMERID;
found = true;
break;
}
}
}
else
{
break;
}
}
}
else
{
isError = true;
}
#endregion
#region create flight trip
if (customerNumber.Length > 0)
{
SAPFlightTrip flightTrip =
new SAPFlightTrip(Config.SAPUserName, Config.SAPPassword);
for (int idx = 0; idx < flights.Length; idx++)
{
SeedEventDataList item = flights[idx];
string tripNumber;
string travelAgencyNumber;
if (flightTrip.CreateTrip(
item.AgencyNum,
item.ClassType,
customerNumber,
item.FlightConnNo,
"",
item.FlightDate,
"",
"none",
dob,
customerName,
out travelAgencyNumber,
out tripNumber))
{
flights[idx].TripNumber = tripNumber;
}
else
{
isError = true;
}
}
}
#endregion
#region save to local db
if (!isError)
{
int eventAttendeeID = 0;
SAPEventAttendeeReadWrite eventAttendee =
new SAPEventAttendeeReadWrite(Config._dbConnectionName);
DateTime dateCreate;
eventAttendee.Insert(
rdrPackage.PackageID,
customerNumber,
DateTime.Now,
out dateCreate,
out eventAttendeeID);
for (int idx = 0; idx < flights.Length; idx++)
{
int eventAttendMapID = 0;
SAPEventAttendeeAgencyMapReadWrite eventMap =
new SAPEventAttendeeAgencyMapReadWrite(Config._dbConnectionName);
eventMap.Insert(
eventAttendeeID,
flights[idx].EventID,
flights[idx].AgencyNum,
flights[idx].TripNumber,
out eventAttendMapID);
}
}
#endregion
currentNameIndex++;
}
//reset flights
for (int idx = 0; idx < flights.Length; idx++)
{
flights[idx].AgencyNum = string.Empty;
flights[idx].ClassType = string.Empty;
flights[idx].FlightConnNo = string.Empty;
flights[idx].FlightDate = string.Empty;
flights[idx].TripNumber = string.Empty;
}
}
}
}
}
}
#endregion
Config.UpdateKey(Config._keySeedData, "true");
Config.UpdateKey(Config._keyDateLastSeed, DateTime.Now.ToString());
}
