private void button_Create_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn chắc chắn muốn khởi tạo bảng điểm?", "Thông báo", MessageBoxButtons.OKCancel) == DialogResult.Cancel) { return; } else { // Khởi tạo điểm trung bình cho những học sinh chưa khởi tạo điểm DataGridViewScore.DataSource = ScoreDAO.Instance.CreateAverageScore(ComboboxSubject.Text, ComboboxSemester.Text, Int32.Parse(ComboboxYear.Text), Int32.Parse(ComboboxGrade.Text)); foreach (DataGridViewRow row in DataGridViewScore.Rows) { if (row.Cells[0].Value == null) { break; } Score scr = new Score(Int32.Parse(row.Cells[0].Value.ToString()), ComboboxSubject.Text, ComboboxSemester.Text, Int32.Parse(ComboboxYear.Text), 0); BUS.ScoreBUS.InitAverageScore(scr); } // Khởi tạo chi tiết điểm cho những học sinh chưa khởi tạo điểm chi tiết DataGridViewScore.DataSource = ScoreDAO.Instance.CreateScoreTable(Int32.Parse(ComboboxYear.Text), ComboboxSubject.Text, ComboboxSemester.Text, ComboboxType.Text, Int32.Parse(ComboboxFrequency.Text), Int32.Parse(ComboboxGrade.Text), ComboboxClass.Text); foreach (DataGridViewRow row in DataGridViewScore.Rows) { if (row.Cells[0].Value == null) { break; } ScoreDetail scrDetail = new ScoreDetail(Int32.Parse(row.Cells[0].Value.ToString()), ComboboxSubject.Text, ComboboxSemester.Text, Int32.Parse(ComboboxYear.Text), TypeTestDAO.Instance.TypeToTypeID(ComboboxType.Text), 0, Int32.Parse(ComboboxFrequency.Text)); BUS.ScoreDetailBUS.InitScoreDetail(scrDetail); } DataGridViewScore.DataSource = ScoreDAO.Instance.SearchClassScore(Int32.Parse(ComboboxGrade.Text), ComboboxClass.Text, ComboboxSemester.Text, ComboboxSubject.Text, ComboboxType.Text, Int32.Parse(ComboboxYear.Text), Int32.Parse(ComboboxFrequency.Text)); } }
public async Task SaveScoreDetails(ScoreDetail scoreDetals) { var convertedValue = JsonConvert.SerializeObject(scoreDetals); Application.Current.Properties[Score] = convertedValue; await Application.Current.SavePropertiesAsync(); }
public ScoreDetail FillScoreDetail() { if (!Application.Current.Properties.ContainsKey(Score)) { var scoreDetail = new ScoreDetail { PerformedCount = 0, TodaysPerformedCount = 0, SaveDate = DateTime.Now, TotalCount = 4 }; return(scoreDetail); } try { var savedSettings = (string)Application.Current.Properties[Score]; var scoreSettings = JsonConvert.DeserializeObject <ScoreDetail>(savedSettings); return(new ScoreDetail() { PerformedCount = scoreSettings.PerformedCount, SaveDate = scoreSettings.SaveDate, TotalCount = scoreSettings.TotalCount }); } catch (Exception ex) { return(null); } }
private ScoreDetailViewModel GetNewScoreDetailViewModel(int ScheduleId, string SetName) { var model = new ScoreDetailViewModel(); //在属性里加了默认值,这里就不需要了 //model.Score = new Score(); //model.ScoreDetails = new List<ScoreDetail>(); var schedule = db.Schedules.Find(ScheduleId); model.Score.ScheduleId = ScheduleId; model.Score.Schedule = schedule; var judgeStaffid = User.Identity.Name; var judge = db.Judges.Where(j => j.StaffId == judgeStaffid).FirstOrDefault(); model.Score.JudgeId = judge.Id; model.Score.Judge = judge; model.SetName = SetName; var criterias = db.EventCriterias.Where(c => c.EventId == schedule.EventId);; if (!string.IsNullOrEmpty(SetName)) { criterias = criterias.Where(c => c.SetName == SetName); } foreach (EventCriteria criteria in criterias) { ScoreDetail detail = new ScoreDetail(); detail.EventCriteriaId = criteria.Id; detail.EventCriteria = criteria; detail.Note = criteria.Note; model.ScoreDetails.Add(detail); } return(model); }
public string Print() { string result = "o " + x + "," + y + " " + width + "x" + height + " " + ValueDetail + "/" + CostDetail + " " + ScoreDetail.ToString("#.##") + " " + Risk.ToString("#.##"); return(result); }
private static void assertScoreDetailOrdered(ScoreDetail actualScoreDetail, int expectedPoints, string expectedDescription, IList <Card> expectedCards) { Assert.NotNull(actualScoreDetail, "scoreDetail != null"); Assert.AreEqual(expectedPoints, actualScoreDetail.Points, "Points"); Assert.AreEqual(expectedDescription, actualScoreDetail.Description, "Description"); assertAllCardsInScore(expectedCards, actualScoreDetail.Cards); }
public static void InsertNewEntiy(ScoreDetail NewScoreDetail) { using (DistributionContext context = new DistributionContext()) { NewScoreDetail.c_id = Guid.NewGuid().ToString(); context.t_score_detail.Add(NewScoreDetail); context.SaveChanges(); } }
public static void UpdateEntity(ScoreDetail UpdateScoreDetail) { using (DistributionContext context = new DistributionContext()) { ScoreDetail ag = context.t_score_detail.Find(UpdateScoreDetail.c_id); CommLogic.DeepClone <ScoreDetail>(ag, UpdateScoreDetail); context.SaveChanges(); } }
public static void DeleteEntity(string ScoreDetailId) { using (DistributionContext context = new DistributionContext()) { ScoreDetail DelScoreDetail = context.t_score_detail.Find(ScoreDetailId); context.t_score_detail.Remove(DelScoreDetail); context.SaveChanges(); } }
public void Play(ScoreDetail scoreDetail) { positions = new int[numberOfTracks]; SetTimeBetweenFrames(Convert.ToInt32(ConfigurationManager.AppSettings["Bpm"])); PlayScoreStart(scoreDetail.Creator); PlayScore(scoreDetail); PlayScoreEnd(); }
private void PlayScore(ScoreDetail scoreDetail) { var stopwatch = new Stopwatch(); stopwatch.Start(); for (var beatCount = 0; beatCount < Convert.ToInt32(ConfigurationManager.AppSettings["BarsToPlay"]) * 4; beatCount++) { Wait(stopwatch, millisecondsBetweenBeats); PlayNextBeat(scoreDetail); stopwatch.Restart(); } }
private void button_Save_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn chắc chắn muốn lưu bảng điểm này?", "Thông báo", MessageBoxButtons.OKCancel) == DialogResult.Cancel) { return; } else { string studentID, subjectID, semesterID, year, testID, score, frequency; foreach (DataGridViewRow row in DataGridViewScore.Rows) { if (row.Cells[0].Value == null) { break; } studentID = row.Cells[0].Value.ToString(); subjectID = row.Cells[2].Value.ToString(); semesterID = row.Cells[3].Value.ToString(); year = row.Cells[4].Value.ToString(); testID = row.Cells[5].Value.ToString(); score = row.Cells[6].Value.ToString(); if (score == "") { continue; } frequency = row.Cells[7].Value.ToString(); ScoreDetail scoreDetail = new ScoreDetail(Int32.Parse(studentID), subjectID, semesterID, Int32.Parse(year), testID, float.Parse(score), Int32.Parse(frequency)); BUS.ScoreDetailBUS.UpdateScoreDetail(scoreDetail); } // Update điểm trung bình cho từng bộ môn của từng học sinh List <Subject> subjects = BUS.SubjectBUS.GetListSubject(); for (int i = 0; i < subjects.Count(); i++) { DataTable data = StudentDAO.Instance.StudentHaveAverageScore(Int32.Parse(ComboboxYear.Text), subjects[i].iD, ComboboxSemester.Text); for (int j = 0; j < data.Rows.Count; j++) { string temp = data.Rows[0][0].ToString(); Score scr = new Score(Int32.Parse(data.Rows[j][0].ToString()), subjects[i].iD, ComboboxSemester.Text, Int32.Parse(ComboboxYear.Text), 0); BUS.ScoreBUS.UpdateAverageScore(scr); } } MessageBox.Show("Lưu điểm thành công!", "Thông báo"); } }
public ActionResult Create(ScoreDetail scoreDetail) { scoreDetail.Created = DateTime.Now; if (ContainsBadWords(scoreDetail.Creator)) { scoreDetail.Played = DateTime.Now; } if (ModelState.IsValid) { db.ScoreDetails.Add(scoreDetail); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(scoreDetail)); }
/// <summary> /// 更新代理商积分并增加积分明细记录 /// </summary> /// <param name="AgentId"></param> /// <param name="ChangeScore"></param> /// <param name="context"></param> /// <param name="reason"></param> public static void UpdateAgentScore(string AgentId, int ChangeScore, string reason = "操作变更", DistributionContext context = null) { if (context == null) { context = new DistributionContext(); } Agent ag = context.t_agent.Find(AgentId); ag.c_score = ag.c_score + ChangeScore; ScoreDetail sd = new ScoreDetail(); sd.c_id = Guid.NewGuid().ToString(); sd.c_amount = ChangeScore; sd.c_reason = reason; sd.c_user_id = AgentId; sd.c_create_date = DateTime.Now; context.t_score_detail.Add(sd); context.SaveChanges(); }
public void GetHashCodeTest() { ScoreDetail target = new ScoreDetail(); target.Score = "A"; target.ScoreFor = "Project"; ScoreDetail target2 = new ScoreDetail(); target2.Score = "A"; target2.ScoreFor = "Project"; Assert.AreEqual(target2.GetHashCode(),target.GetHashCode()); target2.Score = "B"; Assert.AreNotEqual(target2.GetHashCode(), target.GetHashCode()); target2.ScoreFor = "Student"; Assert.AreNotEqual(target2.GetHashCode(), target.GetHashCode()); target2.Score = "A"; Assert.AreNotEqual(target2.GetHashCode(), target.GetHashCode()); target.Id = 1; target2.ScoreFor = "Project"; Assert.AreNotEqual(target2.GetHashCode(), target.GetHashCode()); target2.Id = 1; Assert.AreEqual(target2.GetHashCode(), target.GetHashCode()); }
public void EqualsTest() { ScoreDetail target = new ScoreDetail(); target.Score = "A"; target.ScoreFor = "Project"; ScoreDetail target2 = new ScoreDetail(); target2.Score = "A"; target2.ScoreFor = "Project"; Assert.IsTrue(target.Equals(target2)); target2.Score = "B"; Assert.IsFalse(target.Equals(target2)); target2.ScoreFor = "Student"; Assert.IsFalse(target.Equals(target2)); target2.Score = "A"; Assert.IsFalse(target.Equals(target2)); target.Id = 1; target2.ScoreFor = "Project"; Assert.IsFalse(target.Equals(target2)); target2.Id = 1; Assert.IsTrue(target.Equals(target2)); }
public ActionResult GetScore(Int32 correctAnswers, string totalTime, DateTime today, Int32 currentQuestion, Int32 quesId) { Int32 uid = 0; if (Session["UserId"] != null) { uid = Convert.ToInt32(Session["UserId"]); mocktestEntities1 db = new mocktestEntities1(); ScoreDetail newscore = new ScoreDetail(); newscore.QuesDetailId = quesId; newscore.UserId = uid; newscore.Corrected = correctAnswers; newscore.date = today; newscore.Duration = totalTime; newscore.Score = correctAnswers; newscore.Attempted = currentQuestion; newscore.Active = true; db.ScoreDetails.Add(newscore); db.SaveChanges(); } return(PartialView("~/Views/Home/GetScore.cshtml")); }
public void SeedToContext(Stream stream, SeedingContext context, int year) { using (stream) { using (StreamReader reader = new StreamReader(stream, Encoding.UTF8)) { CsvReader csvReader = new CsvReader(reader); try { csvReader.SkipHeaders(6); while (csvReader.Read()) { var locationCode = csvReader.GetInt(0); var locationName = csvReader.GetString(1); if (!string.IsNullOrWhiteSpace(locationName)) { Location location = new Location() { PlaceName = locationName, Code = locationCode, State = null }; location = context.Locations.AddOrUpdate(location); var disadvantage = csvReader.GetInt(2); var advantage = csvReader.GetInt(4); Score score = new Score() { DisadvantageScore = disadvantage, AdvantageDisadvantageScore = advantage, Year = year, Location = location }; score = context.Scores.AddOrUpdate(score); var disadvantageDecile = csvReader.GetInt(3); var advantageDecile = csvReader.GetInt(5); var indexOfEconomicResourcesScore = csvReader.GetInt(6); var indexOfEconomicResourcesDecile = csvReader.GetInt(7); var indexOfEducationAndOccupationScore = csvReader.GetInt(8); var indexOfEducationAndOccupationDecile = csvReader.GetInt(9); var usualResedantPopulation = csvReader.GetDecimal(10); ScoreDetail scoreDetail = new ScoreDetail() { Score = score, DisadvantageDecile = disadvantageDecile, AdvantageDisadvantageDecile = advantageDecile, IndexOfEconomicResourcesScore = indexOfEconomicResourcesScore, IndexOfEconomicResourcesDecile = indexOfEconomicResourcesDecile, IndexOfEducationAndOccupationScore = indexOfEducationAndOccupationScore, IndexOfEducationAndOccupationDecile = indexOfEducationAndOccupationDecile, UsualResedantPopulation = usualResedantPopulation }; scoreDetail.Score = score; context.ScoreDetails.Add(scoreDetail); } } } // Todo: Create exception class to be caught and logged the right logging catch (Exception e) { throw new DataImportException() { Year = year, Context = csvReader.Context, ThrownException = e }; } } } }
public async Task <ScoreDetail> GetScoreSummaries(Guid ownerId, Guid scoreId) { var(data, hashSet) = await GetDynamoDbScoreDataAsync(ownerId, scoreId); return(ScoreDetail.Create(data, hashSet)); }
public void SeedToContext() { var importFileLocation = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + $"/Seeding/SeedData/{ImportFileName}"; try { using (var stream = new FileStream(importFileLocation, FileMode.Open)) using (var reader = new StreamReader(stream, Encoding.UTF8)) { var csvReader = new CsvReader(reader, CultureInfo.InvariantCulture); csvReader.SkipRecords(6); while (csvReader.Read()) { csvReader.TryGetField <int>(0, out int locationCode); csvReader.TryGetField <string>(1, out var locationName); if (!string.IsNullOrWhiteSpace(locationName)) { var location = new Location() { PlaceName = locationName, Code = locationCode, State = null }; _dotIdContext.Locations.Add(location); csvReader.TryGetField <int>(2, out var disadvantage); csvReader.TryGetField <int>(4, out var advantage); var score = new Score() { DisadvantageScore = disadvantage, AdvantageDisadvantageScore = advantage, //Todo: this should not be hard coded Year = 2016, Location = location }; _dotIdContext.Scores.Add(score); csvReader.TryGetField <int>(3, out var disadvantageDecile); csvReader.TryGetField <int>(5, out var advantageDecile); csvReader.TryGetField <int>(6, out var indexOfEconomicResourcesScore); csvReader.TryGetField <int>(7, out var indexOfEconomicResourcesDecile); csvReader.TryGetField <int>(8, out var indexOfEducationAndOccupationScore); csvReader.TryGetField <int>(9, out var indexOfEducationAndOccupationDecile); csvReader.TryGetField <decimal>(10, out var usualResedantPopulation); ScoreDetail scoreDetail = new ScoreDetail() { Score = score, DisadvantageDecile = disadvantageDecile, AdvantageDisadvantageDecile = advantageDecile, IndexOfEconomicResourcesScore = indexOfEconomicResourcesScore, IndexOfEconomicResourcesDecile = indexOfEconomicResourcesDecile, IndexOfEducationAndOccupationScore = indexOfEducationAndOccupationScore, IndexOfEducationAndOccupationDecile = indexOfEducationAndOccupationDecile, UsualResedantPopulation = usualResedantPopulation }; scoreDetail.Score = score; _dotIdContext.ScoreDetails.Add(scoreDetail); } } _dotIdContext.SaveChanges(); } } // Todo: Create exception class to be caught and logged the right logging catch (Exception e) { } }
// Create score detail public static void InitScoreDetail(ScoreDetail scoreDetail) { Console.WriteLine("Create score student id: " + scoreDetail.IdStudent + " -Subject id: " + scoreDetail.IdSubject); DAO.ScoreDetailDAO.Instance.InitScoreDetail(scoreDetail); Console.WriteLine("Update score success!"); }
protected void BindData() { HttpCookie c*k = Request.Cookies["ftcook"]; if (c*k != null) { ypzzpid = Convert.ToInt32(c*k["ypzzpid"]); kgzpid = Convert.ToInt32(c*k["kgzpid"]); kaotiid = Convert.ToInt32(c*k["kaotiid"]); } List <Shiti> sls = FTInterviewBLL.ShitiManage.GetAllShitiByKaotiId(kaotiid); GridView1.DataSource = sls; GridView1.DataBind(); if (sls.Count < 1) { submitButton.Visible = false; //NextButton.Visible = false; } List <Pingjiaxiangdian> ps = FTInterviewBLL.PingjiaxiangdianManage.GetAll(); List <Pingjiabiaozhun> pz = FTInterviewBLL.PingjiabiaozhunManage.GetAll(); List <Xiangdianbiaozhun> xdbzls = FTInterviewBLL.XiangdianBiaozhunManage.GetAll(); xdn = ps.Count; bzn = pz.Count; sn = sls.Count; if (!flag) { for (int i = 1; i <= sls.Count; i++) { shitils.Add(i, sls[i - 1].Id); } for (int i = 1; i <= ps.Count; i++) { xdls.Add(i, ps[i - 1]); } flag = true; } DataTable dt = new DataTable("msg"); dt.Columns.Add("pjxd", typeof(string)); for (int i = 1; i <= bzn; i++) { dt.Columns.Add("bz" + i, typeof(string)); } for (int i = 1; i <= sn; i++) { dt.Columns.Add("ti" + i, typeof(string)); } DataRow dr = dt.NewRow(); dr["pjxd"] = "项点"; for (int i = 1; i <= bzn; i++) { dr["bz" + i] = pz[i - 1].Content; } for (int i = 1; i <= sn; i++) { dr["ti" + i] = "第" + i + "题"; } dt.Rows.Add(dr); foreach (Pingjiaxiangdian pd in ps) { dr = dt.NewRow(); dr["pjxd"] = pd.Content; dt.Rows.Add(dr); } ScoreDetail.DataSource = dt; ScoreDetail.DataBind(); int ide = 0; for (int ri = 1; ri <= xdn; ri++) { for (int ci = 1; ci <= bzn; ci++) { Label t_text = new Label(); t_text.Text = xdbzls[ide].MyContent; ide++; ScoreDetail.Rows[ri].Cells[ci].Controls.Add(t_text); } } for (int ri = 1; ri <= xdls.Count; ri++) { for (int ci = bzn + 1; ci < bzn + 1 + sn; ci++) { DropDownList dl = new DropDownList(); dl.ID = ri + "DropDownList" + ci; dl.Width = 60; int stid = shitils[ci - bzn]; int xdid = xdls[ri].Id; Pingfen p = FTInterviewBLL.PingfenManage.GetPfByParameter(kgzpid, ypzzpid, stid, xdid); if (p != null) { DataProcess.ScoreBind(dl, xdls[ri].Score, p.Score); } else { DataProcess.ScoreBind(dl, xdls[ri].Score, -1); } dl.Attributes.Add("onchange", "auto_submit()"); ScoreDetail.Rows[ri].Cells[ci].Controls.Add(dl); } } }
private void PlayNextBeat(ScoreDetail scoreDetail) { var score = scoreDetail.Score; SendMessage(m => BuildBeatMessage(score, m)); }