public static void createUser(String userName, List <int> tags, List <int> gifts)
{
using (var context = new GifterDBEntities())
{
Users user = new Users();
user.UserName = userName;
foreach (int i in tags)
{
user.Tags.Add(context.Tags.First(x => x.TagId == i));
}
foreach (int i in gifts)
{
user.Gifts.Add(context.Gifts.First(x => x.GiftId == i));
}
context.Users.Add(user);
context.SaveChanges();
}
}
public static List <int> getPresentsFromString(String s)
{
String[] presents = s.Split(',');
List <int> presentIds = new List <int>();
foreach (String s_present in presents)
{
String tmp = s_present.Trim();
using (var context = new GifterDBEntities())
{
Gifts gift = context.Gifts.FirstOrDefault(x => x.GiftName.Equals(tmp));
if (gift == null)
{
gift = new Gifts();
gift.GiftName = tmp;
context.Gifts.Add(gift);
context.SaveChanges();
}
presentIds.Add(gift.GiftId);
}
}
return(presentIds);
}
public static List <int> getTagsFromString(String s)
{
String[] tags = s.Split(',');
List <int> tagIds = new List <int>();
foreach (String s_tag in tags)
{
String tmp = s_tag.Trim();
using (var context = new GifterDBEntities())
{
Tags tag = context.Tags.FirstOrDefault(x => x.TagName.Equals(tmp));
if (tag == null)
{
tag = new Tags();
tag.TagName = tmp;
context.Tags.Add(tag);
context.SaveChanges();
}
tagIds.Add(tag.TagId);
}
}
return(tagIds);
}