protected void fvMessage_DataBound(object sender, EventArgs e)
{
if(fvMessage.DataItem != null)
{
Message message = (Message)fvMessage.DataItem;
VocabularyContext context = new VocabularyContext();
if(message.SenderID != message.RecipientID)
{
if(currentUser.ID == message.SenderID )
{
Label lblSender = (Label)fvMessage.FindControl("lblSender");
lblSender.Text = GetLocalResourceObject("from").ToString() + " " + currentUser.Name;
Label lblRecipient = (Label)fvMessage.FindControl("lblRecipient");
lblRecipient.Text = GetLocalResourceObject("to").ToString() + " "
+ context.Users.SingleOrDefault(u => u.ID == message.RecipientID).Name;
}
if (currentUser.ID == message.RecipientID)
{
Label lblRecipient = (Label)fvMessage.FindControl("lblRecipient");
lblRecipient.Text = GetLocalResourceObject("to").ToString() + " " + currentUser.Name;
Label lblSender = (Label)fvMessage.FindControl("lblSender");
lblSender.Text = GetLocalResourceObject("from").ToString() + " "
+ context.Users.SingleOrDefault(u => u.ID == message.SenderID).Name;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VocabularyContext context = new VocabularyContext();
int currentLanguageID = context.Languages.SingleOrDefault(l => l.Name == CultureInfo.CurrentUICulture.Name).ID;
lvCategories.DataSource = context.Categories.Where(c => c.LanguageID == currentLanguageID).ToList();
lvCategories.DataBind();
}
protected void PrepareAnswerMessage()
{
if(Request.QueryString["p"] != null)
{
int messageID;
if(int.TryParse(Request.QueryString["p"].ToString(), out messageID))
{
VocabularyContext context = new VocabularyContext();
Message message = context.Messages.SingleOrDefault(m => m.ID == messageID);
if (message != null)
{
if(currentUser.Role == "admin")
{
if(currentUser.ID != message.RecipientID)
{
//current user is the sender (this is from message object) and send message to the recipient again
tbRecipient.Text = context.Users.SingleOrDefault(u => u.ID == message.RecipientID).Name;
}
else
{
//current user is the recipient (this is from message object) and send back message to the sender
tbRecipient.Text = context.Users.SingleOrDefault(u => u.ID == message.SenderID).Name;
}
}
tbMessageText.Text = System.Environment.NewLine + message.Content;
tbMessageText.Focus();
}
}
}
}
string LoadUsers(string partOfName)
{
VocabularyContext ctx = new VocabularyContext();
List<User> userList = ctx.Users.Where(u => u.Name.StartsWith(partOfName) == true).ToList();
JavaScriptSerializer js = new JavaScriptSerializer();
return js.Serialize(userList);
}
string LoadWords(string partOfName)
{
VocabularyContext ctx = new VocabularyContext();
List<Word> wordList = ctx.Word.Where(w => w.Name.StartsWith(partOfName) == true).ToList();
JavaScriptSerializer js = new JavaScriptSerializer();
return js.Serialize(wordList);
}
protected void btnSearchUsers_Click(object sender, EventArgs e)
{
VocabularyContext context = new VocabularyContext();
List<User> userList = context.Users.ToList();
lvUserList.DataSource = userList.FindAll(u => u.Name.Contains(tbUserName.Text));
RequestedUserName = tbUserName.Text;
lvUserList.DataBind();
divContainerBorder.Visible = true;
tbUserName.Text = string.Empty;
}
protected void cvExistingCategory_ServerValidate(object source, ServerValidateEventArgs args)
{
VocabularyContext context = new VocabularyContext();
Category category = context.Categories.SingleOrDefault(c => c.Name == args.Value);
if(category == null)
{
args.IsValid = true;
}
else
{
args.IsValid = false;
}
}
protected void lvCateories_ItemDataBound(object sender, ListViewItemEventArgs e)
{
Category category = (e.Item.DataItem as Category);
if (category != null)
{
VocabularyContext context = new VocabularyContext();
int wordCount = context.Word.Count(w => w.CategoryID == category.ID);
Label lblWordCountInCategory = e.Item.FindControl("lblWordCountInCategory") as Label;
lblWordCountInCategory.Text = wordCount.ToString();
}
}
protected void lvSendedMessages_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.DataItem != null)
{
VocabularyContext context = new VocabularyContext();
Message message = (Message)e.Item.DataItem;
Label lblRecipient = e.Item.FindControl("lblRecipient") as Label;
if (lblRecipient != null)
{
lblRecipient.Text = context.Users.SingleOrDefault(u => u.ID == message.RecipientID).Name;
}
}
}
protected void ibtnDeleteUser_Command(object sender, CommandEventArgs e)
{
VocabularyContext context = new VocabularyContext();
int userID = Convert.ToInt32(e.CommandArgument);
User user = context.Users.SingleOrDefault(u => u.ID == userID);
if(user != null)
{
context.Users.Remove(user);
context.SaveChanges();
List<User> userList = context.Users.ToList();
lvUserList.DataSource = userList.FindAll(u => u.Name.Contains(RequestedUserName));
lvUserList.DataBind();
}
}
protected void lvResults_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if(e.Item.DataItem != null)
{
VocabularyContext context = new VocabularyContext();
int languageID = Helpers.GetCurrentLanguageID();
Word word = (Word)e.Item.DataItem;
Label lblCategory = e.Item.FindControl("lblCategory") as Label;
if (lblCategory != null)
{
lblCategory.Text = context.Categories.SingleOrDefault(c => c.ID == word.CategoryID).Name;
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
VocabularyContext context = new VocabularyContext();
User user = context.Users.SingleOrDefault(u => u.Name == tbUserName.Text && u.Password == tbPassword.Text);
if(user != null)
{
Session["currentUser"] = user;
Response.Redirect("~/Default.aspx");
}
else
{
lblFail.Text = GetLocalResourceObject("fail").ToString();
lblFail.ForeColor = System.Drawing.Color.Red;
lblFail.Visible = true;
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (Session["currentUser"] != null)
{
VocabularyContext context = new VocabularyContext();
User currentUser = (User)Session["currentUser"];
Message newMessage = new Message();
newMessage.MessageDate = DateTime.Now;
newMessage.Content = tbMessageText.Text;
newMessage.UserDeletedThis = 0;
newMessage.SenderID = currentUser.ID;
newMessage.RecipientID = GetRecipientID(tbRecipient.Text);
context.Messages.Add(newMessage);
context.SaveChanges();
}
}
protected void btnAddCategory_Click(object sender, EventArgs e)
{
Page.Validate("AddCategory");
if (Page.IsValid)
{
try
{
Category category = new Category();
//fill word data on english
category.Name = tbCategoryEn.Text;
category.LanguageID = Helpers.EnLangID;
VocabularyContext context = new VocabularyContext();
context.Categories.Add(category);
context.SaveChanges();
////////////////////////////////////
//fill word data on bulgarian
category = new Category();
category.Name = tbCategoryBg.Text;
category.LanguageID = Helpers.BgLangID;
context.Categories.Add(category);
context.SaveChanges();
tbCategoryEn.Text = string.Empty;
tbCategoryBg.Text = string.Empty;
hfResult.Value = "1";
pnlDialog.Visible = true;
litResult.Text = GetLocalResourceObject("Success").ToString();
}
catch (Exception ex)
{
string s = ex.Message;
hfResult.Value = "0";
pnlDialog.Visible = true;
litResult.Text = GetLocalResourceObject("Fail").ToString();
}
}
}
private void setRightView(string viewName)
{
if(Session["currentUser"] != null)
{
User currentUser = (User)Session["currentUser"];
VocabularyContext context = new VocabularyContext();
switch (viewName)
{
case "SendedMessages": mvMessageBox.SetActiveView(vSendedMessages);
lvSendedMessages.DataSource = context.Messages.Where(m => m.SenderID == currentUser.ID && m.UserDeletedThis != currentUser.ID).ToList();
lvSendedMessages.DataBind();
break;
case "ReceivedMessages": mvMessageBox.SetActiveView(vReceivedMessages);
lvReceivedMessages.DataSource = context.Messages.Where(m => m.RecipientID == currentUser.ID && m.UserDeletedThis != currentUser.ID).ToList();
lvReceivedMessages.DataBind();
break;
default: Response.Redirect("Default.aspx"); break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//bind list view
VocabularyContext context = new VocabularyContext();
int languageID = Helpers.GetCurrentLanguageID();
if (Request.QueryString["p"] == null)
Response.Redirect("Default.aspx");
string inputtedWord = HttpUtility.UrlDecode(Request.QueryString["p"].ToString());
List<Word> wordList = context.Word.Where(w => w.Name == inputtedWord && w.LanguageID == languageID).ToList();
if(wordList.Count == 1)
{
Response.Redirect("DisplayWord.aspx?pid=" + wordList[0].ID);
}
else
{
lvResults.DataSource = wordList;
lvResults.DataBind();
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
Page.Validate("Register");
if(Page.IsValid)
{
try
{
User user = new User();
VocabularyContext ctx = new VocabularyContext();
user = ctx.Users.SingleOrDefault(u => u.Name == tbUserName.Text);
if(user != null)
{
hfResult.Value = "1";
pnlDialog.Visible = true;
litResult.Text = GetLocalResourceObject("ExistUser").ToString();
}
else
{
user = new User { Name = tbUserName.Text, Role = "user", Password = tbPassword.Text };
ctx.Users.Add(user);
ctx.SaveChanges();
//Login user
Session["currentUser"] = user;
Response.Redirect("~/Default.aspx");
}
}
catch (Exception ex)
{
string s = ex.Message;
hfResult.Value = "0";
pnlDialog.Visible = true;
litResult.Text = GetLocalResourceObject("Fail").ToString();
}
}
}
protected void ibtnDeleteMessage_Command(object sender, CommandEventArgs e)
{
int messageID;
if(int.TryParse(e.CommandArgument.ToString(), out messageID))
{
VocabularyContext context = new VocabularyContext();
Message message = context.Messages.SingleOrDefault(m => m.ID == messageID);
if (Session["currentUser"] != null)
{
currentUser = (User)Session["currentUser"];
string redirectPage;
if (currentUser.ID == message.SenderID)
{
redirectPage = "MessageBox.aspx?p=SendedMessages";
}
else
{
redirectPage = "MessageBox.aspx?p=ReceivedMessages";
}
if(message.UserDeletedThis == 0)
{
message.UserDeletedThis = currentUser.ID;
context.SaveChanges();
}
else
{
context.Messages.Remove(message);
context.SaveChanges();
}
Response.Redirect(redirectPage);
}
}
}
public static int GetCurrentLanguageID()
{
VocabularyContext context = new VocabularyContext();
return context.Languages.SingleOrDefault(l => l.Name == CultureInfo.CurrentUICulture.Name).ID;
}
// call when send
private int GetRecipientID(string recipientName)
{
VocabularyContext context = new VocabularyContext();
User user = context.Users.SingleOrDefault(u => u.Name == recipientName);
if (user != null)
return user.ID;
else return 0;
}
// The id parameter should match the DataKeyNames value set on the control
// or be decorated with a value provider attribute, e.g. [QueryString]int id
public WebVocabulary2.Models.Message fvMessage_GetItem([QueryString("p")] int id)
{
VocabularyContext context = new VocabularyContext();
return context.Messages.SingleOrDefault(m => m.ID == id);
}
