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