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 <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 string RunStore(string storeName, List <SqlParameter> parrams)
{
try
{
var cm = new WebApiCore.CommonFunction();
SQLHelper.ExecuteStoreProcedure <object>(ConnectionString, storeName, parrams.ToArray()).ToArray();
return("success");
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
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();
}
}