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 string GetUserByPrimaryKey(string userId)
{
try
{
AuthenController ctrl = new AuthenController();
MAS_USERSerializeProperties obj = ctrl.GetUserByPrimaryKey(userId);
object ret = new
{
Code = obj.USER_ID,
Pwd = obj.PASSWORD,
NameEng = obj.USER_NAME_ENG,
NameLoc = obj.USER_NAME_LOC,
PhoneNo = obj.PHONE_NO == "" ? "N/A" : obj.PHONE_NO,
Email = obj.EMAIL == "" ? "N/A" : obj.EMAIL,
CCA = obj.CCA == "" ? "N/A" : obj.CCA,
ServiceKey = obj.CCA_SERVICEKEY == "" ? "N/A" : obj.CCA_SERVICEKEY,
CancelFlag = obj.CANCEL_FLAG == "" ? "N" : obj.CANCEL_FLAG,
DepartmentName = obj.DEPARTMENT_NAME
};
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public bool UpdateOrg(MAS_ORGSerializeProperties values)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.UpdateOrg(values));
}
catch (Exception)
{
throw;
}
}
public bool DeleteUser(string userId)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.DeleteUser(userId, MySession.Current.ModuleCode));
}
catch (Exception)
{
throw;
}
}
public bool AddNewUser(MAS_USERSerializeProperties values)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.AddNewUser(values, MySession.Current.LoginId));
}
catch (Exception)
{
throw;
}
}
public bool DeleteOrg(string ORG_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.DeleteOrg(ORG_CODE, MySession.Current.ModuleCode));
}
catch (Exception)
{
throw;
}
}
public bool SetScreenProfile(List <MAS_SCREEN_PROFILESerializeProperties> values)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.SetScreenProfile(MySession.Current.ModuleCode, values));
}
catch (Exception)
{
throw;
}
}
public bool RemoveGroupFromPermission(string ORG_CODE, string GROUP_USER, string PROGRAM_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.RemoveGroupFromPermission(ORG_CODE, GROUP_USER, PROGRAM_CODE, MySession.Current.ModuleCode, MySession.Current.Schema));
}
catch (Exception)
{
throw;
}
}
public bool DeleteProgram(List <String> PROGRAM_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.DeleteProgram(MySession.Current.ModuleCode, PROGRAM_CODE, MySession.Current.Schema));
}
catch (Exception)
{
throw;
}
}
public string GetUserByOrg(string ORG_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
return(JsonConvert.SerializeObject(ctrl.GetUserByOrg(ORG_CODE)));
}
catch (Exception)
{
throw;
}
}
public bool UpdateMenu(List <MAS_PROGRAMSerializeProperties> values)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.UpdateMenu(MySession.Current.ModuleCode, MySession.Current.Schema, values));
}
catch (Exception)
{
throw;
}
}
public bool RemoveUserFromGroup(string ORG_CODE, string GROUP_USER, string USER_ID)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.RemoveUserFromGroup(ORG_CODE, GROUP_USER, USER_ID, MySession.Current.LoginId, MySession.Current.ModuleCode));
}
catch (Exception)
{
throw;
}
}
public bool DeleteGroup(string ORG_CODE, string GROUP_USER)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.DeleteGroup(ORG_CODE, GROUP_USER));
}
catch (Exception)
{
throw;
}
}
public bool UpdateGroup(MAS_GROUP_USERSerializeProperties values)
{
try
{
AuthenController ctrl = new AuthenController();
return(ctrl.UpdateGroup(values, MySession.Current.LoginId));
}
catch (Exception)
{
throw;
}
}
public bool AddNewModule(MAS_MODULESerializeProperties values)
{
try
{
string schema = ConfigurationManager.AppSettings["stdSchema"].ToString();
AuthenController ctrl = new AuthenController();
return(ctrl.AddNewModule(values, schema));
}
catch (Exception)
{
throw;
}
}
public bool AddNewUserOnRegister(MAS_USERSerializeProperties USER, string MODULE_CODE)
{
try
{
string schema = ConfigurationManager.AppSettings["stdSchema"].ToString();
AuthenController ctrl = new AuthenController();
return(ctrl.AddNewUserOnRegister(USER, MODULE_CODE, schema));
}
catch (Exception)
{
throw;
}
}
public bool CheckOrgRegister()
{
try
{
string schema = ConfigurationManager.AppSettings["stdSchema"].ToString();
AuthenController ctrl = new AuthenController();
return(ctrl.CheckOrgRegister(schema));
}
catch (Exception)
{
throw;
}
}
public string GetRootMenu()
{
try
{
AuthenController ctrl = new AuthenController();
List <MAS_PROGRAMSerializeProperties> ret = ctrl.GetRootMenu(MySession.Current.ModuleCode, MySession.Current.Schema);
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetScreenProfile(string programCode)
{
try
{
AuthenController ctrl = new AuthenController();
List <MAS_SCREEN_PROFILESerializeProperties> ret = ctrl.GetScreenProfile(MySession.Current.ModuleCode, programCode, MySession.Current.MyLanuageName);
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetProgramByPrimaryKey(string PROGRAM_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
MAS_PROGRAMSerializeProperties ret = ctrl.GetProgramByPrimaryKey(PROGRAM_CODE, MySession.Current.Schema);
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetUserPermissionByRoot(string ORG_CODE, string GROUP_ID, string PROGRAM_CODE)
{
try
{
AuthenController ctrl = new AuthenController();
List <MAS_PROGRAMSerializeProperties> ret = ctrl.GetUserPermissionByRoot(MySession.Current.ModuleCode, ORG_CODE, GROUP_ID, PROGRAM_CODE, MySession.Current.Schema);
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetModule()
{
try
{
string ModuleCode = ConfigurationManager.AppSettings["ModuleCode"].ToString();
AuthenController ctrl = new AuthenController();
List <MAS_MODULESerializeProperties> ret = ctrl.GetModule(ModuleCode);
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public string GetUser()
{
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();
int RecordCount = ctrl.GetCountUser(sSearch);
List <MAS_USERSerializeProperties> coll = ctrl.GetUserWithPaging(sSearch, PageStart, PageEnd);
var ret = coll.Select(p => new
{
Code = p.USER_ID,
NameEng = p.USER_NAME_ENG,
NameLoc = p.USER_NAME_LOC,
PhoneNo = p.PHONE_NO,
Email = p.EMAIL,
CCA = p.CCA,
ServiceKey = p.CCA_SERVICEKEY,
Signature = p.SIGNATURE,
DepartmentName = p.DEPARTMENT_NAME
}).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 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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
AuthenController ctrl = new AuthenController();
MAS_PROGRAMSerializeProperties obj = ctrl.GetProgramByPrimaryKey("TRORG", MySession.Current.Schema);
if (MySession.Current.MyLanuage == LanguageType.Eng)
{
lblPageHeader.Text = obj.DESC_ENG;
}
else
{
lblPageHeader.Text = obj.DESC_LOC;
}
}
}
public string GetGroupUser()
{
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 OrgCode = nvc["OrgCode"];
var GroupCode = nvc["GroupCode"];
var iExisting = nvc["iExisting"];
var PageIndex = iDisplayStart == 0 ? 1 : (iDisplayStart / iDisplayLength) + 1;
var PageEnd = PageIndex * iDisplayLength;
var PageStart = (PageEnd - iDisplayLength) + 1;
AuthenController ctrl = new AuthenController();
int RecordCount = ctrl.GetCountGroupUser(sSearch, OrgCode, GroupCode, iExisting);
List <MAS_USERSerializeProperties> coll = ctrl.GetGroupUserWithPaging(sSearch, OrgCode, GroupCode, iExisting, PageStart, PageEnd);
var ret = coll.Select(p => new
{
Code = p.USER_ID,
NameEng = p.USER_NAME_ENG,
NameLoc = p.USER_NAME_LOC
}).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;
}
}
protected void btnLoginAfterSelectOrg_Click(object sender, EventArgs e)
{
try
{
var ctrl = new AuthenController();
MySession.Current.ModuleCode = _moduleCode;
MySession.Current.LoginId = txtUserId.Text.Trim();
MySession.Current.OrgCode = ddlOrgCode.SelectedItem.Value;
MySession.Current.OrgName = ddlOrgCode.SelectedItem.Text;
MySession.Current.Schema = ctrl.GetOrgByPrimaryKey(MySession.Current.OrgCode).SCHEMA;
Response.Redirect("Default.aspx");
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message;
lblErrorMessage.Visible = true;
}
}
public string GetLanguageList()
{
try
{
AuthenController ctrl = new AuthenController();
List <MAS_LANGUAGESerializeProperties> coll = ctrl.GetLanguage();
var ret = coll.Select(p => new
{
p.LANGUAGE_CODE,
LANGUAGE_NAME = MySession.Current.MyLanuage == LanguageType.Eng ? p.DESC_ENG : p.DESC_LOC
}).ToList();
return(JsonConvert.SerializeObject(ret));
}
catch (Exception)
{
throw;
}
}
public bool CheckDup(string userId)
{
try
{
AuthenController ctrl = new AuthenController();
int ret = int.Parse(ctrl.CheckDup(userId));
if (ret > 0)
{
return(true);
}
else
{
return(false);
}
}
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;
}
}
