private void GetBindDop()
{
GetGroup.DataSource = BingGetType("");
GetGroup.DataTextField = "GroupName";
GetGroup.DataValueField = "GroupID";
GetGroup.DataBind();
}
public GetGroup GetGroup(string groupId)
{
GetGroup action = new GetGroup(groupId);
action.Client(client);
action.Proxy(proxy);
return(action);
}
public async Task <IActionResult> GetGroup(int groupId)
{
var command = new GetGroup {
GroupId = groupId
};
return(Ok(await _mediator.Send(command)));
}
public async Task GetGroups(string userId, string list, string search)
{
var user = await _context.User.Include(u => u.GroupUsers).ThenInclude(gu => gu.Group).FirstOrDefaultAsync(u => u.Id == userId);
var groupUsers = await _context.GroupUser.Where(gu => gu.UserId == userId && gu.Group.GroupName.Contains(search) && gu.DM == false).ToListAsync();
List <GetGroup> getGroups = new List <GetGroup>();
foreach (var groupUser in groupUsers)
{
GetGroup getGroup = new GetGroup {
GroupId = groupUser.GroupId, Name = groupUser.Group.GroupName
};
getGroups.Add(getGroup);
}
await Clients.Caller.SendAsync("GetGroups", getGroups.OrderBy(g => g.Name), list);
}
/// <summary>
/// Get the specified group.
/// </summary>
/// <param name="request">Request.</param>
public object Get(GetGroup request)
{
WebGroup result;
var context = TepWebContext.GetWebContext(PagePrivileges.UserView);
try {
context.Open();
context.LogInfo(this, string.Format("/group/{{Id}} GET Id='{0}'", request.Id));
Group grp = Group.FromId(context, request.Id);
result = new WebGroup(grp);
context.Close();
} catch (Exception e) {
context.LogError(this, e.Message, e);
context.Close();
throw e;
}
return(result);
}
public async Task GetContacts(string userId, string list, string search)
{
var user = await _context.User.Include(u => u.GroupUsers).FirstOrDefaultAsync(u => u.Id == userId);
List <GetGroup> getGroups = new List <GetGroup>();
foreach (var gu in user.GroupUsers)
{
if (gu.DM)
{
var ogu = await _context.GroupUser.Include(g => g.User).FirstOrDefaultAsync(g => g.GroupId == gu.GroupId && g.UserId != user.Id && g.User.UserName.Contains(search));
if (ogu != null)
{
GetGroup getGroup = new GetGroup {
GroupId = ogu.GroupId, Name = ogu.User.UserName
};
getGroups.Add(getGroup);
}
}
}
await Clients.Caller.SendAsync("GetGroups", getGroups.OrderBy(g => g.Name), list);
}
public static DataSet getGroupSetting(GetGroup grp)
{
try
{
//var GroupId = new MySqlParameter("?grpId", grp.GroupId);
//var GroupProfileId = new MySqlParameter("?profileId", grp.GroupProfileId);
MySqlParameter[] parameters = new MySqlParameter[2];
parameters[0] = new MySqlParameter("?grpId", grp.GroupId);
parameters[1] = new MySqlParameter("?profileId", grp.GroupProfileId);
string storeproc = "USPGetGroupSettings";
DataSet ds = null;
ds = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, storeproc, parameters);
//var Result = _DbTouchbase.ExecuteStoreQuery<SettingDetails>("CALL USPGetTouchbaseSettings(?grpId,?profileId)", GroupId, GroupProfileId).ToList();
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public object GetGroupSetting(GetGroup grp)
{
dynamic TBGroupSettingResult;
List <object> AllTBSettingResults = new List <object>();
try
{
DataSet Result = Setting.getGroupSetting(grp);
DataTable dtmain = Result.Tables[0];
DataTable dt2 = Result.Tables[1];
//string isMob, isEmail, isPersonal, isFamily, isBusiness;
string isMobileSelf, isMobileOther, isEmailSelf, isEmailOther;
//isMob = dt2.Rows[0]["isMob"].ToString();
//isEmail = dt2.Rows[0]["isEmail"].ToString();
//isPersonal = dt2.Rows[0]["isPersonal"].ToString();
//isFamily = dt2.Rows[0]["isFamily"].ToString();
//isBusiness = dt2.Rows[0]["isBusiness"].ToString();
isMobileSelf = dt2.Rows[0]["show_mobile_self_club"].ToString();
isMobileOther = dt2.Rows[0]["show_mobile_other_club"].ToString();
isEmailSelf = dt2.Rows[0]["show_email_self_club"].ToString();
isEmailOther = dt2.Rows[0]["show_email_other_club"].ToString();
//Convert DataTable into List
List <GRpSettingDetails> GroupSetting = new List <GRpSettingDetails>();
if (dtmain.Rows.Count > 0)
{
GroupSetting = GlobalFuns.DataTableToList <GRpSettingDetails>(dtmain);
}
//Add List into another List
for (int i = 0; i < GroupSetting.Count; i++)
{
AllTBSettingResults.Add(new { GRpSettingDetails = GroupSetting[i] });
}
if (AllTBSettingResults != null)
{
//TBGroupSettingResult = new { status = "0", message = "success", isMob = isMob, isEmail = isEmail, isPersonal = isPersonal, isFamily = isFamily, isBusiness = isBusiness, GRpSettingResult = AllTBSettingResults };
TBGroupSettingResult = new
{
status = "0",
message = "success",
isMobileSelf = isMobileSelf,
isMobileOther = isMobileOther,
isEmailSelf = isEmailSelf,
isEmailOther = isEmailOther,
GRpSettingResult = AllTBSettingResults
};
}
else
{
TBGroupSettingResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBGroupSettingResult = new { status = "1", message = "failed" };
}
return(new { TBGroupSettingResult });
}
public BsTableDataSource <VillageWorkingGroupViewModel> GET(GetGroup request)
{
return(VillageWorkingGroupManage.GetGroup(request));
}
