public HttpResponseMessage loadObjective_Used()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.ObjectType));
List <Objective_Used_Model> list = new List <Objective_Used_Model>();
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <ObjectType> collection = ObjectSpace.GetObjects <ObjectType>(CriteriaOperator.Parse(" GCRecord is null and IsActive = 1", null));
foreach (ObjectType row in collection)
{
Objective_Used_Model model = new Objective_Used_Model();
model.ObjectTypeName = row.ObjectTypeName;
model.Oid = row.Oid.ToString();
list.Add(model);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage ObjectType()
{
try
{
string ObjectTypeOid = HttpContext.Current.Request.Form["ObjectTypeOid"].ToString();
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(ObjectType));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <Objective_Used_Model> list = new List <Objective_Used_Model>();
List <activityDetails_Model> detail = new List <activityDetails_Model>();
IList <ObjectType> collection = ObjectSpace.GetObjects <ObjectType>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 ", null));
{
if (collection.Count > 0)
{
foreach (ObjectType row in collection)
{
Objective_Used_Model Item = new Objective_Used_Model();
Item.Oid = row.Oid.ToString();
Item.ObjectTypeName = row.ObjectTypeName;
list.Add(Item);
}
}
else
{ //invalid
UserError err = new UserError();
err.status = "false";
err.code = "0";
err.message = "กรุณาใส่ข้อมูลให้เรียบร้อย";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
finally
{
SqlConnection.ClearAllPools();
}
}
