public void Delete_Click(object sender, EventArgs e)
{
this.Visible = false;
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
monkey.delete <Smartphone>(Instance, TableName);
}
protected void Page_Load(object sender, EventArgs e)
{
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var articles = monkey.retrieve <Article>("articles").OrderBy(x => x.date);
var selectedCategory = Request.QueryString["category"];
if (selectedCategory != null)
{
LoadCategory(articles.Where(x => x.category == selectedCategory), (string)selectedCategory);
return;
}
var search = Request.QueryString["search"];
if (search != null)
{
LoadCategory(articles.Where
(
x => x.text.ToLower().Contains((string)search.ToLower()) ||
x.title.ToLower().Contains((string)search.ToLower()) ||
x.author.ToLower().Contains((string)search.ToLower())
),
"Search result"
);
return;
}
var categories = articles.Select(x => x.category).Distinct();
foreach (var category in categories)
{
LoadCategory(articles.Where(x => x.category == category), category);
}
}
protected void Register_Click(object sender, EventArgs e)
{
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var count = monkey.retrieve <User>("Users").Count();
var user = new User
{
username = username.Value,
password = password.Value,
email = email.Value,
picture = pictureInput.Value,
type = "reader",
id = count + 1
};
if (user.username == String.Empty)
{
registerButton.InnerText = "Nu ai introdus numele de utilizator!";
return;
}
if (password.Value != confirmpassword.Value)
{
registerButton.InnerText = "Parolele sunt diferite!";
return;
}
if (user.email == String.Empty)
{
registerButton.InnerText = "Nu ai introdus email-ul!";
return;
}
monkey.insert <User>(user, "Users");
Response.Redirect("Default.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
postCommentPanel.Visible = false;
}
var articleTitle = Request.QueryString["article"];
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var article = monkey.retrieve <Article>("articles")
.First(x => x.title == articleTitle);
ArticleTitle = article.title;
Text = article.text;
PictureUrl = article.picture;
ArticleID = article.id;
var comments = monkey.retrieve <Comment>("comments").Where(x => x.articleID == ArticleID);
foreach (var comment in comments)
{
var card = (MaterialCard)Page.LoadControl("Controls/MaterialCard.ascx");
card.Text = comment.text;
var user = monkey.retrieve <User>("users").First(x => x.username == comment.author);
card.SubTitle = user.username;
card.PictureUrl = user.picture;
card.Tag = user.type;
this.commentsPanel.Controls.Add(card);
}
this.DataBind();
}
public void Update_Click(object sender, EventArgs e)
{
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
Instance.brand = edit_brand.Value;
Instance.name = edit_name.Value;
Instance.launchDate = Convert.ToDateTime(edit_date.Value);
Instance.description = edit_description.Value;
monkey.update <Smartphone>(Instance, TableName);
Response.Redirect(Request.RawUrl);
}
protected void commentButton_Click(object sender, EventArgs e)
{
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var comment = new Comment
{
id = monkey.retrieve <Comment>("comments").Count() + 1,
author = (string)Session["user"],
articleID = ArticleID,
text = textarea1.InnerText
};
monkey.insert <Comment>(comment, "comments");
Response.Redirect(Request.RawUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var osList = monkey.retrieve <OS>("OS");
foreach (var osItem in osList)
{
os.Items.Add(new ListItem(String.Format("{0} - {1}", osItem.name, osItem.version)));
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.DataBind();
// connect to the database
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
// call the retrieve method using reflections
var method = typeof(SQLMonkey).GetMethod("retrieve");
var generic = method.MakeGenericMethod(ModelType);
// get the result
var instances = generic.Invoke(monkey, new string[] { Collection }) as IEnumerable <object>;
// add table's head
var columns = ModelType.GetProperties().Select(x => x.Name);
foreach (var column in columns)
{
var thead = new HtmlGenericControl("th")
{
InnerText = column
};
tableHead.Controls.Add(thead);
}
//add table's body
foreach (var instance in instances)
{
var row = (Controls_MonkeyRow)Page.LoadControl("Controls/MonkeyRow.ascx");
row.ModelType = ModelType;
row.Instance = instance;
row.Collection = Collection;
tableBody.Controls.Add(row);
}
//add entry panel
var tr = new HtmlGenericControl("tr");
foreach (var name in columns)
{
var input = new TextBox();
input.Attributes["placeholder"] = name;
var tableData = new HtmlGenericControl("td");
tableData.Controls.Add(input);
tr.Controls.Add(tableData);
}
addPanel.Controls.Add(tr);
}
protected void Submit_Click(object sender, EventArgs e)
{
var smartphone = new Smartphone
{
name = name.Value,
IDos = os.SelectedIndex,
launchDate = Convert.ToDateTime(launchDate.Value),
brand = brand.Value,
description = description.Value
};
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
monkey.insert <Smartphone>(smartphone, "smartphone");
submitButton.InnerText = "Success!";
}
protected void Page_Load(object sender, EventArgs e)
{
// lookup by brand / name
var brandQuery = Request.QueryString["brand"];
var nameQuery = Request.QueryString["name"];
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var smartphones = monkey.retrieve <Smartphone>(TABLE_NAME);
if (brandQuery != null)
{
smartphones = smartphones.Where(x => x.brand == brandQuery);
}
else if (nameQuery != null)
{
smartphones = smartphones.Where(x => x.name == nameQuery);
}
LoadData(smartphones);
}
public void Update_Click(object sender, EventArgs e)
{
var values = new List <string>();
var tds = GetTablesData(editPanel);
foreach (var td in tds)
{
var textbox = td.Controls.OfType <TextBox>().FirstOrDefault();
if (textbox != null)
{
values.Add(textbox.Text);
}
}
var propValuePairs = getInstaceProperties().Zip(values, (p, v) => Tuple.Create(p, v));
GenerateInstance(propValuePairs, ModelType, Instance);
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
// call the update method using reflections
var method = typeof(SQLMonkey).GetMethod("update");
var generic = method.MakeGenericMethod(ModelType);
generic.Invoke(monkey, new object[] { Instance, Collection });
// set updated data to the view row
var tdValuePairs = GetTablesData(viewPanel).Zip(values,
(td, value) => Tuple.Create(td, value));
foreach (var tdValuePair in tdValuePairs)
{
if (tdValuePair.Item2 == String.Empty)
{
continue;
}
tdValuePair.Item1.InnerText = tdValuePair.Item2;
}
viewPanel.Visible = true;
editPanel.Visible = false;
}
public void Submit_Click(object sender, EventArgs e)
{
var tds = Controls_MonkeyRow.GetTablesData(addPanel);
var values = new List <string>();
foreach (var td in tds)
{
values.Add(td.Controls.OfType <TextBox>().First().Text);
}
var propValuePairs = ModelType.GetProperties()
.Select(x => x.Name).Zip(values, (n, v) => Tuple.Create(n, v));
var instance = Activator.CreateInstance(ModelType);
Controls_MonkeyRow.GenerateInstance(propValuePairs, ModelType, instance);
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
// call the update method using reflections
var method = typeof(SQLMonkey).GetMethod("insert");
var generic = method.MakeGenericMethod(ModelType);
generic.Invoke(monkey, new object[] { instance, Collection });
Response.Redirect(Request.RawUrl);
}
protected void Login_Click(object sender, EventArgs e)
{
if (username.Value == String.Empty)
{
Eroare.InnerText = "Nu ai introdus username-ul!";
return;
}
if (password.Value == String.Empty)
{
Eroare.InnerText = "Nu ai introdus parola!";
return;
}
var monkey = new SQLMonkey(Constants.CONNECTION_STRING);
var user = monkey.retrieve <User>("users").FirstOrDefault(
x => x.username == username.Value && x.password == password.Value
);
if (user == null)
{
Eroare.InnerText = "Parola gresita!";
return;
}
Session["user"] = user.username;
if (user.type == "admin")
{
Response.Redirect("Users.aspx");
return;
}
else if (user.type == "editor")
{
Response.Redirect("Articles.aspx");
}
Response.Redirect("Default.aspx");
}
