public static List <UserPlanDTO> ReadAll()
{
List <UserPlanDTO> ups = new List <UserPlanDTO>();;
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from up in db.UserPlans
select up);
foreach (UserPlan up in find)
{
UserPlanDTO upRead = new UserPlanDTO()
{
Id = up.Id,
UserId = up.UserId,
PlanId = up.PlanId
};
ups.Add(upRead);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(ups);
}
public static UserPlanDTO ReadPlanId(int planId)
{
UserPlanDTO upRead = null;
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from up in db.UserPlans
where up.PlanId == planId
select up).First();
upRead = new UserPlanDTO()
{
Id = find.Id,
UserId = find.UserId,
PlanId = find.PlanId
};
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(upRead);
}
public void JoinedUserClick(int masterId, int planId, int userId)
{
Singleton Rooms = Singleton.GetInstance();
if (!Rooms.ListOfRooms[planId].Contains(userId))
{
//dodati usera u bazu
UserPlanDTO userplan = new UserPlanDTO()
{
UserId = userId,
PlanId = planId
};
int userplanId = UserPlans.Create(userplan);
UserDTO user = Users.Read(userId);
AddUserToRoom(planId, userId); //dodavanje u dictionary
Clients.All.joinRoom(planId, user.FirstName, user.LastName);
}
}
public static void Update(UserPlanDTO updateUP)
{
try
{
databaseDataContext db = new databaseDataContext();
var find =
(from up in db.UserPlans
where up.Id == updateUP.Id
select up).Single();
find.UserId = updateUP.UserId;
find.PlanId = updateUP.PlanId;
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void ChangeMaster(int planId)
{
PlanDTO plan = Plans.Read(planId);
UserPlanDTO userPlan = UserPlans.ReadPlanId(planId);
UserPlanDTO newUserPlan = new UserPlanDTO()
{
UserId = plan.UserId,
PlanId = plan.Id
};
PlanDTO updatePlan = new PlanDTO()
{
Id = planId,
UserId = userPlan.UserId,
Name = plan.Name
};
Plans.Update(updatePlan);
UserPlans.Delete(userPlan.Id);
UserPlans.Create(newUserPlan);
}
public static int Create(UserPlanDTO upCreate)
{
try
{
databaseDataContext db = new databaseDataContext();
UserPlan up = new UserPlan()
{
UserId = upCreate.UserId,
PlanId = upCreate.PlanId
};
db.UserPlans.InsertOnSubmit(up);
db.SubmitChanges();
return(up.Id);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(-1);
}
