public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } TblPayments = await _context.TblPayments.FirstOrDefaultAsync(m => m.PaymentId == id); if (TblPayments == null) { return(NotFound()); } return(Page()); }
public int UpdateReceipt(ReceiptPaymentViewModel model) { try { var receiptTable = dbContext.TblReceipt.Select(x => x).Where(x => x.HouseId == model.HouseId).FirstOrDefault(); //var paymentTable = dbContext.TblPayments.Select(x => x).Where(x => x.ReceiptId == receiptTable.Id).order //var viewModel = new Order(); //viewModel.GL = "model ki value"; //viewModel.BLIC = "model ki value1"; //var checkReciept = orderDetail; var payments = new TblPayments(); foreach (var item in model.GetType().GetProperties()) { var columnName = item.Name; var val = model.GetType().GetProperty(columnName).GetValue(model); if (receiptTable.GetType().GetProperty(columnName) != null) { if (val != null && !string.IsNullOrEmpty(val.ToString()) && val.ToString() != "0") { receiptTable.GetType().GetProperty(columnName).SetValue(receiptTable, val); } } if (payments.GetType().GetProperty(columnName) != null) { if (val != null && !string.IsNullOrEmpty(val.ToString()) && val.ToString() != "0") { payments.GetType().GetProperty(columnName).SetValue(payments, val); } } //var IsReceiptExists = dbContext.TblReceipt.Where(x => x.HouseId == model.HouseId).FirstOrDefault(); //if (IsReceiptExists == null) // return 0; //else //{ // int updateReceiptCount = dbContext.Database.ExecuteSqlCommand($"sp_UpdateReceipt {model.HouseId},{model.Amount},{model.PaymentDate}"); // return updateReceiptCount; //} } if (payments != null) { payments.ReceiptId = receiptTable.Id; dbContext.TblPayments.Add(payments); } if (receiptTable != null) { dbContext.Entry(receiptTable).State = EntityState.Modified; } return(dbContext.SaveChanges()); } catch (Exception ex) { StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(ReceiptRepository)} - Method name: {nameof(UpdateReceipt)}", stackTrace: ex.StackTrace); return(0); } }