public void SendToUser(string username,string conversationId,string iamId,string friendId, string message)
{
if (message != null || message != "")
{
User iam;
var msg = new Message()
{
Text = message,
Time = DateTime.Now,
UserId = Convert.ToInt32(iamId),
Ip = HttpContext.Current.Request.UserHostAddress,
ConversationId = Convert.ToInt32(conversationId)
};
using (DatabaseContext db = new DatabaseContext())
{
iam = db.Users.Include("Profile").Where(u => u.Id.ToString() == iamId).FirstOrDefault();
db.Messages.Add(msg);
db.SaveChanges();
}
var msgToSend = new SendMessageModel()
{
AvatarPath=iam.Profile.AvatarPath,
Text=message,
Time=msg.Time,
UserId=iam.Id ,
FullName=iam.FullName
};
Clients.User(username).newMessage(msgToSend);
}
}
public static void AddToFriends(int? id,string name)
{
using(DatabaseContext db = new DatabaseContext())
{
var iam = db.Users.Include("Profile").Where(u => u.Login == name).FirstOrDefault();
var myfriend = db.Users.Include("Profile").Where(u => u.Id == id).FirstOrDefault();
var request = db.Requests.Where(r => r.From == myfriend.Id && r.To == iam.Id).FirstOrDefault();
db.Requests.Remove(request);
if (myfriend.Profile.FriendsList == null)
{
myfriend.Profile.FriendsList = iam.Id.ToString();
}
else
{
myfriend.Profile.FriendsList += " " + iam.Id.ToString();
}
if (iam.Profile.FriendsList == null)
{
iam.Profile.FriendsList = myfriend.Id.ToString();
}
else
{
iam.Profile.FriendsList += " " + myfriend.Id.ToString();
}
db.SaveChanges();
}
}
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (DatabaseContext db = new DatabaseContext())
{
try
{
// Получаем пользователя
User user = db.Users.Where(u => u.Login == username).FirstOrDefault();
if (user != null)
{
//сравниваем
if (user.Role == roleName)
{
outputResult = true;
}
}
}
catch
{
outputResult = false;
}
}
return outputResult;
}
public static int CheckCountOutgoingRequest(string name)
{
int count = 0;
using (DatabaseContext db = new DatabaseContext())
{
var user = db.Users.Where(u => u.Login == name).FirstOrDefault();
var req = db.Requests.Where(r => r.From == user.Id).ToList();
count = req.Count();
}
return count;
}
public static void AddSession(string name)
{
using(DatabaseContext db =new DatabaseContext())
{
var user = db.Users.Where(u => u.Login == name).FirstOrDefault();
if (user != null)
{
user.LastDate = DateTime.Now;
db.SaveChanges();
}
}
}
public static string isOnline(int id)
{
using(DatabaseContext db = new DatabaseContext())
{
var user = db.Users.Where(u => u.Id == id).FirstOrDefault();
if(user.LastDate.Year==DateTime.Now.Year&& user.LastDate.Month==DateTime.Now.Month&&user.LastDate.Day==DateTime.Now.Day)
{
TimeSpan time = DateTime.Now - user.LastDate;
if(time.Hours==0 && time.Minutes<10)
{
return "Online";
}
}
return "";
}
}
public static void EditProfile(EditProfileViewModel model,string userLogin)
{
using(DatabaseContext db = new DatabaseContext())
{
var user=db.Users.Where(u => u.Login == userLogin).FirstOrDefault();
var profile=db.Profiles.Where(p=>p.Id==user.Id).FirstOrDefault();
if(user!=null)
{
if (model.AvatarPath != null)
{ profile.AvatarPath = model.AvatarPath; }
profile.Chair = model.Chair;
profile.Country = model.Country;
profile.Skype = model.Skype;
profile.Phone = model.Phone;
profile.Group = model.Group;
db.SaveChanges();
}
}
}
public static bool Check(string name,int? userId)
{
using (DatabaseContext db = new DatabaseContext())
{
var user = db.Users.Include("Profile").Where(u => u.Login == name).FirstOrDefault();
if (user != null)
{
var friendsList = Parsing(user.Profile.FriendsList);
var result =friendsList.Where(friend => friend == userId.ToString()).FirstOrDefault();
if(result!=null)
{
return true;
}
else
{
return false;
}
}
}
return false;
}
public override string[] GetRolesForUser(string login)
{
string[] role = new string[] { };
using (DatabaseContext db = new DatabaseContext())
{
try
{
// Получаем пользователя
User user = db.Users.Where(u => u.Login == login).FirstOrDefault();
if (user != null)
{
role = new string[] { user.Role };
}
}
catch
{
role = new string[] { };
}
}
return role;
}
public ActionResult Conversations()
{
var iam=db.Users.Where(u=>u.Login==User.Identity.Name).FirstOrDefault();
User friend;
Message msg;
var conversations = db.Conversations.Where(con => con.UserOne == iam.Id || con.UserTwo == iam.Id);
List<ConversationViewModel> model = new List<ConversationViewModel>();
foreach (var item in conversations)
{
using (DatabaseContext db1 = new DatabaseContext())
{
msg = db1.Messages.Where(m => m.ConversationId == item.Id).ToList().LastOrDefault();
if (msg == null)
{
msg = new Message() { Text = " " };
}
if (iam.Id == item.UserOne)
{
friend = db1.Users.Include("Profile").Where(u => u.Id == item.UserTwo).FirstOrDefault();
}
else
{
friend = db1.Users.Include("Profile").Where(u => u.Id == item.UserOne).FirstOrDefault();
}
model.Add(new ConversationViewModel()
{
Id=item.Id,
Iam = iam,
Friend = friend,
Messages = new List<Message>() { msg }
});
}
}
return View(model);
}
public static User UserLogin(string login, string password, string ip)
{
MD5 md5 = new MD5CryptoServiceProvider();
string pass = password;
byte[] checkSum = md5.ComputeHash(Encoding.UTF8.GetBytes(pass));
string result = BitConverter.ToString(checkSum).Replace("-", String.Empty);
using(DatabaseContext db = new DatabaseContext())
{
var user = db.Users.Where(u => u.Login == login).FirstOrDefault();
if(user!=null && user.HashPassword==result)
{
return user;
}
}
return null;
}
public static bool UserCreate(RegisterViewModel model,ref string role)
{
if (model.Login == "admin123")
role = "admin";
else role = "user";
if (MailMessanger.SendMessage("*****@*****.**", model.Email, "*****@*****.**","V80984342375"))
{
MD5 md5 = new MD5CryptoServiceProvider();
string pass = model.Password;
byte[] checkSum = md5.ComputeHash(Encoding.UTF8.GetBytes(pass));
string result = BitConverter.ToString(checkSum).Replace("-", String.Empty);
var user = new User() { FullName = model.SecondName+" "+model.FirstName+" "+model.ThirdName
, HashPassword = result
, Login = model.Login
, Role = role
, Email = model.Email ,
LastDate=DateTime.Now
};
using (DatabaseContext db = new DatabaseContext())
{
db.Users.Add(user);
db.SaveChanges();
db.Profiles.Add(new Profile() {
Id = user.Id, FirstName = model.FirstName,
SecondName = model.SecondName,
ThirdName = model.ThirdName,
Date=model.Date,
Gender=model.Gender,
AvatarPath = "/Images/noavatar.png"
});
db.SaveChanges();
}
return true;
}
else
{
return false;
}
}
public static bool CheckOutgoingRequest(string name,int To)
{
using(DatabaseContext db = new DatabaseContext())
{
var iam=db.Users.Where(u=>u.Login==name).FirstOrDefault();
if(iam!=null)
{
var request = db.Requests.Where(r => r.To == To & r.From == iam.Id).FirstOrDefault();
if(request==null)
{
return false;
}
else
{
return true;
}
}
}
return true;
}
public static List<User> GetFriends(string friendList)
{
var list = Parsing(friendList);
List<User> myfriends = new List<User>();
foreach (var friendId in list)
{
if (friendId != "")
{
using (DatabaseContext db = new DatabaseContext())
{
var Id = Convert.ToInt32(friendId);
var friend = db.Users.Include("Profile").Where(u => u.Id == Id).FirstOrDefault();
myfriends.Add(friend);
}
}
}
return myfriends;
}
public static void DeleteFriend(int? id,string name)
{
using(DatabaseContext db = new DatabaseContext())
{
var user = db.Users.Include("Profile").Where(u => u.Id == id).FirstOrDefault();
var iam = db.Users.Include("Profile").Where(u => u.Login == name).FirstOrDefault();
var userlist = Parsing(user.Profile.FriendsList);
user.Profile.FriendsList = null;
for(int i=0;i<userlist.Count();i++)
{
if(userlist[i]!=iam.Id.ToString())
{
if(user.Profile.FriendsList==null)
{
user.Profile.FriendsList = userlist[i];
}
else
{
user.Profile.FriendsList =" "+ userlist[i];
}
}
}
var iamlist = Parsing(iam.Profile.FriendsList);
iam.Profile.FriendsList = null;
for (int i = 0; i < iamlist.Count(); i++)
{
if (iamlist[i] != user.Id.ToString())
{
if (iam.Profile.FriendsList == null)
{
iam.Profile.FriendsList = iamlist[i];
}
else
{
iam.Profile.FriendsList = " " + iamlist[i];
}
}
}
db.SaveChanges();
}
}
public static int Count(string name)
{
if (name != null)
{
using (DatabaseContext db = new DatabaseContext())
{
var user = db.Users.Include("Profile").Where(u => u.Login == name).FirstOrDefault();
if (user != null)
{
var friendsList = Parsing(user.Profile.FriendsList);
return friendsList.Count();
}
}
}
return 0;
}
public static List<User> SearchUsers(string searchString)
{
List<User> result = new List<User>();
string[] massInStrings = searchString.Split(' ');
using (DatabaseContext db = new DatabaseContext())
{
foreach (var str in massInStrings)
{
var users = db.Users.Include("Profile").Where(u => u.Profile.FirstName==str||u.Profile.SecondName==str||u.Profile.ThirdName==str).ToList();
if (users != null)
{
result.AddRange(users);
}
}
}
result.Distinct();
return result;
}
public ActionResult Requests()
{
var iam=db.Users.Include("Profile").Where(u=>u.Login==User.Identity.Name).FirstOrDefault();
var requestsList = db.Requests.Where(r => r.To == iam.Id && r.Description == "friendadd");
List<RequestModel> model= new List<RequestModel>();
foreach(var item in requestsList)
{
using (DatabaseContext dbT = new DatabaseContext())
{
var userFrom = dbT.Users.Include("Profile").Where(u => u.Id == item.From).FirstOrDefault();
model.Add(new RequestModel()
{
Id = item.Id,
From = userFrom,
To = iam
});
}
}
return View(model);
}
