public RadComboBoxData GetCompanyNames(RadComboBoxContext context)
{
List<ComboBoxItemData> data = GetData(context.Text);
RadComboBoxData comboData = new RadComboBoxData();
int itemOffset = context.NumberOfItems;
int endOffset = Math.Min(itemOffset + ItemsPerRequest, data.Count);
comboData.EndOfItems = endOffset == data.Count;
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(endOffset - itemOffset);
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = data[i].CompanyName;
itemData.Value = data[i].CompanyId.ToString();
itemData.Attributes["Branch"] = data[i].BranchName;
itemData.Attributes["Site"] = data[i].SiteName;
result.Add(itemData);
}
comboData.Message = GetStatusMessage(endOffset, data.Count);
comboData.Items = result.ToArray();
return comboData;
}
public RadComboBoxData GetCompanyNames(RadComboBoxContext context)
{
List <ComboBoxItemData> data = GetData(context.Text);
RadComboBoxData comboData = new RadComboBoxData();
int itemOffset = context.NumberOfItems;
int endOffset = Math.Min(itemOffset + ItemsPerRequest, data.Count);
comboData.EndOfItems = endOffset == data.Count;
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(endOffset - itemOffset);
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = data[i].CompanyName;
itemData.Value = data[i].CompanyId.ToString();
itemData.Attributes["Branch"] = data[i].BranchName;
itemData.Attributes["Site"] = data[i].SiteName;
result.Add(itemData);
}
comboData.Message = GetStatusMessage(endOffset, data.Count);
comboData.Items = result.ToArray();
return(comboData);
}
public RadComboBoxData FillRadComboData4AssignPartner(RadComboBoxContext context, string strClientCode)
{
RadComboBoxData comboData = new RadComboBoxData();
DataTable dtPartnerData = GetPartner4AssignPartnerCombo(context["PartnerCode"].ToString(), context.Text.ToString(), strClientCode).Tables[0];
if (dtPartnerData != null)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > dtPartnerData.Rows.Count)
{
endOffset = dtPartnerData.Rows.Count;
}
if (endOffset == dtPartnerData.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>();
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
String itemText = dtPartnerData.Rows[i]["PartnerCode"].ToString().Trim() + " " + dtPartnerData.Rows[i]["PartnerName"].ToString();
itemData.Text = itemText;
itemData.Value = dtPartnerData.Rows[i]["PartnerCode"].ToString().Trim();
itemData.Attributes["PartnerCode"] = dtPartnerData.Rows[i]["PartnerCode"].ToString().Trim();
itemData.Attributes["PartnerName"] = dtPartnerData.Rows[i]["PartnerName"].ToString().Trim();
itemData.Attributes["PartnerTypeCode"] = dtPartnerData.Rows[i]["PartnerTypeCode"].ToString().Trim();
result.Add(itemData);
}
if (dtPartnerData.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), dtPartnerData.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
public RadComboBoxData GetComboItems([FromBody]RadComboBoxContext context)
{
string text = "";
int numberOfItems = 0;
foreach (var item in context)
{
JToken token = JObject.Parse(item.Value.ToString());
text = (string)token.SelectToken("Text");
numberOfItems = (int)token.SelectToken("NumberOfItems");
}
List<Product> products = GetProducts(text);
RadComboBoxData comboData = new RadComboBoxData();
int itemOffset = numberOfItems;
int endOffset = Math.Min(itemOffset + ItemsPerRequest, products.Count);
comboData.EndOfItems = endOffset == products.Count;
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>();
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = products[i].Name;
itemData.Value = products[i].Id.ToString();
result.Add(itemData);
}
comboData.Message = GetStatusMessage(endOffset, products.Count);
comboData.Items = result.ToArray();
return comboData;
}
public RadComboBoxItemData[] GetProductsByModel(RadComboBoxContext context)
{
List <RadComboBoxItemData> suggestions = new List <RadComboBoxItemData>(context.NumberOfItems);
if (context != null && !string.IsNullOrEmpty(context.Text))
{
var products = new ProductRepository().GetByModel(context.Text);
RadComboBoxData data = new RadComboBoxData();
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > products.Count)
{
endOffset = products.Count;
}
if (endOffset == products.Count)
{
data.EndOfItems = true;
}
else
{
data.EndOfItems = false;
}
suggestions = new List <RadComboBoxItemData>(endOffset - itemOffset);
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = products[i].PartNumber;
itemData.Value = products[i].ID.ToString();
suggestions.Add(itemData);
}
if (products.Count > 0)
{
data.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), products.Count.ToString());
}
else
{
data.Message = "No matches";
}
}
catch (Exception e)
{
data.Message = e.Message;
}
data.Items = suggestions.ToArray();
return(data.Items);
}
return(suggestions.ToArray());
}
public RadComboBoxData LoadStoreDDL(RadComboBoxContext context)
{
//The RadComboBoxData object contains all required information for load on demand:
// - the items
// - are there more items in case of paging
// - status message to be displayed (which is optional)
RadComboBoxData result = new RadComboBoxData();
LookupDAO lkp = new LookupDAO();
List <KeyValuePair <string, string> > stores = lkp.GetStore();
//Get all items from the Customers table. This query will not be executed untill the ToArray method is called.
var allStores = from store in stores
orderby store.Key, store.Value
select new RadComboBoxItemData
{
Text = store.Key + " - " + store.Value,
Value = store.Key
};
//In case the user typed something - filter the result set
string text = context.Text;
if (!String.IsNullOrEmpty(text))
{
allStores = allStores.Where(item => item.Text.StartsWith(text));
}
//Perform the paging
// - first skip the amount of items already populated
// - take the next 10 items
int numberOfItems = context.NumberOfItems;
var storelist = allStores.Skip(numberOfItems).Take(10);
//This will execute the database query and return the data as an array of RadComboBoxItemData objects
result.Items = storelist.ToArray();
int endOffset = numberOfItems + storelist.Count();
int totalCount = allStores.Count();
//Check if all items are populated (this is the last page)
if (endOffset == totalCount)
{
result.EndOfItems = true;
}
//Initialize the status message
result.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>",
endOffset, totalCount);
return(result);
}
public static RadComboBoxData GetEmployeeList(RadComboBoxContext context)
{
RadComboBoxData comboData = new RadComboBoxData();
try
{
string keyword = context.Text;
int pageFrom = context.NumberOfItems;
int pageSize = 10;
int?departmentId = null;
if (context.ContainsKey("DepartmentId") && context["DepartmentId"] != null)
{
departmentId = Convert.ToInt32(context["DepartmentId"]);
}
var employees = EmployeeManager.GetEmployees(pageFrom, pageSize, departmentId, context.Text, null, true);
if (employees != null)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
foreach (var item in employees)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = item.EmployeeName;
itemData.Value = Convert.ToString(item.EmployeeId);
result.Add(itemData);
}
int totalCount = employees[0].TotalCount;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + totalCount;
comboData.EndOfItems = totalCount < pageSize;
//comboData.Message = GetStatusMessagecustom(endOffset);
comboData.Items = result.ToArray();
}
return(comboData);
}
catch (Exception ex)
{
return(comboData);
}
}
public RadComboBoxData GetCoworker(RadComboBoxContext context)
{
if (context.Text.Length > 1)
{
RadComboBoxData comboData = new RadComboBoxData();
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
string searchterm = context.Text.ToLower();
foreach (v_ad_user_creation pos in repo.Query.Where(p => p.Fullname.ToLower().Substring(0, searchterm.Length).Equals(searchterm) && p.User_fk != null))
{
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = pos.Fullname + " -- " + pos.Orgunit + " -- " + pos.Position;
item.Value = pos.samaccount;
result.Add(item);
}
comboData.Items = result.ToArray();
return(comboData);
}
return(null);
}
public RadComboBoxData GetEmployee(RadComboBoxContext context)
{
if (context.Text.Length > 1)
{
RadComboBoxData comboData = new RadComboBoxData();
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
string searchterm = context.Text.ToLower(); //p.User_fk == null &&
foreach (v_ad_user_creation pos in repo.Query.Where(p => p.User_fk == null && p.Fullname.ToLower().Substring(0, searchterm.Length).Equals(searchterm)))
{
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = pos.Fullname + " -- " + pos.Orgunit + " -- " + pos.Position + " -- MedNR: " + pos.Opus_id;
item.Value = pos.Opus_id.ToString();
result.Add(item);
}
comboData.Items = result.ToArray();
return(comboData);
}
return(null);
}
public RadComboBoxData GetComboItems([FromBody] RadComboBoxContext context)
{
string text = "";
int numberOfItems = 0;
foreach (var item in context)
{
JToken token = JObject.Parse(item.Value.ToString());
text = (string)token.SelectToken("Text");
numberOfItems = (int)token.SelectToken("NumberOfItems");
}
List <Product> products = GetProducts(text);
RadComboBoxData comboData = new RadComboBoxData();
int itemOffset = numberOfItems;
int endOffset = Math.Min(itemOffset + ItemsPerRequest, products.Count);
comboData.EndOfItems = endOffset == products.Count;
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>();
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = products[i].Name;
itemData.Value = products[i].Id.ToString();
result.Add(itemData);
}
comboData.Message = GetStatusMessage(endOffset, products.Count);
comboData.Items = result.ToArray();
return(comboData);
}
public RadComboBoxData GetExerciseListOnDemand(RadComboBoxContext context)
{
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
RadComboBoxData comboData = new RadComboBoxData();
try
{
int itemsPerRequest = 15;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
aqufitEntities entities = new aqufitEntities();
IQueryable<Exercise> erercisesQuery = string.IsNullOrEmpty(context.Text) ?
entities.Exercises.OrderBy(e => e.Name) :
entities.Exercises.Where(e => e.Name.ToLower().StartsWith(context.Text)).OrderBy(e => e.Name);
int length = erercisesQuery.Count();
Exercise[] exercises = erercisesQuery.Skip(itemOffset).Take(itemsPerRequest).ToArray();
foreach (Exercise exer in exercises)
{
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = exer.Name;
item.Value = "" + exer.Id;
result.Add(item);
}
if (endOffset > length)
{
endOffset = length;
}
if (endOffset == length)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
if (length > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), length);
}
else
{
comboData.Message = "No matches";
}
comboData.Items = result.ToArray();
}
catch (Exception ex)
{
comboData.Message = ex.Message;
}
return comboData;
}
public RadComboBoxData FillRadComboData(RadComboBoxContext context, string strClientCode)
{
RadComboBoxData comboData = new RadComboBoxData();
DataTable dtMaterialData = GetSalesOrderDetail4Combo(context.Text.ToString(), context["SODocCode"].ToString().Trim(), strClientCode).Tables[0];
if (dtMaterialData != null)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > dtMaterialData.Rows.Count)
{
endOffset = dtMaterialData.Rows.Count;
}
if (endOffset == dtMaterialData.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>();
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
String itemText = dtMaterialData.Rows[i]["MaterialCode"].ToString() + " " + dtMaterialData.Rows[i]["MatDesc"].ToString();
itemData.Text = itemText;
itemData.Value = dtMaterialData.Rows[i]["SOItemNo"].ToString().Trim();
itemData.Attributes["MatDesc"] = dtMaterialData.Rows[i]["MatDesc"].ToString();
itemData.Attributes["MaterialTypeCode"] = dtMaterialData.Rows[i]["MaterialTypeCode"].ToString().Trim();
itemData.Attributes["MatGroup1Code"] = dtMaterialData.Rows[i]["MatGroup1Code"].ToString().Trim();
itemData.Attributes["MatGroup2Code"] = dtMaterialData.Rows[i]["MatGroup2Code"].ToString().Trim();
itemData.Attributes["UOMCode"] = dtMaterialData.Rows[i]["UOMCode"].ToString();
itemData.Attributes["ValClassType"] = dtMaterialData.Rows[i]["ValClassType"].ToString();
itemData.Attributes["NetWeight"] = dtMaterialData.Rows[i]["NetWeight"].ToString();
itemData.Attributes["GrossWeight"] = dtMaterialData.Rows[i]["GrossWeight"].ToString();
itemData.Attributes["NetPriceperQty"] = dtMaterialData.Rows[i]["PriceUnit"].ToString();
result.Add(itemData);
}
if (dtMaterialData.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), dtMaterialData.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
public RadComboBoxData GetStudentsMobileDept(RadComboBoxContext context)
{
string searchtext = string.Empty;
searchtext = Convert.ToString(context.Text);
RadComboBoxData comboData = new RadComboBoxData();
if (HttpContext.Current.Session["GlobalValueKey"] != null)
{
DataTable data = new DataTable();
using (SqlConnection connection = new SqlConnection(Convert.ToString(HttpContext.Current.Session["GlobalValueKey"])))
{
using (SqlCommand CMD = new SqlCommand())
{
//Last Name,First Name,Status
string strqry = string.Empty;
strqry = strqry + " select S.StudentID,S.LastName+', '+ S.FirstName as FullName,convert(varchar(50), S.StudentNo) as StudentNo, ";
strqry = strqry + " (Select StudentStatus from StudentStatus where StudentStatusID=S.StudentStatusID) as StudentStatus ";
strqry = strqry + " ,S.MobilePhone from Students AS S ";
strqry = strqry + " where ( S.MobilePhone is not null and S.MobilePhone<>'') and (S.LastName+', '+ S.FirstName like '" + searchtext + "%' ";
strqry = strqry + " or (Select StudentStatus from StudentStatus where StudentStatusID=S.StudentStatusID) like '" + searchtext + "%' or S.MobilePhone like '" + searchtext + "%') ";
strqry = strqry + " ORDER BY S.LastName+', '+ S.FirstName ";
CMD.Connection = connection;
CMD.CommandType = System.Data.CommandType.Text;
CMD.CommandText = strqry;
CMD.Prepare();
SqlDataAdapter DataAdapter = new SqlDataAdapter(CMD);
DataAdapter.Fill(data);
}
}
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > data.Rows.Count)
{
endOffset = data.Rows.Count;
}
if (endOffset == data.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>(endOffset - itemOffset);
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
// itemData.Text = Convert.ToString(data.Rows[i]["FullName"]);
string itemtext = string.Empty;
itemtext = itemtext + "<ul>";
itemtext = itemtext + "<li class='SMScol1'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["FullName"]) + "</li>";
itemtext = itemtext + "<li class='SMScol2'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["MobilePhone"]) + "</li>";
itemtext = itemtext + "<li class='SMScol3'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["StudentStatus"]) + "</li> ";
itemtext = itemtext + "</ul>";
itemData.Text = itemtext;
itemData.Value = Convert.ToString(data.Rows[i]["MobilePhone"]);
result.Add(itemData);
}
if (data.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), data.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
public RadComboBoxData FillRadComboData(RadComboBoxContext context, string strClientCode)
{
RadComboBoxData comboData = new RadComboBoxData();
DataTable dtCustData = GetCustomer4Combo(context.Text.ToString(), context["SalesOfficeCode"].ToString().Trim(), strClientCode).Tables[0];
if (dtCustData != null)
{
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > dtCustData.Rows.Count)
{
endOffset = dtCustData.Rows.Count;
}
if (endOffset == dtCustData.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>();
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
String itemText = dtCustData.Rows[i]["CustomerCode"].ToString() + " " + dtCustData.Rows[i]["Name1"].ToString();
itemData.Text = itemText;
itemData.Value = dtCustData.Rows[i]["CustomerCode"].ToString();
itemData.Attributes["CustomerCode"] = dtCustData.Rows[i]["CustomerCode"].ToString();
itemData.Attributes["Name1"] = dtCustData.Rows[i]["Name1"].ToString();
itemData.Attributes["StateCode"] = dtCustData.Rows[i]["StateCode"].ToString();
itemData.Attributes["SalesDistrictCode"] = dtCustData.Rows[i]["SalesDistrictCode"].ToString();
itemData.Attributes["SalesRegionCode"] = dtCustData.Rows[i]["SalesRegionCode"].ToString();
itemData.Attributes["SalesOfficeCode"] = dtCustData.Rows[i]["SalesOfficeCode"].ToString();
itemData.Attributes["SalesGroupCode"] = dtCustData.Rows[i]["SalesGroupCode"].ToString();
itemData.Attributes["VATNo"] = dtCustData.Rows[i]["VATNo"].ToString();
itemData.Attributes["IsTaxExempted"] = dtCustData.Rows[i]["IsTaxExempted"].ToString();
itemData.Attributes["SalesOrganizationCode"] = dtCustData.Rows[i]["SalesOrganizationCode"].ToString();
itemData.Attributes["DistChannelCode"] = dtCustData.Rows[i]["DistChannelCode"].ToString();
itemData.Attributes["DivisionCode"] = dtCustData.Rows[i]["DivisionCode"].ToString();
itemData.Attributes["CurrencyCode"] = dtCustData.Rows[i]["CurrencyCode"].ToString();
result.Add(itemData);
}
if (dtCustData.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), dtCustData.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
public RadComboBoxData GetStandardWorkoutsOnDemand(RadComboBoxContext context)
{
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
RadComboBoxData comboData = new RadComboBoxData();
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
long ProfileUserSettingsId = Convert.ToInt64(context["UserSettingsId"]);
aqufitEntities entities = new aqufitEntities();
UserSettings UserSettings = entities.UserSettings.FirstOrDefault(u => u.Id == ProfileUserSettingsId);
IQueryable<WOD> wods = entities.WODs.Where(w => w.Standard > 0);
wods.Select(w => w.WODType).ToArray(); // hydrate WODTypes
string lowerTxt = context.Text.ToLower();
if (!string.IsNullOrWhiteSpace(context.Text))
{
wods = wods.Where(w => w.Name.ToLower().Contains(lowerTxt) || w.WODSchedules.Where(ws => ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0).Any(ws => ws.HiddenName.ToLower().Contains(lowerTxt))).OrderBy(w => w.Name);
}
else
{
wods = wods.OrderByDescending(w => w.CreationDate);
}
int length = wods.Count();
wods = wods.Skip(itemOffset).Take(itemsPerRequest);
WOD[] wodList = wods.ToArray();
for (int i = 0; i < wodList.Length; i++)
{
WOD w = wodList[i];
if (w.WODSchedules != null && w.WODSchedules.Count > 0)
{
WODSchedule ws = w.WODSchedules.OrderByDescending(s => s.HideTillDate).First();
if (ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0)
{
if (string.IsNullOrWhiteSpace(context.Text))
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(ws.HiddenName), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
if (w.Standard > 0 || w.WODSchedules.Count > 1)
{ // CA - here is what is going on here. If the workout is suppost to be hidden until a date (common for crossfit gyms) then we just put a date name like up
// top. But if it is a standard WOD (or a wod that they have done before (w.WODSchedules.Count > 1) then we still need to add the WOD
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
else if (ws.HiddenName.ToLower().StartsWith(lowerTxt))
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(ws.HiddenName), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
else
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
else
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
if (endOffset > length)
{
endOffset = length;
}
if (endOffset == length)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
if (length > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), length);
}
else
{
comboData.Message = "No matches";
}
comboData.Items = result.ToArray();
}
catch (Exception ex)
{
comboData.Message = ex.Message;
}
return comboData;
}
public RadComboBoxData GetLeadsMobileDept(RadComboBoxContext context)
{
string searchtext = string.Empty;
searchtext = Convert.ToString(context.Text);
RadComboBoxData comboData = new RadComboBoxData();
if (HttpContext.Current.Session["GlobalValueKey"] != null)
{
DataTable data = new DataTable();
using (SqlConnection connection = new SqlConnection(Convert.ToString(HttpContext.Current.Session["GlobalValueKey"])))
{
using (SqlCommand CMD = new SqlCommand())
{
//Last Name,First Name,Status
string strqry = string.Empty;
strqry = strqry + " SELECT ";
strqry = strqry + " (L.LName + ', ' + L.FName + CASE WHEN LEN(L.MInitial) > 0 Then ' ' + L.MInitial Else '' End) As FullName , ";
strqry = strqry + " ISNULL(L.StatusCode,'') AS Status,L.PhoneMobile as MobilePhone ";
strqry = strqry + " FROM Lead AS L LEFT JOIN LeadStatus AS LS ON L.StatusCode = LS.StatusCode LEFT JOIN Employees AS E ";
strqry = strqry + " ON L.EmpID = E.EmpID ";
strqry = strqry + " where (L.PhoneMobile is not null and L.PhoneMobile<>'') and ( L.LName + ', ' + L.FName like '" + searchtext + "%' or L.StatusCode like '" + searchtext + "%' or L.PhoneMobile like '" + searchtext + "%') ";
strqry = strqry + " ORDER BY L.LName + ', ' + L.FName ";
CMD.Connection = connection;
CMD.CommandType = System.Data.CommandType.Text;
CMD.CommandText = strqry;
CMD.Prepare();
SqlDataAdapter DataAdapter = new SqlDataAdapter(CMD);
DataAdapter.Fill(data);
}
}
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > data.Rows.Count)
{
endOffset = data.Rows.Count;
}
if (endOffset == data.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>(endOffset - itemOffset);
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
// itemData.Text = Convert.ToString(data.Rows[i]["FullName"]);
string itemtext = string.Empty;
itemtext = itemtext + "<ul>";
itemtext = itemtext + "<li class='SMScol1'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["FullName"]) + "</li>";
itemtext = itemtext + "<li class='SMScol2'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["MobilePhone"]) + "</li>";
itemtext = itemtext + "<li class='SMScol3'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["Status"]) + "</li> ";
itemtext = itemtext + "</ul>";
itemData.Text = itemtext;
itemData.Value = Convert.ToString(data.Rows[i]["MobilePhone"]);
result.Add(itemData);
}
if (data.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), data.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
public RadComboBoxData GetGroupSearch(RadComboBoxContext context)
{
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
RadComboBoxData comboData = new RadComboBoxData();
if (!string.IsNullOrWhiteSpace(context.Text))
{
try
{
const int TAKE = 15;
aqufitEntities entities = new aqufitEntities();
int itemOffset = context.NumberOfItems;
IQueryable<Group> friends = entities.UserSettings.OfType<Group>().OrderBy(w => w.UserName);
friends = friends.Where(w => w.UserName.ToLower().Contains(context.Text) || w.UserFirstName.ToLower().Contains(context.Text));
int length = friends.Count();
friends = friends.Skip(itemOffset).Take(TAKE);
Group[] groups = friends.ToArray();
foreach (Group g in groups)
{
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = g.UserFirstName;
item.Value = " { 'Address': '', 'GroupKey':" + g.Id + ", 'Lat':" + g.DefaultMapLat + ", 'Lng':" + g.DefaultMapLng + " , 'Name':'" + g.UserFirstName + "', 'UserName':'******'", "") + "', 'UserKey':" + g.UserKey + ", 'ImageId':0, 'Description':'' }";
// item.ImageUrl = ResolveUrl("~/DesktopModules/ATI_Base/services/images/profile.aspx") + "?u=" + g.UserKey + "&p=" + g.PortalKey;
result.Add(item);
}
int endOffset = Math.Min(itemOffset + TAKE + 1, length);
if (endOffset > length)
{
endOffset = length;
}
if (endOffset == length)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
if (length > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), length);
}
else
{
comboData.Message = "No matches";
}
comboData.Items = result.ToArray();
}
catch (Exception ex)
{
comboData.Message = ex.Message;
}
}
else
{
comboData.Message = "Type to search";
}
return comboData;
}
public RadComboBoxData GetRoutesOnDemand(RadComboBoxContext context)
{
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
RadComboBoxData comboData = new RadComboBoxData();
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
long ProfileUserSettingsId = Convert.ToInt64(context["UserSettingsId"]);
aqufitEntities entities = new aqufitEntities();
UserSettings UserSettings = entities.UserSettings.FirstOrDefault(u => u.Id == ProfileUserSettingsId);
IQueryable<MapRoute> mapRoutesQuery = string.IsNullOrEmpty(context.Text) ?
entities.User2MapRouteFav.Include("MapRoutes").Where(r => r.UserSettingsKey == ProfileUserSettingsId).Select(r => r.MapRoute).OrderBy(w => w.Name) :
entities.User2MapRouteFav.Include("MapRoutes").Where(r => r.UserSettingsKey == ProfileUserSettingsId).Select(r => r.MapRoute).Where(r => r.Name.ToLower().StartsWith(context.Text)).OrderBy(r => r.Name);
int length = mapRoutesQuery.Count();
MapRoute[] mapRoutes = mapRoutesQuery.Skip(itemOffset).Take(itemsPerRequest).ToArray();
string mapIcon = ResolveUrl("~/DesktopModules/ATI_Base/resources/images/iMap.png");
if (itemOffset == 0)
{
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = "<img src=\"" + mapIcon + "\" /> Add New Map";
item.Value = "{'Id':0, 'Dist':'0'}";
result.Add(item);
}
Affine.Utils.UnitsUtil.MeasureUnit unit = UserSettings.DistanceUnits != null ? Affine.Utils.UnitsUtil.ToUnit(Convert.ToInt32(UserSettings.DistanceUnits)) : Affine.Utils.UnitsUtil.MeasureUnit.UNIT_MILES;
string unitName = Affine.Utils.UnitsUtil.unitToStringName(unit);
foreach (MapRoute mr in mapRoutes)
{
double dist = Affine.Utils.UnitsUtil.systemDefaultToUnits(mr.RouteDistance, unit);
dist = Math.Round(dist, 2);
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = "<img src=\"" + Affine.Utils.ImageUtil.GetGoogleMapsStaticImage(mr, 200, 150) + "\" />" + Affine.Utils.Web.WebUtils.FromWebSafeString(mr.Name) + " (" + dist + " " + unitName + ")";
item.Value = "{ 'Id':" + mr.Id + ", 'Dist':" + mr.RouteDistance + "}";
result.Add(item);
}
if (endOffset > length)
{
endOffset = length;
}
if (endOffset == length)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
if (length > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), length);
}
else
{
comboData.Message = "No matches";
}
comboData.Items = result.ToArray();
}
catch (Exception ex)
{
comboData.Message = ex.Message;
}
return comboData;
}
public RadComboBoxData GetFlexFWDSearch(RadComboBoxContext context)
{
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
RadComboBoxData comboData = new RadComboBoxData();
if (!string.IsNullOrWhiteSpace(context.Text))
{
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
long ProfileUserSettingsId = Convert.ToInt64(context["UserSettingsId"]);
aqufitEntities entities = new aqufitEntities();
//UserSettings profileSettings = entities.UserSettings.OfType<User>().FirstOrDefault(u => u.UserKey == PortalSettings.Current.UserId && u.PortalKey == PortalSettings.Current.PortalId);
IQueryable<UserSettings> friends = entities.UserSettings.Where(u => u.PortalKey == PortalSettings.Current.PortalId).OrderBy(w => w.UserName);
friends = friends.Where(w => w.UserName.ToLower().StartsWith(context.Text) || w.UserFirstName.ToLower().StartsWith(context.Text) || w.UserLastName.ToLower().StartsWith(context.Text));
int length = friends.Count();
var users = friends.Skip(itemOffset).Take(itemsPerRequest).Select(u => new {Id = u.Id, Type = (u is User ? "User" : "Group"), UserKey = u.UserKey, PortalKey = u.PortalKey, UserFirstName = u.UserFirstName, UserLastName = u.UserLastName, UserName = u.UserName }).ToArray();
foreach (var u in users)
{
RadComboBoxItemData item = new RadComboBoxItemData();
if (u.Type == "User")
{
item.Text = "<img style=\"float: left;\" src=\"" + StreamService.ResolveUrl("~/DesktopModules/ATI_Base/services/images/profile.aspx") + "?u=" + u.UserKey + "&p=" + u.PortalKey + "\" /><span class=\"atiTmItem\">" + u.UserName + "<br /> (" + u.UserFirstName + " " + u.UserLastName + ")</span>";
item.Value = "{ Type:'USER', Val:'" + u.UserName + "'}";
}
else
{
item.Text = "<img style=\"float: left;\" src=\"" + StreamService.ResolveUrl("~/DesktopModules/ATI_Base/services/images/profile.aspx") + "?us=" + u.Id + "\" /><span class=\"atiTmItem\">" + u.UserFirstName + "</span>";
item.Value = "{ Type:'GROUP', Val:'" + u.UserName + "'}";
}
result.Add(item);
}
if (endOffset > length)
{
endOffset = length;
}
if (endOffset == length)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
if (length > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), length);
}
else
{
comboData.Message = "No matches";
}
comboData.Items = result.ToArray();
}
catch (Exception ex)
{
comboData.Message = ex.Message;
}
}
else
{
comboData.Message = "Type to search";
}
return comboData;
}
public static RadComboBoxData GetFieldNames(RadComboBoxContext context)
{
var fields = new List<string>();
if (HttpContext.Current.Session["Fields"] != null)
{
fields = (List<string>) HttpContext.Current.Session["Fields"];
}
var data = (from f in fields where f.ToLower().Contains(context.Text.ToLower()) select f).ToList();
var comboData = new RadComboBoxData();
var itemOffset = context.NumberOfItems;
var endOffset = Math.Min(itemOffset + 10, data.Count);
comboData.EndOfItems = endOffset == data.Count;
var result = new List<RadComboBoxItemData>(endOffset - itemOffset);
for (var i = itemOffset; i < endOffset; i++)
{
var itemData = new RadComboBoxItemData {Text = data.ElementAt(i), Value = data.ElementAt(i)};
result.Add(itemData);
}
comboData.Message = GetStatusMessage(endOffset, data.Count);
comboData.Items = result.ToArray();
return comboData;
}
public RadComboBoxData GetWorkoutsOnDemand(RadComboBoxContext context)
{
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
RadComboBoxData comboData = new RadComboBoxData();
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
long ProfileUserSettingsId = Convert.ToInt64(context["UserSettingsId"]);
aqufitEntities entities = new aqufitEntities();
UserSettings UserSettings = entities.UserSettings.FirstOrDefault(u => u.Id == ProfileUserSettingsId);
if (itemOffset == 0)
{
RadComboBoxItemData item = new RadComboBoxItemData();
item.Text = "Create a New Workout";
item.Value = "{'Id':0, 'Type':'0'}";
result.Add(item);
}
IQueryable<WOD> wods = entities.User2WODFav.Where(w => w.UserSetting.Id == UserSettings.Id).Select(w => w.WOD);
wods = wods.Union<WOD>(entities.WODs.Where(w => w.Standard > 0));
wods.Select(w => w.WODType).ToArray(); // hydrate WODTypes
long[] groupIds = null;
groupIds = entities.UserFriends.Where(f => (f.SrcUserSettingKey == UserSettings.Id || f.DestUserSettingKey == UserSettings.Id) && f.Relationship >= (int)Affine.Utils.ConstsUtil.Relationships.GROUP_OWNER).Select(f => f.SrcUserSettingKey == UserSettings.Id ? f.DestUserSettingKey : f.SrcUserSettingKey).ToArray();
// OK this is a bit of a trick... this query hydrates only the "WODSchedule" in the above WOD query.. so we will get the wods we are looking for..
IEnumerable<WODSchedule>[] workoutSchedule = entities.UserSettings.OfType<Group>().Where(LinqUtils.BuildContainsExpression<UserSettings, long>(us => us.Id, groupIds)).Select(g => g.WODSchedules.Where(ws => ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0)).ToArray();
string lowerTxt = context.Text.ToLower();
if (!string.IsNullOrWhiteSpace(context.Text))
{
wods = wods.Where(w => w.Name.ToLower().Contains(lowerTxt) || w.WODSchedules.Where(ws => ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0).Any(ws => ws.HiddenName.ToLower().Contains(lowerTxt))).OrderBy(w => w.Name);
}
else
{
wods = wods.OrderByDescending(w => w.CreationDate);
}
int length = wods.Count();
wods = wods.Skip(itemOffset).Take(itemsPerRequest);
WOD[] wodList = wods.ToArray();
for (int i = 0; i < wodList.Length; i++)
{
WOD w = wodList[i];
if (w.WODSchedules != null && w.WODSchedules.Count > 0)
{
WODSchedule ws = w.WODSchedules.OrderByDescending(s => s.HideTillDate).First();
if (ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0)
{
if (string.IsNullOrWhiteSpace(context.Text))
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(ws.HiddenName), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
if (w.Standard > 0 || w.WODSchedules.Count > 1)
{ // CA - here is what is going on here. If the workout is suppost to be hidden until a date (common for crossfit gyms) then we just put a date name like up
// top. But if it is a standard WOD (or a wod that they have done before (w.WODSchedules.Count > 1) then we still need to add the WOD
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
else if (ws.HiddenName.ToLower().StartsWith(lowerTxt))
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(ws.HiddenName), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
else
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
else
{
result.Add(new RadComboBoxItemData() { Text = Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), Value = "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}" });
}
}
if (endOffset > length)
{
endOffset = length;
}
if (endOffset == length)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
if (length > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), length);
}
else
{
comboData.Message = "No matches";
}
comboData.Items = result.ToArray();
}
catch (Exception ex)
{
comboData.Message = ex.Message;
}
return comboData;
}
public RadComboBoxData GetSwitchLeads(RadComboBoxContext context)
{
string searchtext = string.Empty;
searchtext = Convert.ToString(context.Text);
RadComboBoxData comboData = new RadComboBoxData();
if (HttpContext.Current.Session["Switchcampusconstring"] != null)
{
DataTable data = new DataTable();
using (SqlConnection connection = new SqlConnection(Convert.ToString(HttpContext.Current.Session["Switchcampusconstring"])))
{
using (SqlCommand CMD = new SqlCommand())
{
string strqry = string.Empty;
strqry = strqry + " SELECT L.LeadsID as LeadsID, ";
strqry = strqry + " Lead = L.LName + ', ' + L.FName + CASE WHEN LEN(L.MInitial) > 0 Then ' ' + L.MInitial Else '' End , ";
strqry = strqry + " ISNULL(L.StatusCode,'') AS LeadStatus, AdRep = E.LName + ', ' + E.FName, L.City, L.State, L.Zip, L.SSN ";
strqry = strqry + " FROM Lead AS L LEFT JOIN LeadStatus AS LS ON L.StatusCode = LS.StatusCode ";
strqry = strqry + " LEFT JOIN Employees AS E ON L.EmpID = E.EmpID ";
strqry = strqry + " where L.LName + ', ' + L.FName like '" + searchtext + "%' or L.StatusCode like '" + searchtext + "%' ";
strqry = strqry + " or E.LName + ', ' + E.FName like '" + searchtext + "%' or L.City like '" + searchtext + "%' or ";
strqry = strqry + " L.State like '" + searchtext + "%' or L.Zip like '" + searchtext + "%' or L.SSN like '" + searchtext + "%' ";
strqry = strqry + " ORDER BY L.LName + ', ' + L.FName + ' ' + ISNULL(L.MInitial,'') ";
CMD.Connection = connection;
CMD.CommandType = System.Data.CommandType.Text;
CMD.CommandText = strqry;
CMD.Prepare();
SqlDataAdapter DataAdapter = new SqlDataAdapter(CMD);
DataAdapter.Fill(data);
}
}
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > data.Rows.Count)
{
endOffset = data.Rows.Count;
}
if (endOffset == data.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>(endOffset - itemOffset);
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
string itemtext = string.Empty;
itemtext = itemtext + "<ul style='z-index:100'>";
itemtext = itemtext + "<li class='Lcol1'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["Lead"]);
itemtext = itemtext + "</li>";
itemtext = itemtext + "<li class='Lcol2'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["LeadsID"]);
itemtext = itemtext + "<li class='Lcol3'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["LeadStatus"]);
itemtext = itemtext + "<li class='Lcol4'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["AdRep"]);
itemtext = itemtext + "<li class='Lcol5'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["City"]);
itemtext = itemtext + "<li class='Lcol6'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["State"]);
itemtext = itemtext + "<li class='Lcol7'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["Zip"]);
itemtext = itemtext + "</ul>";
itemData.Text = itemtext;
itemData.Value = Convert.ToString(data.Rows[i]["LeadsID"]);
result.Add(itemData);
}
if (data.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), data.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
public RadComboBoxData GetSwitchStudents(RadComboBoxContext context)
{
string searchtext = string.Empty;
searchtext = Convert.ToString(context.Text);
RadComboBoxData comboData = new RadComboBoxData();
if (HttpContext.Current.Session["Switchcampusconstring"] != null)
{
DataTable data = new DataTable();
using (SqlConnection connection = new SqlConnection(Convert.ToString(HttpContext.Current.Session["Switchcampusconstring"])))
{
using (SqlCommand CMD = new SqlCommand())
{
string strqry = string.Empty;
strqry = strqry + " select S.StudentID,S.LastName+', '+ S.FirstName as FullName,convert(varchar(50), S.StudentNo) as StudentNo, ";
strqry = strqry + " (Select StudentStatus from StudentStatus where StudentStatusID=S.StudentStatusID) as StudentStatus ";
strqry = strqry + " ,S.StudentStatusID,S.EMail,S.SSN from Students AS S ";
strqry = strqry + " where S.LastName+', '+ S.FirstName like '" + searchtext + "%' or S.StudentNo like '" + searchtext + "%' ";
strqry = strqry + " or (Select StudentStatus from StudentStatus where StudentStatusID=S.StudentStatusID) like '" + searchtext + "%' ";
strqry = strqry + " or S.EMail like '" + searchtext + "%' or S.SSN like '" + searchtext + "%' ORDER BY S.LastName+', '+ S.FirstName ";
CMD.Connection = connection;
CMD.CommandType = System.Data.CommandType.Text;
CMD.CommandText = strqry;
CMD.Prepare();
SqlDataAdapter DataAdapter = new SqlDataAdapter(CMD);
DataAdapter.Fill(data);
}
}
List <RadComboBoxItemData> result = new List <RadComboBoxItemData>(context.NumberOfItems);
try
{
int itemsPerRequest = 10;
int itemOffset = context.NumberOfItems;
int endOffset = itemOffset + itemsPerRequest;
if (endOffset > data.Rows.Count)
{
endOffset = data.Rows.Count;
}
if (endOffset == data.Rows.Count)
{
comboData.EndOfItems = true;
}
else
{
comboData.EndOfItems = false;
}
result = new List <RadComboBoxItemData>(endOffset - itemOffset);
//=================================================================
/*List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(context.NumberOfItems);
* foreach(row in rows)
* {
* RadComboBoxItemData itemData = new RadComboBoxItemData();
* itemData.Attributes.Add("HostName", row["HostName"].ToString());
* itemData.Value = row["ID"].ToString();
* result.Add(itemData);
* }
* return result;*/
//===================================================================
for (int i = itemOffset; i < endOffset; i++)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
// itemData.Text = Convert.ToString(data.Rows[i]["FullName"]);
string itemtext = string.Empty;
itemtext = itemtext + "<ul style='z-index:100'>";
itemtext = itemtext + "<li class='col1'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["FullName"]) + "</li>";
itemtext = itemtext + "<li class='col2'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["StudentNo"]) + "</li>";
itemtext = itemtext + "<li class='col3'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["StudentStatus"]) + "</li> ";
itemtext = itemtext + "<li class='col4'>";
itemtext = itemtext + Convert.ToString(data.Rows[i]["EMail"]) + "</li> ";
itemtext = itemtext + "</ul>";
itemData.Text = itemtext;
itemData.Value = Convert.ToString(data.Rows[i]["StudentNo"]);
result.Add(itemData);
}
if (data.Rows.Count > 0)
{
comboData.Message = String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), data.Rows.Count.ToString());
}
else
{
comboData.Message = "No matches";
}
}
catch (Exception e)
{
comboData.Message = e.Message;
}
comboData.Items = result.ToArray();
}
return(comboData);
}
