public object Get(MLAddKeyRequest request)
{
List <MLAddKey> list = request.Data;
string query1 = "INSERT INTO eb_keys (key) VALUES(@KEY) RETURNING id;";
var con = this.TenantDbFactory.ObjectsDB.GetNewConnection();
con.Open();
DbCommand cmd = this.TenantDbFactory.ObjectsDB.GetNewCommand(con, query1);
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("@KEY", System.Data.DbType.String, request.Key));
var key_id = cmd.ExecuteScalar().ToString();
StringBuilder query2 = new StringBuilder();
query2.Append(@"INSERT INTO eb_keyvalue (key_id,lang_id,value) VALUES");
string kid = "@KEY_ID", lid = "@LANG_ID", kval = "@KEY_VALUE";
int i = 0;
List <DbParameter> parameters = new List <DbParameter>();
foreach (MLAddKey obj in request.Data)
{
query2.Append("(" + (kid + i) + "," + (lid + i) + "," + (kval + i) + "),");
parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter((kid + i), System.Data.DbType.Int64, key_id));
parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter((lid + i), System.Data.DbType.Int32, obj.Lang_Id));
parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter((kval + i), System.Data.DbType.String, obj.Key_Value));
i++;
}
query2.Length = query2.Length - 1;
query2.Append(";");
var dt = this.TenantDbFactory.ObjectsDB.DoNonQuery(query2.ToString(), parameters.ToArray());
return(new MLAddKeyResponse {
KeyId = Convert.ToInt32(key_id), RowAffected = dt
});
}
public int AddKeyValue(string k, string d)
{
if (k == "" || d == "")
{
return(0);
}
var data = JsonConvert.DeserializeObject <List <MLAddKey> >(d);
MLAddKeyRequest rqst = new MLAddKeyRequest();
rqst.Data = data;
rqst.Key = k;
var result = this.ServiceClient.Get <MLAddKeyResponse>(rqst);
return(result.KeyId);
}
