public int SaveNewLabselectList(int testid, DataTable theDTselectList, int UserID) { try { int theRowAffected = 0; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject LabManager = new ClsObject(); LabManager.Connection = this.Connection; LabManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@testID", SqlDbType.Int, testid.ToString()); theRowAffected = (Int32)LabManager.ReturnObject(ClsUtility.theParams, "pr_Admin_deleteLabTestselectList_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); if (theRowAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in delete Lab Result record. Try Again.."; AppException.Create("#C1", theBL); } for (int i = 0; i < theDTselectList.Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@LabName", SqlDbType.VarChar, theDTselectList.Rows[i]["selectlist"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@testID", SqlDbType.Int, testid.ToString()); theRowAffected = (Int32)LabManager.ReturnObject(ClsUtility.theParams, "pr_Admin_AddLabTestselectList_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); if (theRowAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Lab record. Try Again.."; AppException.Create("#C1", theBL); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theRowAffected); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public ExceptionResponse Map(Exception exception) { return(exception switch { DomainException ex => new ExceptionResponse(new { code = ex.Code, reason = ex.Message }, HttpStatusCode.BadRequest), AppException ex => new ExceptionResponse(new { code = ex.Code, reason = ex.Message }, HttpStatusCode.BadRequest), _ => new ExceptionResponse(new { code = "error", reason = "We obtained a problem, try again later." }, HttpStatusCode.BadRequest) });
/// <summary> /// 查询总的图书藏书与可借书信息 /// </summary> /// <param name="conn">IDbConnection数据库连接对象</param> /// <returns>总的图书藏书与可借书信息</returns> public List <DisplayInfo> QuerySumISLoan(IDbConnection conn) { // 用来显示 List <DisplayInfo> displayInfolist = new List <DisplayInfo>(); // 统计数量查询语句 string sqlforbookitem = "select OrderNum, BookID, ISLoan from BookItem"; try { // 统计数量 using (SqlDataReader result = SqlHelper.ExecuteReader(null, conn as SqlConnection, sqlforbookitem, null)) { if (result.HasRows) { // 统计数量 List <BookItem> booknum = new List <BookItem>(); while (result.Read()) { BookItem tempBookItem = new BookItem(); // 条形码 if (!result.IsDBNull(0)) { tempBookItem.OrderNum = result.GetGuid(0); } // 图书ID if (!result.IsDBNull(1)) { tempBookItem.BookID = result.GetGuid(1); } // 图书是否可借 if (!result.IsDBNull(2)) { tempBookItem.ISLoan = result.GetInt32(2); } booknum.Add(tempBookItem); } displayInfolist = this.GetRepeat(booknum); } } } catch (Exception exp) { AppException appexp = new AppException("查询总的图书藏书与可借书信息", exp, ExceptionLevel.Error); LogManager.Log.WriteException(appexp); } return(displayInfolist); }
public int SaveExposedInfant(int Id, int Ptn_Pk, int ExposedInfantId, string FirstName, string LastName, DateTime DOB, string FeedingPractice3mos, string CTX2mos, string HIVTestType, string HIVResult, string FinalStatus, DateTime?DeathDate, int UserID) { int theRowAffected = 0; ClsObject VisitManager = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString()); ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, Ptn_Pk.ToString()); ClsUtility.AddParameters("@ExposedInfantId", SqlDbType.Int, ExposedInfantId.ToString()); ClsUtility.AddParameters("@FirstName", SqlDbType.VarChar, FirstName.ToString()); ClsUtility.AddParameters("@LastName", SqlDbType.VarChar, LastName.ToString()); ClsUtility.AddParameters("@DOB", SqlDbType.DateTime, DOB.ToString()); ClsUtility.AddParameters("@FeedingPractice3mos", SqlDbType.VarChar, FeedingPractice3mos.ToString()); ClsUtility.AddParameters("@CTX2mos", SqlDbType.VarChar, CTX2mos.ToString()); ClsUtility.AddParameters("@HIVResult", SqlDbType.VarChar, HIVResult.ToString()); ClsUtility.AddParameters("@HIVTestType", SqlDbType.VarChar, HIVTestType.ToString()); ClsUtility.AddParameters("@FinalStatus", SqlDbType.VarChar, FinalStatus.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, UserID.ToString()); if (DeathDate != null) { ClsUtility.AddParameters("@DeathDate", SqlDbType.VarChar, DeathDate == null ? null : DeathDate.ToString()); } theRowAffected = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveExposedInfant", ClsUtility.ObjectEnum.ExecuteNonQuery); if (theRowAffected == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Custom Field. Try Again.."; AppException.Create("#C1", theMsg); } } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { VisitManager = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(theRowAffected); }
public async Task <string> ScheduleCallAsync([FromBody] ScheduleCallDTO callInfo) { try { if (callInfo == null) { return("NotFound"); } //Widget wgt = context.Widgets.Find(Guid.Parse(callInfo.token)); //wgt.User = context.Users.Find(wgt.UserID); Widget wgt = await context.Widgets.Include(widget => widget.User) .Where(widget => widget.ID == Guid.Parse(callInfo.token)) .FirstOrDefaultAsync(); if (wgt == null) { return("NotFound"); } CallbackSchedule schedule = new CallbackSchedule(); schedule.widget = wgt; schedule.LeadName = callInfo.name; schedule.LeadEmail = callInfo.email; schedule.LeadMessage = callInfo.message ?? ""; schedule.LeadPhoneNumber = callInfo.phone; schedule.CallDone = false; schedule.EmailNotificationDone = false; schedule.ScheduledDateTime = ParseDateTime(callInfo.date, callInfo.time); context.CallbackSchedules.Add(schedule); await context.SaveChangesAsync(); try { EmailManager.SendCallNotificationEmail(wgt.DomainURL, wgt.NotificationEmail, wgt.User.Name, schedule.LeadName, schedule.LeadEmail, schedule.LeadPhoneNumber, schedule.ScheduledDateTime.ToString(), schedule.LeadMessage); }catch (Exception) { } return("OK: Call request sent"); }catch (Exception ex) { AppException exception = new AppException(); exception.ErrorDateTime = DateTime.Now; exception.Message = ex.Message; exception.FullString = ex.ToString(); context.AppExceptions.Add(exception); await context.SaveChangesAsync(); return("Error"); } }
/// <summary> /// Bulids the app exception global log. /// </summary> /// <param name="trackId">The track id.</param> /// <param name="appex">The appex.</param> /// <returns>GlobalLog.</returns> public GlobalLog BulidAppExceptionGlobalLog(TrackID trackId, AppException appex) { GlobalLog log = new GlobalLog() { CurrentTrackID = trackId, AppException = appex, LogType = LogType.AppExceptionLog, TimePoint = DateTime.Now, }; return log; }
private async void HandleFunctionError(string functionToCall, AppException ex) { string message = "It looks like your backend is not set up correctly. " + $"Did the \"{functionToCall}\" function get " + $"created? See the 'Set up the Task Tracker " + $"Tutorial Backend' steps in the tutorial." + $"\r\n\r\n{ex.Message}"; await DisplayAlert("Error", message, "OK"); LogFunctionError(); }
/// <summary> /// /// </summary> /// <param name="app"></param> public void Configuration(IAppBuilder app) { try { HttpConfiguration = new HttpConfiguration(); GlobalConfiguration.Configuration.Formatters.JsonFormatter.SerializerSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; ConfigureOAuth(app); app.UseCors(CorsOptions.AllowAll); //HttpConfiguration.EnableCors(); //AreaRegistration.RegisterAllAreas(); AppConfiguration.RegisterApi(HttpConfiguration); app.UseWebApi(HttpConfiguration); HttpConfiguration.MessageHandlers.Add(new ApiKeyHandler()); HttpConfiguration.Filters.Add(new CustomExceptionFilter()); //app.MapSignalR("/websocket", new HubConfiguration()); var idProvider = new CustomUserProvider(); IoC.InitializeWith(new DependencyResolverFactory()); GlobalHost.DependencyResolver.Register(typeof(IUserIdProvider), () => idProvider); app.Map("/websocket", map => { // Setup the CORS middleware to run before SignalR. // By default this will allow all origins. You can // configure the set of origins and/or http verbs by // providing a cors options with a different policy. map.UseCors(CorsOptions.AllowAll); var hubConfiguration = new HubConfiguration { // You can enable JSONP by uncommenting line below. // JSONP requests are insecure but some older browsers (and some // versions of IE) require JSONP to work cross domain // EnableJSONP = true }; map.RunSignalR(hubConfiguration); }); } catch (Exception ex) { var exception = new AppException(ex.ToString(), ex.InnerException); logger.Error(exception.FullDetail); } }
//public int SaveNewLabType(string LabTypeName, int UserID) //{ // try // { // this.Connection = DataMgr.GetConnection(); // this.Transaction = DataMgr.BeginTransaction(this.Connection); // ClsObject LabManager = new ClsObject(); // LabManager.Connection = this.Connection; // LabManager.Transaction = this.Transaction; // ClsUtility.Init_Hashtable(); // ClsUtility.AddParameters("@LabTypeName", SqlDbType.VarChar, LabTypeName); // ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); // DataRow theDR; // int RowsAffected = (Int32)LabManager.ReturnObject(ClsUtility.theParams, "pr_Admin_AddLabtype_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); // if (RowsAffected == 0) // { // MsgBuilder theBL = new MsgBuilder(); // theBL.DataElements["MessageText"] = "Error in Saving Lab type record. Try Again.."; // AppException.Create("#C1", theBL); // } // DataMgr.CommitTransaction(this.Transaction); // DataMgr.ReleaseConnection(this.Connection); // return Convert.ToInt32(RowsAffected); // } // catch // { // throw; // } // finally // { // if (this.Connection != null) // DataMgr.ReleaseConnection(this.Connection); // } //} //public int UpdateLabType(int LabTypeID, string LabTypeName, int UserID) //{ // try // { // this.Connection = DataMgr.GetConnection(); // this.Transaction = DataMgr.BeginTransaction(this.Connection); // ClsObject LabManager = new ClsObject(); // LabManager.Connection = this.Connection; // LabManager.Transaction = this.Transaction; // ClsUtility.Init_Hashtable(); // ClsUtility.AddParameters("@LabTypeName", SqlDbType.VarChar, LabTypeName); // ClsUtility.AddParameters("@LabTypeID", SqlDbType.Int, LabTypeID.ToString()); // ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); // DataRow theDR; // int RowsAffected = (Int32)LabManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_UpdateLabType_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); // if (RowsAffected == 0) // { // MsgBuilder theBL = new MsgBuilder(); // theBL.DataElements["MessageText"] = "Error in Saving Lab type record. Try Again.."; // AppException.Create("#C1", theBL); // } // DataMgr.CommitTransaction(this.Transaction); // DataMgr.ReleaseConnection(this.Connection); // return Convert.ToInt32(RowsAffected); // } // catch // { // throw; // } // finally // { // if (this.Connection != null) // DataMgr.ReleaseConnection(this.Connection); // } //} public DataTable UpdateLab(int LabID, string LabName, int LabDepartmentID, int LabTypeID, int UserID, int DeleteFlag, string DataType, decimal MaxBoundary, decimal MinBoundary, int LabValueId, int Sequence, int UnitId) { try { DataTable theAffectedDT; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject LabManager = new ClsObject(); LabManager.Connection = this.Connection; LabManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@LabName", SqlDbType.VarChar, LabName); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@LabDepartmentId", SqlDbType.Int, LabDepartmentID.ToString()); ClsUtility.AddParameters("@LabTypeId", SqlDbType.Int, LabTypeID.ToString()); ClsUtility.AddParameters("@LabTestId", SqlDbType.Int, LabID.ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString()); ClsUtility.AddParameters("@DataType", SqlDbType.NVarChar, DataType.ToString()); ClsUtility.AddParameters("@MaxBoundary", SqlDbType.Decimal, MaxBoundary.ToString()); ClsUtility.AddParameters("@MinBoundary", SqlDbType.Decimal, MinBoundary.ToString()); ClsUtility.AddParameters("@LabValueId", SqlDbType.Int, LabValueId.ToString()); ClsUtility.AddParameters("@Sequence", SqlDbType.Int, Sequence.ToString()); ClsUtility.AddParameters("@UnitId", SqlDbType.Int, UnitId.ToString()); //DataRow theDR; theAffectedDT = (DataTable)LabManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_UpdateLabTest_Constella", ClsDBUtility.ObjectEnum.DataTable); if (theAffectedDT.Rows[0][0].ToString() == "-1") { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Lab test record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theAffectedDT); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveUpdateSatellite(String ID, String SatelliteID, String SatelliteName, String status, int priority, int Flag, int UserID, String Createdate) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject SatelliteMgr = new ClsObject(); SatelliteMgr.Connection = this.Connection; SatelliteMgr.Transaction = this.Transaction; oUtility.Init_Hashtable(); oUtility.AddParameters("@SatelliteID", SqlDbType.VarChar, SatelliteID); oUtility.AddParameters("@SatelliteName", SqlDbType.VarChar, SatelliteName); oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, status.ToString()); oUtility.AddParameters("@SRNo", SqlDbType.Int, priority.ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); int RowsAffected = 0; if (Flag == 0) { RowsAffected = (Int32)SatelliteMgr.ReturnObject(oUtility.theParams, "pr_Admin_SaveSatellite_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); } else if (Flag == 1) { oUtility.AddParameters("@ID", SqlDbType.Int, ID.ToString()); RowsAffected = (Int32)SatelliteMgr.ReturnObject(oUtility.theParams, "pr_Admin_UpdateSatellite_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); } /*********/ if (RowsAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Reason record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(Convert.ToInt32(RowsAffected)); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
/// <summary> /// /// </summary> /// <param name="context"></param> /// <returns></returns> public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); try { } catch (Exception ex) { var exception = new AppException(ex.ToString(), ex.InnerException); logger.Error(exception.FullDetail); } }
public override void Handle(ExceptionHandlerContext context) { try { context.Exception.Handle(); } catch (AppException) { AppException ex = (context.Exception as AppException) ?? new AppException(context.Exception.Message); context.Result = new TextPlainErrorResult(Request: context.ExceptionContext.Request, Content: ex.ExceptionData, HttpStatusCode: ex.HttpStatus); } base.Handle(context); }
public static BadRequestObjectResult BadRequest(AppException ex) { var result = new List <ErrorObjectResult> { new ErrorObjectResult("Business", ex.Message) }; return(new BadRequestObjectResult(new { Errors = result, Success = false })); }
public int CreateAppException(Exception e) { var appException = new AppException { Message = e.Message, StackTrace = e.StackTrace, ExceptionString = e.ToString(), WhenCreated = DateTime.UtcNow }; context.AppException.Add(appException); context.SaveChanges(); return(appException.AppExceptionID); }
/// <summary> /// 获取全部图书信息 /// </summary> /// <param name="conn">数据库连接</param> /// <returns>图书信息</returns> public List <Bookinfo> GetAllBookInfo(IDbConnection conn) { // 图书信息查询语句 string sqlforbookinfo = "select Top(100) BookID, Title, Decrible from BookInfo"; List <Bookinfo> bookinfoList = new List <Bookinfo>(); try { using (SqlDataReader result = SqlHelper.ExecuteReader(null, conn as SqlConnection, sqlforbookinfo, null)) { if (result.HasRows) { while (result.Read()) { Bookinfo bookinfo = new Bookinfo(); // 图书名 if (!result.IsDBNull(0)) { bookinfo.BookID = result.GetGuid(0); } // 图书名 if (!result.IsDBNull(1)) { bookinfo.Title = result.GetString(1); } // 图书描述 if (!result.IsDBNull(2)) { bookinfo.Decrible = result.GetString(2); } bookinfoList.Add(bookinfo); } } result.Close(); } } catch (Exception exp) { AppException appexp = new AppException("获取全部图书信息", exp, ExceptionLevel.Error); LogManager.Log.WriteException(appexp); } return(bookinfoList); }
public override void OnException(HttpActionExecutedContext context) { AppException hbiEx = null; if (context.Exception is AppException) { hbiEx = context.Exception as AppException; } else { hbiEx = new AppException(Unhandled_Error, context.Exception); } Logger.Error(hbiEx.InnerException != null ? hbiEx.InnerException.ToString() : hbiEx.ToString()); context.Response = context.Request.CreateResponse(HttpStatusCode.InternalServerError, hbiEx.Errors); }
protected void ShowError(AppException ex, string title) { Deployment.Current.Dispatcher.BeginInvoke(() => { MessageBoxResult result = T360ViewUtlity.Handle(CultureManager.Instance, ex, title); if (result == MessageBoxResult.OK || result == MessageBoxResult.None) { SetFocus(); } if (T360ErrorCodes.AppSessionExpired.Equals(ex.ErrorCodes[0].Code)) { RedirectToLogin(); } }); }
/// <summary> /// 立即缴纳并归还图书 /// </summary> /// <param name="orderNum">条形码</param> /// <param name="fine">罚款</param> /// <returns>是否成功</returns> private bool ReturnBookPay(Guid orderNum, decimal fine) { bool issuccess = false; // 写入罚款 if (this.loanInfoAccess.WritePaied(orderNum, fine, this.Transaction) == 1) { // 是否罚款置1 if (this.loanInfoAccess.PayMoneyByguid(orderNum, this.Transaction) == 1) { // 写入还书日期 if (this.loanInfoAccess.ReturnBook(orderNum, this.Transaction) == 1) { // 图书入库 if (this.bookItemAccess.ReturnBook(orderNum, this.Transaction)) { issuccess = true; } else { AppException appexp = new AppException("图书入库失败,还书失败", ExceptionLevel.Info); issuccess = false; throw appexp; } } else { AppException appexp = new AppException("图书入库失败,还书失败", ExceptionLevel.Info); issuccess = false; throw appexp; } } else { AppException appexp = new AppException("还书失败", ExceptionLevel.Info); issuccess = false; throw appexp; } } else { AppException appexp = new AppException("还书失败", ExceptionLevel.Info); issuccess = false; throw appexp; } return(issuccess); }
public static void SendActivationEmail(Cxt cxt, string userName) { User user = User.GetUser(cxt, userName); if (user.IsNew) { AppException.Throw("Msg.UserNameNotExists(userName)"); } MailVerifyResult result = EmailTemplate.Send(cxt, EmailTemplateE.NewAccount, user); if (result == MailVerifyResult.Ok) { AppException.Throw("Msg.ActivationEmailOk(userName)"); } }
public int SaveUpdateRegimenGeneric(string RegimenName, string RegimenCode, int RegimenID, string Stage, int Status, string GenericID, int UserID, int SRNo, int flag) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject DrugManager = new ClsObject(); DrugManager.Connection = this.Connection; DrugManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@RegimenName", SqlDbType.VarChar, RegimenName); ClsUtility.AddParameters("@RegimenCode", SqlDbType.VarChar, RegimenCode); ClsUtility.AddParameters("@Rid", SqlDbType.Int, RegimenID.ToString()); ClsUtility.AddParameters("@Stage", SqlDbType.VarChar, Stage); ClsUtility.AddParameters("@Status", SqlDbType.Int, Status.ToString()); ClsUtility.AddParameters("@GenericID", SqlDbType.VarChar, GenericID); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@SRNo", SqlDbType.Int, SRNo.ToString()); ClsUtility.AddParameters("@flag", SqlDbType.Int, flag.ToString()); Int32 RowsAffected = (Int32)DrugManager.ReturnObject(ClsUtility.theParams, "pr_Admin_SaveRegimenGeneric_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (RowsAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Regimen Generic Combinations. Try Again.."; Exception ex = AppException.Create("#C1", theBL); throw ex; } DrugManager = null; DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(RowsAffected); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public async Task <IActionResult> Login([FromBody] VmLoginRequest LoginRequest) { if (ModelState.IsValid) { try { User user = await _userService.ValidateUserToLogin(LoginRequest.UserName, LoginRequest.Password); List <Claim> authClaims = new() { new Claim(ClaimTypes.Name, user.Username), new Claim(JwtRegisteredClaimNames.Jti, user.Id.ToString()), new Claim(ClaimTypes.Role, user.Role.ToString()), }; SymmetricSecurityKey authSigningKey = new(Encoding.UTF8.GetBytes(_config.JWTConfig.Secret)); JwtSecurityToken token = new( issuer : _config.JWTConfig.ValidIssuer, audience : _config.JWTConfig.ValidAudience, expires : DateTime.Now.AddHours(_config.JWTConfig.Expires), claims : authClaims, signingCredentials : new SigningCredentials(authSigningKey, SecurityAlgorithms.HmacSha256) ); string JWTToken = new JwtSecurityTokenHandler().WriteToken(token); return(Ok(DataMessage.Data(new VmLoginResponse() { Token = JWTToken }))); } catch (AppException ex) { return(BadRequest(ex.ReturnBadRequest())); } catch (Exception ex) { return(BadRequest(AppException.ReturnBadRequest(ex.Message))); } } else { return(BadRequest(AppException.ReturnBadRequest(ModelState))); } }
/// <summary> /// 模糊查询图书数 /// </summary> /// <param name="bookname">查询关键字</param> /// <param name="conn">IDbConnection(数据库连接对象)</param> /// <returns>获得满足筛选条件的图书信息</returns> public List <Bookinfo> QueryBookByName(string bookname, IDbConnection conn) { string sqlText = "select top(100) BookID, Title, Decrible from BookInfo WHERE Title LIKE '%" + bookname + "%'"; List <Bookinfo> bookinfolist = new List <Bookinfo>(); try { using (SqlDataReader result = SqlHelper.ExecuteReader(null, conn as SqlConnection, sqlText, null)) { if (result.HasRows) { while (result.Read()) { Bookinfo stbookinfo = new Bookinfo(); // 图书ID if (!result.IsDBNull(0)) { stbookinfo.BookID = result.GetGuid(0); } // 图书名字 if (!result.IsDBNull(1)) { stbookinfo.Title = result.GetString(1).Trim(); } // 图书描述 if (!result.IsDBNull(2)) { stbookinfo.Decrible = result.GetString(2).Trim(); } bookinfolist.Add(stbookinfo); } } } } catch (Exception exp) { AppException appexp = new AppException("模糊查询图书数", exp, ExceptionLevel.Error); LogManager.Log.WriteException(appexp); } return(bookinfolist); }
/// <summary> /// 查询显示用户信息 /// </summary> /// <param name="coll">传入参数</param> /// <returns>视图</returns> public ActionResult LibrayMgr(FormCollection coll) { this.trackID = TrackIdManager.GetInstance("shaoyu"); List <DisplayInfo> displayInfolist = new List <DisplayInfo>(); List <Bookinfo> bookinfoList = new List <Bookinfo>(); try { // 初始信息 if (coll.Count == 0) { QueryAllBook queryAllBook = new QueryAllBook(); displayInfolist = queryAllBook.GetAllBookInfo(); } else if (coll.Count > 0) { // 查询信息 if (Request.IsAjaxRequest()) { string bookname = coll["bookname"] != null ? coll["bookname"].Trim() : string.Empty; DisplayMgr displayMgr = new DisplayMgr(); // 模糊查询 displayInfolist = displayMgr.QueryByName(bookname); return(this.PartialView("BookList", displayInfolist)); } } } catch (AppException appexp) { return(this.View("Shared/Error", appexp.ToString())); } catch (Exception exp) { AppException appexp = new AppException(" 查询显示用户信息 ", exp, ExceptionLevel.Error); LogManager.Log.WriteException(appexp); return(this.View("Shared/Error", exp.ToString())); } finally { LogManager.Log.WriteUiAcc("shaoyu", "UserInfo", "shaoyu", "127.0.0.1", string.Empty, string.Empty, "查询显示用户信息", null); } return(this.View(displayInfolist)); }
public int UpdateOccupation(int OccupationID, string OccupationName, int UserID, int DeleteFlag, int Sequence) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject OccupationManager = new ClsObject(); OccupationManager.Connection = this.Connection; OccupationManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@OccupationName", SqlDbType.VarChar, OccupationName); ClsUtility.AddParameters("@OccupationID", SqlDbType.Int, OccupationID.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString()); ClsUtility.AddParameters("@Sequence", SqlDbType.Int, Sequence.ToString()); int RowsAffected = (Int32)OccupationManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_UpdateOccupation_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); if (RowsAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Occupation record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(RowsAffected); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveNewReason(string ReasonName, int CategoryID, int SRNo, int UserID) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject ReasonManager = new ClsObject(); ReasonManager.Connection = this.Connection; ReasonManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ReasonName", SqlDbType.VarChar, ReasonName); ClsUtility.AddParameters("@CategoryID", SqlDbType.Int, CategoryID.ToString()); ClsUtility.AddParameters("@SRNo", SqlDbType.Int, SRNo.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); // ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString()); // DataRow theDR; int RowsAffected = (Int32)ReasonManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_InsertReason_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); if (RowsAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Reason record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(Convert.ToInt32(RowsAffected)); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public ErrorList BadRequest(AppException appException, HttpRequest request) { var error = new Error { Id = Guid.NewGuid(), Status = HttpStatus.BadRequest, Code = HttpStatus.BadRequest.ToString(), Title = "Bad Request", Detail = appException.Message, InnerException = appException, HttpRequest = request.ToHttpRequestMeta() }; _context.Errors.Add(error); _context.SaveChanges(); return(error.ToErrorList()); }
public DataTable SaveLabUnitLinks(int ID, int SubTestID, decimal MinBoundaryValue, decimal MaxBoundaryValue, int UnitID, int DefaultUnit, int Undetectable) { try { DataTable theAffectedDT; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject LabManager = new ClsObject(); LabManager.Connection = this.Connection; LabManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ID", SqlDbType.Int, ID.ToString()); ClsUtility.AddParameters("@SubTestID", SqlDbType.Int, SubTestID.ToString()); ClsUtility.AddParameters("@MinBoundaryValue", SqlDbType.Decimal, MinBoundaryValue.ToString()); ClsUtility.AddParameters("@MaxBoundaryValue", SqlDbType.Decimal, MaxBoundaryValue.ToString()); ClsUtility.AddParameters("@UnitID", SqlDbType.Int, UnitID.ToString()); ClsUtility.AddParameters("@DefaultUnit", SqlDbType.Int, DefaultUnit.ToString()); ClsUtility.AddParameters("@Undetectable", SqlDbType.Int, Undetectable.ToString()); DataRow theDR; theAffectedDT = (DataTable)LabManager.ReturnObject(ClsUtility.theParams, "pr_Admin_SaveLabUnitLinks_Constella", ClsDBUtility.ObjectEnum.DataTable); if (theAffectedDT.Rows[0][0].ToString() == "-1") { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Lab record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theAffectedDT); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveNewEducation(int UserID, string EducationName, int Sequence) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject EducationManager = new ClsObject(); EducationManager.Connection = this.Connection; EducationManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@EducationName", SqlDbType.VarChar, EducationName); ClsUtility.AddParameters("@Sequence", SqlDbType.Int, Sequence.ToString()); DataRow theDR; theDR = (DataRow)EducationManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_Insert_Education_Constella", ClsUtility.ObjectEnum.DataRow); if (Convert.ToInt32(theDR[0]) == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Education record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(Convert.ToInt32(theDR[0])); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveUpdate(string ID, string PatientId, string TransferfromId, string TransfertoId, string TransfertoDate, int userId, string createdate, int flag) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject SaveUpdateMgr = new ClsObject(); SaveUpdateMgr.Connection = this.Connection; SaveUpdateMgr.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ID", SqlDbType.VarChar, ID); ClsUtility.AddParameters("@PatientId", SqlDbType.VarChar, PatientId); //ClsUtility.AddParameters("@LocationId", SqlDbType.VarChar, LocationId); ClsUtility.AddParameters("@TransferfromId", SqlDbType.VarChar, TransferfromId); ClsUtility.AddParameters("@TransfertoId", SqlDbType.VarChar, TransfertoId); ClsUtility.AddParameters("@TransfertoDate", SqlDbType.VarChar, TransfertoDate); ClsUtility.AddParameters("@UserId", SqlDbType.Int, userId.ToString()); ClsUtility.AddParameters("@Createdate", SqlDbType.VarChar, createdate); ClsUtility.AddParameters("@Flag", SqlDbType.Int, flag.ToString()); int RowsAffected = (Int32)SaveUpdateMgr.ReturnObject(ClsUtility.theParams, "pr_Clinical_PatientSatelliteTransferSaveUpdate_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); if (RowsAffected == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Reason record. Try Again.."; AppException.Create("#C1", theBL); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(Convert.ToInt32(RowsAffected)); } catch { throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
/// <summary> /// 综合还书 /// </summary> /// <param name="flag">还书类型</param> /// <param name="bookid">图书条形码</param> /// <returns>返回还书信息</returns> public string RetrunBook(string flag, Guid bookid) { string reslut = string.Empty; try { OutTimeBookInfo outTimeBookInfo = new OutTimeBookInfo(); GetLoanInfoMgr getLoanInfoMgr = new GetLoanInfoMgr(); // 获取未还图书信息 outTimeBookInfo = getLoanInfoMgr.GetReturnBookInfo(bookid); switch (flag) { // 正常还书无罚款 case "0": ReturnbookNomle returnbookNomMgr = new ReturnbookNomle(bookid); returnbookNomMgr.Execute(); break; // 立即缴纳并归还图书 case "1": ReturnBookPayMoney returnBookPayMoney = new ReturnBookPayMoney(bookid, (decimal)outTimeBookInfo.Money); returnBookPayMoney.Execute(); break; // 还书但暂时不缴纳罚款 case "2": ReturnOutTimeBookNoPay returnOutTimeBookNoPay = new ReturnOutTimeBookNoPay(bookid, (decimal)outTimeBookInfo.Money); returnOutTimeBookNoPay.Execute(); break; } } catch (AppException exp) { reslut = exp.Message; } catch (Exception exp) { AppException appexp = new AppException("还书失败", exp, ExceptionLevel.Info); throw appexp; } return(reslut); }
/// <summary> /// Writes the app exception. /// </summary> /// <param name="appex">The appex.</param> /// <param name="timepoint">The timepoint.</param> /// <param name="routeModuleName">Name of the route module.</param> public void WriteAppException(AppException appex, DateTime timepoint, string routeModuleName) { try { string trackID = appex.Data["TrackID"] as string; Dictionary<string, object> parameters = new Dictionary<string, object>(); if (appex.Data != null) { foreach (var key in appex.Data.Keys) { if (key is string) { string keyStr = key as string; parameters.Add(keyStr, appex.Data[key]); } } } string originalException = appex.InnerException != null ? appex.InnerException.Message : string.Empty; string exceptionContext = JsonHelper.JsonSerializer<Dictionary<string, object>>(parameters); string localip = IPAddressHelper.GetLocalIpAddress(); MAppException mappex = new MAppException() { OrginalExceptionMsg = originalException, ExceptionContext = exceptionContext, ExceptionMsg = appex.ToString(), ErrorCode = appex.ErrorCode, LocalIP = localip, ApplicationName = AppKeySettings.ApplicationName, LogID = Guid.NewGuid().ToString(), TrackID = trackID, TimePoint = DateTime.Now, ExceptionLevel = appex.Level, }; DALFactory.GetAppExceptionDAL(LogRecordType.DBLog).InsertAppException(mappex); } catch (Exception ex) { TextDataAccess.AddLog(ex.StackTrace.ToString()); } }
public int DeleteCustomField(int fieldID, int flag) { lock (this) { ClsObject CustomField = new ClsObject(); ClsUtility.Init_Hashtable(); int theRowAffected = 0; ClsUtility.AddParameters("@ID", SqlDbType.Int, fieldID.ToString()); ClsUtility.AddParameters("@flag", SqlDbType.Int, flag.ToString()); theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_PMTCT_DeleteCustomFields_Future", ClsUtility.ObjectEnum.ExecuteNonQuery); if (theRowAffected == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Deleting Custom Field. Try Again.."; AppException.Create("#C1", theMsg); } return(theRowAffected); } }
private AppException MapException(Exception ex) { if (ex == null) return null; var exception = new AppException { HelpLink = ex.HelpLink, Message = ex.Message, Source = ex.Source, StackTrace = ex.StackTrace, TargetSite = ex.TargetSite != null ? ex.TargetSite.ToString() : string.Empty, ExceptionTypeName = ex.GetType().FullName, }; exception.InnerException = MapException(ex.InnerException); return exception; }
public bool validateUser(string username, string password , out User user, out AppException error) { try { user= DBManager.Instance.users.login(username, password); error = null; return true; } catch(AppException e) { user = null; error = e; return false; } }
protected void OnAppException(AppException exception) { var task = DispatcherHelper.RunAsync(async () => { await new MessageDialog("Error:\r\n" + exception.Message).ShowAsync(); }); }