public static DataTable updateGeoReport(eGeoReportItem eReport, string userId)
{
OracleParameter[] sqlParam = new OracleParameter[7];
sqlParam[0] = new OracleParameter("PREPORTCODE", eReport.GEOREPORTCD);
sqlParam[1] = new OracleParameter("PDEPTCODE", eReport.DEPTCODE);
sqlParam[2] = new OracleParameter("PSYS_EMPID", eReport.SYS_EMPID);
sqlParam[3] = new OracleParameter("PAPPLYDATE", eReport.APPLYDATE.ToString("yyyyMMdd"));
sqlParam[4] = new OracleParameter("PISACTIVE", eReport.ISACTIVE ? "1" : "0");
sqlParam[5] = new OracleParameter("PUSER", userId);
sqlParam[6] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
return(DBHelper.getDataTable_SP("HR_GEO_REPORT.SP_UPDATE_GEO_REPORT", sqlParam));
}
public static DataTable insertNewGeoReport(eGeoReportItem eReport, string userId)
{
OracleParameter[] sqlParam = new OracleParameter[6];
sqlParam[0] = new OracleParameter("PDEPTCODE", eReport.DEPTCODE);
sqlParam[1] = new OracleParameter("PSYS_EMPID", eReport.SYS_EMPID);
sqlParam[2] = new OracleParameter("PAPPLYDATE", eReport.APPLYDATE.ToString("yyyyMMdd"));
//sqlParam[3] = new OracleParameter("UPDATE_DT", formEntity.UPDATE_DT);
sqlParam[3] = new OracleParameter("PISACTIVE", eReport.ISACTIVE ? "1" : "0");
sqlParam[4] = new OracleParameter("PUSER", userId);
sqlParam[5] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
//return DBHelper.getDataTable_SP("HR_GEO_REPORT.SP_INSERT_GEO_REPORT", sqlParam);
return(DBHelper.getDataTable_SP("HR_GEO_REPORT.SP_INSERT_GEO_REPORT_VER2", sqlParam));
}
public static List <eGeoReportItem> getGeoReportByDepartment(string deptcode)
{
List <eGeoReportItem> lstResult = new List <eGeoReportItem>();
DataTable dtResult = GeoReportAccess.getReportByDepartment(deptcode);
/*
* foreach (DataRow dtr in dtResult.Rows)
* {
* eGeoReportItem item = new eGeoReportItem();
* item.GEOREPORTCD = dtr["GEOREPORTCD"].ToString();
* item.DEPTCODE = dtr["DEPTCODE"].ToString();
* item.SYS_EMPID = dtr["SYS_EMPID"].ToString();
* string strDate = dtr["APPLYDATE"].ToString();
* item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
* item.ISACTIVE = dtr["ISACTIVE"].ToString();
* item.EMPNAME = dtr["EMPNAME"].ToString();
* lstResult.Add(item);
* }
*/
foreach (DataRow dtr in dtResult.Rows)
{
eGeoReportItem item = new eGeoReportItem();
item.GEOREPORTCD = dtr["GEOREPORTCD"].ToString();
item.DEPTCODE = dtr["DEPTCODE"].ToString();
item.SYS_EMPID = dtr["SYS_EMPID"].ToString();
string strDate = dtr["APPLYDATE"].ToString();
item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
int nActive = 0;
int.TryParse(dtr["ISACTIVE"].ToString(), out nActive);
item.ISACTIVE = Convert.ToBoolean(nActive);
item.EMPNAME = dtr["EMPNAME"].ToString();
lstResult.Add(item);
}
return(lstResult);
}
public ActionResult updateGeoReporter([DataSourceRequest] DataSourceRequest request, eGeoReportItem _reporter, string deptcode)
{
//FormEntity formEntity = new FormEntity();
//formEntity.FormID = _form.FORM_CODE;
//formEntity.FormName = _form.FORM_NAME;
//formEntity.DictionaryID = "";
//formEntity.FilePath = _form.FILE_PATH;
//formEntity.ModuleID = "";
//formEntity.UPDATE_UID = "hieuht";
//bool result = FormAccess.UpdateForm(formEntity);
_reporter.DEPTCODE = deptcode;
string userId = Session["UserId"].ToString();
DataTable dtResult = GeoReportAccess.updateGeoReport(_reporter, userId);
Session["geoorganizationreport_tree"] = bGeoReport.getTreeGeoDepts();
dynamic res = string.Empty;
res = new
{
result = dtResult.Rows[0][0].ToString(),
message = dtResult.Rows[0][1].ToString()
};
return(Json(new[] { _reporter, res }.ToDataSourceResult(request, ModelState)));
}
