public SmsSendToMobile GetTodayMessage(string UserID)
{
try
{
using (var context = new windeskmobiledbEntities())
{
var foundUser = context.users.FirstOrDefault(user => user.guid == UserID);
if (foundUser == null) throw new Exception();
var result = from msgs in context.sentmessages
where msgs.userid == foundUser.id &&
msgs.sent == false &&
msgs.date == DateTime.Today
select msgs;
var message = result.FirstOrDefault();
if (message == null) return null;
var mes = context.sentmessages.FirstOrDefault(msg => msg.id == message.id);
mes.sent = true;
context.SaveChanges();
return new SmsSendToMobile { Id = message.id, Message = message.message, PhoneNumber = message.Reciever.value, UserId = message.User.guid};
}
}
catch
{
return null;
}
}
public string Login(string UserName, string Password)
{
var hashedPassword = GetHash(Password);
try
{
using (var context = new windeskmobiledbEntities())
{
var foundUser = context.users.FirstOrDefault(user => user.user == UserName && user.password == hashedPassword);
return (foundUser == null) ? null : foundUser.guid;
}
}
catch
{
// Any other provider error
return null;
}
}
public bool RegisterSentMessage(SmsSendToMobile sentMessage)
{
try
{
using (var context = new windeskmobiledbEntities())
{
var message = context.sentmessages.FirstOrDefault(mes => mes.id == sentMessage.Id);
if (message == null) return false;
message.sent = true;
context.SaveChanges();
}
}
catch
{
return false;
}
return true;
}
public bool PublishContactDetails(ContactDetailsCollection contactDetails)
{
try
{
using (var context = new windeskmobiledbEntities())
{
var foundUser = context.users.FirstOrDefault(user => user.guid == contactDetails.UserGUID);
if (foundUser == null) return false;
var result = from cpu in context.contactsperusers
join usr in context.users on cpu.userid equals usr.id
join cnt in context.contactdetails on cpu.contactdetailid equals cnt.id
join phn in context.phonenumbers on cpu.phonenumberid equals phn.id
where usr.id == foundUser.id
select new { ContactName = cnt.first, ContactPhone = phn.value };
foreach (var contactDetail in contactDetails.ContactDetails)
{
foreach (var phone in contactDetail.Phones)
{
if (result.FirstOrDefault(listItem => listItem.ContactName == contactDetail.Name && listItem.ContactPhone == phone) != null) continue;
var existingContactDetails = context.contactdetails.FirstOrDefault(cd => cd.contactsperusers.Where(cpu => cpu.userid == foundUser.id).Count() == 1 && cd.first == contactDetail.Name);
var newPhoneNumber = context.phonenumbers.Add(new phonenumbers { value = phone });
var newContactDetails = existingContactDetails !=null ? existingContactDetails : context.contactdetails.Add(new contactdetails { first = contactDetail.Name });
context.SaveChanges();
context.contactsperusers.Add(new contactsperusers { phonenumberid = newPhoneNumber.id, contactdetailid = newContactDetails.id, userid = foundUser.id });
context.SaveChanges();
}
}
}
}
catch
{
return false;
}
return true;
}
public ActionResult Index()
{
var context = new windeskmobiledbEntities();
ViewBag.Message = "Am obţinut" + context.phonenumbers.First().value;
return View();
}
