public ActionResult Voted(int id) { var electionid = db.tblCandidates.Where(b => b.CandidateId == id).Select(b => b.ElectionId).FirstOrDefault(); var userid = Convert.ToInt32(Session["UserId"]); var isvoted = db.tblResults.Where(a => a.ElectionId == electionid && a.UserId == userid).FirstOrDefault(); if (isvoted != null) { var CandidateName = isvoted.tblCandidate.CandidateName; ViewBag.Action = "You have already Casted Your Vote To" + CandidateName; return(View()); } tblResult tb = new tblResult(); tb.CandidateId = id; tb.ElectionId = electionid; tb.UserId = userid; tb.UserName = Convert.ToString((Session["UserName"])); var votecounted = db.tblCandidates.Where(a => a.CandidateId == id).FirstOrDefault(); var oldvote = votecounted.VoteObtained; votecounted.VoteObtained = oldvote + 1; var candidatename = votecounted.CandidateName; db.tblResults.Add(tb); db.SaveChanges(); ViewBag.Action = "You Have Sucessfully Casted Your Vote " + candidatename; return(View()); }
protected void btnAddResult_Click(object sender, EventArgs e) { try { for (int i = 0; i < grdResultAdd.Rows.Count; i++) { GridViewRow row = grdResultAdd.Rows[i]; decimal studentid = Convert.ToDecimal(((Label)row.FindControl("lblStudentId")).Text); decimal quiz = decimal.Parse(((TextBox)row.FindControl("txtQuiz")).Text); decimal final = decimal.Parse(((TextBox)row.FindControl("txtFinal")).Text); decimal total = decimal.Parse(((TextBox)row.FindControl("txtTotal")).Text); tblResult item = new tblResult(); item.Quiz = quiz; item.Final = final; item.Total = quiz + final; item.StudentId = (int)studentid; item.ClassId = int.Parse(drpClassName.SelectedValue.Trim()); item.SubjectId = int.Parse(drpSubjectName.SelectedValue.Trim()); dbcontext.tblResults.AddObject(item); dbcontext.SaveChanges(); } showdata2(); } catch { string script = "alert('Duplicate items are Not Allowed');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); } }
public override void SaveDB() { db = new DataHarvesterDBEntities(); tblResult newResult = base.SaveResultDB(CheckUserIP(), db); PropertySplit(); SaveEmailDB_Free(newResult.ID); db.SaveChanges(); }
public void SaveResult(ResultModel data) { tblResult objtblResult = new tblResult(); objtblResult.Result_Date = DateTime.Now; objtblResult.Result_Heading = data.Result_Heading; objtblResult.Result_Text = data.Result_Text; objtblResult.tblUserId = data.tblUserId; dbentity.tblResults.Add(objtblResult); dbentity.SaveChanges(); }
public virtual tblResult SaveResultDB(int userID, DataHarvesterDBEntities db) { tblResult newResultDB = new tblResult { searchDate = Convert.ToDateTime(SearchDate), searchQuery = SearchQuery, userID = userID }; db.tblResults.Add(newResultDB); return(newResultDB); }
public ActionResult AddResult() { if (Convert.ToInt32(Session["UserRollId"]) == 1) { tblResult objtblResult = new tblResult(); return(View(objtblResult)); } else { return(Redirect("/Admin/index")); } }
public override void SaveDB() { db = new DataHarvesterDBEntities(); tblResult newResult = base.SaveResultDB(Convert.ToInt32(HttpContext.Current.User.Identity.Name), db); PropertySplit(); SaveEmailDB(newResult.ID); SaveFileUrlDB(newResult.ID); SaveHostnameDB(newResult.ID); SaveIPDB(newResult.ID); SaveLinkedInLinkDB(newResult.ID); SaveLinkedInProfileDB(newResult.ID); SavePortDB(newResult.ID); db.SaveChanges(); }
public IHttpActionResult UpdateResult(int courseId, Result[] courseResults) { PenOCDataContext db = new PenOCDataContext(); IQueryable<tblResult> queryResults = db.tblResults.Where(r => r.intCourse == courseId); db.tblResults.DeleteAllOnSubmit(queryResults); foreach (Result courseResult in courseResults) { tblResult resultRecord = new tblResult { intCourse = courseId, intPosition = courseResult.position, intCompetitor = courseResult.competitorId, intClub = courseResult.clubId, intCategory = courseResult.categoryId, strRaceNumber = courseResult.raceNumber, dteTime = courseResult.time, intPoints = courseResult.points, blnDisqualified = courseResult.disqualified, strComment = courseResult.comment }; db.tblResults.InsertOnSubmit(resultRecord); db.SubmitChanges(); }; return Ok(); }