public async Task <ActionResult> DeleteModule(string store, [FromBody] List <ModuleFieldInfo> fieldsInfos)
{
var outPut = new RestOutput <string>();
try
{
var m_Client = new CoreController(_configuration);
var cm = new WebApiCore.CommonFunction();
//var lst = new List<string>();
//var param = m_Client.DiscoveryParameters(store);
////cm.GetSQLServerParameterValues(out lst, store, param, fieldsInfos);
//cm.GetNpgsqlParameterValues(param, fieldsInfos);
//var userName = GetUserName();
//var dataStore = m_Client.RunStore(store, lst, userName);
var param = m_Client.DiscoveryParameters(store.IndexOf(".") > 0 ? store : _Schema + "." + store);
cm.GetNpgsqlParameterValues(param, fieldsInfos);
var userName = GetUserName();
var dataStore = m_Client.RunFunction(store, param);
outPut.Data = dataStore;
outPut.ResultCode = 1;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
}
return(Ok(outPut));
}
public async Task <string> SearchModSearch([FromBody] SearchModSearch searchModSearch)
{
var outPut = new RestOutput <string>();
try
{
var m_Client = new CoreController(_configuration);
var whereExtension = string.Empty;
var query = BuildQuerySearch.BuildSearchCondition(searchModSearch.ModInfo, ref whereExtension, null, searchModSearch.StaticConditionInstances.First());
//var ds = m_Client.LoadProcedure(query.Store, query.Parram);
//if (ds != null)
//{
// //Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
// //json.Converters.Add(new DataSetConverter());
// //(((DataSet)ds).Tables[0])
// outPut.Data = JsonConvert.SerializeObject(((DataSet)ds).Tables[0], Formatting.Indented, new JsonSerializerSettings { Converters = new[] { new DataSetConverter() } });
// //string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented, new JsonSerializerSettings { Converters = new[] { new Newtonsoft.Json.Converters.DataSetConverter() } });
// outPut.ResultCode = 1;
// outPut.Message = "";
// return JsonConvert.SerializeObject(outPut);
//}
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(JsonConvert.SerializeObject(outPut));
}
return(null);
}
public async Task <ActionResult> LoadMainTainModule(string modId, string subModId, string parram, [FromBody] List <ModuleFieldInfo> fieldsInfos)
{
var outPut = new RestOutput <object>();
try
{
var m_Client = new CoreController(_configuration);
var data = m_Client.LoadMainTainModule(modId);
MaintainModuleInfo modMaintain = null;
var store = "";
if (data.Any())
{
modMaintain = data.First();
store = CommonFunction.GetStoreRunModMaintain(modMaintain, subModId ?? ESubMod.MVW.ToString());
}
var fields = CommonFunction.GetModuleFields(fieldsInfos, modId, FLDGROUP.PARAMETER);
var cm = new WebApiCore.CommonFunction();
var lst = new List <string>();
if (!string.IsNullOrEmpty(store))
{
var param = m_Client.DiscoveryParameters(store.IndexOf(".") > 0 ? store : store);
cm.GetNpgsqlParameterValues(param, fields);
var dataStore = m_Client.RunStoreToDataTable(store, param);
outPut.Data = JsonConvert.SerializeObject(dataStore);
return(Ok(outPut));
}
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
}
public async Task <string> LoadQueryModule([FromBody] ParramModuleQuery query)
{
var outPut = new RestOutput <string>();
try
{
var m_Client = new CoreController(_configuration);
var ds = m_Client.LoadProcedure(query.Store, query.Parram);
if (ds != null)
{
//Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
//json.Converters.Add(new DataSetConverter());
//(((DataSet)ds).Tables[0])
outPut.Data = JsonConvert.SerializeObject(((DataSet)ds).Tables[0], Formatting.Indented, new JsonSerializerSettings {
Converters = new[] { new DataSetConverter() }
});
//string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented, new JsonSerializerSettings { Converters = new[] { new Newtonsoft.Json.Converters.DataSetConverter() } });
outPut.ResultCode = 1;
outPut.Message = "";
return(JsonConvert.SerializeObject(outPut));
}
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(JsonConvert.SerializeObject(outPut));
}
return(null);
}
public async Task <string> ExcuteStore2DataTable(ParramModuleQuery query)
{
var outPut = new RestOutput <string>();
try
{
var m_Client = new CoreController(_configuration);
PostgresqlHelper postgresqlHelper = new PostgresqlHelper();
var param = m_Client.DiscoveryParameters(query.Store);
// var checkParram = param.Where(x => x.SqlDbType != SqlDbType.);
if (param != null && param.Any())
{
if (query.Parram.Length > 0)
{
param.First().Value = query.Parram.First();
}
}
var tb = (DataTable)m_Client.RunStoreToDataTable(query.Store, param); //m_Client.ExecuteStoreProcedurePostgreSQL(query.Store, query.Parram.Length>0? query.Parram.First().ToString():"");
if (tb != null)
{
outPut.Data = JsonConvert.SerializeObject(tb);
outPut.ResultCode = 1;
outPut.Message = "";
return(JsonConvert.SerializeObject(outPut));
}
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(JsonConvert.SerializeObject(outPut));
}
return(JsonConvert.SerializeObject(outPut));
}
public async Task <ActionResult> Get(string moduleName)
{
var outPut = new RestOutput <ModuleInfoViewModel>();
var moduleInfo = new ModuleInfoViewModel();
try
{
var modulesInfo = new List <ModuleInfo>();
var fieldsInfo = new List <ModuleFieldInfo>();
var buttonsInfo = new List <ButtonInfo>();
var buttonParamsInfo = new List <ButtonParamInfo>();
var languageInfo = new List <LanguageInfo>();
var oracleParamsInfo = new List <OracleParam>();
var m_Client = new CoreController(_configuration);
m_Client.ForceLoadModule(out modulesInfo, out fieldsInfo, out buttonsInfo, out buttonParamsInfo, out languageInfo, out oracleParamsInfo, moduleName);
var fields = fieldsInfo.Where(x => String.IsNullOrEmpty(x.ParentId)).ToList();
var parentIds = fieldsInfo.Where(x => !String.IsNullOrEmpty(x.ParentId)).Select(x => x.ParentId).Distinct().ToList();
if (parentIds != null)
{
foreach (var parentId in parentIds)
{
var field = fields.Where(x => x.FieldID == parentId);
if (field != null && field.Any())
{
field.First().FieldChilds = fieldsInfo.Where(x => x.ParentId == parentId).ToList();
}
}
}
//var dicFieldInfo = new Dictionary<ModuleFieldInfo, string>();
moduleInfo = new ModuleInfoViewModel
{
ButtonParamsInfo = buttonParamsInfo,
ButtonsInfo = buttonsInfo,
FieldsInfo = fields,
LanguageInfo = languageInfo,
ModulesInfo = modulesInfo,
OracleParamsInfo = oracleParamsInfo
};
outPut.Data = moduleInfo;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
return(Ok(outPut));
}
public async Task <ActionResult> GetAllCodeInfo()
{
var outPut = new RestOutput <List <CodeInfo> >();
try
{
var m_Client = new CoreController(_configuration);
var data = m_Client.GetAllCodeInfo();
outPut.Data = data;
return(Ok(outPut));
}
catch (Exception ex)
{
}
return(Ok(outPut));
}
public async Task <ActionResult> LoadModMaintainByModId(string modId)
{
var outPut = new RestOutput <List <MaintainModuleInfo> >();
try
{
var m_Client = new CoreController(_configuration);
var data = m_Client.LoadMainTainModule(modId);
outPut.Data = data;
return(Ok(outPut));
}
catch (Exception ex)
{
}
return(Ok(outPut));
}
public async Task <ActionResult> LoadModSearchByModId(string modId)
{
var outPut = new RestOutput <List <SearchModuleInfo> >();
try
{
var m_Client = new CoreController(_configuration);
var data = m_Client.LoadModSearchByModId(modId);
outPut.Data = data;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
}
return(Ok(null));
}
public async Task <ActionResult> LoadDefModByTypeValue(string parameter)
{
var outPut = new RestOutput <List <CodeInfo> >();
try
{
var m_Client = new CoreController(_configuration);
var outPutData = m_Client.LoadDefModByTypeValue(parameter);
outPut.Data = outPutData;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
return(Ok(outPut));
}
public async Task <ActionResult> GetGroupModByUserId(string userId)
{
try
{
var outPut = new RestOutput <List <GroupMod> >();
try
{
var m_Client = new CoreController(_configuration);
var data = m_Client.GetGroupModByUserId(userId);
outPut.Data = data;
return(Ok(outPut));
}
catch (Exception ex)
{
}
return(Ok(outPut));
}
catch (Exception ex)
{
}
return(Ok(null));
}
public async Task <ActionResult> InsertLog([FromBody] LOG log)
{
var outPut = new RestOutput <int>();
var m_Client = new CoreController(_configuration);
SqlConnection conn = new SqlConnection(m_Client.ConnectionString);
try
{
var cm = new WebApiCore.CommonFunction();
var lst = new List <string>();
var store = "sp_LOG_INS";
var param = m_Client.DiscoveryParameters(store);
var fieldInfos = new List <SqlParameter>();
fieldInfos.Add(new SqlParameter("@ModId", log.ModId));
fieldInfos.Add(new SqlParameter("@Type", log.Type));
fieldInfos.Add(new SqlParameter("@ActionError", log.ActionError));
fieldInfos.Add(new SqlParameter("@Note", log.Note));
var userName = GetUserName();
fieldInfos.Add(new SqlParameter("@UserName", userName));
fieldInfos.Add(new SqlParameter("@Ip", log.Ip));
conn.Open();
var comm = new SqlCommand(store, conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddRange(fieldInfos.ToArray());
comm.ExecuteNonQuery();
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
finally
{
conn.Close();
}
}
public async Task <ActionResult> GetAllIcon()
{
var outPut = new RestOutput <List <LanguageInfo> >();
try
{
var m_Client = new CoreController(_configuration);
var menu = m_Client.GetAllLanguageIcon();
if (!menu.Any())
{
outPut.Data = null;
return(Ok(outPut));
}
outPut.Data = menu;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
}
public async Task <ActionResult> GetUserLogin(string userName, string password)
{
var outPut = new RestOutput <User>();
try
{
var m_Client = new CoreController(_configuration);
var users = m_Client.GetUserByUserNamePassword(userName, password);
if (!users.Any())
{
outPut.Data = null;
return(Ok(outPut));
}
outPut.Data = users.First();
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
}
public async Task <ActionResult> GetAllSysVar()
{
var outPut = new RestOutput <List <SysVar> >();
try
{
var m_Client = new CoreController(_configuration);
var sysVar = m_Client.GetAllSysVar();
if (!sysVar.Any())
{
outPut.Data = null;
return(Ok(outPut));
}
outPut.Data = sysVar;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
}
public async Task <ActionResult> LoadDefModByTypeValue([FromBody] List <CodeInfoParram> codeInfos)
{
var outPut = new RestOutput <List <CodeInfoModel> >();
var outPutData = new List <CodeInfoModel>();
try
{
var m_Client = new CoreController(_configuration);
foreach (var item in codeInfos)
{
try
{
if (item.ListSource == null)
{
continue;
}
if (item.ListSource.Contains(":"))
{
var codeInfoModel = new CodeInfoModel
{
Name = item.Name,
CodeInfos = m_Client.LoadDefModByTypeValue(item.ListSource)
};
outPutData.Add(codeInfoModel);
}
else
{
var parram = new List <string>();
if (!string.IsNullOrEmpty(item.Parrams))
{
parram.Add(item.Parrams);
}
var param = new List <SqlParameter>();
var storeName = item.ListSource;
if (!(item.ListSource.IndexOf("(") < 0 && item.ListSource.IndexOf(")") < 0))
{
storeName = item.ListSource.Substring(0, item.ListSource.IndexOf("("));
var strParr = item.ListSource.Substring(item.ListSource.IndexOf("(") + 1, item.ListSource.IndexOf(")") - item.ListSource.IndexOf("(") - 1);
if (!string.IsNullOrEmpty(strParr))
{
parram.AddRange(strParr.Split(','));
}
}
param = m_Client.DiscoveryParameters(storeName);
int index = 0;
foreach (var pr in param)
{
//if (pr.NpgsqlDbType != NpgsqlTypes.NpgsqlDbType.Refcursor)
//{
pr.Value = parram[index];
index++;
//}
}
var data = new DataTable();
data = (DataTable)m_Client.RunStoreToDataTable(storeName, param);
if (data != null)
{
if (data.Columns.Contains("VALUE"))//Trường hợp load các Listsource không phải callback
{
if (item.CtrlType != EControlType.SCL.ToString())
{
var codeInfoControls = (from p in data.AsEnumerable() select new CodeInfo {
CodeValue = p["VALUE"].ToString(), CodeValueName = p["TEXT"].ToString()
}).ToList();
var codeInfoModel = new CodeInfoModel
{
ControlType = item.CtrlType,
Name = item.Name,
CodeInfos = codeInfoControls
};
outPutData.Add(codeInfoModel);
}
else
{
var scheduleControl = (from p in data.AsEnumerable() select new ScheduleControlModel {
id = p["id"].ToString(), title = p["title"].ToString(), className = p["className"].ToString(), end = p["end"].ToString(), start = p["start"].ToString(), url = p["url"].ToString(), modId = p["modId"].ToString()
}).ToList();
var codeInfoModel = new CodeInfoModel
{
ControlType = item.CtrlType,
Name = item.Name,
ScheduleControls = scheduleControl
};
outPutData.Add(codeInfoModel);
}
}
else//Trường hợp load các Listsource callback
{
var dataCallBack = JsonConvert.SerializeObject(data);
var codeInfoModel = new CodeInfoModel
{
ControlType = item.CtrlType,
Name = item.Name,
DataCallBack = dataCallBack
};
outPutData.Add(codeInfoModel);
}
}
}
}
catch (Exception e)
{
}
}
outPut.Data = outPutData;
outPut.ResultCode = 1;
return(Ok(outPut));
}
catch (Exception ex)
{
outPut.ResultCode = -1;
outPut.Message = ex.ToString();
return(Ok(outPut));
}
return(Ok(outPut));
}