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 string Post(FileMetaPersistMqRequest request)
{
string tag = string.Empty;
if (request.FileDetails.MetaDataDictionary.Count != 0)
{
foreach (var items in request.FileDetails.MetaDataDictionary)
{
tag = string.Join(",", items.Value);
}
}
TenantDbFactory tenantDbFactory = new TenantDbFactory(request.TenantAccountId, this.Redis);
string sql = "INSERT INTO eb_files(userid, objid, length, filetype, tags, bucketname, uploaddatetime) VALUES(@userid, @objid, @length, @filetype,@tags,@bucketname, CURRENT_TIMESTAMP) RETURNING id";
DbParameter[] parameters =
{
tenantDbFactory.ObjectsDB.GetNewParameter("userid", System.Data.DbType.Int32, request.UserId),
tenantDbFactory.ObjectsDB.GetNewParameter("objid", System.Data.DbType.String, request.FileDetails.ObjectId),
tenantDbFactory.ObjectsDB.GetNewParameter("length", System.Data.DbType.Int64, request.FileDetails.Length),
tenantDbFactory.ObjectsDB.GetNewParameter("filetype", System.Data.DbType.String, request.FileDetails.FileType),
tenantDbFactory.ObjectsDB.GetNewParameter("tags", System.Data.DbType.String, tag),
tenantDbFactory.ObjectsDB.GetNewParameter("bucketname", System.Data.DbType.String, request.BucketName)
};
var iCount = tenantDbFactory.ObjectsDB.DoQuery(sql, parameters);
return(null);
}
public bool Post(RefreshSolutionConnectionsMqRequest req)
{
using (var con = new TenantDbFactory("expressbase", this.Redis).DataDB.GetNewConnection() as Npgsql.NpgsqlConnection)
{
try
{
con.Open();
string sql = @"SELECT con_type, con_obj FROM eb_connections WHERE solution_id = @solution_id AND eb_del = false";
DataTable dt = new DataTable();
var ada = new Npgsql.NpgsqlDataAdapter(sql, con);
ada.SelectCommand.Parameters.Add(new Npgsql.NpgsqlParameter("solution_id", NpgsqlTypes.NpgsqlDbType.Text)
{
Value = req.TenantAccountId
});
ada.Fill(dt);
EbSolutionConnections cons = new EbSolutionConnections();
foreach (DataRow dr in dt.Rows)
{
if (dr["con_type"].ToString() == EbConnectionTypes.EbDATA.ToString())
{
cons.DataDbConnection = EbSerializers.Json_Deserialize <EbDataDbConnection>(dr["con_obj"].ToString());
}
else if (dr["con_type"].ToString() == EbConnectionTypes.EbDATA_RO.ToString())
{
cons.DataDbConnection = EbSerializers.Json_Deserialize <EbDataDbConnection>(dr["con_obj"].ToString());
}
else if (dr["con_type"].ToString() == EbConnectionTypes.EbOBJECTS.ToString())
{
cons.ObjectsDbConnection = EbSerializers.Json_Deserialize <EbObjectsDbConnection>(dr["con_obj"].ToString());
}
else if (dr["con_type"].ToString() == EbConnectionTypes.EbFILES.ToString())
{
cons.FilesDbConnection = EbSerializers.Json_Deserialize <EbFilesDbConnection>(dr["con_obj"].ToString());
}
else if (dr["con_type"].ToString() == EbConnectionTypes.EbLOGS.ToString())
{
cons.LogsDbConnection = EbSerializers.Json_Deserialize <EbLogsDbConnection>(dr["con_obj"].ToString());
}
else if (dr["con_type"].ToString() == EbConnectionTypes.SMTP.ToString())
{
cons.SMTPConnection = EbSerializers.Json_Deserialize <SMTPConnection>(dr["con_obj"].ToString());
}
// ... More to come
}
Redis.Set <EbSolutionConnections>(string.Format("EbSolutionConnections_{0}", req.TenantAccountId), cons);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public void Post(ChangeSMTPConnectionRequest request)
{
TenantDbFactory dbFactory = new TenantDbFactory("expressbase", this.Redis);
request.SMTPConnection.Persist(request.TenantAccountId, dbFactory, request.IsNew);
base.MessageProducer3.Publish(new RefreshSolutionConnectionsMqRequest()
{
TenantAccountId = request.TenantAccountId, UserId = request.UserId
});
}
public string Post(SlackPostMqRequest req)
{
TenantDbFactory dbFactory = new TenantDbFactory(req.TenantAccountId, this.Redis);
string sql = "SELECT slackjson FROM eb_users WHERE id = @id";
var dt = dbFactory.DataDB.DoQuery(sql, new DbParameter[] { dbFactory.DataDB.GetNewParameter("id", System.Data.DbType.Int32, req.UserId) });
var json = dt.Rows[0][0];
SlackJson slackJson = JsonConvert.DeserializeObject <SlackJson>(json.ToString());
var client = new RestClient("https://slack.com");
if (req.PostType == 1)
{
var request = new RestRequest("api/files.upload", Method.POST);
request.AddParameter("token", slackJson.AccessToken);
request.AddParameter("user_id", slackJson.UserId);
request.AddParameter("team_id", slackJson.TeamId);
request.AddParameter("channels", req.Payload.Channel);
if (!string.IsNullOrEmpty(req.Payload.Text))
{
request.AddParameter("content", req.Payload.Text);
}
if (req.Payload.SlackFile != null && req.Payload.SlackFile.FileByte != null && req.Payload.SlackFile.FileByte.Length > 0)
{
request.AddFile("file", req.Payload.SlackFile.FileByte, req.Payload.SlackFile.FileName, contentType: "multipart/form-data");
}
//Execute the request
var res = client.ExecuteAsyncPost(request, SlackCallBack, "POST");
}
else if (req.PostType == 0)
{
var request = new RestRequest("api/chat.postMessage", Method.POST);
request.AddParameter("token", slackJson.AccessToken);
request.AddParameter("channels", req.Payload.Channel);
request.AddParameter("user_id", slackJson.UserId);
request.AddParameter("team_id", slackJson.TeamId);
if (!string.IsNullOrEmpty(req.Payload.Text))
{
request.AddParameter("text", req.Payload.Text);
}
//Execute the request
var res = client.ExecuteAsyncPost(request, SlackCallBack, "POST");
}
return(null);
}
