protected void prihl_Click(object sender, EventArgs e)
{
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
string heslo;
var userQuery = (from user in db.Users
where user.UserName == uzjmenoP.Text
select user).SingleOrDefault();
if (userQuery == null)
{
Label1.Text = " Zadejte spravne udaje";
}
else
{
if (hesloP.Text != userQuery.Password)
{
Label1.Text = " Zadejte spravne udaje";
}
else
{
var username = uzjmenoP.Text;
FormsAuthentication.SetAuthCookie(username, createPersistentCookie);
Response.Redirect("UserPage.aspx");
}
}
}
}
catch (Exception er)
{
Label1.Text = er.ToString();
}
}
protected void checkboxListCompleted_SelectedIndexChanged(object sender, EventArgs e)
{
foreach (ListItem li in checkboxListCompleted.Items)
{
if (li.Selected == false)
{
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
var value = Convert.ToInt32(li.Value);
var query = from q in db.Texts
where q.IdText == value
select q;
foreach (var checkbox in query)
{
checkbox.Completed = false;
db.SubmitChanges();
}
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
catch (Exception er)
{
labelKontrola.Text += er.ToString();
}
}
}
}
protected void newCat_Click(object sender, EventArgs e)
{
//labelKontrola.Text = "btn";
if (catName.Text != "")
{
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
Category cat = new Category();
cat.CategoryName = catName.Text;
var id = userId();
cat.IdUser = id;
db.Categories.InsertOnSubmit(cat);
db.SubmitChanges();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
catch { }
}
else
{
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
protected void addText_Click(object sender, EventArgs e)
{
string cat = Request.QueryString["category"];
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
if (novyUkol.Text != "")
{
var idUser = userId();
Text todo = new Text();
todo.IdUser = idUser;
todo._Task = novyUkol.Text;
todo.Completed = false;
todo.Date = DateTime.Now; //.ToString("yyyy-MM-dd");
if (cat != null)
{
todo.IdCategory = Convert.ToInt32(cat);
}
db.Texts.InsertOnSubmit(todo);
db.SubmitChanges();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
}
catch (Exception er)
{
labelKontrola.Text = er.ToString();
}
}
protected int userId()
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
var query = (from q in db.Users
where q.UserName == Context.User.Identity.Name
select q).Single();
int idU = query.IdUser;
return(idU);
}
}
protected void SmazSplnene_Click(object sender, EventArgs e)
{
string par = Request.QueryString["category"];
var idUser = userId();
if (par == null)
{
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
//var idUser = userId();
var query = from q in db.Texts
where q.IdUser == idUser && q.Completed == true
select q;
foreach (var rm in query)
{
db.Texts.DeleteOnSubmit(rm);
db.SubmitChanges();
}
//smazSplnene.Visible = false;
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
catch
{
}
}
else
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
var query = from q in db.Texts
where q.IdCategory == Convert.ToInt32(par) && q.IdUser == idUser && q.Completed == true
select q;
//delete from db
foreach (var row in query)
{
db.Texts.DeleteOnSubmit(row);
db.SubmitChanges();
}
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
}
protected void smazatVse_Click(object sender, EventArgs e)
{
string par = Request.QueryString["category"];
var idUser = userId();
if (par == null)
{
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
var query = from q in db.Texts
where q.IdUser == idUser
select q;
foreach (var rm in query)
{
db.Texts.DeleteOnSubmit(rm);
db.SubmitChanges();
}
}
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
catch (Exception er)
{
labelKontrola.Text = er.ToString();
}
}
else
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
var query = from q in db.Texts
where q.IdCategory == Convert.ToInt32(par) && q.IdUser == idUser
select q;
//delete from db
foreach (var row in query)
{
db.Texts.DeleteOnSubmit(row);
db.SubmitChanges();
}
}
}
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
protected void registr_Click(object sender, EventArgs e)
{
//registrace
try
{
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
var query = from q in db.Users
where q.UserName == uzjmenoR.Text
select q;
var count = query.Count();
if (count == 0)
{
if (hesloR.Text == phesloR.Text)
{
User user = new User();
user.UserName = uzjmenoR.Text;
user.Password = hesloR.Text;
user.Email = emailR.Text;
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
var username = uzjmenoR.Text;
FormsAuthentication.SetAuthCookie(username, createPersistentCookie);
Response.Redirect("UserPage.aspx");
}
else
{
potvrzeniH.Text = " Hesla se neschoduji"; //label
}
}
else
{
uzjmenoExistuje.Text = "Uzivatel s takovym jmenem uz existuje"; //???????????
}
}
}
catch (Exception er)
{
Label1.Text = er.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var idUser = userId();
string del = Request.QueryString["del"];
if (del != null)
{
using (ListDbLinqDataContext db1 = new ListDbLinqDataContext())
{
var qUkol = from qU in db1.Texts
where idUser == qU.IdUser && qU.IdCategory == Convert.ToInt32(del)
select qU;
foreach (var row in qUkol)
{
db1.Texts.DeleteOnSubmit(row);
db1.SubmitChanges();
}
var q = from d in db1.Categories
where idUser == d.IdUser && d.IdCategory == Convert.ToInt32(del)
select d;
foreach (var row in q)
{
db1.Categories.DeleteOnSubmit(row);
db1.SubmitChanges();
}
}
Response.Redirect("UserPage.aspx");
}
string par = Request.QueryString["category"];
if (!IsPostBack)
{
Form.DefaultButton = addText.UniqueID; // Enter, novy ukol
linkName.Text = Context.User.Identity.Name;
CheckBoxList1.Items.Clear();
using (ListDbLinqDataContext db = new ListDbLinqDataContext())
{
if (par == null)
{
var query = from q in db.Texts
where q.IdUser == idUser && q.Completed == false
select q;
foreach (var checkbox in query)
{
addToCheckboxList(checkbox._Task.ToString(), checkbox.IdText, checkbox.Completed, CheckBoxList1);
}
var query2 = from q2 in db.Texts
where q2.IdUser == idUser && q2.Completed == true
select q2;
if (query2.Count() != 0)
{
smazSplnene.Visible = true;
//hrLine.Visible = false;
if (query.Count() != 0)
{
hrLine.Visible = true;
}
}
foreach (var checkbox in query2)
{
addToCheckboxList(checkbox._Task.ToString(), checkbox.IdText, checkbox.Completed, checkboxListCompleted);
}
}
if (par != null)
{
var queryCateg = (from qC in db.Categories
where qC.IdCategory == Convert.ToInt32(par)
select qC).Single();
labelCategName.Text = queryCateg.CategoryName;
var query4 = from q4 in db.Texts
where q4.IdUser == idUser && q4.IdCategory == Convert.ToInt32(par) && q4.Completed == false
select q4;
foreach (var k in query4)
{
addToCheckboxList(k._Task.ToString(), k.IdText, k.Completed, CheckBoxList1);
}
var query5 = from q5 in db.Texts
where q5.IdUser == idUser && q5.IdCategory == Convert.ToInt32(par) && q5.Completed == true
select q5;
foreach (var k in query5)
{
addToCheckboxList(k._Task.ToString(), k.IdText, k.Completed, checkboxListCompleted);
}
if (query5.Count() != 0)
{
smazSplnene.Visible = true;
if (query4.Count() != 0)
{
hrLine.Visible = true;
}
}
}
var query3 = from q3 in db.Categories
where q3.IdUser == idUser
select q3;
foreach (var c in query3)
{
/*HyperLink btn = new HyperLink();
* btn.CssClass = "btn btn-default btn-sm";
* btn.NavigateUrl = "UserPage.aspx?category=" + c.IdCategory;
* btn.Text = c.CategoryName;
* btnCat.Controls.Add(btn);
*/
HtmlGenericControl newdiv = new HtmlGenericControl("div");
newdiv.ID = c.IdCategory.ToString();
newdiv.Attributes["class"] = "btn-group mezera";
newdiv.Attributes["role"] = "group";
HyperLink btn = new HyperLink();
btn.CssClass = "btn btn-default btn-sm";
btn.NavigateUrl = "UserPage.aspx?category=" + c.IdCategory;
btn.Text = c.CategoryName;
//newdiv.Controls.Add(btn, btn2);
HyperLink btn2 = new HyperLink();
//btn2.ID = c.IdCategory.ToString();
btn2.CssClass = "btn btn-default btn-sm";
btn2.NavigateUrl = "UserPage.aspx?del=" + c.IdCategory;
HtmlGenericControl span = new HtmlGenericControl("span");
span.Attributes["class"] = "glyphicon glyphicon-trash";
btn2.Controls.Add(span);
newdiv.Controls.Add(btn);
newdiv.Controls.Add(btn2);
btnCat.Controls.Add(newdiv);
btnCat.Controls.Add(new LiteralControl("<br />"));
}
}
}
}
