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