public void FillTeamMembersTable(int id)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var team = ctx.Teams.Where(t => t.id == id).FirstOrDefault();
try
{
NameLbl.Text = team.teamName;
}
catch
{
NameLbl.Text = "Such team not found";
}
foreach (var u in ctx.Users)
{
if (u.teamId == team.id)
{
memberIds.Add(u.id);
resultStr.Text += $"<tr>" +
$"<td data-title='ID'>{u.id}</td>" +
$"<td data-title='ID'><a href='UserPage.aspx?uid={u.id}'>{u.userName}</a></td>" +
$"<td data-title='ID'>{u.fullName}</td>"; //+
// $"<td>{getRoleName(u.roleId)}</td> </tr>";
}
}
}
}
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 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_Init(object sender, EventArgs e) // for updating table on search we need to use Page_Init
// to set initial values because its getting called only one time
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
foreach (var item in ctx.Statuses)
{
if (item.User.userName == "d1mnewz")
{
resultStr.Text += $"<tr>" +
$"<td data-title='ID'>{item.id}</td>" +
$"<td data-title='team-name' ><a href='UserPage.aspx?uid={item.User.id}'>{item.User.userName}</a></td>" +
$"<td data-title='team-name' >{item.whenToCollect}</td>" +
$"<td data-title='team-name' ><a href = 'QAsById.aspx?sid={item.id}'>3/3</a></td>" +
$"</tr>";
}
else
{
resultStr.Text += $"<tr>" +
$"<td data-title='ID'>{item.id}</td>" +
$"<td data-title='team-name' ><a href='UserPage.aspx?uid={item.User.id}'>{item.User.userName}</a></td>" +
$"<td data-title='team-name' >{item.whenToCollect}</td>" +
$"<td data-title='team-name' ><a href = 'QAsById.aspx?sid={item.id}'>0/3</a></td>" +
$"</tr>";
}
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
Int32.TryParse(Request.QueryString["qqid"], out questionId);
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var question = ctx.Questions.Where(q => q.id == questionId).FirstOrDefault();
newText = question.questionContent;
edittbx.Text = question.questionContent;
}
}
private string getUserName(int userId)
{
string uName;
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var user = ctx.Users.Where(u => u.id == userId).FirstOrDefault();
uName = user.userName;
}
return(uName);
}
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");
}
private string getRoleName(int roleId)
{
string rname;
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var role = ctx.Roles.Where(r => r.id == roleId).FirstOrDefault();
rname = role.roleName;
}
return(rname);
}
protected void Page_Init(object sender, EventArgs e) // for updating table on search we need to use Page_Init
// to set initial values because its getting called only one time
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
foreach (var item in ctx.Teams)
{
resultStr.Text += $"<tr><td>{item.id}" +
$"</td><td ><a href='TeamPage.aspx?tid={item.id}'>{item.teamName}</a><td></tr>";
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
string searchWord = txtWord.Text;
var results = ctx.Teams.Where(x => x.teamName.Contains(searchWord));
resultStr.Text = "";
// this empties our table. and if there is no items in result set, table will be empty.
foreach (var item in results)
{
resultStr.Text += $"<tr><td>{item.id}" +
$"</td><td ><a href='TeamPage.aspx?tid={item.id}'>{item.teamName}</a><td></tr>";
}
}
}
protected void Page_Init(object sender, EventArgs e) // for updating table on search we need to use Page_Init
// to set initial values because its getting called only one time
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
foreach (var item in ctx.Questions)
{
resultStr.Text += $"<tr>" +
$"<td data-title='ID'>{item.id}</td>" +
$"<td data-title='team-name' >{item.questionContent}</td>" +
$"<td class='btn btn-dagner'><a href='Delete.aspx?dqid={item.id}'>Delete</a></td>" +
$"<td class='btn btn-dagner'><a href='EditQuestions.aspx?qqid={item.id}'>Edit</a></td>" +
$"</tr>";
}
}
}
protected void Page_Init(object sender, EventArgs e) // for updating table on search we need to use Page_Init
// to set initial values because its getting called only one time
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
foreach (var item in ctx.QAs)
{
resultStr.Text += $"<tr>" +
$"<td data-title='ID'>{item.id}</td>" +
$"<td data-title='team-name' >{item.Question.questionContent}</td>" +
$"<td data-title='team-name' >{item.answer}</td>" +
$"<td data-title='team-name' >{item.whenCollected}</td>" +
$"<td data-title='team-name' >{item.statusId}</td>" +
$"</tr>";
}
}
}
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 Page_Init(object sender, EventArgs e) // for updating table on search we need to use Page_Init
// to set initial values because its getting called only one time
{
int statusId = 0;
Int32.TryParse(Request.QueryString["sid"], out statusId);
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
foreach (var item in ctx.QAs.Where(x => x.statusId == statusId))
{
resultStr.Text += $"<tr>" +
$"<td data-title='team-name' >{item.Question.questionContent}</td>" +
$"<td data-title='team-name' >{item.answer}</td>" +
$"<td data-title='team-name' >{item.whenCollected}</td>" +
$"<td data-title='team-name' >{item.statusId}</td>" +
$"</tr>";
}
}
}
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");
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
resultStr.Text +=
$"We have {ctx.Users.Count()} users," +
$" {ctx.Teams.Count()} teams," +
$" {ctx.QAs.Count()} QA combinations," +
$" {ctx.Questions.Count()} questions," +
$" {ctx.Statuses.Count()} statuses. <br><br>";
foreach (var variable in ctx.Users)
{
resultStr.Text += $"{variable.id} {variable.userName} {variable.fullName} <br>";
}
resultStr.Text += "<br>";
foreach (var variable in ctx.Questions)
{
resultStr.Text += $"{variable.id} {variable.questionContent} <br>";
}
resultStr.Text += "<br>";
foreach (var variable in ctx.Teams)
{
resultStr.Text += $"{variable.id} {variable.teamName} <br>";
}
resultStr.Text += "<br>";
foreach (var variable in ctx.QAs)
{
resultStr.Text += $"{variable.id} {variable.questionId} {variable.statusId} {variable.answer} {variable.whenCollected} <br>";
}
resultStr.Text += "<br>";
foreach (var VARIABLE in ctx.Statuses)
{
resultStr.Text += $"{VARIABLE.id} {VARIABLE.userId} {VARIABLE.whenToCollect} <br>";
}
resultStr.Text += "<br>";
}
}
private void fillStatusesTable()
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
int tmp;
for (int i = 0; i < memberIds.Count; i++)
{
tmp = memberIds[i];
var status = ctx.Statuses.Where(s => s.userId == 1).FirstOrDefault();
Label2.Text = $"<tr><td>{status.id}</td>" +
$"<td>{getUserName(1)}</td>" +
$"<td>{status.whenToCollect}</td>";
foreach (var q in ctx.QAs)
{
if (q.statusId == 1)
{
Label2.Text += $"<td>{q.answer}</td><td>{q.whenCollected}</td>";
}
}
Label2.Text += "</tr>";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Int32.TryParse(Request.QueryString["uid"], out userId);
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
var user = ctx.Users.Where(u => u.id == userId).FirstOrDefault();
LoginLbl.Text = user.userName;
FNameLbl.Text = user.fullName;
foreach (var r in ctx.Roles)
{
rolesDDl.Items.Add(r.roleName);
}
if (user.roleId == 1)
{
rolesDDl.SelectedIndex = 0;
}
else if (user.roleId == 2)
{
rolesDDl.SelectedIndex = 1;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (DaphneBotEntities ctx = new DaphneBotEntities())
{
}
}
