public static NoneQueryResponse ReadNoneQuery(string sql, string connectionString, bool isStoreProcedure = true,
object[] parms = null)
{
NoneQueryResponse response = new NoneQueryResponse();
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;
using (var command = factory.CreateCommand())
{
command.Connection = connection;
command.CommandText = sql;
if (isStoreProcedure)
{
command.CommandType = CommandType.StoredProcedure;
}
command.SetParameters(parms); // Extension method
connection.Open();
var reader = command.ExecuteReader();
if (reader.Read())
{
response.SSID = reader.GetString(reader.GetOrdinal("SSID"));
response.RowID = reader.GetString(reader.GetOrdinal("RowID"));
response.StatusCode = reader.GetString(reader.GetOrdinal("StatusCode"));
response.StatusMess = reader.GetString(reader.GetOrdinal("StatusMess"));
}
return(response);
}
}
}
public static bool UpdateCustomData(string serviceUrl, string serviceMethod, List <string> filterParam) // Return Rowcount
{
try
{
var _client = new RestClient(serviceUrl);
var request = new RestRequest(serviceMethod, Method.PATCH)
{
RequestFormat = DataFormat.Json
};
GetDataRequest dataRequest = new GetDataRequest();
request.AddBody(dataRequest);
var response = _client.Execute(request);
GetDataResponse responseData = JsonConvert.DeserializeObject <GetDataResponse>(response.Content);
NoneQueryResponse dataObject = new NoneQueryResponse();
if (responseData != null)
{
dataObject = JsonConvert.DeserializeObject <NoneQueryResponse>(responseData.Content.ToString());
if (dataObject.StatusCode == "Done")
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
return(false);
}
}
public static NoneQueryResponse MakeNoneQuery(IDataReader reader)
{
Type type = typeof(NoneQueryResponse);
NoneQueryResponse entity = (NoneQueryResponse)Activator.CreateInstance(type);
for (int i = 0; i < reader.FieldCount; i++)
{
string column = reader.GetName(i);
bool check = true;
if (!string.IsNullOrEmpty(column))
{
foreach (PropertyInfo info in type.GetProperties())
{
try
{
string fieldName = info.Name;
if (column == fieldName)
{
info.SetValue(entity, TypeDescriptor.GetConverter(info.PropertyType).ConvertFrom(reader[fieldName].ToString()), null);
check = false;
}
}
catch { }
}
if (check)
{
entity.ExtentionProperty.Add(column, Extensions.AsString(reader[i]));
}
}
}
return(entity);
}
public static NoneQueryResponse AddUpdate <T>(string serviceUrl, string serviceMethod, string tokenKey, T dataPost, string denyFields = "", string username = "", string permissionCode = "") // Return Single Object
{
try
{
var _client = new RestClient(serviceUrl);
var request = new RestRequest(serviceMethod, Method.POST)
{
RequestFormat = DataFormat.Json
};
PutDataRequest dataRequest = new PutDataRequest();
dataRequest.RequestObject = dataPost;
dataRequest.DenyFields = denyFields;
/*
* For case add more param over object
*/
request.AddBody(dataRequest);
if (!String.IsNullOrEmpty(tokenKey))
{
request.AddHeader("tokenKey", tokenKey);
}
var response = _client.Execute(request);
GetDataResponse responseData = JsonConvert.DeserializeObject <GetDataResponse>(response.Content);
NoneQueryResponse dataObject = new NoneQueryResponse();
if (responseData != null)
{
dataObject = JsonConvert.DeserializeObject <NoneQueryResponse>(responseData.Content.ToString());
return(dataObject);
}
return(dataObject);
}
catch (Exception ex)
{
return(new NoneQueryResponse());
}
}
