public string GetOrgByOrgCode(string ORG_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
MAS_ORGSerializeProperties obj = ctrl.GetOrgByPrimaryKey(ORG_CODE);
if (obj != null)
{
object ret = new
{
OrgCode = obj.ORG_CODE,
OrgName = MySession.Current.MyLanuage == LanguageType.Eng ? obj.ORG_NAME_ENG : obj.ORG_NAME_LOC
};
return(JsonConvert.SerializeObject(ret));
}
else
{
return("");
}
}
catch (Exception)
{
throw;
}
}
public bool UpdateOrg(MAS_ORGSerializeProperties values)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.UpdateOrg(values));
}
catch (Exception)
{
throw;
}
}
public string GetOrganization()
{
try
{
NameValueCollection nvc = HttpUtility.ParseQueryString(HttpContext.Current.Request.Url.Query);
var sEcho = nvc["sEcho"];
var iDisplayStart = Convert.ToInt32(nvc["iDisplayStart"]);
var iDisplayLength = Convert.ToInt32(nvc["iDisplayLength"]);
var iSortCol = Convert.ToInt32(nvc["iSortCol_0"]);
var isAsc = nvc["sSortDir_0"] == "asc";
var sSearch = nvc["sSearch"];
var PageIndex = iDisplayStart == 0 ? 1 : (iDisplayStart / iDisplayLength) + 1;
var PageEnd = PageIndex * iDisplayLength;
var PageStart = (PageEnd - iDisplayLength) + 1;
AuthenController ctrl = new AuthenController();
MAS_ORGSerializeProperties org = ctrl.GetOrgByPrimaryKey(MySession.Current.OrgCode);
int RecordCount = ctrl.GetCountOrg(sSearch, MySession.Current.Schema, org.CENTER_ORG);
List <MAS_ORGSerializeProperties> coll = ctrl.GetOrgWithPaging(sSearch, PageStart, PageEnd, MySession.Current.Schema, org.CENTER_ORG);
var ret = coll.Select(p => new
{
OrgCode = p.ORG_CODE,
OrgNameEng = p.ORG_NAME_ENG,
OrgNameLoc = p.ORG_NAME_LOC,
ShortNameEng = p.SHORT_NAME_ENG,
ShortNameLoc = p.SHORT_NAME_LOC,
Schema = p.SCHEMA,
CenterOrg = p.CENTER_ORG
}).ToList();
var dtPage = new SysDataTablePager();
dtPage.sEcho = sEcho;
dtPage.iTotalRecords = RecordCount;
dtPage.iTotalDisplayRecords = RecordCount;
dtPage.aaData = ret.Select(c => (object)c).ToList();
return(JsonConvert.SerializeObject(dtPage));
}
catch (Exception)
{
throw;
}
}
public string GetProgramList()
{
try
{
AuthenController ctrl = new AuthenController();
MAS_ORGSerializeProperties org = ctrl.GetOrgByPrimaryKey(MySession.Current.OrgCode);
List <MAS_PROGRAMSerializeProperties> coll = ctrl.GetProgramList(MySession.Current.Schema, org.CENTER_ORG);
var ret = coll.Select(p => new
{
p.PROGRAM_CODE,
p.PROGRAM_PATH,
PROGRAM_NAME = MySession.Current.MyLanuage == LanguageType.Eng ? p.DESC_ENG : p.DESC_LOC
}).ToList();
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetGroupDetailByPrimaryKey(string ORG_CODE, string GROUP_USER)
{
try
{
AuthenController ctrl = new AuthenController();
MAS_GROUP_USERSerializeProperties obj = ctrl.GetGroupByPrimaryKey(ORG_CODE, GROUP_USER);
string groupName = MySession.Current.MyLanuage == LanguageType.Eng ? obj.DESC_ENG : obj.DESC_LOC;
MAS_ORGSerializeProperties objOrg = ctrl.GetOrgByPrimaryKey(ORG_CODE);
string orgName = MySession.Current.MyLanuage == LanguageType.Eng ? objOrg.ORG_NAME_ENG : objOrg.ORG_NAME_LOC;
object ret = new
{
GroupName = groupName,
OrgName = orgName
};
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetOrgByPrimaryKey(string ORG_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
MAS_ORGSerializeProperties obj = ctrl.GetOrgByPrimaryKey(ORG_CODE);
object ret = new
{
OrgCode = obj.ORG_CODE,
OrgNameEng = obj.ORG_NAME_ENG,
OrgNameLoc = obj.ORG_NAME_LOC,
ShortNameEng = obj.SHORT_NAME_ENG,
ShortNameLoc = obj.SHORT_NAME_LOC,
Schema = obj.SCHEMA,
CenterOrg = obj.CENTER_ORG
};
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
