public VolunteerPlanVM() { db = new Database(Database.connectStr); Dic_Unfinish = new Dictionary<string, ObservableCollection<RecyclePlanModel>>(); ListPlan_Un = new ObservableCollection<string>(); ListUser_Un = new ObservableCollection<RecyclePlanModel>(); foreach (VolunteerPlanTable plan in db.VolunteerPlans.Where(c => c.IsFinish == false)) { ListUser_Un.Clear(); foreach (VolunteerPlanShipTable ship in db.VolunteerPlanShips.Where(c => c.PlanId == plan.Id)) { RecyclePlanModel model = new RecyclePlanModel() { UserName = db.Users.Single(c => c.Id == ship.UserId).UserName, Address = db.Users.Single(c => c.Id == ship.UserId).Address, IsFinish = plan.IsFinish, IsCheck = ship.IsCheck, UserId = ship.UserId, ShipId = ship.Id, }; ListUser_Un.Add(model); } if (!Dic_Unfinish.Keys.Contains(plan.Time)) Dic_Unfinish.Add(plan.Time, ListUser_Un); else { Dic_Unfinish.Add(plan.Time + " ", ListUser_Un); } } foreach (VolunteerPlanTable plan in db.VolunteerPlans.Where(c => c.IsFinish == true)) { ListUser_Un.Clear(); foreach (VolunteerPlanShipTable ship in db.VolunteerPlanShips.Where(c => c.PlanId == plan.Id)) { RecyclePlanModel model = new RecyclePlanModel() { UserName = db.Users.Single(c => c.Id == ship.UserId).UserName, Address = db.Users.Single(c => c.Id == ship.UserId).Address, IsFinish = plan.IsFinish, IsCheck = ship.IsCheck, UserId = ship.UserId, ShipId = ship.Id, }; ListUser_Un.Add(model); } if (!Dic_Unfinish.Keys.Contains(plan.Time)) Dic_Unfinish.Add(plan.Time, ListUser_Un); else { Dic_Unfinish.Add(plan.Time + " ", ListUser_Un); } } }
public AcquirerVM(CallBack _callback1, CallBack _callback2, CallBack _callback3) { db = new Database(Database.connectStr); callback1 = _callback1; callback2 = _callback2; callback3 = _callback3; acquirerId = (App.Current as App).AcquirerId; client.GetResidentsAsync(acquirerId); client.GetAcquirerInfoAsync(acquirerId); client.GetAcquirerInfoCompleted += new EventHandler<GetAcquirerInfoCompletedEventArgs>(client_GetAcquirerInfoCompleted); client.GetItemsCompleted += new EventHandler<GetItemsCompletedEventArgs>(client_GetItemsCompleted); client.GetResidentsCompleted += new EventHandler<GetResidentsCompletedEventArgs>(client_GetResidentsCompleted); client.GetAciquirer_MessagesCompleted += new EventHandler<GetAciquirer_MessagesCompletedEventArgs>(client_GetAciquirer_MessagesCompleted); }
public MessageVM() { db = new Database(Database.connectStr); List_ConfirmMessages = new ObservableCollection<ConfirmMessageModel>(); List_Messages = new ObservableCollection<MessageModel>(); if ((App.Current as App).UserId == 0) { getUserInfo(); } else { client.GetMessgeAsync((App.Current as App).UserId); client.GetMessgeCompleted += new EventHandler<GetMessgeCompletedEventArgs>(client_GetMessgeCompleted); } }
public VolunteerVM(CallBack _callback1, CallBack _callback2, CallBack _callback3) { db = new Database(Database.connectStr); callback1 = _callback1; callback2 = _callback2; callback3 = _callback3; acquirerId = (App.Current as App).UserId; acquirerInfo = (App.Current as App).Userinfo; //client.GetResidentsAsync(acquirerId); // client.GetAcquirerInfoAsync(acquirerId); // client.GetAcquirerInfoCompleted += new EventHandler<GetAcquirerInfoCompletedEventArgs>(client_GetAcquirerInfoCompleted); client.GetResidents_VAsync(acquirerId); client.GetItems_VCompleted += new EventHandler<GetItems_VCompletedEventArgs>(client_GetItems_VCompleted); client.GetResidents_VCompleted += new EventHandler<GetResidents_VCompletedEventArgs>(client_GetResidents_VCompleted); }
public RewardVM (int id,CallBack callback) { db = new Database(Database.connectStr); List_RewardModel = new List<RewardModel>(); // UserTable user = db.Users.Single(c => c.Id == id); Title = "Rewrad List"; //List<RewardTable> list_Acquirer = db.Rewards.Where(c => Math.Abs(c.Latitude - user.Latitude) < 1 && Math.Abs(c.Longitude - user.Longitude) < 1).ToList<RewardTable>(); if (db.Rewards.Count() == 0) { PublisherServiceClient client = new PublisherServiceClient(); client.GetRewardAsync(id); client.GetRewardCompleted += new EventHandler<GetRewardCompletedEventArgs>(client_getRewardCompleted); } else { getList_RewardModel(); } }
public FriendVM(int id, Callback _callback1, Callback _callback2, Callback _callback3) { callback1 = _callback1; callback2 = _callback2; callback3 = _callback3; db = new Database(Database.connectStr); list_PostModel = new ObservableCollection<PostModel>(); list_UnloadModel = new ObservableCollection<UnloadModel>(); list_AchievementModel = new ObservableCollection<AchievementModel>(); list_FriendId=db.Friends.Where(c=>c.UserId==id).Select(c=>c.FriendId).ToList<int>(); list_FriendId.Add(id); if (db.PostTrends.Count() != 0) { dealWithAchievement(); dealWithPhotoTrend(); dealWithPostTrend(); } else { getTrendFromServer(); } }
public DataVM(int id,DataPage1 _page) { page = _page; string city = (App.Current as App).Userinfo.City; db = new Database(Database.connectStr); Dictionary_User = new Dictionary<int, string>(); Dictionary_City = new Dictionary<int, string>(); client.GetMyPointsAsync(id); client.GethighestPointsAlluserAsync(); client.GetAveragePointsAllUserAsync(); client.GetAveragePointsInCityAsync(city); client.GetHighestPointsInCityAsync(city); client.GetMyRankAsync(id); client.GetMyCityRankAsync(id); client.GetMyRankCompleted+=new EventHandler<GetMyRankCompletedEventArgs>(client_GetMyRankCompleted); client.GetMyCityRankCompleted += new EventHandler<GetMyCityRankCompletedEventArgs>(client_GetMyCityRankCompleted); client.GetMyPointsCompleted += new EventHandler<GetMyPointsCompletedEventArgs>(client_GetMyPointsCompleted); client.GethighestPointsAlluserCompleted += new EventHandler<GethighestPointsAlluserCompletedEventArgs>(client_GethighestPointsAlluserCompleted); client.GetAveragePointsAllUserCompleted += new EventHandler<GetAveragePointsAllUserCompletedEventArgs>(client_GetAveragePointsAllUserCompleted); client.GetAveragePointsInCityCompleted += new EventHandler<GetAveragePointsInCityCompletedEventArgs>(client_GetAveragePointsInCityCompleted); client.GetHighestPointsInCityCompleted += new EventHandler<GetHighestPointsInCityCompletedEventArgs>(client_GetHighestPointsInCityCompleted); client.GetRankUserCompleted += new EventHandler<GetRankUserCompletedEventArgs>(client_GetRankUserCompleted); client.GetRankCityCompleted += new EventHandler<GetRankCityCompletedEventArgs>(client_GetRankCityCompleted); if (db.DataUsers.Count() == 0) { client.GetRankCityAsync(); client.GetRankUserAsync(); } else { //db.DataUsers.DeleteAllOnSubmit(db.DataUsers); //db.Citys.DeleteAllOnSubmit(db.Citys); //client.GetRankCityAsync(); //client.GetRankUserAsync(); dealWithRankList(); } }
public RecycleVM(int id,CallBack _callback,CallBack _callback1) { callback = _callback; callback1 = _callback1; userId = id; db = new Database(Database.connectStr); List<AcquirerTable> list = db.Acquirers.ToList(); if (db.Acquirers.Count() == 0) { client.GetAcquirerAsync(userId); client.GetAcquirerCompleted += new EventHandler<GetAcquirerCompletedEventArgs>(client_GetAcquirerCompleted); } client.GetMessgeCompleted += new EventHandler<GetMessgeCompletedEventArgs>(client_GetMessgeCompleted); Title = "Recycle List"; }
// 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(); }