public HttpResponseMessage GetDLD_byORG()
{
string OrganizationOid = null;
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(DLDArea));
XafTypesInfo.Instance.RegisterEntity(typeof(Organization));
List <listdetail> DLD = new List <listdetail>();
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
//IList<Organization> collection = ObjectSpace.GetObjects<Organization>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and OrganizeNameTH LIKE 'เขต%'", null));
IList <Organization> collection = ObjectSpace.GetObjects <Organization>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and OrganizeNameTH like 'เขต%'", null));
var query = from Q in collection orderby Q.OrganizeNameTH select Q;
foreach (Organization row in query)
{
listdetail listsa = new listdetail();
listsa.OId = row.Oid.ToString();
listsa.DLDName = row.OrganizeNameTH;
IList <Organization> collection2 = ObjectSpace.GetObjects <Organization>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and MasterOrganization ='" + row.Oid + "' ", null));
List <listDLD> listDLDs = new List <listDLD>();
foreach (Organization row2 in collection2)
{
listDLD item = new listDLD();
item.ORGOid = row2.Oid.ToString();
item.OrganizationName = row2.OrganizeNameTH;
listDLDs.Add(item);
}
listsa.Detail = listDLDs;
DLD.Add(listsa);
}
return(Request.CreateResponse(HttpStatusCode.OK, DLD));
}
catch (Exception ex)
{
err2 err = new err2();
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
throw;
}
}
public HttpResponseMessage getDLDarea()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(DLDArea));
XafTypesInfo.Instance.RegisterEntity(typeof(Organization));
List <listdetail> DLD = new List <listdetail>();
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
//IList<Organization> collection = ObjectSpace.GetObjects<Organization>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and OrganizeNameTH LIKE 'เขต%'", null));
IList <Organization> collection = ObjectSpace.GetObjects <Organization>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and OrganizeNameTH like 'เขต%'", null));
var query = from Q in collection orderby Q.OrganizeNameTH select Q;
{
if (query != null)
{
string Oidzone = ConfigurationManager.AppSettings["Oidzoneall"];
string Textzone = ConfigurationManager.AppSettings["textzoneall"];
string OidOrg = ConfigurationManager.AppSettings["OidOrgall"];
string TextOrg = ConfigurationManager.AppSettings["textOrgall"];
listdetail listsa = new listdetail();
listsa.OId = Oidzone;
listsa.DLDName = Textzone;
List <listDLD> listDLDs = new List <listDLD>();
listDLD item = new listDLD();
item.ORGOid = OidOrg;
item.OrganizationName = TextOrg;
listDLDs.Add(item);
listsa.Detail = listDLDs;
DLD.Add(listsa);
}
foreach (Organization row in query)
{
listdetail listsa = new listdetail();
listsa.OId = row.Oid.ToString();
listsa.DLDName = row.OrganizeNameTH;
IList <Organization> collection2 = ObjectSpace.GetObjects <Organization>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and MasterOrganization ='" + row.Oid + "' ", null));
List <listDLD> listDLDs = new List <listDLD>();
//if (collection2 != null && listDLDs.Count == 0)
//{
// string OidOrg = ConfigurationManager.AppSettings["OidOrgall"];
// string TextOrg = ConfigurationManager.AppSettings["textOrgall"];
// listDLD item = new listDLD();
// item.ORGOid = OidOrg;
// item.OrganizationName = TextOrg;
// listDLDs.Add(item);
//}
foreach (Organization row2 in collection2)
{
listDLD item = new listDLD();
item.ORGOid = row2.Oid.ToString();
item.OrganizationName = row2.OrganizeNameTH;
listDLDs.Add(item);
}
listsa.Detail = listDLDs;
DLD.Add(listsa);
}
return(Request.CreateResponse(HttpStatusCode.OK, DLD));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
