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(); }