private PERMISSIONSRes validPermission(PERMISSIONSReq dataReq, string conStr = null)
{
var res = new PERMISSIONSRes();
try
{
var userReq = new ASSETKKF_MODEL.Data.Mssql.Asset.STUSERASSET()
{
UCODE = dataReq.INPID,
COMPANY = dataReq.COMPANY,
};
var userLst = ASSETKKF_ADO.Mssql.Asset.STUSERASSETAdo.GetInstant().Search(userReq, null, conStr);
var objUser = userLst != null?userLst.FirstOrDefault() : null;
var gucode = objUser != null ? objUser.GUCODE : null;
var req = new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE,
GUCODE = gucode,
COMPANY = dataReq.COMPANY,
P_ACCESS = dataReq.P_ACCESS,
P_MANAGE = dataReq.P_MANAGE,
P_DELETE = dataReq.P_DELETE,
P_APPROVE = dataReq.P_APPROVE,
P_EXPORT = dataReq.P_EXPORT,
INPID = dataReq.INPID,
};
var lst = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().Valid(req, null, conStr);
res.PERMISSIONSLST = lst;
if (lst != null && lst.Count > 0)
{
res.hasPermission = true;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res.hasPermission = false;
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Not Found";
}
}
catch (Exception ex)
{
res.hasPermission = false;
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
private PERMISSIONSRes deleteByGroup(PERMISSIONSReq dataReq, string conStr = null)
{
var res = new PERMISSIONSRes();
try
{
var lst = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().Get(new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE, GUCODE = dataReq.GUCODE, COMPANY = dataReq.COMPANY
}, null, conStr);
if (lst != null && lst.Count > 0)
{
var req = new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE,
GUCODE = dataReq.GUCODE,
COMPANY = dataReq.COMPANY,
P_ACCESS = dataReq.P_ACCESS,
P_MANAGE = dataReq.P_MANAGE,
P_DELETE = dataReq.P_DELETE,
P_APPROVE = dataReq.P_APPROVE,
P_EXPORT = dataReq.P_EXPORT,
INPID = dataReq.INPID,
};
var state = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().DeleteAllByGroup(req, null, conStr);
res._result._code = "200";
res._result._message = "ลบข้อมูลเรียบร้อยแล้ว";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Not Found";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var newList = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().ListActive(new STPERMISSIONS()
{
COMPANY = dataReq.COMPANY
}, null, conStr);
res.PERMISSIONSLST = newList;
}
return(res);
}
private PERMISSIONSRes insert(PERMISSIONSReq dataReq, string conStr = null)
{
var res = new PERMISSIONSRes();
try
{
var lst = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().Get(new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE, GUCODE = dataReq.GUCODE, COMPANY = dataReq.COMPANY
}, null, conStr);
if (lst == null || (lst != null && lst.Count == 0))
{
var req = new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE,
GUCODE = dataReq.GUCODE,
COMPANY = dataReq.COMPANY,
P_ACCESS = dataReq.P_ACCESS,
P_MANAGE = dataReq.P_MANAGE,
P_DELETE = dataReq.P_DELETE,
P_APPROVE = dataReq.P_APPROVE,
P_EXPORT = dataReq.P_EXPORT,
INPID = dataReq.INPID,
};
var state = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().Insert(req, null, conStr);
res._result._code = "200";
res._result._message = "บันทึกข้อมูลเรียบร้อยแล้ว";
res._result._status = "OK";
}
else
{
throw new Exception("กำหนดสิทธิ์การใช้งานซ้ำ");
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var newList = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().ListActive(new STPERMISSIONS()
{
COMPANY = dataReq.COMPANY
}, null, conStr);
res.PERMISSIONSLST = newList;
}
return(res);
}
private PERMISSIONSRes getGroupUser(PERMISSIONSReq dataReq, string conStr = null)
{
var res = new PERMISSIONSRes();
try
{
var req = new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE,
GUCODE = dataReq.GUCODE,
COMPANY = dataReq.COMPANY,
P_ACCESS = dataReq.P_ACCESS,
P_MANAGE = dataReq.P_MANAGE,
P_DELETE = dataReq.P_DELETE,
P_APPROVE = dataReq.P_APPROVE,
P_EXPORT = dataReq.P_EXPORT,
INPID = dataReq.INPID,
};
var lst = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().getGROUPUSER(new STPERMISSIONS()
{
COMPANY = dataReq.COMPANY
}, null, conStr);
res.GROUPUSERLST = lst;
if (lst != null && lst.Count > 0)
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Not Found";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
protected override void ExecuteChild(PERMISSIONSReq dataReq, ResponseAPI dataRes)
{
DBMode = dataReq.DBMode;
var res = new PERMISSIONSRes();
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
try
{
switch (dataReq.MODE.Trim().ToLower())
{
case "insert":
res = insert(dataReq, conString);
break;
case "update":
res = update(dataReq, conString);
break;
case "delete":
res = delete(dataReq, conString);
break;
case "deletebygroup":
res = deleteByGroup(dataReq, conString);
break;
case "search":
res = search(dataReq, conString);
break;
case "groupuser":
res = getGroupUser(dataReq, conString);
break;
case "groupuseractive":
res = getGroupUserActive(dataReq, conString);
break;
case "getmenu":
res = getMenu(dataReq, conString);
break;
case "getgrouppermission":
res = getGroupPermission(dataReq, conString);
break;
case "validpermission":
res = validPermission(dataReq, conString);
break;
default:
res = getPermissions(dataReq, conString);
break;
}
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
