public JObject GetBlocks()
{
try
{
JObject filter = new JObject();
filter[CommonConst.CommonField.IS_ENABLED] = true;
string filterPage = string.Empty;
var page = _paramContainer.GetKey(PAGE);
if (page != null)
{
filterPage = page.ToString();
}
var data = DBProxy.Get(ZBLOCK_COLLECTION, filter.ToString(), new List <string>()
{
CommonConst.CommonField.DATA_KEY, PAGES, INDEX, BLOCK_PATH, DISPLAY_AREA
});
data = new JArray(data.Where(f => f[PAGES] != null && (f[PAGES] as JArray).Where(f1 => f1.ToString() == filterPage).Count() != 0).OrderBy(f => (int)f[INDEX]));
Logger.Debug("Enter to Get Blocks");
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, data));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
public JObject GetMenuItems()
{
try
{
Logger.Debug("Enter to GetMenuItems");
// TODO need to do the session user filter;
var data = DBProxy.Get(ModuleAppConsts.Collection.BACKEND_UI_ROUTES, CommonConst.Filters.IS_OVERRIDE_FILTER);
List <string> userAccess = new List <string>()
{
"*"
};
var sessionUser = SessionProvider.GetValue <UserModel>(CommonConst.CommonValue.SESSION_USER_KEY);
if (sessionUser != null)
{
userAccess.AddRange(sessionUser.groups);
}
JArray menuData = new JArray();
foreach (var item in data)
{
if (item["auth_users"].Where(f => userAccess.Contains(f.ToString())).Any())
{
menuData.Add(item);
}
}
Logger.Debug("Got GetMenuItems");
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, menuData));
}
catch (Exception ex)
{
Logger.Error(string.Format("Error in GetMenuItems: {0}", ex.Message), ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
private JObject GetGalleryImages(string id)
{
JObject filter = new JObject();
filter[CommonConst.CommonField.DISPLAY_ID] = id;
var data = DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_GALLERY_COLLECTION, filter.ToString());
if (data != null)
{
ImageGalleryHelper.AddDefaultOwner(data);
if (ImageGalleryHelper.IsValidaUser(data, SessionProvider))
{
AddGalleryThumbnailImage(data);
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, GetGalleryPageData(data)));
}
else
{
data.Remove(ImageProcessor.AUTH_USERS);
data.Remove(ImageProcessor.FILE_HASHS);
return(ResponseBuilder.CreateReponse(CommonConst._401_UNAUTHORIZED, data));
}
}
else
{
return(ResponseBuilder.CreateReponse(CommonConst._404_RESOURCE_NOT_FOUND));
}
}
public static ArrayList GetCollection(int flag_value)
{
MySqlConnection myConn = DBProxy.GetMySqlConnection();
DBProxy.OpenConnectionForObject(ref myConn);
MySqlCommand myCmd = new MySqlCommand("SELECT * from `tablename` WHERE flag_column = " + flag_value, myConn);
MySqlDataReader myRdr = null;
ArrayList aCltn = new ArrayList();
if (DBProxy.ExecuteSQLReader(ref myCmd, ref myRdr, "GETTER") == false)
{
if (myRdr != null && myRdr.IsClosed == false)
{
myRdr.Close();
}
DBProxy.CloseConnectionForObject(ref myConn);
return(aCltn);
}
while (myRdr.Read())
{
Classname me = new Classname(
/* getters */
);
aCltn.Add(me);
}
myRdr.Close();
DBProxy.CloseConnectionForObject(ref myConn);
return(aCltn);
}
protected bool CreateUser(string userid, string name, UserIDType userType)
{
JObject userData = new JObject();
userData[CommonConst.CommonField.USER_ID] = userData[CommonConst.CommonField.DATA_KEY] = userid;
userData[CommonConst.CommonField.USER_TYPE] = userType.ToString();
var updateFilter = userData.ToString();
userData[CommonConst.CommonField.DISPLAY_ID] = CommonUtility.GetNewID();
userData[CommonConst.CommonField.IS_ENABLED] = true;
userData[CommonConst.CommonField.NAME] = name;
userData[CommonConst.CommonField.IS_EMAIL_VALIDATE] = false;
userData[CommonConst.CommonField.IS_PHONE_VALIDATE] = false;
var userGroup = AppSettingService.GetAppSetting(ModuleAppConsts.Field.DEFAULT_USER_GROUPS_APP_SETTING_KEY);
Logger.Debug("userGroup setting data", userGroup);
if (userGroup == null)
{
throw new Exception("User Group setting not found in AppSettings");
}
if (userGroup[CommonConst.CommonField.DATA] == null || userGroup[CommonConst.CommonField.DATA][CommonConst.CommonField.USER_GROUPS] == null)
{
throw new Exception("User Groups not found in AppSettings");
}
userData[CommonConst.CommonField.USER_GROUPS] = (userGroup[CommonConst.CommonField.DATA][CommonConst.CommonField.USER_GROUPS] as JArray);
return(DBProxy.Write(CommonConst.Collection.USERS, userData, updateFilter, true));
}
public JObject Update()
{
try
{
JObject request = HttpProxy.GetRequestBody <JObject>();
if (request == null)
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
if (request[CommonConst.CommonField.DISPLAY_ID] == null)
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
JObject filter = new JObject();
filter[CommonConst.CommonField.DISPLAY_ID] = request[CommonConst.CommonField.DISPLAY_ID].ToString();
var dbresponse = DBProxy.Update(CommonConst.Collection.APP_SETTING, filter.ToString(), request, true, MergeArrayHandling.Replace);
if (dbresponse == 0)
{
Logger.Error(string.Format("Error in SettingController.update: {0}, collection {1}", "Error in updating data in db", CommonConst.Collection.APP_SETTING));
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS));
}
catch (Exception ex)
{
Logger.Error(string.Format("SettingController.Get {0}", ex.Message), ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
public bool SqlBaseClear(SqlBaseItemXml basemodel)
{
bool revalue = false;
var serverlist = DBConfig.GetServerItemXmlConfigList(basemodel);
if (serverlist != null)
{
foreach (var serveritem in serverlist)
{
string connstr = DBProxyAction.GetConnStr(basemodel, serveritem);
var databaselist = DBConfig.GetDatabaseItemXmlConfigList(basemodel, serveritem.Number);
if (databaselist != null)
{
foreach (var databaseitem in databaselist)
{
DBProxy.GetDBAccess(serveritem.DBType).DatabaseDrop(connstr, databaseitem.DatabaseName);
}
}
}
ManagerConfig servermanagerconfig = new ManagerConfig();
//servermanagerconfig.InitServerXml(basemodel);
servermanagerconfig.InitDatabaseXml(basemodel);
servermanagerconfig.InitTableXml(basemodel);
servermanagerconfig.InitFieldXml(basemodel);
}
return(revalue);
}
private bool UpdateCustomContentData(JObject contentCustomData, UserModel user, string data, JObject updateFilter)
{
JObject updateFilterExistingData = new JObject();
updateFilterExistingData[CommonConst.CommonField.FILE_PATH] = contentCustomData[CommonConst.CommonField.FILE_PATH].ToString();
updateFilterExistingData[CommonConst.CommonField.IS_OVERRIDE] = false;
var updateData = new JObject();
updateData[CommonConst.CommonField.OVERRIDE_BY] = _contentUpdateModuleName;
updateData[CommonConst.CommonField.IS_OVERRIDE] = true;
DBProxy.Update(CommonConst.Collection.STATIC_CONTECT, updateFilterExistingData.ToString(), updateData);
var existingData = contentCustomData[CommonConst.CommonField.DATA];
JObject history = new JObject();
history[CommonConst.CommonField.DATA] = existingData;
history[CommonConst.CommonField.UPDATED_BY] = user.user_id;
history[CommonConst.CommonField.UPDATED_DATE_TIME] = CommonUtility.GetUnixTimestamp(DateTime.Now);
(contentCustomData[_contentHistory] as JArray).Add(history);
contentCustomData[CommonConst.CommonField.DATA] = data;
if (DBProxy.Update(CommonConst.Collection.STATIC_CONTECT, updateFilter.ToString(), contentCustomData) != 1)
{
Logger.Error(string.Format("Error in UpdateContent.Update: {0}", "error updating contentCustomData"));
return(false);
}
return(true);
}
public bool GetTable(SqlBaseItemXml basemodel, SqlServerItemXml item, SqlDatabaseItemXml item2)
{
var tablelist = DBConfig.GetTableItemXmlConfigList(basemodel, item2.Number);
var tablelist2 = tablelist.Where(m => m.IsUse == true && m.IsWrite == true).ToList();
foreach (var tableobjectitem2 in tablelist2)
{
var temp3 = DBProxy.GetDBAccess(item.DBType).TableStorageSize(currentconnstrdatabase, tableobjectitem2.TableName);
var temp3count = DBProxy.GetDBAccess(item.DBType).TableCount(currentconnstrdatabase, tableobjectitem2.TableName);
if (tableobjectitem2.StorageSize > temp3 && tableobjectitem2.RowNum > temp3count)
{
currenttable = tableobjectitem2.TableName;
currenttablenumber = tableobjectitem2.Number;
isposition = true;
return(isposition);
}
else
{
new ManagerConfig().TableChangeIsWrite(tableobjectitem2);
}
}
if (item2.TableNum > tablelist.Count() && item2.IsCreate)
{
var temptable = DBWrite.AddTable(currentconnstrdatabase, item, item2);
currenttable = temptable.TableName;
currenttablenumber = temptable.Number;
isposition = true;
return(isposition);
}
return(isposition);
}
public long SyncTaskManagerSum(List <TaskDataParam> taskdata, int tasknum = 20, bool IsFreeCache = true)
{
List <Task <long> > listtask = new List <Task <long> >();
runnumold = taskdata.Count;
runnumcurrent = 0;
while (runnumold > runnumcurrent)
{
listtask.Clear();
if (IsFreeCache)
{
var tempmodel = taskdata[runnumcurrent];
DBProxy.GetDBAccess(tempmodel.dbtype).ServerCacheClear(tempmodel.connstr);
}
for (int i = 1; (i < tasknum) && (runnumold > runnumcurrent); i++)
{
Task <long> t = new Task <long>(n => SyncTaskSum((TaskDataParam)n), taskdata[runnumcurrent++]);
t.Start();
listtask.Add(t);
}
rowcount += listtask.Sum(m => m.Result);
}
Console.WriteLine("执行完成:" + rowcount);
return(rowcount);
}
public void DatabaseUseCheckAll(SqlBaseItemXml basemodel)
{
var serverlist = DBConfig.GetServerItemXmlConfigList(basemodel);
int servernum = serverlist.Count;
int databasenum = 0;
ManagerConfig serverconfig = new ManagerConfig();
foreach (var item in serverlist)
{
var databaselist = DBConfig.GetDatabaseItemXmlConfigList(basemodel, item.Number);
string connstr = DBProxyAction.GetConnStr(basemodel, item);
foreach (var item2 in databaselist)
{
var restatus = DBProxy.GetDBAccess(item.DBType).DatabaseExists(connstr, item2.DatabaseName);
if (item2.IsUse != restatus)
{
databasenum++;
serverconfig.DatabaseChangeIsUse(item2, restatus);
}
Console.WriteLine("检查数据库连接,服务器：" + item.ServerName + ",数据库:" + item2.DatabaseName + ",status:" + restatus);
}
}
new ManagerConfig().SaveConfig(basemodel);
Console.WriteLine("测试连接执行完成,操作服务器：" + servernum + ",操作数据库:" + databasenum);
}
public bool Send()
{
Logger.Info("Start TextLocalSMSController.Send");
string sms_id = _paramContainer.GetKey(TextLocalConsts.SMS_QUEUE_ID);
if (string.IsNullOrEmpty(sms_id))
{
Logger.Error("sms_id is null");
ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR);
}
var smsData = DBProxy.FirstOrDefault(CommonConst.Collection.SMS_QUEUE, CommonConst.CommonField.DISPLAY_ID, sms_id);
if (smsData == null)
{
Logger.Error("sms_data is null");
ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR);
}
var phone = smsData[CommonConst.CommonField.PHONE].ToString();
var textSMSData = smsData[CommonConst.CommonField.BODY].ToString();
string apiKey = AppSettingService.GetAppSettingData(TextLocalConsts.TEXT_LOCAL_SMS_GATEWAY_KEY);
string endPoint = AppSettingService.GetAppSettingData(TextLocalConsts.TEXT_LOCAL_SMS_GATEWAY_ENDPOINT);
string fromPhone = AppSettingService.GetAppSettingData(TextLocalConsts.SMS_FROM);
return(TextLocalSMSHelper.SendSMS(textSMSData, phone, apiKey, endPoint, fromPhone, Logger));
}
public int TableUseCheckServer(object model)
{
int changetablenum = 0;
var item = model as SqlServerItemXml;
var basemodel = DBConfig.GetBaseXmlConfig(item.BaseNumber);
if (item != null)
{
ManagerConfig serverconfig = new ManagerConfig();
var databaselist = DBConfig.GetDatabaseItemXmlConfigList(basemodel, item.Number);
string connstr = DBProxyAction.GetConnStr(basemodel, item);
foreach (var item2 in databaselist)
{
var tablelist = DBConfig.GetTableItemXmlConfigList(basemodel, item2.Number);
foreach (var item3 in tablelist)
{
var restatus = DBProxy.GetDBAccess(item.DBType).TableExists(connstr, item2.DatabaseName, item3.TableName);
if (item3.IsUse != restatus)
{
changetablenum++;
serverconfig.TableChangeIsUse(item3, restatus);
}
Console.WriteLine("检查数据表连接,服务器：" + item.ServerName + ",数据库:" + item2.DatabaseName + ",表:" + item3.TableName + ",status:" + restatus);
}
}
}
Console.WriteLine("服务器:" + item.ServerName + ",涉及表总数:" + changetablenum);
return(1);
}
public IEnumerable <T> PurviewcodeGetList <T>(int?R_ID = null, int?U_Id = null) where T : class
{
var client = DBProxy.CreateClient();
var sql = new StringBuilder(@"SELECT
DISTINCT
smp.MPC_ID
,smp.MPC_NAME
,smp.MPC_NAME_C
,smp.MPC_NAME_J
,smp.MPC_CODE
,sm.M_NAME
,sm.M_NAME_C
FROM SS_MENU_PURVIEWCODE smp
LEFT JOIN SS_ROLE_MENU_PURVIEWCODE srmp
ON smp.MPC_CODE = srmp.MPC_CODE
LEFT JOIN SS_MENU sm
ON smp.M_ID = sm.M_ID
WHERE smp.MPC_DISABLED = 0
AND sm.M_DISABLED = 0
");
var param = new DynamicParameters();
if (R_ID.HasValue)
{
sql.Append(" AND srmp.R_ID = @R_ID");
param.Add("@R_ID", R_ID.Value);
}
if (U_Id.HasValue)
{
var rIds = RepoBase.Instance.GetWhere <SS_ROLE_USER>(x => x.U_ID == U_Id.Value).Select(x => x.R_ID);
sql.Append(" AND srmp.R_ID IN @R_ID");
param.Add("@R_ID", rIds);
}
return(client.Query <T>(sql.ToString(), param));
}
public bool GetServer(SqlBaseItemXml basemodel)
{
var templist = DBConfig.GetServerXmlConfig(basemodel).SqlServerList.Where(m => m.IsUse == true && m.IsWrite == true).ToList();
foreach (SqlServerItemXml item in templist)
{
long currentStorageSize = 0;
currentserver = item.ServerName;
currentservernumber = item.Number;
currentconnstrserver = DBProxyAction.GetConnStr(basemodel, item);
try
{
currentStorageSize = DBProxy.GetDBAccess(item.DBType).DatabaseStorageSizeAll(currentconnstrserver, basemodel.DatabasePrev);
}
catch (Exception ex)
{
Console.WriteLine("error:" + ex.Message);
new ManagerConfig().ServerChangeIsUse(item);
return(false);
}
if ((item.StorageSize - item.RetainStorageSize) > currentStorageSize)
{
if (GetDatabase(basemodel, item))
{
return(isposition);
}
}
else
{
new ManagerConfig().ServerChangeIsWrite(item);
}
}
return(false);
}
public JObject GetUserBookmark()
{
var user = SessionProvider.GetValue <UserModel>(CommonConst.CommonValue.SESSION_USER_KEY);
if (user == null)
{
return(ResponseBuilder.CreateReponse(CommonConst._401_UNAUTHORIZED));
}
var filter = new JObject();
filter[CommonConst.CommonField.USER_ID] = user.user_id;
var bookmarkData = DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_IMAGE_BOOKMARK_COLLECTION, filter.ToString());
JObject responseData = new JObject();
if (bookmarkData != null)
{
JArray data = new JArray();
foreach (var item in bookmarkData[ImageProcessor.IMAGES])
{
var d = ImageGalleryHelper.GetImageData(DBProxy, SessionProvider, item[ImageProcessor.FILE_HASH].ToString()).First();
d[ImageProcessor.GALLERY_ID] = item[ImageProcessor.GALLERY_ID];
data.Add(d);
}
responseData[CommonConst.CommonField.NAME] = "My Bookmarked Images";
responseData[ImageProcessor.IMAGES] = data;
}
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, responseData));
}
public long SyncThreadPoolManagerSum(List <TaskDataParam> taskdata, int tasknum = 20, bool IsFreeCache = true)
{
runnumold = taskdata.Count;
runnumcurrent = 0;
while (runnumold > runnumcurrent)
{
if (IsFreeCache)
{
var tempmodel = taskdata[runnumcurrent];
DBProxy.GetDBAccess(tempmodel.dbtype).ServerCacheClear(tempmodel.connstr);
}
for (int i = 1; (i < tasknum) && (runnumold > runnumcurrent); i++)
{
Threadnum++;
ThreadPool.QueueUserWorkItem(SyncThreadPoolSum, taskdata[runnumcurrent++]);
}
while (Threadrunnum < (Threadnum - 1))
{
Thread.Sleep(50);
}
}
Console.WriteLine("执行完成:" + rowcount);
return(rowcount);
}
public JObject Bookmark()
{
try
{
var fileHash = HttpProxy.GetQueryString(ImageProcessor.FILE_HASH);
var galleryId = HttpProxy.GetQueryString(ImageProcessor.GALLERY_ID);
if (string.IsNullOrEmpty(fileHash) || string.IsNullOrEmpty(galleryId))
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
if (!ImageGalleryHelper.HasAccess(DBProxy, SessionProvider, galleryId, fileHash))
{
return(ResponseBuilder.CreateReponse(CommonConst._401_UNAUTHORIZED));
}
var user = SessionProvider.GetValue <UserModel>(CommonConst.CommonValue.SESSION_USER_KEY);
var filter = new JObject();
filter[CommonConst.CommonField.USER_ID] = user.user_id;
var bookmarkData = DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_IMAGE_BOOKMARK_COLLECTION, filter.ToString());
if (bookmarkData == null)
{
bookmarkData = new JObject();
bookmarkData[CommonConst.CommonField.DISPLAY_ID] = CommonUtility.GetNewID();
bookmarkData[CommonConst.CommonField.USER_ID] = user.user_id;
bookmarkData[ImageProcessor.IMAGES] = new JArray();
}
JObject bookmarrkResponse = new JObject();
var bookmarkFile = (bookmarkData[ImageProcessor.IMAGES] as JArray).FirstOrDefault(f => f[ImageProcessor.FILE_HASH].ToString() == fileHash);
Logger.Debug("Get Bookmark data");
if (bookmarkFile != null)
{
(bookmarkData[ImageProcessor.IMAGES] as JArray).Remove(bookmarkFile);
bookmarrkResponse[ImageProcessor.COUNT] = -1;
Logger.Debug("Removed");
}
else
{
bookmarkFile = new JObject();
bookmarkFile[ImageProcessor.FILE_HASH] = fileHash;
bookmarkFile[ImageProcessor.GALLERY_ID] = galleryId;
(bookmarkData[ImageProcessor.IMAGES] as JArray).Add(bookmarkFile);
bookmarrkResponse[ImageProcessor.COUNT] = +1;
Logger.Debug("Adding");
}
DBProxy.Update(ImageProcessor.MYPHOTO_IMAGE_BOOKMARK_COLLECTION, filter.ToString(), bookmarkData, true, MergeArrayHandling.Replace);
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, bookmarrkResponse));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
public int PingCompleted()
{
if (IsSuccessResponse())
{
DBProxy.Delete(CommonConst.Collection.PING, CommonConst.EMPTY_JSON_OBJECT);
}
return(1);
}
public JObject Like()
{
try
{
var fileHash = HttpProxy.GetQueryString(ImageProcessor.FILE_HASH);
var galleryId = HttpProxy.GetQueryString(ImageProcessor.GALLERY_ID);
if (string.IsNullOrEmpty(fileHash) || string.IsNullOrEmpty(galleryId))
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
if (!ImageGalleryHelper.HasAccess(DBProxy, SessionProvider, galleryId, fileHash))
{
return(ResponseBuilder.CreateReponse(CommonConst._401_UNAUTHORIZED));
}
var user = SessionProvider.GetValue <UserModel>(CommonConst.CommonValue.SESSION_USER_KEY);
var filter = new JObject();
filter[ImageProcessor.FILE_HASH] = fileHash;
var likeData = DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_IMAGE_LIKE_COLLECTION, filter.ToString());
if (likeData == null)
{
likeData = new JObject();
likeData[ImageProcessor.USERS] = new JArray();
likeData[ImageProcessor.FILE_HASH] = fileHash;
likeData[ImageProcessor.COUNT] = 0;
likeData[CommonConst.CommonField.DISPLAY_ID] = CommonUtility.GetNewID();
}
var totalCount = 0;
int.TryParse(likeData[ImageProcessor.COUNT].ToString(), out totalCount);
JObject like = new JObject();
var likeUser = (likeData[ImageProcessor.USERS] as JArray).FirstOrDefault(f => f.ToString() == user.user_id);
if (likeUser != null)
{
(likeData[ImageProcessor.USERS] as JArray).Remove(likeUser);
totalCount--;
like[ImageProcessor.COUNT] = -1;
}
else
{
(likeData[ImageProcessor.USERS] as JArray).Add(user.user_id);
totalCount++;
like[ImageProcessor.COUNT] = +1;
}
likeData[ImageProcessor.COUNT] = (likeData[ImageProcessor.USERS] as JArray).Count;
DBProxy.Update(ImageProcessor.MYPHOTO_IMAGE_LIKE_COLLECTION, filter.ToString(), likeData, true, MergeArrayHandling.Replace);
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, like));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
public JObject AdminUpdate()
{
try
{
Logger.Debug("Enter to UpdateUserInfo.AdminUpdate");
JObject request = HttpProxy.GetRequestBody <JObject>();
if (request == null)
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
string userId = string.Empty;
if (request[CommonConst.CommonField.USER_ID] != null)
{
userId = request[CommonConst.CommonField.USER_ID].ToString();
}
if (string.IsNullOrEmpty(userId))
{
Logger.Error(string.Format("Error in UpdateUserInfo.AdminUpdate: {0}", "User id empty"));
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
JObject updateFilter = new JObject();
updateFilter[CommonConst.CommonField.USER_ID] = userId;
if (request[ModuleAppConsts.Field.USER_INFO] != null && (request[ModuleAppConsts.Field.USER_INFO] as JArray).Count > 0)
{
var userInfo = request[ModuleAppConsts.Field.USER_INFO][0] as JObject;
Logger.Debug("Updating User Info", userInfo);
var dbresponse = DBProxy.Update(CommonConst.Collection.USER_INFO, updateFilter.ToString(), userInfo, true, MergeArrayHandling.Replace);
if (dbresponse == 0)
{
Logger.Error(string.Format("Error in UpdateUserInfo.AdminUpdate: {0}, collection {1}", "Error in updating data in db", CommonConst.Collection.USER_INFO));
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
JObject userdata = new JObject();
userdata[CommonConst.CommonField.PHONE] = request[CommonConst.CommonField.PHONE];
userdata[CommonConst.CommonField.EMAIL] = request[CommonConst.CommonField.EMAIL];
userdata[CommonConst.CommonField.NAME] = request[CommonConst.CommonField.NAME];
Logger.Debug("Updating User", userdata);
if (DBProxy.Write(CommonConst.Collection.USERS, userdata, updateFilter.ToString(), false, MergeArrayHandling.Union))
{
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS, updateFilter));
}
else
{
Logger.Error(string.Format("Error in UpdateUserInfo.AdminUpdate: {0}, collection {1}", "Error in updating data in db", CommonConst.Collection.USERS));
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
catch (Exception ex)
{
Logger.Error(string.Format("Error in UpdateUserInfo.AdminUpdate: {0}", ex.Message), ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
private void SyncThreadPoolSum(object model)
{
TaskDataParam dataparam = model as TaskDataParam;
long revalue = CommonHelper.ToLong(DBProxy.GetDBHelper(dataparam.dbtype).GetSingle(dataparam.connstr, dataparam.sqlstr));
Threadrunnum++;
Console.WriteLine("线程执行" + Threadrunnum + ",总数:" + revalue + "," + dataparam.sqlstr);
rowcount += revalue;
}
private string UploadFile(string galleryId, UserModel user, string fileName, IKeyValueStorage keyValueStorage)
{
FileInfo fi = new FileInfo(fileName);
Logger.Debug(string.Format("Getting File Data"));
byte[] fileData = _fileUploader.GetFileData(fileName);
using (Bitmap image = ImageGalleryHelper.GetImageBitmapFromByte(fileData))
{
Logger.Debug(string.Format("Getting file Hash"));
var fileModel = new FileModel()
{
file_hash = Hashing.GetFileHash(fileData), file_paths = new List <string>()
};
JObject fileFilter = new JObject();
fileFilter[ImageProcessor.FILE_HASH] = fileModel.file_hash;
if (DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_COLLECTION, fileFilter.ToString()) == null)
{
Logger.Debug(string.Format("CreateFileDataJObject"));
var imageJObjectData = ImageGalleryHelper.CreateFileDataJObject(fileModel, string.Empty, image, keyValueStorage);
imageJObjectData[CommonConst.CommonField.DISPLAY_ID] = CommonUtility.GetNewID();
imageJObjectData[ImageProcessor.OWNER] = user.user_id;
DBProxy.Write(ImageProcessor.MYPHOTO_COLLECTION, imageJObjectData);
}
var filter = new JObject();
filter[CommonConst.CommonField.DISPLAY_ID] = galleryId;
Logger.Debug(string.Format("Getting gallery "));
var galleryData = DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_GALLERY_COLLECTION, filter.ToString());
if (galleryData == null)
{
galleryData = new JObject();
galleryData[ImageProcessor.FILE_HASHS] = new JArray();
(galleryData[ImageProcessor.FILE_HASHS] as JArray).Add(fileModel.file_hash);
galleryData[ImageProcessor.GALLERY_THUMBNAIL] = fileModel.file_hash;
galleryData[ImageProcessor.OWNER] = user.user_id;
galleryData[ImageProcessor.AUTH_USERS] = new JArray();
(galleryData[ImageProcessor.AUTH_USERS] as JArray).Add(user.user_id);
}
else
{
if (galleryData[ImageProcessor.FILE_HASHS] == null)
{
galleryData[ImageProcessor.FILE_HASHS] = new JArray();
}
Logger.Debug(string.Format("Adding file to collection "));
(galleryData[ImageProcessor.FILE_HASHS] as JArray).Insert(0, fileModel.file_hash);
}
galleryData[ImageProcessor.FILES_COUNT] = (galleryData[ImageProcessor.FILE_HASHS] as JArray).Count;
DBProxy.Update(ImageProcessor.MYPHOTO_GALLERY_COLLECTION, filter.ToString(), galleryData, false, MergeArrayHandling.Replace);
return(fileModel.file_hash);
}
}
public int ServerCacheClearItem(object model)
{
var item = model as SqlServerItemXml;
var basemodel = DBConfig.GetBaseXmlConfig(item.BaseNumber);
string connstr = DBProxyAction.GetConnStr(basemodel, item);
Console.WriteLine("操作服务器开始:" + item.ServerName);
DBProxy.GetDBAccess(item.DBType).ServerCacheClear(connstr);
Console.WriteLine("操作服务器完成:" + item.ServerName);
return(1);
}
public int UpdateOTPStatus()
{
int duration = 15;
int.TryParse(AppSettingService.GetAppSettingData(CommonConst.CommonField.OTP_DURATION), out duration);
var expirestime = CommonUtility.GetUnixTimestamp(DateTime.Now.AddMinutes(-duration));
string filter = "{" + CommonConst.CommonField.CREATED_DATA_DATE_TIME + " : { $lt : " + expirestime + "}}";
DBProxy.Delete(CommonConst.Collection.OTPs, filter);
return(1);
}
public JObject UpdateAlbum()
{
try
{
var galleryId = HttpProxy.GetQueryString(ImageProcessor.GALLERY_ID);
var requestBody = HttpProxy.GetRequestBody <JObject>();
if (requestBody == null || string.IsNullOrEmpty(galleryId))
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
if (!ImageGalleryHelper.IsOwner(DBProxy, SessionProvider, galleryId))
{
return(ResponseBuilder.CreateReponse(CommonConst._401_UNAUTHORIZED));
}
var filter = new JObject();
filter[CommonConst.CommonField.DISPLAY_ID] = galleryId;
var data = DBProxy.FirstOrDefault(ImageProcessor.MYPHOTO_GALLERY_COLLECTION, filter.ToString());
if (data == null)
{
return(ResponseBuilder.CreateReponse(CommonConst._400_BAD_REQUEST));
}
if (requestBody[ImageProcessor.DISPLAY_NAME] != null)
{
data[ImageProcessor.DISPLAY_NAME] = requestBody[ImageProcessor.DISPLAY_NAME].ToString();
}
if (requestBody[ImageProcessor.DESCRIPTION] != null)
{
data[ImageProcessor.DESCRIPTION] = requestBody[ImageProcessor.DESCRIPTION].ToString();
}
if (requestBody[ImageProcessor.GALLERY_THUMBNAIL] != null)
{
data[ImageProcessor.GALLERY_THUMBNAIL] = requestBody[ImageProcessor.GALLERY_THUMBNAIL].ToString();
}
if (requestBody[ImageProcessor.AUTH_USERS] != null)
{
data[ImageProcessor.AUTH_USERS] = requestBody[ImageProcessor.AUTH_USERS];
}
if (DBProxy.Update(ImageProcessor.MYPHOTO_GALLERY_COLLECTION, filter.ToString(), data, false, MergeArrayHandling.Replace) != 1)
{
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
return(ResponseBuilder.CreateReponse(CommonConst._1_SUCCESS));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
return(ResponseBuilder.CreateReponse(CommonConst._500_SERVER_ERROR));
}
}
public long SyncTaskSum(TaskDataParam model)
{
long revalue = CommonHelper.ToLong(DBProxy.GetDBHelper(model.dbtype).GetSingle(model.connstr, model.sqlstr));
if (revalue < 1)
{
;
}
Threadrunnum++;
Console.WriteLine("线程执行" + Threadrunnum + ",总数:" + revalue + ",服务器名:" + model.servername);
return(revalue);
}
public int CleanSession()
{
double duration = ApplicationConfig.SessionDuration;
double.TryParse(AppSettingService.GetAppSettingData(CommonConst.CommonField.SESSION_DURATION), out duration);
var expirestime = CommonUtility.GetUnixTimestamp(DateTime.Now.AddMinutes(-duration));
string filter = "{" + CommonConst.CommonField.UPDATED_DATE_TIME + " : { $lt : " + expirestime + "}}";
DBProxy.Delete(CommonConst.Collection.SESSION_DATA, filter);
return(1);
}
private bool ResetPass(UserModel requestUser, string password)
{
JObject userData = new JObject();
userData[CommonConst.CommonField.USER_ID] = userData[CommonConst.CommonField.DATA_KEY] = requestUser.user_id;
userData[CommonConst.CommonField.USER_TYPE] = requestUser.user_type;
var filter = userData.ToString();
userData[CommonConst.CommonField.PASSWORD] = EncryptionService.GetHash(password);
return(DBProxy.Write(CommonConst.Collection.USERS, userData, filter));
}
public T GetModelByUserName <T>(UserInfoGetRequest req) where T : class
{
var client = DBProxy.CreateClient();
var sql = new StringBuilder(@"SELECT * FROM SS_USER su WHERE 1=1 ");
var param = new DynamicParameters();
if (req.U_ID.HasValue)
{
sql.Append(" AND U_ID=@U_ID");
param.Add("@U_ID", req.U_ID);
}
return(client.Query <T>(sql.ToString(), param).FirstOrDefault());
}
