private void insertPackage(string[] pids, string fbId, string username, string[] photos, string packName, DateTime now)
{
//insert package
using (var dbcon = new TourCrowDBEntities())
{
var pack_insert_query = new PACKAGE {
UserFBID = fbId, Date = now, Title = packName
};
dbcon.PACKAGEs.Add(pack_insert_query);
dbcon.SaveChanges();
//( packName.ToString() == null ? Convert.ToString(DateTime.Now) : packName.ToString() )
//get package id
var get_packid = from pckid in dbcon.PACKAGEs
where pckid.UserFBID == fbId.ToString()
select pckid.PackageID;
var packid = get_packid.AsEnumerable().LastOrDefault();
for (int i = 0, j = 0; i < pids.Count() && j < photos.Count(); i++, j++)
{
var userpack_insert_query = new USER_PACKAGE
{
PackageID = Convert.ToInt32(packid),
PlaceID = pids[i],
PhotoKey = photos[i]
};
dbcon.USER_PACKAGE.Add(userpack_insert_query);
dbcon.SaveChanges();
}
}
}
private void insertPackage(string[] pids,string fbId,string username,string[] photos, string packName, DateTime now)
{
//insert package
using (var dbcon = new TourCrowDBEntities())
{
var pack_insert_query = new PACKAGE {UserFBID = fbId, Date = now, Title = packName};
dbcon.PACKAGEs.Add(pack_insert_query);
dbcon.SaveChanges();
//( packName.ToString() == null ? Convert.ToString(DateTime.Now) : packName.ToString() )
//get package id
var get_packid = from pckid in dbcon.PACKAGEs
where pckid.UserFBID == fbId.ToString()
select pckid.PackageID;
var packid = get_packid.AsEnumerable().LastOrDefault();
for (int i = 0, j = 0; i < pids.Count() && j < photos.Count(); i++, j++)
{
var userpack_insert_query = new USER_PACKAGE
{
PackageID = Convert.ToInt32(packid),
PlaceID = pids[i],
PhotoKey = photos[i]
};
dbcon.USER_PACKAGE.Add(userpack_insert_query);
dbcon.SaveChanges();
}
}
}
