//Dongpv:15/06/2020
//public async Task<List<dynamic>> getQuery(ParramModuleQuery parram)
public async Task <List <dynamic> > getQuery(Message msg) //ParramModuleQuery parram ModalParameters
{
try
{
//var json = JsonConvert.SerializeObject(obj);
//var json = JsonConvert.DeserializeObject<string>(apiResponse);
//ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId);
//1. Convert obj to arraylist
//foreach (ParramModuleQuery moduleFieldInfo in parram)
//{
// if (moduleFieldInfo.Value != null)
// {
// Body.Add(moduleFieldInfo.FieldName); Body.Add(moduleFieldInfo.Value);
// enity = moduleFieldInfo.Entity;
// }
//}
var json = JsonConvert.SerializeObject(msg);
//2. CALL HOST
var result = await SendMessage(json);
DataTable tb = new DataTable();
if (!string.IsNullOrEmpty(result) && result != "null")
{
tb = SysUtils.Json2Table(result);
}
//DataTable tb = SysUtils.Json2Table(data);
//var moduleds = JsonConvert.DeserializeObject<string> (data);
//var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data);
//DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
//var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds.Data);
//var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds);
// return moduledData;
//DataTable dt = (DataTable)JsonConvert.DeserializeObject(data, (typeof(DataTable)));
var outPut = new RestOutput <string>();
outPut.Data = JsonConvert.SerializeObject(tb, 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);
var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut));
DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data);
return(moduledData);
//return data;
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <RestOutput <string> > UpdateData(string modId, string enity, string keyEdit, List <ModuleFieldInfo> fieldEdits)
{
try
{
//var json = JsonConvert.SerializeObject(obj);
//var json = JsonConvert.DeserializeObject<string>(apiResponse);
//ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId);
//1. Convert obj to arraylist
//ArrayList Body = new ArrayList();
//foreach (ModuleFieldInfo moduleFieldInfo in fieldEdits)
//{
// Body.Add(moduleFieldInfo.FieldName); Body.Add(moduleFieldInfo.Value);
//}
var order = new {
UserID = "0000",
IP = "00000",
BranchID = "000",
ModuleID = modId,
ObjectName = enity,
MsgType = Constants.MSG_MNT_TYPE,
MsgAction = Constants.MSG_UPDATE_ACTION,
Body = fieldEdits
};
var json = JsonConvert.SerializeObject(order);
var result = await SendMessage(json);
DataTable tb = new DataTable();
if (!string.IsNullOrEmpty(result) && result != "null")
{
tb = SysUtils.Json2Table(result);
}
//var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data);
var outPut = new RestOutput <string>();
outPut.Data = JsonConvert.SerializeObject(tb, Formatting.Indented, new JsonSerializerSettings {
Converters = new[] { new DataSetConverter() }
});
outPut.ResultCode = 1;
outPut.Message = "";
var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut));
DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data);
return(moduleds);
}
catch (Exception ex)
{
throw ex;
}
}
//Dongpv:20/07/2020
public async Task <DataTable> PostApi(object obj)
{
try
{
ParramModuleQuery query = (ParramModuleQuery)obj;
Message msg = new Message();
msg.ObjectName = Constants.OBJ_SEARCH;
msg.MsgType = Constants.MSG_MISC_TYPE;
msg.MsgAction = Constants.MSG_SEARCH;
msg.Body.Add("SearchObject");
msg.Body.Add(query.Store);
msg.Body.Add("Condition");
msg.Body.Add(" WHERE 1=0");
msg.Body.Add("Page");
msg.Body.Add(0);
var json = JsonConvert.SerializeObject(msg);
var result = await SendMessage(json);
DataTable tb = new DataTable();
if (!string.IsNullOrEmpty(result) && result != "null")
{
tb = SysUtils.Json2Table(result);
}
return(tb);
}
catch (Exception ex)
{
ErrorHandler.Process(ex);
}
return(null);
}
public async Task <RestOutput <string> > SaveData(string modId, string enity, string keyEdit, List <ModuleFieldInfo> fieldEdits)
{
try
{
//var json = JsonConvert.SerializeObject(obj);
//var json = JsonConvert.DeserializeObject<string>(apiResponse);
//ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId);
//1. Convert obj to arraylist
//ArrayList Body = new ArrayList();
//foreach (ModuleFieldInfo moduleFieldInfo in fieldEdits)
//{
// if (moduleFieldInfo.Value != null)
// {
// if(string.IsNullOrEmpty(enity)) enity = moduleFieldInfo.Entity;
// string controlType = moduleFieldInfo.ControlType;
// string fileName = moduleFieldInfo.FieldName.Trim();
// object value = moduleFieldInfo.Value;
// if (controlType == "GE")
// {
// ArrayList arrDetail = new ArrayList();
// SysUtils.String2ArrayList(ref arrDetail, value.ToString().Replace("[", "").Replace("]", "").Replace("{", "").Replace("}", "").Replace("\r\n", "").Replace("\"", ""), ",", ":");
// value = arrDetail;
// }
// Body.Add(fileName); Body.Add(value);
// }
//}
var message = new {
UserID = "0000",
IP = "00000",
BranchID = "000",
ModuleID = modId,
ModId = modId,
ObjectName = enity,
MsgType = Constants.MSG_MNT_TYPE,
MsgAction = Constants.MSG_ADD_ACTION,
Body = fieldEdits
};
var json = JsonConvert.SerializeObject(message);
var result = await SendMessage(json);
DataTable tb = new DataTable();
if (!string.IsNullOrEmpty(result) && result != "null")
{
tb = SysUtils.Json2Table(result);
}
var outPut = new RestOutput <string>();
outPut.Data = JsonConvert.SerializeObject(tb, 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 = "";
//var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data);
var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut));
DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data);
return(moduleds);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <dynamic> > getDetail(string modId, string modSearchId, List <ModuleFieldInfo> fieldEdits) //ParramModuleQuery parram ModalParameters
{
try
{
//var json = JsonConvert.SerializeObject(obj);
//var json = JsonConvert.DeserializeObject<string>(apiResponse);
//ArrayList Body = new ArrayList(); Body.Add("pv_UserId"); Body.Add(userId);
//1. Convert obj to arraylist
var order = new {
UserID = "0000",
MsgIP = "00000",
BranchID = "000",
ModId = modId,
ObjectName = Constants.OBJ_DETAIL,
MsgType = Constants.MSG_MISC_TYPE,
MsgAction = Constants.MSG_SEARCH,
Body = fieldEdits
};
var json = JsonConvert.SerializeObject(order);
//2. CALL HOST
var result = await SendMessage(json);
DataTable tb = new DataTable();
if (!string.IsNullOrEmpty(result) && result != "null")
{
tb = SysUtils.Json2Table(result);
}
//DataTable tb = SysUtils.Json2Table(data);
//var moduleds = JsonConvert.DeserializeObject<string> (data);
//var moduleds = JsonConvert.DeserializeObject<RestOutput<string>>(data);
//DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
//var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds.Data);
//var moduledData = JsonConvert.DeserializeObject<List<dynamic>>(moduleds);
// return moduledData;
//DataTable dt = (DataTable)JsonConvert.DeserializeObject(data, (typeof(DataTable)));
var outPut = new RestOutput <string>();
outPut.Data = JsonConvert.SerializeObject(tb, 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);
var moduleds = JsonConvert.DeserializeObject <RestOutput <string> >(JsonConvert.SerializeObject(outPut));
DataTable dt = (DataTable)JsonConvert.DeserializeObject(moduleds.Data, (typeof(DataTable)));
var moduledData = JsonConvert.DeserializeObject <List <dynamic> >(moduleds.Data);
return(moduledData);
//return data;
}
catch (Exception ex)
{
throw ex;
}
}