public void ProcessRequest(HttpContext context)
{
if (context.Request.RequestType == "PUT")
{
string retJSON = string.Empty;
using (StreamReader sr = new StreamReader(context.Request.InputStream))
{
retJSON = sr.ReadToEnd();
sr.Close();
sr.Dispose();
}
//process the JSON
List<vw_Assignment_Allocation> allocations = (List<vw_Assignment_Allocation>) new JavaScriptSerializer().Deserialize(retJSON, typeof(List<vw_Assignment_Allocation>));
Regex rex = new Regex(@"^C\d{2}_\d{2}_\d{4}$");
AllocationEntities ae = new AllocationEntities();
foreach (vw_Assignment_Allocation allocation in allocations)
{
foreach (var prop in allocation.GetType().GetProperties())
{
//allocation.C06_17_2016
Match m = rex.Match(prop.Name);
if(m.Success)
ae.upds_Assignment_Allocation_Update(null, allocation.Assignment_ID, GetDate(prop.Name), (double)prop.GetValue(allocation));
}
}
}
context.Response.ContentType = "application/json";
context.Response.Write("{\"status\":\"ok\"}");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
AllocationEntities ae = new AllocationEntities();
string json = new JavaScriptSerializer().Serialize(ae.Resources.OrderBy(o => o.Resource_Name));
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
AllocationEntities ae = new AllocationEntities();
string json = new JavaScriptSerializer().Serialize(ae.WeekEnding.AsQueryable().Where(o => o.Week_Ending > DateTime.Today).OrderBy(o => o.Week_Ending_Text));
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
string resource = context.Request.QueryString.Get(0);
context.Response.ContentType = "application/json";
AllocationEntities ae = new AllocationEntities();
var query = ae.vw_Assignment_Allocation.AsQueryable().Where(o => o.Developer == resource);
string json = new JavaScriptSerializer().Serialize(query);
context.Response.Write(json);
}