public static Apply_record GetApplyRecord(int recordId) { using (var context = new DataModels()) { return(context.Apply_record.Find(recordId)); } }
public static Apply_record GetLastApplyRecordbySenderID(string senderID) { using (var context = new DataModels()) { return(context.Apply_record.Where(r => r.sender_id == senderID).Last()); } }
/// <summary> /// 获取全部虚拟机 /// </summary> /// <returns></returns> private static List <VMConfig> GetAllVm() { List <VMConfig> configs; if (ManagerType.Equals("Sangfor")) { configs = restful.GetVMList(SangforDao.GetAllId()); configs = SangforDao.MergeData(configs); } else { configs = manager.GetVMList(); using (var context = new DataModels()) { List <VirtualMachine> virtualMachines = context.VirtualMachines.ToList(); foreach (var vm in virtualMachines) { var conf = configs.FirstOrDefault(c => c.Name.Equals(vm.vm_name)); if (conf != null) { conf.due_time = vm.due_time; } } } } return(configs); }
public static List <Apply_record> GetAllApplyRecord() { using (var context = new DataModels()) { return(context.Apply_record.ToList()); } }
void IBlogEngine.AddEntry(DataModels.Entry blogEntry) { using (IBlogService DataService = new BlogEngineDataService(this.Config)) { DataService.AddBlogEntry(blogEntry); } }
public static void insertNewPenaltyIntoDb(GameViewModel game, ManagementContext db, SkaterInPenaltyBoxViewModel pen, DataModels.Game.Game g) { try { var m = GameMemberClass.getMemberOfTeamInGame(pen.PlayerSentToBox.SkaterId, g); if (m != null) { GameMemberPenaltyBox penalty = new GameMemberPenaltyBox(); penalty.PenaltyNumberForSkater = pen.PenaltyNumberForSkater; penalty.Member = m; penalty.GameTimeMilliSecondsSent = pen.GameTimeInMillisecondsSent; penalty.GameTimeMilliSecondsReturned = pen.GameTimeInMillisecondsReleased; penalty.JamNumberReturned = pen.JamNumberReleased; penalty.JamIdReturned = pen.JamIdReleased; penalty.JamIdSent = pen.JamIdSent; penalty.JamTimeMilliSecondsReturned = pen.JamTimeInMillisecondsReleased; penalty.JamTimeMilliSecondsSent = pen.JamTimeInMillisecondsSent; penalty.Game = g; penalty.PenaltyIdFromGame = pen.PenaltyId; penalty.PenaltyType = pen.PenaltyType.ToString(); db.GameMemberPenaltyBox.Add(penalty); db.SaveChanges(); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
public UserInfo(DataModels.Twitter.User user) { Id = user.Id; Name = user.Name.Trim(); ScreenName = user.ScreenName; Location = user.Location; Description = user.Description; try { ImageUrl = new Uri(user.ProfileImageUrl); } catch (Exception) { ImageUrl = null; } Url = user.Url; Protect = user.Protected; FriendsCount = user.FriendsCount; FollowersCount = user.FollowersCount; CreatedAt = MyCommon.DateTimeParse(user.CreatedAt); StatusesCount = user.StatusesCount; Verified = user.Verified; //// isFollowing = isFollowing; if (user.Status == null) return; RecentPost = user.Status.Text; PostCreatedAt = MyCommon.DateTimeParse(user.Status.CreatedAt); PostSource = user.Status.Source; }
/// <summary> /// updates the penalty box DB with new information /// </summary> /// <param name="game"></param> /// <param name="cachedGame"></param> /// <param name="db"></param> /// <param name="pen"></param> public static void updatePenaltyBoxInDb(GameViewModel game, ManagementContext db, SkaterInPenaltyBoxViewModel pen, DataModels.Game.Game g) { try { var cachedPen = g.GameMemberPenaltyBox.Where(x => x.PenaltyIdFromGame == pen.PenaltyId).FirstOrDefault(); if (cachedPen == null) insertNewPenaltyIntoDb(game, db, pen, g); else { cachedPen.GameTimeMilliSecondsReturned = pen.GameTimeInMillisecondsReleased; cachedPen.GameTimeMilliSecondsSent = pen.GameTimeInMillisecondsSent; cachedPen.JamNumberReturned = pen.JamNumberReleased; cachedPen.JamNumberSent = pen.JamNumberSent; cachedPen.JamIdReturned = pen.JamIdReleased; cachedPen.JamIdSent = pen.JamIdSent; cachedPen.JamTimeMilliSecondsReturned = pen.JamTimeInMillisecondsReleased; cachedPen.JamTimeMilliSecondsSent = pen.JamTimeInMillisecondsSent; cachedPen.PenaltyType = pen.PenaltyType.ToString(); db.SaveChanges(); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
public static void insertBlockIntoDb(Guid teamId, GameViewModel game, BlockViewModel block, ManagementContext db, DataModels.Game.Game g) { try { GameMemberBlock blocks = new GameMemberBlock(); blocks.DateTimeBlocked = block.CurrentDateTimeBlock; blocks.GameBlockId = block.BlockId; blocks.JamNumber = block.JamNumber; blocks.JamId = block.JamId; blocks.PeriodNumber = block.Period; blocks.PeriodTimeRemainingMilliseconds = block.PeriodTimeRemaining; blocks.Game = g; blocks.MemberWhoBlocked = g.GameTeams.Where(x => x.TeamId == teamId).First().GameMembers.Where(x => x.GameMemberId == block.PlayerWhoBlocked.SkaterId).FirstOrDefault(); if (blocks.MemberWhoBlocked != null) { db.GameMemberBlock.Add(blocks); db.SaveChanges(); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
public static int insertAssistIntoDb(Guid teamId, GameViewModel game, AssistViewModel assisted, ManagementContext db, DataModels.Game.Game g) { int c = 0; try { GameMemberAssist assist = new GameMemberAssist(); assist.DateTimeAssisted = assisted.CurrentDateTimeAssisted; assist.GameAssistId = assisted.AssistId; assist.JamNumber = assisted.JamNumber; assist.JamId = assisted.JamId; assist.PeriodNumber = assisted.Period; assist.PeriodTimeRemainingMilliseconds = assisted.PeriodTimeRemaining; assist.Game = g; assist.MemberWhoAssisted = g.GameTeams.Where(x => x.TeamId == teamId).First().GameMembers.Where(x => x.GameMemberId == assisted.PlayerWhoAssisted.SkaterId).FirstOrDefault(); if (assist.MemberWhoAssisted != null) { db.GameMemberAssist.Add(assist); c += db.SaveChanges(); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return c; }
private async Task <bool> TestEditContact(string id, string first_name, string last_name, string nickname, string image, string email, string phone, string phone_2, string skype, string country, string city, string status) { var jObj = DataModels.GetDataModelUserInfo(id, first_name, last_name, nickname, image, email, phone, phone_2, skype, country, city, status); var modelExp = WebMsgParser.ParseResponsePersonalInfo(jObj.ToString()); var statusCode = await _requests.Auth(email); if (statusCode != HttpStatusCode.OK) { return(false); } var response = await _requests.UpdateEditContactInfo(email, skype, country, city, phone); if (response.StatusCode != HttpStatusCode.OK) { return(false); } var responseStream = new StreamReader(response.Content.ReadAsStreamAsync().Result); var responseString = responseStream.ReadToEnd(); responseStream.Dispose(); var modelAct = WebMsgParser.ParseResponsePersonalInfo(responseString); var result = modelExp.Equals(modelAct); return(result); }
public static List <string> GetUsersInDepart(string departId) { using (var dbContext = new DataModels()) { return(dbContext.Users.Where(u => u.department_id == departId).Select(u => u.id).ToList()); } }
void IBlogService.AddBlogEntry(DataModels.Entry entry) { var Blog = this.Repository.GetBlogs().FirstOrDefault(b => b.Id == entry.BlogId); if (Blog != null) { var Entry = this.Repository.GetEntries().FirstOrDefault(e => e.Id == entry.Id && e.BlogId == entry.BlogId); if (Entry != null) { this.Repository.Attach(entry); } else { Entry = this.Repository.CreateEntry(); } Entry.BlogId = entry.BlogId; Entry.CreateDate = entry.CreateDate; Entry.EditedDate = entry.EditedDate; Entry.EntryText = entry.EntryText; Entry.IsRawHtml = entry.IsRawHtml; Entry.Tags = entry.Tags; Entry.Title = entry.Title; this.Repository.Save(); } }
/* * Create By xzy *互评分数结算 * 2019/8/1 */ public static string ComputeFinalScore(string stuId, int expId) { using (var dbContext = new DataModels()) { Assignment assignment = dbContext.Assignments.Where(a => a.student_id == stuId && a.experiment_id == expId).First(); List <Peer_assessment> pa = dbContext.Peer_assessment.Where(p => p.student_id == stuId && p.experiment_id == expId).ToList(); int cnt = 0; float res = 0; if (assignment.score == null) { foreach (var temp_pa in pa) { if (temp_pa.score != null) { cnt++; res += (float)temp_pa.score; } } if (cnt != 0) { assignment.score = res / cnt; dbContext.SaveChanges(); return(assignment.score.ToString()); } else { return("评分数量为0"); } } else { return(assignment.score.ToString()); } } }
public static int DeepCompareOfficialReviewsToDb(GameViewModel game, ManagementContext db, DataModels.Game.Game gameNew) { try { if (game.OfficialReviews != null) { foreach (var member in game.OfficialReviews) { var review = gameNew.OfficialReviews.Where(x => x.OfficialReviewIdFromGame == member.OfficialReviewId).FirstOrDefault(); if (review == null) AddOfficialReview(game, gameNew, member); else { review.TeamNumber = (byte)member.TeamNumber; review.Details = member.Details; review.Result = member.Result; } } } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return db.SaveChanges(); }
public static File GetFileById(string fileId) { using (var dbContext = new DataModels()) { return(dbContext.Files.Find(fileId)); } }
private static void UpdateWebsiteConfirmButton_Click(object sender, RoutedEventArgs e) { Button button = (Button)sender; List <object> data = (List <object>)button.Tag; Website website = (Website)data[0]; TextBox websiteRatingTextBox = (TextBox)data[1]; string websiteRating = websiteRatingTextBox.Text; if (!BackEndHelper.IsNumber(websiteRating)) { MessageBox.Show("Rating must be a number"); return; } int newRating = int.Parse(websiteRating); website.rating = newRating; DataModels database = DataModels.GetInstance(); bool done = database.UpdateWebsite(website); if (done) { MessageBox.Show("Website Updated successfully !"); } else { MessageBox.Show("Couldn't update website"); } }
public void HelloLabel_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { User user = ((LoggedinNavigationCanvas)currentNavigationCanvas).GetActiveUser(); CurrentCanvas.Hide(); InitializeBookingsListShowCanvas(DataModels.GetInstance().GetUserBookings(user)); }
// GET: Customer public ActionResult Index() { using (DataModels db = new DataModels()) { return(View(db.Customers.ToList())); } }
private static void AddWebsiteConfirmButton_Click(object sender, RoutedEventArgs e) { Button button = (Button)sender; List <TextBox> data = (List <TextBox>)button.Tag; string websiteName = data[0].Text; string websiteRating = data[1].Text; if (!BackEndHelper.IsNumber(websiteRating)) { MessageBox.Show("Rating must be a number"); return; } int rating = int.Parse(websiteRating); DataModels database = DataModels.GetInstance(); Website website = new Website(websiteName, rating); bool done = database.AddWebsite(website); if (done) { MessageBox.Show("Website Added successfully !"); } else { MessageBox.Show("Couldn't add website"); } }
public static List <Course> GetAllCourse() { using (var context = new DataModels()) { return(context.Courses.ToList()); } }
// GET: Customer/Delete/5 public ActionResult Delete(int id) { using (DataModels db = new DataModels()) { return(View(db.Customers.Where(x => x.CustomerId == id).FirstOrDefault())); } }
public static List <Assistant> GetAssistantsByStuId(string stuId) { using (var context = new DataModels()) { return(context.Assistants.Where(a => a.student_id == stuId).ToList()); } }
public static List <Course> GetCourseByDepId(string depId) { using (var context = new DataModels()) { return(context.Courses.Where(c => c.department_id == depId).ToList()); } }
/// <summary> /// 获取学院全部 /// created by jyf /// 2019.7.29 /// </summary> /// <returns>List<Department></returns> public static List <Department> GetDepartments() { using (var dbContext = new DataModels()) { return(dbContext.Departments.ToList()); } }
public static List <Assistant> GetAssistantsByCourseId(int courseId) { using (var context = new DataModels()) { return(context.Assistants.Where(a => a.course_id == courseId).ToList()); } }
public static List <Term> GetTerms() { using (var dbContext = new DataModels()) { return(dbContext.Terms.ToList()); } }
/// <summary> /// 根据id查看学期名称 /// created by jyf /// 2019.7.23 /// </summary> /// <param name="id"></param> /// <returns>Term</returns> public static Term GetTermById(int id) { using (var dbContext = new DataModels()) { return(dbContext.Terms.Find(id)); } }
private static void AddReviewConfirmButton_Click(object sender, RoutedEventArgs e) { DataModels database = DataModels.GetInstance(); Button addRoomButton = (Button)sender; List <object> objects = (List <object>)addRoomButton.Tag; Booking booking = (Booking)objects[0]; TextBox reviewTextBox = (TextBox)objects[1]; TextBox ratingTexyBox = (TextBox)objects[2]; if (!BackEndHelper.IsNumber(ratingTexyBox.Text)) { MessageBox.Show("Rating must be a number !"); return; } bool done = database.AddReview(new Review(reviewTextBox.Text, int.Parse(ratingTexyBox.Text), booking.number)); if (done) { MessageBox.Show("Review submitted"); } else { MessageBox.Show("Error!"); } }
private static void AddOfferConfirmButton_Click(object sender, RoutedEventArgs e) { DataModels database = DataModels.GetInstance(); Button button = (Button)sender; List <object> data = (List <object>)button.Tag; ComboBox websiteCombo = (ComboBox)data[0]; ComboBox HotelCombo = (ComboBox)data[1]; ComboBox RoomCombo = (ComboBox)data[2]; TextBox priceText = (TextBox)data[3]; Website website = (Website)websiteCombo.SelectedItem; Room room = (Room)RoomCombo.SelectedItem; int price = int.Parse(priceText.Text); bool done = database.AddOffer(new Offer(website, room, price)); if (done) { MessageBox.Show("Offer Added successfully !"); } else { MessageBox.Show("Couldn't add offer"); } }
public static void insertScoreIntoDb(Guid teamId, GameViewModel game, ScoreViewModel score, ManagementContext db, DataModels.Game.Game g) { try { GameScore scores = new GameScore(); if (score.CurrentDateTimeScored != new DateTime()) scores.DateTimeScored = score.CurrentDateTimeScored; else scores.DateTimeScored = DateTime.UtcNow; scores.GameScoreId = score.PointId; scores.JamNumber = score.JamNumber; scores.JamId = score.JamId; scores.PeriodNumber = score.Period; scores.PeriodTimeRemainingMilliseconds = score.PeriodTimeRemaining; scores.Point = score.Points; scores.GameTeam = g.GameTeams.Where(x => x.TeamId == teamId).First(); if (score.PlayerWhoScored != null && score.PlayerWhoScored.SkaterId != new Guid()) scores.MemberWhoScored = g.GameTeams.Where(x => x.TeamId == teamId).First().GameMembers.Where(x => x.GameMemberId == score.PlayerWhoScored.SkaterId).FirstOrDefault(); db.GameScore.Add(scores); db.SaveChanges(); } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: "jamId:" + score.JamId + "/ pointId:" + score.PointId); } }
//仅供测试 public static Course GetCourse(int courseId) { using (var dbContext = new DataModels()) { return(dbContext.Courses.Find(courseId)); } }
/* * Create By xzy * 随机抽取评分作业 * 2019/7/18 */ public static List <Assignment> GenAssignmentsToMark(int expId) { using (var dbContext = new DataModels()) { List <Assignment> assignments = dbContext.Assignments.Where(a => a.experiment_id == expId).ToList(); List <Assignment> returnList = new List <Assignment>(); int assCount = assignments.Count(); if (assCount < 6) { return(null); } else { Random random = new Random(DateTime.Now.Millisecond); int r = random.Next(0, assCount - 1); int step = random.Next(1, assCount / 6); int cnt = 0; while (cnt < 6) { returnList.Add(assignments[r]); assignments[r].is_standard = 1; r = (r + step) % assCount; cnt++; } dbContext.SaveChanges(); return(returnList); } } }
/// <summary> /// 按照applyId获取实验 /// create by xzh /// 2019.8.9 /// </summary> /// <param name="applyId"></param> /// <returns></returns> public static Experiment GetExperimentByApplyId(int applyId) { using (var dbContext = new DataModels()) { return(dbContext.Experiments.Where(e => e.vm_apply_id == applyId).First()); } }
internal CompilationUnitSyntax GenerateCompilationUnit() { var ctx = SourceFileContext.CreateFullyQualified(SystemClock.Instance); var ns = Namespace(PackageName); using (ctx.InNamespace(ns)) { var serviceClass = GenerateServiceClass(ctx); var baseRequestClass = GenerateBaseRequestClass(ctx); ns = ns.AddMembers(serviceClass, baseRequestClass); foreach (var resource in Resources) { var resourceClass = resource.GenerateClass(ctx); ns = ns.AddMembers(resourceClass); } } var dataNs = Namespace(PackageName + ".Data"); using (ctx.InNamespace(dataNs)) { var dataModels = DataModels .Where(dm => !dm.IsPlaceholder) .OrderBy(dm => dm.Typ.Name, StringComparer.Ordinal); foreach (var dataModel in dataModels) { dataNs = dataNs.AddMembers(dataModel.GenerateClass(ctx)); } } return(ctx.CreateCompilationUnit(ns).AddMembers(dataNs)); }
private static void AddRoomButton_Click(object sender, RoutedEventArgs e) { Button addRoomButton = (Button)sender; List <object> objects = (List <object>)addRoomButton.Tag; ComboBox hotelComboBox = (ComboBox)objects[0]; TextBox roomNumberTextBox = (TextBox)objects[1]; ComboBox roomTypeComboBox = (ComboBox)objects[2]; Button browseRoomPhotoButton = (Button)objects[3]; Window popup = (Window)objects[4]; DataModels database = DataModels.GetInstance(); if (hotelComboBox.SelectedItem == null) { MessageBox.Show("Please select a hotel"); return; } Hotel hotel = (Hotel)((ComboBoxItem)hotelComboBox.SelectedItem).Content; int roomNumber; if (!int.TryParse(roomNumberTextBox.Text, out roomNumber)) { MessageBox.Show("Please enter a valid room number"); return; } if (roomTypeComboBox.SelectedItem == null) { MessageBox.Show("Please select a room type"); return; } RoomType roomType = (RoomType)((ComboBoxItem)roomTypeComboBox.SelectedItem).Content; if ((string)browseRoomPhotoButton.Tag == "") { MessageBox.Show("Please select a photo path"); return; } CustomImage roomImage = new CustomImage((string)browseRoomPhotoButton.Tag); Room room = new Room(roomNumber, hotel, roomType, roomImage, new List <RoomView>()); if (database.AddRoom(room) == true) { MessageBox.Show("Added"); if (adminWindow.currentCanvas != null) { adminWindow.currentCanvas.Hide(); } adminWindow.InitializeRoomsCanvas(database.GetAllRooms()); popup.Close(); return; } else { MessageBox.Show("please enter a valid room number"); return; } }
public static ForumCategory DisplayCategory(DataModels.Forum.ForumCategories cat) { ForumCategory c = new ForumCategory(); c.CategoryId = cat.CategoryId; c.CategoryName = cat.NameOfCategory; c.GroupId = cat.GroupId; return c; }
/// <summary> /// 返回当前学期 Create By zzw /// </summary> /// <param></param> /// <returns>Term</returns> public static Term GetNowTerm() { using (var dbContext = new DataModels()) { Term t = dbContext.Terms.OrderBy(term => term.id).ToList().Last(); return(t); } }
/// <summary> /// 添加助教到课程 Create By zzw /// </summary> /// <param name="ast"></param> /// <returns>成功返回1,没有改变返回0</returns> public static int AddAstToCourse(Assistant ast) { using (var dbContext = new DataModels()) { dbContext.Assistants.Add(ast); return(dbContext.SaveChanges()); } }
/// <summary> /// 管理员添加学期 Create By zzw /// </summary> /// <param name="term"></param> /// <returns>成功返回1,没有改变返回0</returns> public static int AddTerm(Term term) { using (var dbContext = new DataModels()) { dbContext.Terms.Add(term); return(dbContext.SaveChanges()); } }
public void AddFavourite(DataModels.StopInfo stopInfo) { var contains = (_favourites.Contains(stopInfo)); if (!contains) Favourites.Add(stopInfo); SaveFavourites(); }
void IAuthorizerDataService.RegisterUserLogIn(DataModels.User user) { var DbUser = ThisService.Repository.GetUsers().FirstOrDefault(u => u.OpenId == user.OpenId); if (DbUser == null) { ThisService.Repository.AddUser(user); ThisService.Repository.Save(); } }
public static void ShowUserStatus(DataModels.User user) { Console.WriteLine("--------------USER STATUS-------------"); Console.WriteLine(user.Id); Console.WriteLine(user.Age); Console.WriteLine(user.FirstName); Console.WriteLine(user.LastName); Console.WriteLine(user.Handicap); Console.WriteLine(user.Status); Console.WriteLine("--------------USER STATUS-------------"); }
private static TaskListDA DisplayTaskList(DataModels.League.Task.TaskList oTaskList) { TaskListDA bl = new TaskListDA(); bl.AssignedTo = oTaskList.AssignedTo; bl.EndDate = oTaskList.EndDate; bl.ListAddByMember = oTaskList.ListAddByMember.MemberId; bl.ListId = oTaskList.ListId; bl.ListName = oTaskList.ListName; bl.TaskListForLeague = oTaskList.TaskListForLeague.LeagueId; return bl; }
public static bool AddEmailToContactCard(string email, DataModels.ContactCard.ContactCard contact) { try { contact.Emails.Add(new RDN.Library.DataModels.ContactCard.Email { EmailAddress = email, IsDefault = true }); return true; } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return false; }
public static bool UpdateEmailToContactCard(string email, DataModels.ContactCard.Email emailCard) { try { emailCard.EmailAddress = email; return true; } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return false; }
/// <summary> /// Retrieve a cached (and pre-parsed) callstack container from the cache, or parse the raw callstack, and add to the cache. /// </summary> /// <param name="CurrentCrash">The crash to retrieve the parsed callstack for.</param> /// <returns>A parsed callstack.</returns> public DataModels.CallStackContainer GetCallStackFast( DataModels.Crash CurrentCrash ) { using( var logTimer = new FAutoScopedLogTimer( this.GetType().ToString() + "(CrashId=" + CurrentCrash.Id + ")" ) ) { var key = CacheKeyPrefix + CallstackKeyPrefix + CurrentCrash.Id; var callStack = (CallStackContainer)CacheInstance[key]; if (callStack != null) return callStack; callStack = new CallStackContainer( CurrentCrash ); callStack.bDisplayFunctionNames = true; CacheInstance.Insert( key, callStack ); return callStack; } }
void IAuthorizerDataService.RegisterUserAlias(string openId, DataModels.UserAlias alias) { var DbUser = ThisService.Repository.GetUsers().FirstOrDefault(u => u.OpenId == openId); var DbAlias = ThisService.Repository.GetAliases().FirstOrDefault(a => a.Id == DbUser.AliasId); if (DbAlias == null) { ThisService.Repository.AddAlias(alias); ThisService.Repository.Save(); DbUser.AliasId = ThisService.Repository.Context.Entry(alias).Entity.Id; ThisService.Repository.UpdateUser(DbUser); ThisService.Repository.Save(); } }
void IBlogService.AddComment(DataModels.Comment comment) { var Comment = this.Repository.GetComments().FirstOrDefault(c => c.Id == comment.Id); if (Comment == null) { Comment = this.Repository.CreateComment(); Comment.By = comment.By; Comment.CanRespond = comment.CanRespond; Comment.CommentDate = comment.CommentDate; Comment.Content = comment.Content; Comment.EntryId = comment.EntryId; } }
/// <summary> /// inserts the team into the DB. /// </summary> /// <param name="game"></param> /// <param name="team"></param> /// <param name="db"></param> public static void insertTeamIntoDb(GameViewModel game, TeamViewModel team, ManagementContext db, DataModels.Game.Game g) { try { DataModels.Game.GameTeam tm = new DataModels.Game.GameTeam(); tm.Created = DateTime.UtcNow; tm.Game = g; if (String.IsNullOrEmpty(team.TeamName)) tm.TeamName = "Temp"; else tm.TeamName = team.TeamName; if (team.TeamId == new Guid()) tm.TeamId = Guid.NewGuid(); else tm.TeamId = team.TeamId; if (team.Logo != null && team.Logo.TeamLogoId != new Guid()) { var logo = db.TeamLogos.Where(x => x.TeamLogoId == team.Logo.TeamLogoId).FirstOrDefault(); if (logo != null) { tm.Logo = logo; team.Logo.ImageUrl = logo.ImageUrl; team.Logo.ImageUrlThumb = logo.ImageUrlThumb; } } if (team.LineUpSettings != null) { UpdateLineUpSettings(team, tm); } db.GameTeam.Add(tm); foreach (var member in team.TeamMembers) { GameMemberClass.insertNewSkater(game.GameId, db, tm.TeamId, member, tm); } //TODO:record time outs left. db.SaveChanges(); } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
/// <summary> /// entry point for updating the team. /// </summary> /// <param name="game"></param> /// <param name="team"></param> /// <param name="db"></param> public static void updateTeam(GameViewModel game, TeamViewModel team, ManagementContext db, DataModels.Game.Game g) { try { var getTeam = g.GameTeams.Where(x => x.TeamId == team.TeamId).FirstOrDefault(); if (getTeam == null) { insertTeamIntoDb(game, team, db, g); } else { if (String.IsNullOrEmpty(team.TeamName)) getTeam.TeamName = "Temp"; else getTeam.TeamName = team.TeamName; if (team.Logo != null) { if ((getTeam.Logo == null) || (getTeam.Logo != null && getTeam.Logo.TeamLogoId != team.Logo.TeamLogoId)) { var logo = db.TeamLogos.Where(x => x.TeamLogoId == team.Logo.TeamLogoId).FirstOrDefault(); if (logo != null) { getTeam.Logo = logo; team.Logo.ImageUrl = logo.ImageUrl; team.Logo.ImageUrlThumb = logo.ImageUrlThumb; } } } getTeam.CurrentTimeouts = team.TimeOutsLeft; getTeam.LeageName = team.LeagueName; if (team.LineUpSettings != null) { UpdateLineUpSettings(team, getTeam); } } db.SaveChanges(); } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: "tried to update the team"); } }
private bool AnalizeUserInfo(DataModels.Twitter.User user) { if (user == null) { return false; } try { _info.Id = user.Id; _info.Name = user.Name.Trim(); _info.ScreenName = user.ScreenName; _info.Location = user.Location; _info.Description = user.Description; _info.ImageUrl = new Uri(user.ProfileImageUrl); _info.Url = user.Url; _info.Protect = user.Protected; _info.FriendsCount = user.FriendsCount; _info.FollowersCount = user.FollowersCount; _info.FavoriteCount = user.FavouritesCount; _info.CreatedAt = MyCommon.DateTimeParse(user.CreatedAt); _info.StatusesCount = user.StatusesCount; _info.Verified = user.Verified; try { _info.RecentPost = user.Status.Text; _info.PostCreatedAt = MyCommon.DateTimeParse(user.Status.CreatedAt); _info.PostSource = user.Status.Source; if (!_info.PostSource.Contains("</a>")) { _info.PostSource += "</a>"; } } catch (Exception) { _info.RecentPost = null; _info.PostSource = null; } } catch (Exception) { return false; } return true; }
/// <summary> /// gets the member of a particular team from the game in the DB. /// </summary> /// <param name="teamId"></param> /// <param name="jam"></param> /// <param name="g"></param> /// <returns></returns> public static GameMember getMemberOfTeamInGame(Guid teamId, Guid skaterId, DataModels.Game.Game g) { try { if (g.GameTeams != null && g.GameTeams.Count > 0) { var t = g.GameTeams.Where(x => x.TeamId == teamId).FirstOrDefault(); if (t == null) return null; var m = t.GameMembers.Where(x => x.GameMemberId == skaterId).FirstOrDefault(); return m; } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return null; }
public static bool UpdateEmailToContactCard(string email, DataModels.ContactCard.ContactCard card) { try { if (card.Emails.FirstOrDefault() == null) { DataModels.ContactCard.Email e = new DataModels.ContactCard.Email(); UpdateEmailToContactCard(email, e); card.Emails.Add(e); } else UpdateEmailToContactCard(email, card.Emails.FirstOrDefault()); return true; } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return false; }
/// <summary> /// updates the team assists to the DB. /// </summary> /// <param name="team"></param> /// <param name="teamId"></param> /// <param name="game"></param> /// <param name="db"></param> /// <param name="g"></param> public static void updateTeamAssists(TeamNumberEnum team, Guid teamId, GameViewModel game, ManagementContext db, DataModels.Game.Game g) { try { List<AssistViewModel> assitsNew = new List<AssistViewModel>(); if (team == TeamNumberEnum.Team1) assitsNew = game.AssistsForTeam1; else assitsNew = game.AssistsForTeam2; for (int i = 0; i < assitsNew.Count; i++) { insertAssistIntoDb(teamId, game, assitsNew[i], db, g); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: "tried updating team scores"); } }
public static void AddOfficialReview(GameViewModel game, DataModels.Game.Game gameNew, OfficialReviewViewModel review) { try { GameOfficialReview or = new GameOfficialReview(); or.CurrentDateTimeReviewed = review.CurrentDateTimeReviewed; or.Details = review.Details; or.Game = gameNew; or.JamId = review.JamId; or.JamNumber = review.JamNumber; or.OfficialReviewIdFromGame = review.OfficialReviewId; or.Period = review.Period; or.PeriodTimeRemaining = review.PeriodTimeRemaining; or.Result = review.Result; or.TeamNumber = (byte)review.TeamNumber; gameNew.OfficialReviews.Add(or); } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
public static void AddOfficialToGame(GameViewModel game, ManagementContext db, DataModels.Game.Game gameNew, Guid skaterId, string skaterName, OfficialTypeEnum officialType, int refereeType, CertificationLevelEnum cert) { try { if (!String.IsNullOrEmpty(skaterName)) { GameOfficial o = new GameOfficial(); o.Game = gameNew; o.GameOfficialId = skaterId; o.MemberName = skaterName; o.OfficialTypeEnum = Convert.ToInt32(officialType); o.RefereeType = refereeType; o.CertificationLevelEnum = (byte)cert; db.GameOfficials.Add(o); db.SaveChanges(); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
private static void UpdateOfficialToDb(GameViewModel game, ManagementContext db, DataModels.Game.Game gameNew, Guid skaterId, string skaterName, OfficialTypeEnum officialType, int refereeType, CertificationLevelEnum cert) { try { var off = db.GameOfficials.Where(x => x.GameOfficialId == skaterId).FirstOrDefault(); if (off != null && !String.IsNullOrEmpty(skaterName)) { off.Game = gameNew; off.MemberName = skaterName; off.OfficialTypeEnum = Convert.ToInt32(officialType); off.RefereeType = refereeType; off.CertificationLevelEnum = (byte)cert; } else { AddOfficialToGame(game, db, gameNew, skaterId, skaterName, officialType, refereeType, cert); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } }
public static int DeepCompareOfficialsToDb(GameViewModel game, ManagementContext db, DataModels.Game.Game gameNew) { try { if (game.Officials != null) { foreach (var member in game.Officials.Nsos) { UpdateOfficialToDb(game, db, gameNew, member.SkaterId, member.SkaterName, OfficialTypeEnum.NSO, Convert.ToInt32(member.RefereeType), member.Cert); } foreach (var member in game.Officials.Referees) { UpdateOfficialToDb(game, db, gameNew, member.SkaterId, member.SkaterName, OfficialTypeEnum.Referee, Convert.ToInt32(member.RefereeType), member.Cert); } } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return db.SaveChanges(); }
/// <summary> /// updates the team penalties to the DB. /// </summary> /// <param name="team"></param> /// <param name="teamId"></param> /// <param name="game"></param> /// <param name="db"></param> /// <param name="g"></param> public static void updateTeamPenalties(TeamNumberEnum team, Guid teamId, GameViewModel game, ManagementContext db, DataModels.Game.Game g) { try { List<PenaltyViewModel> blocksNew = new List<PenaltyViewModel>(); if (team == TeamNumberEnum.Team1 && game.PenaltiesForTeam1 != null) blocksNew = game.PenaltiesForTeam1; else if (team == TeamNumberEnum.Team1 && game.PenaltiesForTeam2 != null) blocksNew = game.PenaltiesForTeam2; for (int i = 0; i < blocksNew.Count; i++) { var blockDb = g.GameMemberPenalties.Where(x => x.GamePenaltyId == blocksNew[i].PenaltyId).FirstOrDefault(); if (blockDb == null) insertPenaltyIntoDb(teamId, game, blocksNew[i], db, g); } } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: "tried updating team scores"); } }