public static List <ContactModel> GetAllContacts()
{
try
{
using (CokeTRMSEntities context = new CokeTRMSEntities())
{
return(context.Contacts.Select(c => new ContactModel
{
ID = c.Id,
Name = c.Name,
TelephoneNumber = c.TelephoeNumber
}).ToList());
}
}
catch (Exception ex)
{
return(new List <ContactModel>());
}
}
public static bool IsUserValid(string username, string password)
{
try
{
using (CokeTRMSEntities context = new CokeTRMSEntities())
{
string hashedPw = CryptoHelper.GetMD5Hash(password);
if (context.Users.Where(u => u.Username.Equals(username, StringComparison.OrdinalIgnoreCase) &&
u.Password.Equals(hashedPw, StringComparison.OrdinalIgnoreCase)).SingleOrDefault() != null)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public bool AddImportedContacts(List <ImportContactsModel> importedContacts)
{
try
{
using (CokeTRMSEntities context = new CokeTRMSEntities())
{
foreach (ImportContactsModel contact in importedContacts)
{
context.Contacts.AddObject(new Contact
{
Name = contact.Name,
TelephoeNumber = contact.TelephoeNumber
});
}
context.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
