// Code to execute when the application is launching (eg, from Start) // This code will not execute when the application is reactivated private void Application_Launching(object sender, LaunchingEventArgs e) { Database db=new Database(Database.connectStr); if (!db.DatabaseExists()) { db.CreateDatabase(); //List<ItemTable> Items = new List<ItemTable>() // { // new ItemTable(){UserId=1,CategoryId=1,Name="Phone",Num=1}, // new ItemTable(){UserId=2,CategoryId=4,Name="Icon",Num=10}, // new ItemTable(){UserId=3,CategoryId=1,Name="TV",Num=1}, // new ItemTable(){UserId=4,CategoryId=4,Name="Aluminum",Num=10}, // new ItemTable(){UserId=1,CategoryId=1,Name="MP3MP4",Num=2}, // new ItemTable(){UserId=1,CategoryId=1,Name="Computer",Num=1}, // new ItemTable(){UserId=3,CategoryId=2,Name="Cloths",Num=10}, // new ItemTable(){UserId=3,CategoryId=4,Name="Copper",Num=10}, // new ItemTable(){UserId=4,CategoryId=2,Name="Shoes",Num=10}, // new ItemTable(){UserId=4,CategoryId=3,Name="Bottle",Num=10}, // new ItemTable(){UserId=2,CategoryId=3,Name="Bottle",Num=10}, // }; //#region[data] List<CategoryTable> categorys = new List<CategoryTable>() { new CategoryTable(){Name="E_Waste"}, new CategoryTable(){Name="Fabric"}, new CategoryTable(){Name="Glass"}, new CategoryTable(){Name="Metal"}, new CategoryTable(){Name="Paper"}, new CategoryTable(){Name="Plastic"} }; // //List<UserTable> users = new List<UserTable>() // // { // // new UserTable(){UserName="******",Longitude=-73.996847,Latitude=40.737665}, // // new UserTable(){UserName="******",Longitude=-73.995441,Latitude=40.739271}, // // new UserTable(){UserName="******",Longitude=-73.998671,Latitude=40.739913}, // // new UserTable(){UserName="******",Longitude=-73.997083,Latitude=40.737421}, // // new UserTable(){UserName="******",Longitude=-73.996900,Latitude=40.739868}, // // new UserTable(){UserName="******",Longitude=-73.994669,Latitude=40.7404470}, // // }; // List<ItemTable> Items = new List<ItemTable>() // { // new ItemTable(){UserId=1,CategoryId=1,Name="Phone",Num=1,AvatarUri="/Image_Acquirer/Detail/ItemImage/5.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=2,CategoryId=4,Name="Icon",Num=10,AvatarUri="/Image_Acquirer/Detail/ItemImage/4.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=3,CategoryId=1,Name="TV",Num=1,AvatarUri="/Image_Acquirer/Detail/ItemImage/5.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=4,CategoryId=4,Name="Aluminum",Num=30,AvatarUri="/Image_Acquirer/Detail/ItemImage/4.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=5,CategoryId=1,Name="MP3MP4",Num=2,AvatarUri="/Image_Acquirer/Detail/ItemImage/5.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=6,CategoryId=1,Name="Computer",Num=1,AvatarUri="/Image_Acquirer/Detail/ItemImage/5.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=2,CategoryId=2,Name="Cloths",Num=10,AvatarUri="/Image_Acquirer/Detail/ItemImage/1.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=3,CategoryId=4,Name="Copper",Num=10,AvatarUri="/Image_Acquirer/Detail/ItemImage/4.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=4,CategoryId=2,Name="Shoes",Num=10,AvatarUri="/Image_Acquirer/Detail/ItemImage/1.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=5,CategoryId=3,Name="Bottle",Num=10,AvatarUri="/Image_Acquirer/Detail/ItemImage/2.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=1,CategoryId=3,Name="Bottle",Num=10,AvatarUri="/Image_Acquirer/Detail/ItemImage/2.jpg",Time="3/22/2012"}, // new ItemTable(){UserId=6,CategoryId=5,Name="Paper",Num=30,AvatarUri="/Image_Acquirer/Detail/ItemImage/3.jpg"}, // }; // List<UserTable> users = new List<UserTable>() // { // new UserTable(){UserName="******",Longitude=-73.998847m,Latitude=40.737665m,Point=130,City="WuHan",LastRank=6,AvatarUri="/Image_Home/Avatar/0.jpg"}, // new UserTable(){UserName="******",Longitude=-73.995441m,Latitude=40.737271m,Point=230,City="XiaMen",LastRank=2,AvatarUri="/Image_Home/Avatar/1.jpg"}, // new UserTable(){UserName="******",Longitude=-73.998671m,Latitude=40.739913m,Point=120,City="ChangSha",LastRank=1,AvatarUri="/Image_Home/Avatar/2.jpg"}, // new UserTable(){UserName="******",Longitude=-73.997083m,Latitude=40.735421m,Point=112,City="XiaMen",LastRank=3,AvatarUri="/Image_Home/Avatar/3.jpg"}, // new UserTable(){UserName="******",Longitude=-73.992900m,Latitude=40.739868m,Point=113,City="WuHan",LastRank=4,AvatarUri="/Image_Home/Avatar/4.jpg"}, // new UserTable(){UserName="******",Longitude=-73.994669m,Latitude=40.7404470m,Point=202,City="GuangZhou",LastRank=5,AvatarUri="/Image_Home/Avatar/5.jpg"}, // }; // List<CityTable> citys = new List<CityTable>() // { // new CityTable(){Name="WuHan",Point=120,LastRank=6}, // new CityTable(){Name="ChangSha",Point=200,LastRank=2}, // new CityTable(){Name="XiaMen",Point=100,LastRank=1}, // new CityTable(){Name="BeiJing",Point=210,LastRank=3}, // new CityTable(){Name="SiChuan",Point=130,LastRank=4}, // new CityTable(){Name="GuangZhou",Point=200,LastRank=5}, // }; // List<FriendTable> friends = new List<FriendTable>() // { // new FriendTable(){UserId=1,FriendId=2}, // new FriendTable(){UserId=1,FriendId=3}, // new FriendTable(){UserId=1,FriendId=4}, // new FriendTable(){UserId=1,FriendId=5}, // new FriendTable(){UserId=1,FriendId=6} // }; // List<PostTrendTable> Posttrends = new List<PostTrendTable>() // { // new PostTrendTable(){UserId=2,Describe="Post Some new Resource Information",Time="3/22/2012 ",PostAffect="This behavior will prevent 1000m forest from destroy and prevent 1000m water from being pulluted"}, // new PostTrendTable(){UserId=2,Describe="Post Some new Resource Information",Time="3/21/2012 ",PostAffect="This behavior will prevent 1000m forest from destroy and prevent 1000m water from being pulluted"}, // new PostTrendTable(){UserId=2,Describe="Post Some new Resource Information",Time="3/22/2012",PostAffect="This behavior will prevent 1000m forest from destroy and prevent 1000m water from being pulluted"}, // new PostTrendTable(){UserId=2,Describe="Post Some new Resource Information",Time="3/22/2012",PostAffect="This behavior will prevent 1000m forest from destroy and prevent 1000m water from being pulluted"}, // new PostTrendTable(){UserId=2,Describe="Post Some new Resource Information",Time="3/12/2012",PostAffect="This behavior will prevent 1000m forest from destroy and prevent 1000m water from being pulluted"}, // new PostTrendTable(){UserId=2,Describe="Post Some new Resource Information",Time="3/21/2012",PostAffect="This behavior will prevent 1000m forest from destroy and prevent 1000m water from being pulluted"}, // }; // List<PhotoTrendTable> Phototrends = new List<PhotoTrendTable>() // { // new PhotoTrendTable(){UserId=2,ImageUri="/Image_Acquirer/Detail/ItemImage/5.jpg",Describe="Post Some new Resource Information",Time="3/22/2012 "}, // new PhotoTrendTable(){UserId=2,ImageUri="/Image_Acquirer/Detail/ItemImage/3.jpg",Describe="Post Some new Resource Information",Time="3/21/2012 "}, // new PhotoTrendTable(){UserId=2,ImageUri="/Image_Acquirer/Detail/ItemImage/2.jpg",Describe="Post Some new Resource Information",Time="3/22/2012"}, // new PhotoTrendTable(){UserId=2,ImageUri="/Image_Acquirer/Detail/ItemImage/1.jpg",Describe="Post Some new Resource Information",Time="3/22/2012",}, // new PhotoTrendTable(){UserId=2,ImageUri="/Image_Acquirer/Detail/ItemImage/4.jpg",Describe="Post Some new Resource Information",Time="3/22/2012"}, // new PhotoTrendTable(){UserId=2,ImageUri="/Image_Acquirer/Detail/ItemImage/1.jpg",Describe="Post Some new Resource Information",Time="3/21/2012"}, // }; // List<AchievementTrendTable> Achievementtrends = new List<AchievementTrendTable>() // { // new AchievementTrendTable(){UserId=2,ImageUri="/Image_Friends/crown.png",Time="3/22/2012",Achievement="rose to No.4"}, // new AchievementTrendTable(){UserId=2,ImageUri="/Image_Friends/crown.png",Time="3/21/2012",Achievement="rose to No.7"}, // new AchievementTrendTable(){UserId=2,ImageUri="/Image_Friends/crown.png",Time="3/22/2012",Achievement="get a title of"}, // new AchievementTrendTable(){UserId=2,ImageUri="/Image_Friends/crown.png",Time="3/22/2012",Achievement="rose to No.2"}, // new AchievementTrendTable(){UserId=2,ImageUri="/Image_Friends/crown.png",Time="3/21/2012",Achievement="rose to No.4"}, // new AchievementTrendTable(){UserId=2,ImageUri="/Image_Friends/crown.png",Time="3/21/2012",Achievement="rose to No.4"}, // }; // List<AcquirerTable> acquirers = new List<AcquirerTable>() // { // new AcquirerTable(){ // UserName="******", // BinName="Hust Resource bin", // Longitude=114.454m, // Latitude=30.50m, // City="WuHan", // AvatarUri="/Image_Home/Avatar/0.jpg", // Address="Hust qin yuan shi dong 430", // Phone="15527263237"}, // new AcquirerTable(){ // UserName="******", // BinName="Hust Resource bin", // Longitude=114.452m, // Latitude=30.501m, // City="XiaMen", // AvatarUri="/Image_Home/Avatar/1.jpg", // Address="Hust qin yuan shi dong 430", // Phone="15527263237"}, // new AcquirerTable(){ // UserName="******", // BinName="Hust Resource bin", // Longitude=114.451m, // Latitude=30.507m, // City="ChangSha", // AvatarUri="/Image_Home/Avatar/2.jpg", // Address="Hust qin yuan shi dong 430", // Phone="15527263237"}, // new AcquirerTable(){ // UserName="******", // BinName="Hust Resource bin", // Longitude=114.451m, // Latitude=30.507m, // City="XiaMen", // AvatarUri="/Image_Home/Avatar/3.jpg", // Address="Hust qin yuan shi dong 430", // Phone="15527263237"}, // new AcquirerTable(){ // UserName="******", // BinName="Hust Resource bin", // Longitude=114.453m, // Latitude=30.505m, // City="WuHan", // AvatarUri="/Image_Home/Avatar/4.jpg", // Address="Hust qin yuan shi dong 430",Phone="15527263237"}, // new AcquirerTable(){UserName="******",BinName="Hust Resource bin", // Longitude=-73.994669m, // Latitude=40.7404470m, // City="GuangZhou", // AvatarUri="/Image_Home/Avatar/5.jpg", // Address="Hust qin yuan shi dong 430", // Phone="15527263237"}, // }; List<RewardTable> rewards = new List<RewardTable>() { new RewardTable(){StoreName="视佳医眼镜", Summary="换取50元的优惠券", Points=1000, Describe="即日起,凡在本店购买价值超过150元眼镜的顾客,均可使用Becle的1000积分换取50元的优惠。每人仅可使用一次。本次活动最终解释权归视佳医眼镜所有", Longitude=114.41835250865400000m, Latitude=30.51626398490010000m, City="武汉", AvatarUri="/Image_Recycle/RewardItem/glasses.jpg", Address="光谷/鲁巷/视佳医眼镜", Phone="15578458241"}, new RewardTable(){ StoreName="青苹果宝贝", Summary="换20元减价的优惠券", Points=300, Describe="2012年3月1日起至9月1日,本体验中心推出Becle网站300积分换20元减价的优惠活动。关爱宝宝,从Becle开始", Longitude=114.40866406921800000m, Latitude=30.50970770947070000m, City="武汉", AvatarUri="/Image_Recycle/RewardItem/baby.jpg", Address="光谷/鲁巷/视佳医眼镜", Phone="027-85413254"}, new RewardTable(){ StoreName="中百仓储", Summary="兑换享受20元优惠券", Points=100, Describe="即日起至2012年9月1日,凡购买本商场超过200元的顾客,可使用Becle上的100积分兑换享受20元优惠", Longitude=114.43153115537700000m, Latitude=30.50533823583970000m, City="武汉", AvatarUri="/Image_Recycle/RewardItem/discount.png", Address="光谷/鲁巷", Phone="027-85471212"}, new RewardTable(){ StoreName="喻园超市", Summary="换取20元优惠券", Points=200, Describe="即日起至2013年1月1日,在喻园小区超市一次性消费超过50元的本校学生,可用Becle的200积分换取20元优惠。每次消费仅可使用一次。", Longitude=114.40866406921800000m, Latitude=30.50533823583970000m, City="武汉", AvatarUri="/Image_Recycle/RewardItem/surpermarket.jpg", Address="关山口/华科", Phone="027-85471212" }, }; // List<MessageTable> messages = new List<MessageTable>() // { // new MessageTable(){FromId=1,ToId=1,IsSee=false,Time="3/22/2012",Message="Hust recycle bin will come to recycle paper & metal in your area in 3/24/2012 10:00 AM!"}, // new MessageTable(){FromId=2,ToId=1,IsSee=false,Time="3/23/2012",Message="Yuyuan recycle bin will come to recycle plastic & metal & paper in your area in 3/24/2012 10:00 AM! "}, // new MessageTable(){FromId=3,ToId=1,IsSee=false,Time="3/22/2012",Message="QiMing recycle bin will come to recycle plastic & metal & paper in your area in 3/24/2012 10:00 AM! "}, // }; // List<ConfirmMessageTable> confrimMessages = new List<ConfirmMessageTable>() // { // new ConfirmMessageTable(){FromId=1,ToId=1,IsSee=false,Title="e-waste & metal", Time="3/22/2012",Message="Hust recycle bin recycle paper resourse in your area and your paper cups,paper box are in the confines .Do you want to confirm that these resourses have been recycled? "}, // new ConfirmMessageTable(){FromId=2,ToId=1,IsSee=false,Title="paper", Time="3/23/2012",Message="Hust recycle bin recycle paper resourse in your area and your paper cups,paper box are in the confines .Do you want to confirm that these resourses have been recycled? "}, // new ConfirmMessageTable(){FromId=3,ToId=1,IsSee=false, Title="metal & glass & plastic",Time="3/22/2012",Message="Hust recycle bin recycle paper resourse in your area and your paper cups,paper box are in the confines .Do you want to confirm that these resourses have been recycled? "}, // new ConfirmMessageTable(){FromId=3,ToId=1,IsSee=false, Title="metal & glass & plastic",Time="3/22/2012",Message="Hust recycle bin recycle paper resourse in your area and your paper cups,paper box are in the confines .Do you want to confirm that these resourses have been recycled? "}, // new ConfirmMessageTable(){FromId=3,ToId=1,IsSee=false, Title="metal & fabric & plastic",Time="3/22/2012",Message="Hust recycle bin recycle paper resourse in your area and your paper cups,paper box are in the confines .Do you want to confirm that these resourses have been recycled? "}, // new ConfirmMessageTable(){FromId=3,ToId=1,IsSee=false, Title="Paper & glass & plastic & metal",Time="3/22/2012",Message="Hust recycle bin recycle paper resourse in your area and your paper cups,paper box are in the confines .Do you want to confirm that these resourses have been recycled? "}, // }; // #endregion // db.ConfirmMessages.InsertAllOnSubmit(confrimMessages); // db.Messages.InsertAllOnSubmit(messages); // db.Acquirers.InsertAllOnSubmit(acquirers); db.Rewards.InsertAllOnSubmit(rewards); // db.PostTrends.InsertAllOnSubmit(Posttrends); // db.PhotoTrends.InsertAllOnSubmit(Phototrends); // db.AchievementTrends.InsertAllOnSubmit(Achievementtrends); //db.Friends.InsertAllOnSubmit(friends); //db.Citys.InsertAllOnSubmit(citys); //db.Items.InsertAllOnSubmit(Items); //db.Users.InsertAllOnSubmit(users); db.Categorys.InsertAllOnSubmit(categorys); //db.SubmitChanges(); } //db.ConfirmMessages.DeleteAllOnSubmit(db.ConfirmMessages); //db.Messages.DeleteAllOnSubmit(db.Messages); db.Acquirers.DeleteAllOnSubmit(db.Acquirers); // db.Rewards.DeleteAllOnSubmit(db.Rewards); db.PostTrends.DeleteAllOnSubmit(db.PostTrends); db.PhotoTrends.DeleteAllOnSubmit(db.PhotoTrends); db.AchievementTrends.DeleteAllOnSubmit(db.AchievementTrends); db.Friends.DeleteAllOnSubmit(db.Friends); db.Citys.DeleteAllOnSubmit(db.Citys); db.Items.DeleteAllOnSubmit(db.Items); db.Users.DeleteAllOnSubmit(db.Users); // db.Categorys.DeleteAllOnSubmit(db.Categorys); db.DataUsers.DeleteAllOnSubmit(db.DataUsers); db.SubmitChanges(); }