public static bool Update(Card card) { bool result = false; try { var conn = OracleDL.connect(); OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = "UPDATE CARDACCOUNTREQUESTS SET PRINTSTATUS = :printstatus WHERE ID1 = :id"; cmd.Parameters.Add(":printstatus", OracleDbType.Varchar2, card.PrintStatus, ParameterDirection.Input); cmd.Parameters.Add(":id", OracleDbType.Varchar2, card.ID1, ParameterDirection.Input); int rowsUpdated = cmd.ExecuteNonQuery(); if (rowsUpdated > 0) result = true; OracleDL.close(conn); return result; } catch (Exception ex) { throw ex; } }
public static Response Update(Card card, string username, bool overrideApproval) { try { if (!overrideApproval) { bool logForApproval = ApprovalConfigurationDL.RetrieveByType(StatusUtil.GetDescription(StatusUtil.ApprovalType.ResetCardPrintStatus)).Approve; if (logForApproval) { Approval approvalObj = new Approval(); approvalObj.Type = StatusUtil.GetDescription(StatusUtil.ApprovalType.ResetCardPrintStatus); approvalObj.Details = JsonConvert.SerializeObject(card); approvalObj.Obj = JsonConvert.SerializeObject(card); approvalObj.RequestedBy = username; approvalObj.RequestedOn = System.DateTime.Now; approvalObj.Status = StatusUtil.ApprovalStatus.Pending.ToString(); if (ApprovalDL.Save(approvalObj)) { return new Response { SuccessMsg = "Card record successfully logged for approval", ErrorMsg = string.Empty }; } else { return new Response { SuccessMsg = string.Empty, ErrorMsg = "Operation failed" }; } } else { if (CardDL.Update(card)) { AuditTrail obj = new AuditTrail(); obj.Type = StatusUtil.GetDescription(StatusUtil.ApprovalType.ResetCardPrintStatus); obj.Details = JsonConvert.SerializeObject(card); obj.RequestedBy = username; obj.RequestedOn = System.DateTime.Now; obj.ApprovedBy = username; obj.ApprovedOn = System.DateTime.Now; AuditTrailDL.Save(obj); return new Response { SuccessMsg = "Card record updated successfully", ErrorMsg = string.Empty }; } else { return new Response { SuccessMsg = string.Empty, ErrorMsg = "Operation failed" }; } } } else { if (CardDL.Update(card)) { return new Response { SuccessMsg = "Card record updated successfully", ErrorMsg = string.Empty }; } else { return new Response { SuccessMsg = string.Empty, ErrorMsg = "Operation failed" }; } } } catch (Exception ex) { ErrorHandler.WriteError(ex); return new Response { SuccessMsg = string.Empty, ErrorMsg = ex.Message }; } }