protected void SaveBtn_Click(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var user = ctx.Users.Where(u => u.id == userId).FirstOrDefault();
//to rework this peace of code
/*
* if (rolesDDl.SelectedIndex==0)
* {
* user.roleId = 1;
* }
* else
* {
* user.roleId = 2;
* }*/
if (user.roleId == 2)
{
user.roleId = 1;
}
else
{
user.roleId = 2;
}
ctx.Entry(user).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
Response.Redirect("Users.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int questionId;
Int32.TryParse(Request.QueryString["dqid"], out questionId);
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var question = ctx.Questions.FirstOrDefault(q => q.id == questionId);
try
{
ctx.Questions.Remove(question);
ctx.SaveChanges();
}
catch (SqlException ex)
{
return;
// how do we handle this exception?
// it occurs when you delete question that is referenced by other QAs
// we should notify our user about unallowed action somehow.
}
finally
{
Response.Redirect("Questions.aspx");
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var question = ctx.Questions.Where(q => q.id == questionId).FirstOrDefault();
question.questionContent = newText;
ctx.Entry(question).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
Response.Redirect("Questions.aspx");
}
protected void addBtn_Click(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
if (addQuestion.Text != "")
{
var question = ctx.Questions.Where(q => q.id == 1).FirstOrDefault();
question.questionContent = addQuestion.Text;
ctx.Questions.Add(question);
ctx.SaveChanges();
}
}
addQuestion.Visible = false;
addQuestion.Text = "";
addBtn.Visible = false;
cancelBtn.Visible = false;
Response.Redirect(Request.RawUrl);
}
protected void Unnamed_Click(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var questionA = ctx.Questions.Where(q => q.id == 1).FirstOrDefault();
questionA.questionContent = question1.Text;
ctx.Entry(questionA).State = System.Data.Entity.EntityState.Modified;
var questionB = ctx.Questions.Where(q => q.id == 2).FirstOrDefault();
questionB.questionContent = question2.Text;
ctx.Entry(questionB).State = System.Data.Entity.EntityState.Modified;
var questionC = ctx.Questions.Where(q => q.id == 3).FirstOrDefault();
questionC.questionContent = question3.Text;
ctx.Entry(questionC).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
Response.Redirect("Questions.aspx");
}
}
