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();
}
