public ActionResult updateDept(eDepartmentItem dept, string userId)
{
dept.UPDATE_UID = Session["UserId"].ToString();
dynamic showMessageString = string.Empty;
DataTable dtResult = aDeptAccessVer2.updateDept(dept);
string strResult = dtResult.Rows[0][0].ToString();
string strMes = dtResult.Rows[0][1].ToString();
showMessageString = new
{
param1 = 200,
param2 = strResult,
param3 = strMes
};
try
{
Session["dept_tree_ver2"] = null;
return(Json(showMessageString, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var errorMsg = ex.Message.ToString();
showMessageString = new
{
param1 = 404,
param2 = "error",
param3 = "proccess error"
};
return(Json(showMessageString, JsonRequestBehavior.AllowGet));
}
}
public eDepartmentItem addNewDept(eDepartmentItem _dept)
{
eDepartmentItem result = new eDepartmentItem();
result.DEPTNAME = _dept.DEPTNAME;
result.DEPTSHORTNAME = _dept.DEPTSHORTNAME;
result.ISACTIVE = _dept.ISACTIVE;
result.DEPTPARENT = _dept.DEPTPARENT;
return(result);
}
public static DataTable updateDept(eDepartmentItem dept)
{
DataTable dtResult = new DataTable();
OracleParameter[] _sqlParam = new OracleParameter[6];
_sqlParam[0] = new OracleParameter("PDEPTCODE", string.IsNullOrEmpty(dept.DEPTCODE) ? "" : dept.DEPTCODE);
_sqlParam[1] = new OracleParameter("pDeptName", string.IsNullOrEmpty(dept.DEPTNAME) ? "" : dept.DEPTNAME);
_sqlParam[2] = new OracleParameter("pDeptShortName", string.IsNullOrEmpty(dept.DEPTSHORTNAME) ? "" : dept.DEPTSHORTNAME);
_sqlParam[3] = new OracleParameter("pIsActive", dept.ISACTIVE);
_sqlParam[4] = new OracleParameter("pUserId", dept.UPDATE_UID);
_sqlParam[5] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
dtResult = DBHelper.getDataTable_SP("PKHR_ORGANIZATION_VER2.SP_UPDATE_DEPARTMENT", _sqlParam);
return(dtResult);
}
public JsonResult getDeptDetail(string deptcode)
{
eDepartmentItem eResult = new eDepartmentItem();
DataTable dtResult = aDeptAccessVer2.getDeptDetail(deptcode);
dynamic strResult = string.Empty;
strResult = new
{
parent_name = dtResult.Rows[0]["parentname"].ToString(),
deptcode = dtResult.Rows[0]["deptcode"].ToString(),
deptName = dtResult.Rows[0]["deptname"].ToString(),
deptParent = dtResult.Rows[0]["deptparent"].ToString(),
deptShortName = dtResult.Rows[0]["deptshortname"].ToString(),
isActive = dtResult.Rows[0]["isactive"].ToString()
};
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public static List <eDepartmentItem> getDeptTreeVer2()
{
List <eDepartmentItem> lstResult = new List <eDepartmentItem>();
DataTable dtResult = new DataTable();
dtResult = aDeptAccessVer2.getAllDept();
foreach (DataRow dtr in dtResult.Rows)
{
eDepartmentItem item = new eDepartmentItem();
item.DEPTCODE = dtr["DEPTCODE"].ToString();
item.DEPTNAME = dtr["DEPTNAME"].ToString();
item.DEPTPARENT = dtr["DEPTPARENT"].ToString();
item.ISLEAF = dtr["ISLEAF"].ToString();
lstResult.Add(item);
}
return(lstResult);
}
