public async Task <IActionResult> Handle(HttpRequest request, CheckStatusRequest data) { AuthByKeyResult authResult = this.GetAuthenticationKey(request); if (!authResult.Result) { return(new JsonErrorResult(authResult.ErrorResponse)); } ErrorResponse validationError = this.ValidateRequest(data); if (validationError != null) { return(new JsonErrorResult(validationError)); } try { using (SqlConnection conn = sqlServer.GetConnection()) { await conn.OpenAsync(); using (SqlCommand cmd = sqlServer.GetSpCommand("dbo.Employee_CheckEmployeeStatus", conn)) { cmd.AddBinaryParam("@PermanentKey", 16, authResult.Key.ToArray()); cmd.AddIntParam("@PlaceId", data.PlaceId); SqlParameter EmployeeIdParam = cmd.AddIntParam("@EmployeeId").Output(); SqlParameter EmployeeFirstNameParam = cmd.AddNVarCharParam("@EmployeeFirstName", 50).Output(); SqlParameter EmployeeLastNameParam = cmd.AddNVarCharParam("@EmployeeLastName", 50).Output(); SqlParameter EmployeeIsDisabledParam = cmd.AddBitParam("@EmployeeIsDisabled").Output(); SqlParameter PlaceGroupIdParam = cmd.AddIntParam("@PlaceGroupId").Output(); SqlParameter PlaceGroupNameParam = cmd.AddNVarCharParam("@PlaceGroupName", 50).Output(); SqlParameter retValParam = cmd.AddReturnValue(); await cmd.ExecuteNonQueryAsync(); int retVal = retValParam.GetInt32OrDefault(); if (retVal == -1) { return(this.GetAuthKeyNotFoundResponse()); } CheckStatusResponse response = new CheckStatusResponse(); response.EmployeeId = EmployeeIdParam.GetInt32OrDefault(); response.EmployeeFirstName = EmployeeFirstNameParam.Value.ToString(); response.EmployeeLastName = EmployeeLastNameParam.Value.ToString(); response.EmployeeIsDisabled = EmployeeIsDisabledParam.GetBooleanOrDefault(); response.PlaceGroupId = PlaceGroupIdParam.GetInt32OrNull(); response.PlaceGroupName = PlaceGroupNameParam.GetStringOrNull(); return(new JsonResult(response)); } } } catch (Exception ex) { return(new JsonErrorResult(this.GetExceptionResponse(ex))); } }
private async Task <ShareData> GetShareData(Payment payment, SqlConnection conn, SqlTransaction tx) { ShareData share = new ShareData(); Dictionary <int, GroupShareData> groups = new Dictionary <int, GroupShareData>(); using (SqlCommand cmd = _sqlServer.GetSpCommand("payment.LoadShareData", conn, tx)) { cmd.AddIntParam("@PlaceId", payment.PlaceId); cmd.AddIntParam("@EmployeeId", payment.EmployeeId); cmd.AddDateTime2Param("@PaymentDateTime", payment.PaymentDateTime); cmd.AddBitParam("@IsTimeSpecified", payment.IsTimeSpecified); SqlParameter PaymentLimitParam = cmd.AddDecimalParam("@PaymentLimit", 18, 2).Output(); SqlParameter SystemCommissionParam = cmd.AddDecimalParam("@SystemCommission", 4, 2).Output(); SqlParameter IsPlaceActiveParam = cmd.AddIntParam("@IsPlaceActive").Output(); SqlParameter PlaceDisplayNameParam = cmd.AddNVarCharParam("@PlaceDisplayName", 100).Output(); SqlParameter ShareSchemeHistoryIdParam = cmd.AddIntParam("@ShareSchemeHistoryId").Output(); SqlParameter PersonalShareParam = cmd.AddTinyIntParam("@PersonalShare").Output(); SqlParameter EmployeeFirstNameParam = cmd.AddNVarCharParam("@EmployeeFirstName", 50).Output(); SqlParameter EmployeeLastNameParam = cmd.AddNVarCharParam("@EmployeeLastName", 50).Output(); SqlParameter EmployeeIsFiredParam = cmd.AddBitParam("@EmployeeIsFired").Output(); using (SqlDataReader dr = await cmd.ExecuteReaderAsync()) { while (dr.Read()) { GroupShareData gdata = new GroupShareData(); gdata.Name = dr.GetString("Name"); gdata.Id = dr.GetInt32("GroupId"); gdata.Weight = dr.GetByte("GroupWeight"); groups.Add(gdata.Id, gdata); share.Groups.Add(gdata); } dr.NextResult(); while (dr.Read()) { MembershipData md = new MembershipData(); md.EmployeeId = dr.GetInt32("EmployeeId"); md.GroupId = dr.GetInt32("GroupId"); md.BeginDateTime = dr.GetDateTime("BeginDateTime"); md.EndDateTime = dr.GetDateTime("EndDateTime"); md.IsManager = dr.GetBoolean("IsManager"); md.IsOwner = dr.GetBoolean("IsOwner"); share.Memberships.Add(md); groups[md.GroupId].AddMembership(md); } } share.PaymentLimit = PaymentLimitParam.GetDecimal(); share.SystemCommission = SystemCommissionParam.GetDecimal(); share.Place.Id = payment.PlaceId; share.Place.Name = PlaceDisplayNameParam.Value.ToString(); share.Place.IsActive = (IsPlaceActiveParam.GetInt32() != 0); share.ShareSchemeHistoryId = ShareSchemeHistoryIdParam.GetInt32(); share.PersonalShare = PersonalShareParam.GetByte(); if (payment.EmployeeId.HasValue) { share.Receiver = new ReceiverData(); share.Receiver.Id = payment.EmployeeId.Value; share.Receiver.FirstName = EmployeeFirstNameParam.Value.ToString(); share.Receiver.LastName = EmployeeLastNameParam.Value.ToString(); share.Receiver.IsFired = EmployeeIsFiredParam.GetBooleanOrDefault(); } } return(share); }