public void ProcessRequest(HttpContext context)
{
List<data> search;
using (var db = new WaltonCrmEntities())
{
var spareParts =
db.SpareParts.Select(x => new data
{
id = x.ItemID,
text = x.ItemName
}).ToList();
search = spareParts;
}
if (context.Request.QueryString["term"] != null)
{
var term = context.Request.QueryString["term"].ToString();
context.Response.Clear();
context.Response.ContentType = "application/json";
//q 2term 2
search = search.Where(x => x.text.ToLower().Contains(term)).ToList();
}
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
string json = jsSerializer.Serialize(search);
context.Response.Write(json);
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db=new WaltonCrmEntities())
{
var dataToBing = db.SpareParts.Take(1000).ToList();
GridView1.DataSource = dataToBing;
GridView1.DataBind();
}
GridView1.UseAccessibleHeader = true;
GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;
}
public static string getSpareParts()
{
List<String> spareParts;
using (var db = new WaltonCrmEntities())
{
spareParts = db.SpareParts.Select(x =>x.ItemName).ToList();
}
JavaScriptSerializer js = new JavaScriptSerializer();
return js.Serialize(spareParts);
//return spareParts;
}
public static List<Select2Data> getSpareParts(string search, string page)
{
//q 2term 2
var db = new WaltonCrmEntities();
var dataOfSelect = db.SpareParts.Select(x => new Select2Data
{
id = x.ItemID,
text = x.ItemName
}).ToList();
JavaScriptSerializer js = new JavaScriptSerializer();
return dataOfSelect;
}
protected void Page_Load(object sender, EventArgs e)
{
String userName = Request["userName"];
String password = Request["password"];
using (var dataContext=new WaltonCrmEntities())
{
}
}
public void GetDropDownListBindings()
{
if (!User.Identity.IsAuthenticated)
{
List<DropDownListBinding> downList;
using (var db = new WaltonCrmEntities())
{
downList = db.SpareParts.Where(x => x.ItemID < 100).Select(x => new DropDownListBinding
{
Id = x.ItemID,
ItemName = x.ItemName + "_" + x.ItemCode
}).ToList();
}
JavaScriptSerializer js = new JavaScriptSerializer();
HttpContext.Current.Response.Write(js.Serialize(downList));
}
else
{
HttpContext.Current.Response.Write("hi");
}
//return js.Serialize(downList);
}
public static List<SparePart> ajaxcall(string text)
{
var spareParts = new WaltonCrmEntities().SpareParts.ToList();
return spareParts;
}
