public string GroupTableSelectForGroupId(string gName, string user)
{
utemp = context.UserTables.SingleOrDefault(x => x.user_id == user);
int a = utemp.no_of_group;
usergroupid = 0;
for (int i = 0; i < a; i++)
{
ugtemp = context2.UserAndGroupTables.First(x => x.user_id == user && x.user_group_id > usergroupid);
usergroupid = ugtemp.user_group_id;
string groupId = ugtemp.group_id;
gtemp = context.GroupTables.SingleOrDefault(x => x.group_id == groupId);
string groupName = gtemp.group_name;
if (groupName.Equals(gName))
{
break;
}
else
{
continue;
}
}
return(gtemp.group_id);
}
public string UserAndGroupTableSelectAndReturnGroupNames(string tempuser)
{
ugtemp = context2.UserAndGroupTables.FirstOrDefault(x => x.user_id == tempuser && x.user_group_id > usergroupid);
usergroupid = ugtemp.user_group_id;
gtemp = context.GroupTables.SingleOrDefault(x => x.group_id == ugtemp.group_id);
return(gtemp.group_name);
}
public void userAndGroupTableInsert(string gAdmin, string gId)
{
UserAndGroupTable obj = new UserAndGroupTable();
obj.group_id = gId;
obj.user_id = gAdmin;
context2.UserAndGroupTables.InsertOnSubmit(obj);
context2.SubmitChanges();
}
public string userAndGroupTableSelect(string tempuser)
{
try
{
// LinqToSqlDataContext context = new LinqToSqlDataContext();
ugtemp = context2.UserAndGroupTables.FirstOrDefault(x => x.user_id == tempuser && x.user_group_id > usergroupid);
usergroupid = ugtemp.user_group_id;
return(ugtemp.group_id);
}
catch (Exception)
{ return("You Are Not Connected To Any Group"); }
}
public Boolean userAndGroupTableCheckByGidAndUId(string adminId, string gId)
{
Boolean a = false;
try
{
ugtemp = context2.UserAndGroupTables.Single(x => x.user_id == adminId && x.group_id == gId);
a = true;
return(a);
}
catch (Exception)
{ return(a); }
}
partial void DeleteUserAndGroupTable(UserAndGroupTable instance);
partial void UpdateUserAndGroupTable(UserAndGroupTable instance);
partial void InsertUserAndGroupTable(UserAndGroupTable instance);
public int LastRowUserAndGroupTable()
{
ugtemp = context2.UserAndGroupTables.AsEnumerable().Last();
return(ugtemp.user_group_id);
}
public int firstRowUserAndGroupTable()
{
ugtemp = context2.UserAndGroupTables.First();
return(ugtemp.user_group_id);
}
public string userAndGroupTableSelectByGroupId(string gId)
{
ugtemp = context2.UserAndGroupTables.FirstOrDefault(x => x.group_id == gId && x.user_group_id > usergroupidtofindgroupmember);
usergroupidtofindgroupmember = ugtemp.user_group_id;
return(ugtemp.user_id);
}
public void deleteFromuserAndGroupTable(string groupId)
{
ugtemp = context2.UserAndGroupTables.FirstOrDefault(x => x.group_id == groupId);
context2.UserAndGroupTables.DeleteOnSubmit(ugtemp);
context2.SubmitChanges();
}
public void deleteFromuserAndGroupTable(string memberId, string groupId)
{
ugtemp = context2.UserAndGroupTables.SingleOrDefault(x => x.group_id == groupId && x.user_id == memberId);
context2.UserAndGroupTables.DeleteOnSubmit(ugtemp);
context2.SubmitChanges();
}
