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()); } }