public Dictionary <string, string> SendSMS(string To, string Body) { Dictionary <string, string> msgStatus = null; try { Data["msg"] = Body; Data["to"] = To; var response = Client.UploadValues(Unifonic_base_url, "POST", Data); string responseInString = Encoding.UTF8.GetString(response); Console.WriteLine(responseInString); if (response != null) { msgStatus = new Dictionary <string, string> { { "To", To }, { "From", Config.From }, { "Uri", url }, { "Body", Body }, { "ErrorMessage", "" }, { "ConId", Config.Id.ToString() }, { "Result", responseInString } }; } } catch (Exception e) { Console.WriteLine("Exception:" + e.ToString()); msgStatus.Add("ErrorMessage", e.ToString()); } Console.WriteLine(" --- SMS msg" + EbSerializers.Json_Serialize(msgStatus)); return(msgStatus); }
//public object GetObjectAndPermission(string roleId, int appId) //{ // var fr = this.ServiceClient.Get<GetObjectAndPermissionResponse>(new GetObjectAndPermissionRequest { RoleId = Convert.ToInt32(roleId), AppId = appId }); // return JsonConvert.SerializeObject(fr); //} //GET PERMISSION OPERATIONS AS JS private string GetPermissionOperationsAsJs() { Assembly assembly = Assembly.GetAssembly(typeof(EbWebForm)); //DO NOT CHANGE List <Eb_ObjectTypeOperations> _listObj = new List <Eb_ObjectTypeOperations>(); foreach (var ObjectType in Enum.GetValues(typeof(EbObjectTypesUI))) { string sObjectType = ObjectType.ToString(); int sIntObj = (int)ObjectType; var eOperations = assembly.GetType(string.Format("ExpressBase.Objects.{0}+Operations", sObjectType)); if (eOperations != null) { Eb_ObjectTypeOperations _obj = new Eb_ObjectTypeOperations() { Op_Id = sIntObj, Op_Name = sObjectType, Operations = new List <string>() }; foreach (var Op in Enum.GetValues(eOperations)) { _obj.Operations.Add(Op.ToString()); } _listObj.Add(_obj); } } return(EbSerializers.Json_Serialize(_listObj)); }
public Dictionary <string, string> SendSMS(string To, string body) { Dictionary <string, string> msgStatus = null; string result; try { body += " -" + Config.BrandName; var status = string.Empty; IEnumerable <string> matches = Regex.Matches(To, @"[1-9]").OfType <Match>() .Select(m => m.Groups[0].Value) .Distinct(); if (matches.Count() > 0) { string msg = HttpUtility.UrlEncode(body); using (var wb = new WebClient()) { byte[] response = wb.UploadValues("https://api.textlocal.in/send/", new NameValueCollection() { { "apikey", Config.ApiKey }, { "numbers", To }, { "message", msg }, { "sender", Config.From } // {"test" , "1"} }); result = System.Text.Encoding.UTF8.GetString(response); } status = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(result)["status"]; } else { status = "FAILED"; result = "'To' is not a Valid number."; } msgStatus = new Dictionary <string, string> { { "ApiKey", Config.ApiKey }, { "To", To }, { "From", Config.From }, { "Body", body }, { "ConId", Config.Id.ToString() }, { "Status", status }, { "Result", result } }; } catch (Exception e) { Console.WriteLine("Exception:" + e.Message); if (!(msgStatus is null)) { msgStatus.Add("ErrorMessage", e.Message); } } Console.WriteLine(" --- SMS msg" + EbSerializers.Json_Serialize(msgStatus)); return(msgStatus); }
private string Get_EbObjTypesStr() { Dictionary <string, int> _dic = new Dictionary <string, int>(); foreach (Structures.EbObjectType objectType in Structures.EbObjectTypes.Enumerator) { _dic.Add(objectType.Name, objectType.IntCode); } return(EbSerializers.Json_Serialize(_dic)); }
public string VersionCodes(string objid, int objtype) { var resultlist = this.ServiceClient.Get <EbObjectParticularVersionResponse>(new EbObjectParticularVersionRequest { RefId = objid }); var dsobj = EbSerializers.Json_Deserialize(resultlist.Data[0].Json); dsobj.Status = resultlist.Data[0].Status; dsobj.VersionNumber = resultlist.Data[0].VersionNumber; return(EbSerializers.Json_Serialize(dsobj)); }
private string Get_EbObjTypesStr() { Dictionary <string, int> _dic = new Dictionary <string, int>(); foreach (string enumString in Enum.GetNames(typeof(EbObjectType))) { EbObjectType _type; Enum.TryParse(enumString, out _type); _dic.Add(enumString, (int)_type); } return(EbSerializers.Json_Serialize(_dic)); }
public string EmailTemplateCommit(string _Refid, string Htmlcode, string PropObj, string ChangeLog) { IServiceClient client = this.ServiceClient; var emailobj = EbSerializers.Json_Deserialize <EbEmailTemplate>(PropObj); string refid = ""; if (string.IsNullOrEmpty(_Refid)) { var ds = new EbObject_Create_New_ObjectRequest(); ds.EbObjectType = (int)EbObjectType.EmailBuilder; ds.Name = emailobj.Name; ds.Description = emailobj.Description; ds.Json = EbSerializers.Json_Serialize(new EbEmailTemplate { Body = emailobj.Body, //EbObjectType = emailobj.EbObjectType, Name = emailobj.Name, Subject = emailobj.Subject, DataSourceRefId = emailobj.DataSourceRefId }); ds.Relations = ""; ds.IsSave = false; var res = ServiceClient.Post <EbObject_Create_New_ObjectResponse>(ds); refid = res.RefId; } else { var ds = new EbObject_CommitRequest(); ds.EbObjectType = (int)EbObjectType.EmailBuilder; ds.Name = emailobj.Name; ds.Description = emailobj.Description; ds.Json = EbSerializers.Json_Serialize(new EbEmailTemplate { Body = emailobj.Body, //EbObjectType = emailobj.EbObjectType, Name = emailobj.Name, Subject = emailobj.Subject, DataSourceRefId = emailobj.DataSourceRefId }); ds.Relations = ""; ds.RefId = _Refid; ds.ChangeLog = ChangeLog; var res = ServiceClient.Post <EbObject_CommitResponse>(ds); refid = res.RefId; } return(refid); }
public string EmailTemplateSave(string _Refid, string PropObj) { var req = this.HttpContext.Request.Form; var emailobj = EbSerializers.Json_Deserialize <EbEmailTemplate>(PropObj); string refid; if (string.IsNullOrEmpty(_Refid)) { var ds = new EbObject_Create_New_ObjectRequest(); ds.EbObjectType = (int)EbObjectType.EmailBuilder; ds.Name = emailobj.Name; ds.Description = emailobj.Description; ds.Json = EbSerializers.Json_Serialize(new EbEmailTemplate { Body = emailobj.Body, //EbObjectType = emailobj.EbObjectType, Name = emailobj.Name, Subject = emailobj.Subject, DataSourceRefId = emailobj.DataSourceRefId }); ds.Relations = ""; ds.IsSave = true; var res = ServiceClient.Post <EbObject_Create_New_ObjectResponse>(ds); refid = res.RefId; } else { var ds = new EbObject_SaveRequest(); ds.RefId = _Refid; ds.Name = emailobj.Name; ds.Description = emailobj.Description; ds.EbObjectType = (int)EbObjectType.EmailBuilder; ds.Json = EbSerializers.Json_Serialize(new EbEmailTemplate { Body = emailobj.Body, //EbObjectType = emailobj.EbObjectType, Name = emailobj.Name, Subject = emailobj.Subject, DataSourceRefId = emailobj.DataSourceRefId }); ds.Relations = ""; ViewBag.IsNew = "false"; var res = this.ServiceClient.Post <EbObject_SaveResponse>(ds); refid = res.RefId; } return(refid); }
public string getdv(string refid, EbObjectType objtype) { EbDataVisualization dsobj = null; if (refid != null) { var resultlist = this.ServiceClient.Get <EbObjectParticularVersionResponse>(new EbObjectParticularVersionRequest { RefId = refid }); dsobj = EbSerializers.Json_Deserialize(resultlist.Data[0].Json); dsobj.Status = resultlist.Data[0].Status; dsobj.VersionNumber = resultlist.Data[0].VersionNumber; } return(EbSerializers.Json_Serialize(dsobj)); }
public Dictionary <string, string> SendSMS(string To, string body) { Dictionary <string, string> msgStatus = null; try { var requestContent = new FormUrlEncodedContent(new[] { new KeyValuePair <string, string>("From", Config.From), new KeyValuePair <string, string>("To", To), new KeyValuePair <string, string>("Body", body) }); using (var httpClient = new HttpClient()) { requestContent.Headers.Clear(); requestContent.Headers.Add("Content-Type", "application/x-www-form-urlencoded"); httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", Convert.ToBase64String( System.Text.ASCIIEncoding.ASCII.GetBytes( string.Format("{0}:{1}", Config.UserName, Config.Password)))); HttpResponseMessage response = httpClient.PostAsync(url, requestContent).Result; if (response.IsSuccessStatusCode) { msgStatus = new Dictionary <string, string> { { "To", To }, { "From", Config.From }, { "Uri", url }, { "Body", body }, { "Status", response.StatusCode.ToString() }, { "SentTime", response.Headers.Date.ToString() }, { "ErrorMessage", "" }, { "ConId", Config.Id.ToString() }, { "Result", response.ToString() } }; } } } catch (Exception e) { Console.WriteLine("Exception:" + e.ToString()); msgStatus.Add("ErrorMessage", e.ToString()); } Console.WriteLine(" --- SMS msg" + EbSerializers.Json_Serialize(msgStatus)); return(msgStatus); }
public Dictionary <string, string> SendSMS(string To, string body) { Dictionary <string, string> msgStatus = null; string result; try { //string msg = HttpUtility.UrlEncode(body); using (var wb = new WebClient()) { byte[] response = wb.UploadValues("http://thesmsbuddy.com/api/v1/sms/send?", new NameValueCollection() { { "key", Config.ApiKey }, { "type", "1" }, { "to", To }, { "sender", Config.From }, { "message", body }, { "flash", "0" } }); result = System.Text.Encoding.UTF8.GetString(response); } var status = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(result)["status"]; msgStatus = new Dictionary <string, string> { { "ApiKey", Config.ApiKey }, { "To", To }, { "From", Config.From }, { "Body", body }, { "ConId", Config.Id.ToString() }, { "Status", status }, { "Result", result } }; } catch (Exception e) { Console.WriteLine("Exception:" + e.ToString()); msgStatus.Add("ErrorMessage", e.ToString()); } Console.WriteLine(" --- SMS msg" + EbSerializers.Json_Serialize(msgStatus)); return(msgStatus); }
public string Post(SlackAuthMqRequest req) { TenantDbFactory dbFactory = new TenantDbFactory(req.TenantAccountId, this.Redis); if (req.IsNew) { try { string sql = "UPDATE eb_users SET slackjson = @slackjson WHERE id = @id RETURNING id"; var id = dbFactory.DataDB.DoQuery <Int32>(sql, new DbParameter[] { dbFactory.DataDB.GetNewParameter("slackjson", NpgsqlTypes.NpgsqlDbType.Json, EbSerializers.Json_Serialize(req.SlackJson)), dbFactory.DataDB.GetNewParameter("id", System.Data.DbType.Int32, req.UserId) }); } catch (Exception e) { return(null); } } else { } return(null); }
public void InitFromDataBase(JsonServiceClient ServiceClient, IRedisClient redis) { EbChartVisualization ChartVisualization = EbFormHelper.GetEbObject <EbChartVisualization>(TVRefId, ServiceClient, redis, null); this.ChartVisualizationJson = EbSerializers.Json_Serialize(ChartVisualization); }
public int PersistIntegrationConf(string Sol_Id, EbConnectionFactory infra, int UserId) { int nid = 0; string query = string.Empty; string json = EbSerializers.Json_Serialize(this);// JsonConvert.SerializeObject(this); DbParameter[] parameters = { infra.DataDB.GetNewParameter("solution_id", EbDbTypes.String, Sol_Id), infra.DataDB.GetNewParameter("nick_name", EbDbTypes.String, !(string.IsNullOrEmpty(this.NickName))?this.NickName:string.Empty), infra.DataDB.GetNewParameter("type", EbDbTypes.String, this.Type.ToString()), infra.DataDB.GetNewParameter("con_obj", EbDbTypes.Json, json), infra.DataDB.GetNewParameter("uid", EbDbTypes.Int32, UserId), infra.DataDB.GetNewParameter("id", EbDbTypes.Int32, this.Id) }; if (this.Id <= 0) { query = @" INSERT INTO eb_integration_configs (solution_id, nickname, type, con_obj, created_by, created_at, eb_del) VALUES (@solution_id, @nick_name, @type, @con_obj, @uid, NOW() , 'F') RETURNING id;"; EbDataSet ds = infra.DataDB.DoQueries(query, parameters); nid = Convert.ToInt32(ds.Tables[0].Rows[0][0]); } else { query = @" UPDATE eb_integration_configs SET modified_at = NOW(), modified_by = @uid, eb_del = 'T' WHERE id = @id; INSERT INTO eb_integration_configs (solution_id, nickname, type, con_obj, created_by, created_at, eb_del) VALUES (@solution_id, @nick_name, @type, @con_obj, @uid, NOW() , 'F') RETURNING id;"; EbDataSet ds = infra.DataDB.DoQueries(query, parameters); nid = Convert.ToInt32(ds.Tables[0].Rows[0][0]); if (this.Id != 0) { query = @"UPDATE eb_integrations SET eb_integration_conf_id = @nid WHERE eb_integration_conf_id = @oid; "; DbParameter[] parameter = { infra.DataDB.GetNewParameter("nid", EbDbTypes.Int32, nid), infra.DataDB.GetNewParameter("oid", EbDbTypes.Int32, this.Id) }; infra.DataDB.DoNonQuery(query, parameter); } } return(nid); }
private string JsVarDecl(PropertyInfo prop, object obj) { string s = @"this.{0} = {1};"; string _c = @"this.Controls = new EbControlCollection(JSON.parse('{0}'));"; string _name = prop.Name; if (prop.IsDefined(typeof(JsonPropertyAttribute))) { _name = prop.GetCustomAttribute <JsonPropertyAttribute>().PropertyName; } if (prop.IsDefined(typeof(DefaultPropValue)) && (prop.PropertyType.IsPrimitive || prop.PropertyType == typeof(string) || prop.PropertyType.IsEnum)) { string DefaultVal = prop.GetCustomAttribute <DefaultPropValue>().Value; // For Object Selector if (prop.GetType().GetTypeInfo().IsDefined(typeof(PropertyEditor)) && prop.GetCustomAttribute <PropertyEditor>().PropertyEditorType == (int)PropertyEditorType.ObjectSelector) { Attribute EditorAttr = prop.GetCustomAttribute <PropertyEditor>(); PropertyEditorType EditorType = (PropertyEditorType)(EditorAttr as PropertyEditor).PropertyEditorType; if (EditorType is PropertyEditorType.ObjectSelector) { DefaultVal = DefaultVal.SingleQuoted(); } } //for Others else if (prop.PropertyType == typeof(string) || prop.PropertyType == typeof(DateTime)) { DefaultVal = DefaultVal.SingleQuoted(); } return(string.Format(s, _name, DefaultVal)); } if (prop.PropertyType == typeof(string)) { if (!string.IsNullOrEmpty((string)prop.GetValue(obj))) { return(string.Format(s, _name, string.Format("'{0}'", prop.GetValue(obj)))); } if (prop.Name.EndsWith("Color")) { return(string.Format(s, _name, "'#FFFFFF'")); } else { return(string.Format(s, _name, (prop.Name == "Name" || prop.Name == "EbSid") ? "id" : "''")); } } else if (prop.Name == "Controls") { return(string.Format(_c, JsonConvert.SerializeObject((obj as EbControlContainer).Controls, new JsonSerializerSettings { TypeNameHandling = TypeNameHandling.All }))); } else if (prop.PropertyType == (typeof(int)) || prop.PropertyType == (typeof(float))) { return(string.Format(s, _name, ((prop.Name == "Id") ? "id" : "0"))); } else if (prop.PropertyType == typeof(bool)) { return(string.Format(s, _name, prop.GetValue(obj).ToString().ToLower())); } else if (prop.PropertyType.GetTypeInfo().IsEnum) { if (prop.IsDefined(typeof(PropertyEditor)) && prop.GetCustomAttribute <PropertyEditor>().BooleanOption) { Type[] args = prop.PropertyType.GetGenericArguments(); Type itemType = args[0]; return(string.Format(s, _name, "{\"$type\":\"System.Collections.Generic.List`1[[@typeName, @nameSpace]], System.Private.CoreLib\",\"$values\":[]}".Replace("@typeName", itemType.FullName).Replace("@nameSpace", itemType.AssemblyQualifiedName.Split(",")[1]))); } return(string.Format(s, _name, ((int)prop.GetValue(obj)).ToString())); } else if (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition().Name == "IDictionary`2") { return(string.Format(s, _name, "{\"$type\": \"System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib],[System.Object, System.Private.CoreLib]], System.Private.CoreLib\",\"$values\": {}}"));//need to recheck format } else if (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(List <>)) { Type[] args = prop.PropertyType.GetGenericArguments(); if (args.Length > 0) { Type itemType = args[0]; return(string.Format(s, _name, "{\"$type\":\"System.Collections.Generic.List`1[[@typeName, @nameSpace]], System.Private.CoreLib\",\"$values\":[]}".Replace("@typeName", itemType.FullName).Replace("@nameSpace", itemType.AssemblyQualifiedName.Split(",")[1]))); } else { return(string.Format(s, _name, "[]")); } } else if (prop.PropertyType.IsClass && !prop.PropertyType.IsPrimitive) { if (prop.PropertyType == typeof(EbFont)) { return(string.Format(s, _name, "null")); } else { try { object Obj = Activator.CreateInstance(prop.PropertyType); SetAllDefaultPropVals(prop, Obj); return(string.Format(s, _name, EbSerializers.Json_Serialize(Obj))); } catch (Exception e) { Console.Write(e.Message); return(""); } } } else { return(string.Format(s, _name, "null")); } }
public bool Post(SlackAuthRequest req) { EbConnectionFactory dbFactory = new EbConnectionFactory(req.SolnId, this.Redis); if (req.IsNew) { try { string sql = "UPDATE eb_users SET slackjson = @slackjson WHERE id = @id"; var id = dbFactory.DataDB.DoQuery <Int32>(sql, new DbParameter[] { dbFactory.DataDB.GetNewParameter("slackjson", EbDbTypes.Json, EbSerializers.Json_Serialize(req.SlackJson)), dbFactory.DataDB.GetNewParameter("id", EbDbTypes.Int32, req.UserId) }); } catch (Exception e) { Console.WriteLine("Exception: " + e.ToString()); return(false); } } else { throw new NotImplementedException(); } return(true); }
private string JsVarDecl(PropertyInfo prop, object obj) { string s = @"this.{0} = {1};"; string _c = @"this.Controls = new EbControlCollection(JSON.parse('{0}'));"; if (prop.IsDefined(typeof(DefaultPropValue))) { string DefaultVal = prop.GetCustomAttribute <DefaultPropValue>().Value; // For Object Selector if (prop.GetType().GetTypeInfo().IsDefined(typeof(PropertyEditor)) && prop.GetCustomAttribute <PropertyEditor>().PropertyEditorType == PropertyEditorType.ObjectSelector) { Attribute EditorAttr = prop.GetCustomAttribute <PropertyEditor>(); PropertyEditorType EditorType = (EditorAttr as PropertyEditor).PropertyEditorType; if (EditorType is PropertyEditorType.ObjectSelector) { DefaultVal = DefaultVal.SingleQuoted(); } } //for Others else if (prop.PropertyType == typeof(string) || prop.PropertyType == typeof(DateTime)) { DefaultVal = DefaultVal.SingleQuoted(); } return(string.Format(s, prop.Name, DefaultVal)); } if (prop.PropertyType == typeof(string)) { if (prop.Name.EndsWith("Color")) { return(string.Format(s, prop.Name, "'#FFFFFF'")); } else { return(string.Format(s, prop.Name, (prop.Name == "Name" || prop.Name == "EbSid") ? "id" : "''")); } } else if (prop.Name == "Controls") { return(string.Format(_c, JsonConvert.SerializeObject((obj as EbControlContainer).Controls, new JsonSerializerSettings { TypeNameHandling = TypeNameHandling.All }))); } else if (prop.PropertyType == (typeof(int)) || prop.PropertyType == (typeof(float))) { return(string.Format(s, prop.Name, ((prop.Name == "Id") ? "id" : "0"))); } else if (prop.PropertyType == typeof(bool)) { return(string.Format(s, prop.Name, "false")); } else if (prop.PropertyType.GetTypeInfo().IsEnum) { return(string.Format(s, prop.Name, "0")); } else if (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(List <>)) { Type[] args = prop.PropertyType.GetGenericArguments(); if (args.Length > 1) { Type itemType = args[0]; return(string.Format(s, prop.Name, "{\"$type\":\"System.Collections.Generic.List`1[[@typeName, ExpressBase.Objects]], System.Private.CoreLib\",\"$values\":[]}".Replace("@typeName", itemType.FullName))); } else { return(string.Format(s, prop.Name, "[]")); } } else if (prop.PropertyType.IsClass) { object Obj = Activator.CreateInstance(prop.PropertyType); return(string.Format(s, prop.Name, EbSerializers.Json_Serialize(Obj))); } else { return(string.Format(s, prop.Name, "null")); } }
public Dictionary <string, string> SendSMS(string To, string body) { Dictionary <string, string> msgStatus = null; try { string status = string.Empty; string result = string.Empty; string url = string.Format(SMS_URL_BARE, Config.UserName, Config.Password, Config.ApiKey, To, body); IEnumerable <string> matches = Regex.Matches(To, @"[1-9]").OfType <Match>() .Select(m => m.Groups[0].Value) .Distinct(); if (matches.Count() > 0) { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); WebResponse resp = request.GetResponse(); WebHeaderCollection header = resp.Headers; Encoding encoding = ASCIIEncoding.ASCII; string responseText; using (System.IO.StreamReader reader = new System.IO.StreamReader(resp.GetResponseStream(), encoding)) { responseText = reader.ReadToEnd(); } XmlDocument Doc = new XmlDocument(); Doc.LoadXml(responseText); XmlNode node = Doc.GetElementsByTagName("ExpertTextAPI").Item(0); foreach (XmlNode item in node.ChildNodes) { if ((item).NodeType == XmlNodeType.Element) { if (item.Name == "Status") { if (item.FirstChild.Value == "SUCCESS") { status = item.FirstChild.Value; } else { status = "FAILED"; result = item.FirstChild.Value; } } } } } else { status = "FAILED"; result = "'To' is not a Valid number."; } msgStatus = new Dictionary <string, string> { { "To", To }, { "From", Config.From }, { "Uri", url }, { "Body", body }, { "Status", status.ToLower() }, // { "SentTime", msg.DateSent.ToString() }, // { "ErrorMessage", msg.ErrorMessage } { "ConId", Config.Id.ToString() }, { "Result", result } }; } catch (Exception e) { Console.WriteLine("Exception:" + e.Message); if (!(msgStatus is null)) { msgStatus.Add("ErrorMessage", e.Message); } } Console.WriteLine(" --- SMS msg" + EbSerializers.Json_Serialize(msgStatus)); return(msgStatus); }
public virtual void Persist(string TenantAccountId, ITenantDbFactory dbconf, bool IsNew) { if (IsNew) { string sql = "INSERT INTO eb_connections (con_type, solution_id, nick_name, con_obj) VALUES (@con_type, @solution_id, @nick_name, @con_obj) RETURNING id"; DbParameter[] parameters = { dbconf.DataDB.GetNewParameter("con_type", System.Data.DbType.String, EbConnectionType), dbconf.DataDB.GetNewParameter("solution_id", System.Data.DbType.String, TenantAccountId), dbconf.DataDB.GetNewParameter("nick_name", System.Data.DbType.String, !(string.IsNullOrEmpty(NickName))?NickName:string.Empty), dbconf.DataDB.GetNewParameter("con_obj", NpgsqlTypes.NpgsqlDbType.Json, EbSerializers.Json_Serialize(this)) }; var iCount = dbconf.DataDB.DoQuery(sql, parameters); } else if (!IsNew) { string sql = @"UPDATE eb_connections SET eb_del = true WHERE con_type = @con_type AND solution_id = @solution_id; INSERT INTO eb_connections (con_type, solution_id, nick_name, con_obj) VALUES (@con_type, @solution_id, @nick_name, @con_obj)"; DbParameter[] parameters = { dbconf.DataDB.GetNewParameter("con_type", System.Data.DbType.String, EbConnectionType), dbconf.DataDB.GetNewParameter("solution_id", System.Data.DbType.String, TenantAccountId), dbconf.DataDB.GetNewParameter("nick_name", System.Data.DbType.String, !(string.IsNullOrEmpty(NickName))?NickName:string.Empty), dbconf.DataDB.GetNewParameter("con_obj", NpgsqlTypes.NpgsqlDbType.Json, EbSerializers.Json_Serialize(this)) }; var iCount = dbconf.DataDB.DoNonQuery(sql, parameters); } }